JSqlParser

JSqlParser copied to clipboard

sql contain join [shuffle], so error

2

next version can support [shuffle] ？

zbjbaggio

### Grammar or Syntax Description Snowflake supports an `AT | BEFORE` clause in SELECT statements to enable time travel functionality. This currently causes the statement to be unparseable. ### SQL...

davidjgoss

`LOAD` statement

3

Hi: when use JSqlParser to parse sql then occur exception Test load data into table code like below: @test public void testLoadDataTable() throws JSQLParserException { String sqlString = “load data...

LeBronChen1

[BUG] JSQLParser 4.7: `ADD COLUMN IF NOT EXISTS` not supported

4

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - Brief description of the failing SQL feature - Example: `Encountered unexpected token: "IF"...

zdhuangelephant

[Feature] Prostgres Procedural `DO $$BEGIN ... END$$`

4

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - Brief description of the failing SQL feature - Example: `Encountered unexpected token: "DO"...

zdhuangelephant

I am using Informix and jsql parser to parse the SQL statements. ### Failing SQL Feature: - While using jsql parser with Informix if we use Informix set isolation statement...

shubhjet

[BUG] JSQLParser 4.7 : MySQL 8 : Cannot parse functional indices in table creation DDL

3

### Failing SQL Feature: Parsing `CREATE TABLE` DDL query failed when there is a `KEY` parameter that uses functions like `LOWER`. The parsing fails with this error: ``` net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException:...

ls-denis-iakovlev

[BUG]with as (update xxxx) can't be parsed

2

### Failing SQL Feature: "with as (update xxx)" can't be parsed the error is Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "update" "UPDATE" at line 2, column 9. Was expecting:...

coach00

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "UNIQUE" "UNIQUE"

1

I tried using 3 versions: 4.5, 4.6, 4.7. I want to get table name from this sql: ``` CREATE TABLE `sys_user` ( `id` bigint NOT NULL, `role_id` bigint NULL, `name`...

Meow-Cat

I notice that the parser seems to create incorrect index types from create table statements when multiple constraints are defined. The index type then depends on the order of constraints....

reboot