JSqlParser

JSqlParser copied to clipboard

JSqlParser api keyword setting whitelist

1

How to set a whitelist for keywords

guandatawangjialin

JSQLParser 4.2 up to 4.4 hava a problem

2

hi~ JSQLParser 4.2 up to 4.4 vesion, I have a problem，net.sf.jsqlparser.expression.Function toString method When the database dialect is MySQL，when i want to assemble SQL totalcount , there are some differences,...

afuchrisma

Added support for NOT RLIKE expressions

2

Added support for NOT RLIKE expressions #1553

guandatawangjialin

String sql = "select * from test where id not rlike '111'"; ValidationError [ statement=select * from test where id not rlike '111' capability=parsing errors=[ParseException: Cannot parse statement: Encountered unexpected...

guandatawangjialin

parse "CURRENT_TIMESTAMP(3)" error

4

CCJSqlParserUtil.parse("update btrip_payment set update_time = CURRENT_TIMESTAMP(3) where id = 1"); version:4.2 

patinousward

WITH ... AS ( DELETE ... RETURNING )

3

The following is valid in postgresql but gives an error in JSqlParser ```sql WITH updated_rows AS ( DELETE FROM documents WHERE something='something' RETURNING * ) SELECT * FROM updated_rows LIMIT...

dfcatdivvy

Any recommended projects for NodeJS / JavaScript

1

Hey folks, I maintain [Beekeeper Studio](/beekeeper-studio/beekeeper-studio), which is built in Electron using JavaScript. I'd love to use this powerful SQL parser, but unfortunately I don't have Java available to me...

rathboma

JSQLParserException: MySQL style single quoted string with line break and backslash escaped single quote

2

Test case to reproduce: ```java @Test public void testInsertWithStringWithLineBreakAndEscapedSingleQuote() throws JSQLParserException { assertSqlCanBeParsedAndDeparsed( "INSERT INTO `table_a` (`code`) VALUES ('\n" + " print(\\'a string\\')\n" + "')" ); } ``` Not only...

SylphiaWindy

begin end

2

https://github.com/JSQLParser/JSqlParser/blob/6cff161dacc1e6feeccce709ca08220e576836be/src/main/java/net/sf/jsqlparser/statement/Block.java#L31 in oracle 19c ‘begin end;‘ its needs the semicolon otherwise oracle showed the error code “pls-00103”. Is there an option to provide.

DexterPoker

I use it to analyze clickhouse sql，But there is a problem，Can you show me

4

select b.name, a.pay_amount, a.partner_team_id from order_pay a GLOBAL join team b on a.partner_team_id = b.id error net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "GLOBAL" "GLOBAL" at line 1, column 73. Was expecting one...

lif123456