JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

Results 222 JSqlParser issues
Sort by recently updated
recently updated
newest added

Bumps [org.junit.jupiter:junit-jupiter-engine](https://github.com/junit-team/junit5) from 5.11.4 to 5.13.1. Release notes Sourced from org.junit.jupiter:junit-jupiter-engine's releases. JUnit 5.13.1 = Platform 1.13.1 + Jupiter 5.13.1 + Vintage 5.13.1 See Release Notes. Full Changelog: https://github.com/junit-team/junit5/compare/r5.13.0...r5.13.1 JUnit...

dependencies
java

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: quantile(0.95)(cost) not support ### SQL Example: select toStartOfDay(timestamp) AS date, count(1) as count, quantile(0.95)(cost)...

exotic
Sponsor needed
Clickhouse

### Grammar or Syntax Description - `ALTER TABLE` with a `USING INDEX` clause cannot parse the name of the index. The name of the index is reported in an UnsupportedStatement...

DDL
Sponsor needed

### Failing SQL Feature: - AS integer can't be parsed ### SQL Example: - Simplified Query Example, focusing on the failing feature ```sql CREATE SEQUENCE public.activites_activite_id_seq AS integer START WITH...

postgres
exotic
Sponsor needed

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: `WITH ROLLUP` can't be...

postgres
exotic

### Failing To Parse SQL - Join Fetch query is failing to parse - Example: `JOIN FETCH` can't be parsed ### SQL Example: - Simplified Query Example, focusing on the...

MySQL
exotic
Sponsor needed

### Failing SQL Feature: Can't be parsed: ```sql SELECT a as 测试() from b ``` ### Error Message: ```text Caused by: net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 1, column 15. Encountered:...

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: Time out occurred. ### SQL Example: select SUM(`ge_deal_standard_deal_ord_amt`) as `SUM_4ff219f1b0ffdffcab3b46688ac2ad0e`, `saler_bu_id` as...

### Failing SQL Feature: - Brief description of the failing SQL feature - Example: `WITH ROLLUP` can't be parsed - ![Image](https://github.com/user-attachments/assets/7d9b92ff-755a-41e8-8221-eb9a552df4a1) ### SQL Example: SELECT id,knowledge_type_code,knowledge_data,url_routing,keyword,update_by,update_time,sort FROM "SUNYA-SYSTEM".sys_knowledge_base WHERE ((JSON_UNQUOTE(JSON_EXTRACT(knowledge_data,...

duplicate
Sponsor needed

### Grammar or Syntax Description BigQuery supports a non-standard extension to `UNION ALL` that includes `FULL OUTER UNION ALL BY NAME`. This construct allows combining multiple SELECT queries by **matching...