JSqlParser

JSqlParser copied to clipboard

Adding WITH DATA statement

6

**Describe the bug** When I try to parse the following SQL : ` CREATE TABLE empty_nation AS SELECT * FROM nation WITH DATA ` I got a exception (Full Stack...

abourakba

WithIsolation regression between v4.3 and v4.4

2

Hi, I found that following query cannot be parsed with v4.4, but with v4.3 it is ok. ```java @Test void name1() throws JSQLParserException { final String statement = "" +...

bedla

ALTER INDEX sql cannot be parsed

1

**Describe the bug** ALTER INDEX not implemented **To Reproduce** Steps to reproduce the behavior: 1. Example SQL ALTER INDEX idx_t_fa RENAME TO idx_t_fb; 2. Parsing this SQL using JSqlParser with...

jackiezh

use arrayMap function when Mybatis-plus integrated clickhouse appear: optimize this sql to a count sql has exception net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("

4

**Describe the bug** use clickhouse database arrayMap function **To Reproduce** Steps to reproduce the behavior: 1. Example SQL select card_type, origin_account, trade_account, // 异常情况在执行arrayMap处 arrayMap(x -> (toDecimal128(x,15) * toDecimal128(transfer_preference_amount,15)),prefer_path_ratio) as...

it-learning-diary

Cannot parse PGSQL JSONB_ARRAY_ELEMENTS() WITH ORDINALITY ARR()

4

Was expecting one of: "." ";" "ACTION" "ACTIVE" "ALGORITHM" "ARCHIVE" "ARRAY" "AS" "AT" "BYTE" "CASCADE" "CASE" "CAST" "CHANGE" "CHAR" "CHARACTER" "CHECKPOINT" "COLUMN" "COLUMNS" "COMMENT" "COMMIT" "CONNECT" "COSTS" "CYCLE" "DBA_RECYCLEBIN" "DEFAULT"...

qiqingli

where table_name = select database() has exception

1

**Describe the bug** paser `where table_name = select database()` has exception **To Reproduce Example** ``` public static void main(String[] args) throws JSQLParserException { String sql = " select table_name, table_comment,...

luoguohua

Several create function statements are stuck in a single statement

1

**Describe the bug** Several create function statements are stuck in a single statement **To Reproduce** ```scala def parse(sql: String): Seq[AstNode] = { var collected = ArrayBuffer[AstNode]() val stmts = CCJSqlParserUtil.parseStatements(sql)...

JakkuSakura

parser SQL failed on create index syntar.

1

We use postgresql database, and check create index syntar on Exception. Steps to reproduce the behavior: 1. CREATE UNIQUE INDEX "department_department_uindex" ON "public"."department" USING btree ( "department" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops"...

peter-hst

Postgres identifiers with double quotes not supported

3

**Describe the bug** Postgres supports double-quotes in table in column name identifiers with CSV-escape syntax, but they are unable to parse using JSqlParser **To Reproduce** Steps to reproduce the behavior:...

raipc

But actually an empty file is a list of statements of size 0. net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: at line 4, column 1. Was expecting one of: "(" ";" "ALTER" "BEGIN"...

JakkuSakura