JSqlParser

JSqlParser copied to clipboard

To Do List: Missing Oracle specific statements

4

This is just a reminder for myself, so far I found the following Oracle specific statements missing: - ~~`ALTER SYSTEM`~~ Fixed by PR #1288 - ~~`RENAME table TO ...`~~ Fixed...

manticore-projects

implicit cast to "double precision" is not supported

5

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: 1. `SELECT double precision '1'` 2. Parsing this SQL using...

sixinli

TIME WITH TIME ZONE

2

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: 1. `SELECT TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02'` 2. Parsing...

sixinli

it seems like since https://github.com/JSQLParser/JSqlParser/pull/1274/files#diff-7a533138e54adbf0baac5356d4b7d4a6d192300199ef50eede004f706fd35de3R104 `ColumnDefinition` accepts `ExpressionVisitorAdapter` https://github.com/JSQLParser/JSqlParser/blob/c89cf21641d672b1ea5e724b3c6f3497429ce97a/src/main/java/net/sf/jsqlparser/statement/create/table/ColumnDefinition.java#L104-L106 is it possible to have it take one of the interfaces instead? (just noticed also, they seem to be referencing each...

sixinli

ParseException: Cannot parse statement: Encountered unexpected token: "exists" "EXISTS"

24

My code: ``` @Test public void testJSQParser() { String sql = "alter table if exists public.table2 rename to table3;"; Validation validation = new Validation(List.of(DatabaseType.POSTGRESQL), sql); List errors = validation.validate(); Assert.assertTrue(errors.toString(),...

AmitAmely

Get the position of an Where/From AST item in the input

12

(Sorry for opening a new issue. I could not find a way to reopen the previous one.) Unfortunately, this does not work for all items. Or am I missing something?...

Wisser

sql parser exception when with double quotation marks

8

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: 1. Example SQL SELECT id,account,real_name,mobile,email,mobile_account,created_at,status,merchant_type,type FROM user WHERE deleted =...

maitong

Update JSqlParserCC.jjt

3

support json operator in postgres

xiaoyunwu

Cannot parse statement: Encountered unexpected token: "DEFERRABLE" "DEFERRABLE"

1

My code: ``` @Test public void testJSQLParserValidation() { String sql = "CREATE TABLE SOMESCHEMA.SOMERELATIONTABLE (REL1_PK INT NOT NULL, REL2_PK " + "INT NOT NULL, CONSTRAINT REL1_REL2_PKS UNIQUE (REL1_PK, REL2_PK) "...

AmitAmely

Hi, interesting case **To reproduce:** Parse `t1.t2(v).t3.c1 = @v`. Exception message: "Encountered unexpected token: "=" "=" at line 1, column 15. Was expecting one of: "("" but the next similar...

nikolayandr