JSqlParser

JSqlParser copied to clipboard

[BUG] JSQLParser 5.1 : Oracle : special table function JSON_TABLE

1

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - `CASE WHEN EXISTS` can't be parsed ### SQL Example: SELECT id, RECORD_ID, MODULE_ID,...

baliure

JSQLParser 5.1: Incorrect Parent node

2

I have a query: `select A from B where (A ~ 'fish')` which when tree walking with an ExpressionVisitor, I end up in `void visit(RegExpMatchOperator regExpMatchOperator) {...}`, the parent of...

davyboyhayes

The first parameter of the `array_map` function is `(x, y, z) -> x + y`, but it is incorrectly parsed as `(x, y, z)`. `Statement statement = CCJSqlParserUtil.parse("select array_map((x,y,z) ->...

style1002

### Failing SQL Feature: Stored procedures with placeholders are failing to parse. Multiple placeholders is failing parsing which is better. Previously this was being parsed successfuly in 1.x but with...

FCsean

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html)  ### Failing SQL Feature: - mysql unique index parse fail   ### SQL Example: - Simplified...

ThinkSure

[BUG] JSQLParser 4.0 : DM : Oracle `INSERT ALL ...` unsupported

1

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "ALL" "ALL" at line 1, column 8. Was expecting...

FelixDxc

[BUG] JSQLParser Version : 5.1 解析sqlserver数据库 stuff函数，当查询语句添加order by ，解析会报错

2

### SQL Example: public static void main(String[] args) { String sql = "SELECT STUFF((SELECT ',' + name FROM class order by id FOR XML PATH('')),1,1,'') AS names from " +...

rayliang123

[BUG] JSQLParser Version : 5.1 RDBMS : PostgreSQL 10 mix the JSON and relational operators, it outputs the wrong AST and sql.

4

### Description: - When using a mix of JSON and relational operators, there is a priority error in the parsing results. - The new sql lost some blank spaces. ###...

hijackworld

Oracle `xmlparse(content ...)` not supported

1

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 - `xmlagg` can't be parsed ###...

krislint

[BUG] JSQLParser 4.9 : MySQL 8.0 : unable to parse: ALTER TABLE ... ADD INDEX

2

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - unable to parse: ALTER TABLE .. ADD INDEX fAdd for composite index -...

sachandrasekaran