JSqlParser

JSqlParser copied to clipboard

[BUG] JSQLParser Version : 5.0 RDBMS : Hive syntax is not supported INSERT OVERWRITE PARTITION (dtime = '20220403')CASE WHEN condition THEN END ELSE ...

1

### Grammar or Syntax Description -Hive syntax is not supported: INSERT OVERWRITE And PARTITION (dtime = '20220403') -Hive syntax is not supported: CASE WHEN condition THEN END ELSE ... ###...

loevingerx

### Discussed in https://github.com/JSQLParser/JSqlParser/discussions/2111 Originally posted by **dani-petrov** November 19, 2024 Hello, I will attach a screenshot of the currently supported syntax for Alter Table -> modify column: Looking at...

manticore-projects

[feat] Support for JSON_TABLE

6

ANeumann82

[FEATURE] Add support for MATCH_RECOGNIZE clause (BigQuery) to JSQLParser

1

### Grammar or Syntax Description - JSQLParser version tested: 5.4-SNAPSHOT. The query above throws `> Encountered: / "BY", at line 14, column 12, in lexical state DEFAULT.` - Error encountred...

zedach

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - Encountered unexpected token: "as" "AS" ### SQL Example: ```sql insert into xxx(a, b,...

okou19900722

[BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : Custom type casting with more than one level not working

1

It seems that the parser supports single-level composite types but fails on nested multi-level composite types. Query to reproduce the parsing error: ``` SELECT (product_data::product_info_similarity).info.category AS category, COUNT(*) AS num_products...

tomershay

Sample queries that lead to `NullPointerException`: `SELECT (((((((((((((((((((((((((((((((((((((((((((((((((((((((((1+1)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))); ` `SELECT abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(1))))))))))))))))))))))))));`

tomershay

### Failing SQL Feature: - Oracle supports outer joins with (+) notation and can be used in conjunction with nvl or coalesce - Example: The following example cannot be parsed...

mantesap

https://www.postgresql.org/docs/18/dml-returning.html PostgreSQL 18 adds support for `OLD` and `NEW` references in a `RETURNING` statement. It could be beneficial to add support to this syntax in a more structured way, as...

tomershay

**PostgreSQL official documentation:** https://www.postgresql.org/docs/current/functions-xml.html#FUNCTIONS-XML-PROCESSING-XMLTABLE **Error trying to parse:** **Steps to reproduce:** ```-- Table to store XML data CREATE TABLE xmldata ( id SERIAL PRIMARY KEY, -- optional, just for uniqueness...

tomershay