JSqlParser

JSqlParser copied to clipboard

[BUG] JSQLParser Version 4.6: RDBMS ORACLE : Encountered unexpected token: "INTO" "INTO"

3

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

qiuchsh

[BUG] JSQLParser 4.6 : KsqlDB : Not able to parse Ksqldb queries

2

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax.html) ### Failing SQL Feature: - When I tried to parse some ksql db queries not able to parse...

devanshusharma17

Redshift notation for SET is not supported

1

In Redshift the syntax for SET statements is `SET x TO y`, for [example](https://docs.aws.amazon.com/redshift/latest/dg/super-configurations.html#upper-mixed-case): `SET enable_case_sensitive_identifier to true` This format is not supported and fails with ``` net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered...

zaza

### Failing SQL Feature: When parsing an example (taken from the postgres website: https://www.postgresql.org/docs/current/sql-createtable.html) that uses `interval hour to minute` in `CREATE TABLE...` parsing fails with: ``` Failed to parse...

dguy

Support for JSON_TABLE function from mysql

1

It seems that the following json function is not supported: Failed to process, Error SQL: SELECT epcItem.epc FROM s_delivery_bill_detail detail CROSS JOIN JSON_TABLE ( detail.epc_list, '$[*]' COLUMNS ( epc VARCHAR...

Sxxjava

Encountered unexpected token: "ALL" "ALL"

1

When i use the test case "testOracleInsertMultiRowValue()", got this exception. doesn`t support sql segement like "INSERT ALL" ?

veiframework

parser sql of MySQL create or alter table with partition occur exception

1

Hi: when use JSqlParser to parse sql then occur exception Test create table ddl with range partition code like blew: @Test public void test_CreateTablePartition() throws JSQLParserException { String sqlString =...

krihy

Not support SQLServer 2016 Temporal Table "FOR SYSTEM_TIME" query?

2

**Question:** ------ Not support SQLServer 2016 Temporal Table "FOR SYSTEM_TIME" query? **SQL:** ------ select count(0) from ( select score_id, rule_id, fy, employee_no, total_score, final_score, record_count, del_flag, create_by, create_time, update_by, update_time,...

ourcolour

support for informix db fnc

1

how to use informix db functions like date(CURRENT YEAR TO DAY) the parser is not able to parse it correctly it treats day as column name

karth06

No support for LOCK TABLES

2

**Describe the bug** JSqlParser doesn't support `LOCK TABLES` and throws `ParseException: Encountered unexpected token`. **To Reproduce** SQL: ``` -- Other Parsable Statements; LOCK TABLES `table` WRITE; -- Other Parsable Statements;...

ksqsf