JSqlParser

JSqlParser copied to clipboard

[FEATURE] allow RDBMS specific keywords as columns

2

### Grammar or Syntax Description - Postgresql allows some keywords as column names (i.e. `start`) ### SQL Example - Simplified Query Example, focusing on the failing feature ```sql SELECT 'Monday'...

d2a-raudenaerde

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 resolve, sign in DROP statement Exception in thread "main" net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered...

awei2024

### Failing SQL Feature: In JSON operator `->> int`, you cannot use negative number, which can be used to index from the end (same as in python) In Postgres also...

zabojpetr

[BUG] JSQLParser Version 4.9 : RDBMS Postgresql 14.2 : Using Named Notation

1

### Failing SQL Feature: When calling a PostgreSQL function, you can use the `:=` operator by specifying the name of each argument. * The following error occurs when parsing: ```...

bigdream96

ORACLE: ALTER TABLE ... ADD CONSTRAINT ... with tablespace option unsupported

1

### Software Information: - 4.9+ - oracle 19c ```sql ALTER TABLE bfmcs.your_table ADD CONSTRAINT your_table_pk PRIMARY KEY (ID) using index tablespace your_tablespace; ``` net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "tablespace" "TABLESPACE"...

LuckyLXX

maven dependence: com.github.jsqlparser jsqlparser 4.7 sqlServer sql: insert bulk tpch.dbo.order_line([ol_o_id] int,[ol_d_id] tinyint,[ol_w_id] int,[ol_number] tinyint,[ol_i_id] int, [ol_delivery_d] datetime,[ol_amount] smallmoney,[ol_supply_w_id] int,[ol_quantity] smallint,[ol_dist_info] char(24) collate Chinese_PRC_CI_AS)with(ROWS_PER_BATCH=500000) ### Failing SQL Feature: sqlserver insert bulk...

jisongxi

Support custom SelectDeParser

2

redkale

### Failing SQL Feature: Starting with JSQLParser 5.0, `CHARACTER SET` is not properly parsed and result in an error ### SQL Example: E.g. this query ``` ALTER TABLE `jobs`.`runs` MODIFY...

micheltuu

[FEATURE] Parsing LOCK Clause in ALTER TABLE Using JSQLParser

1

### Grammar or Syntax Description The `LOCK=NONE` clause in ALTER TABLE statements is not correctly parsed by JSQLParser. The parser successfully parses the statement into three AlterExpression objects, but the...

minleejae

[FEATURE] Parsing CONVERT TO Statement in ALTER TABLE Using JSQLParser

1

### Grammar or Syntax Description - The `CONVERT TO CHARACTER SET` clause in ALTER TABLE statements is not correctly parsed by JSQLParser. - The parser treats the operation as `UNSPECIFIC`...

minleejae