JSqlParser

JSqlParser copied to clipboard

Error in parsing create statement: Encountered unexpected token: "KEY" "KEY"

4

This is one of the tables from the famous sakila DB, I am using SQL Server. ``` CREATE TABLE actor ( actor_id INT NOT NULL IDENTITY , first_name VARCHAR(45) NOT...

Vipin-Sharma

Get Table Object List instead of full qualified table name list from a statement

1

TablesNamesFinder class allows us to retrieve tables names from a statement with the getTableList method. For our needs, we would like to get directly table object List instead of full...

detienneZN

The ->> operation in postgresql does not work properly

1

select visit_hour,json_array_elements(into_sex_json)->>'name',json_array_elements(into_sex_json)->>'value' from period_market

offSwitch

Google Spanner support

4

add support of a Google Spanner Interleaved table, commit timestamp options and array types

s13o

Oracle SQL XMLSERIALIZE syntax not supported

3

Oracle's [`XMLSERIALIZE`](https://docs.oracle.com/database/121/SQLRF/functions268.htm#SQLRF06231) differs from the parser's expectations in that it has a `CONTENT` keyword. The following example doesn't parse: ```sql SELECT XMLSERIALIZE(CONTENT XMLTYPE('Grandco')) AS xmlserialize_doc FROM DUAL; ``` ``` 2....

xiongtx

TSQL/MS SQL Server statements/syntax not supported.

1

From https://github.com/dbeaver/dbeaver/issues/16756. Two large TSQL files: https://github.com/jOOQ/sakila/blob/main/sql-server-sakila-db/sql-server-sakila-schema.sql https://github.com/jOOQ/sakila/blob/main/sql-server-sakila-db/sql-server-sakila-insert-data.sql

manticore-projects

Illegal table aliases in JSQLParser 4.4

2

Hi, After upgrade to 4.4 from 3.1 I got some exceptions in some of my legal Mariadb SQL queries. After a bit of investigation, it turns out that some table...

rolfwoll

MySQL (optional) Index Names

1

**Steps to reproduce/Actual Behavior:** 1. `CCJSqlParserUtil.parse("CREATE TABLE table1 (col1 type1, col2 type2 UNIQUE, CONSTRAINT my_constraint UNIQUE KEY index_name (col1))")` >JSQLParserException: Was expecting "(" 2. `CCJSqlParserUtil.parse("CREATE TABLE table1 (col1 type1, col2...

Alletkla

Failed to parse SQL Server ddl

5

Steps to Reproduce the Problem: ``` String ddl = """ CREATE TABLE [Person].[Person] ( [BusinessEntityID] [int] NOT NULL, [PersonType] [nchar](2) NOT NULL, [NameStyle] [dbo].[NameStyle] NOT NULL, [Title] [nvarchar](8) NULL, [FirstName]...

Vipin-Sharma

Share/deploy the Auto Generated Sources on top of the Actual Sources

2

https://github.com/i-net-software/JWebAssembly/issues/43 refers. How can we share the auto-generated Sources?

manticore-projects