JSqlParser

JSqlParser copied to clipboard

TenantLineInnerInterceptor Could not support "Replace" grammer like "replace into table_xx values ..."

1

I execute "replace INTO b_house ( id, `name1`) values ( (#{house.id} ,#{house.name1})" in multiple tenant mode，using "TenantLineInnerInterceptor" to help me，but it cannot work. because there is no related code... at...

JuneMare

Can support "FOR UPDATE SKIP LOCKED"?

1

It seems not support "SKIP LOCKED". The following two SQL can execute normally in MySql8, but parse failed by JSqlParser. ```sql SELECT * FROM t_user FOR UPDATE SKIP LOCKED; SELECT...

jimmy384

Closes #1604, added simple OVERLAPS support

7

* Using the `ExpressionList` approach as discussed in the other PR * No renames of existing classes * Moved to `SQLCondition`

d2a-raudenaerde

Fixes PR #1524 support hive alter sql and Commit [fb6e950](https://github.com/JSQLParser/JSqlParser/commit/fb6e950ce0e62ebcd7a44ba9eea679da2b04b2ed)

manticore-projects

Test Failed Issue about 4.5

1

I'm working with 4.5. And I found out bug when I run example of replacing(https://github.com/JSQLParser/JSqlParser/wiki/Examples-of-SQL-building#more-general-replacing-of-string-values-in-statements). ``` import net.sf.jsqlparser.JSQLParserException; import net.sf.jsqlparser.expression.LongValue; import net.sf.jsqlparser.expression.StringValue; import net.sf.jsqlparser.parser.CCJSqlParserUtil; import net.sf.jsqlparser.statement.Statement; import net.sf.jsqlparser.util.deparser.ExpressionDeParser; import net.sf.jsqlparser.util.deparser.SelectDeParser;...

yugeeklab

Enhanced Keywords

51

Rewrite the Reserved Keywords Logic: 1) Automatically Derive all Keyword Tokens from the Parser. 2) Explicitly add Reserved Keywords to the Grammar and classify, why/when it is reserved. 3) Auto-generate...

manticore-projects

Could not parse complex COALESCE/CAST

16

This bit of (Postgresql valid) SQL fails: ``` select t0.* , cr.code from mytable t0 join othertable cr ON cr.code = '1234' where COALESCE (cast(to_date(to_char(t0.datum_ontslagen,'YYYYMMDD'),'YYYYMMDD')||' '||t0.tijd_ontslagen as timestamp), current_timestamp(0)) -...

d2a-raudenaerde

parse args in case when error

5

I have a stamemnt than run ok in postgresql : select * from customer m where id=case when id > max(id, :maxValue) then 1 else 2 end, max is customized...

wolfjiang

In SQL it is possible to do something like this: `select 'yes' from dual where (sysdate-5,sysdate) overlaps (sysdate-2,sysdate-1)` (interval5.sql) JsqlParser currently does not support this. I started a Discussion on...

d2a-raudenaerde

Missing support for presto : TABLESAMPLE BERNOULLI clause

2

SELECT * FROM fact_halllogin_detail TABLESAMPLE BERNOULLI (10) where dt>=20220710 limit 10 Exception: Encountered unexpected token: "BERNOULLI" at line 1, column 49. Was expecting one of: ";" "CONNECT" "EMIT" "GROUP" "HAVING"...

ctdcj