JSqlParser

JSqlParser copied to clipboard

JSqlParser doesn't support convert function used as converting a value to a specified character set

3

**Describe the bug** ParseException occurs when parse SQL **To Reproduce** Steps to reproduce the behavior: 1. Example SQL SELECT id,name,version,identity,type,`desc`,enable,content FROM tbl_template WHERE (name like ?) ORDER BY convert(name using...

csxcsx00

Parsing "@@" throws exception

1

**Describe the bug** When parsing the below SQL an exception with the message: "Not yet supprted" is thrown. This is totally valid MariaDB SQL Syntax that runs just fine when...

Aceto1

Error while parsing literals with backslash

35

**Describe the bug** Can't properly parse the statement when 1. Backslash is the last character of a literal; 2. The literal is not the last value of a sequence. **To...

xccui

4.1 Parser fails on Nested Comments /* foo /*bar*/ */

17

JSQLParser 4.1: ```sql -- Nested Comments failure select /*this is a /*nested!!!*/ comment*/ 1 from dual; ``` at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:206) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:194) at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:28225) at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:28064) at net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:623) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:204) This...

manticore-projects

impala/hive grammar

9

I want to implement impala/hive grammar, for example: > ****`insert overwrite a(b,c) partitions(tx_date=20190626) select b,c from b`**** I would like to ask which class I should pay attention to

xiearthur

Count statements after Error Recovery.

2

From the test suite: ```java @Test public void testStatementsErrorRecovery3() throws JSQLParserException, ParseException { String sqls = "select * from mytable; select * from;select * from mytable2"; CCJSqlParser parser = new...

manticore-projects

Jsqlparser can support hive or spark sql

1

INSERT overwrite table t.b partition(p1=1,p2=2,mth_beg_dt) as select * from t.b1 distribute by column1

haha174

net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "desc" "DESC"

2

**Describe the bug** parser error. **To Reproduce** Steps to reproduce the behavior: 1. Example SQL : select a from b group by c desc; 2. Parsing this SQL using JSqlParser...

zhaochengbei

Lexical error from backslash in string literal

2

**Describe the bug** Lexical error for Oracle update statement when where clause has backslash in string literal. **To Reproduce** Steps to reproduce the behavior: 1. update PARAM_TBL set PARA_DESC =...

erilong

NotExpression parsing error

1

**Describe the bug** NotExpression is not parsed correctly. **To Reproduce** Steps to reproduce the behavior: 1. `CCJSqlParserUtil.parseCondExpression("not not 1 = 1")` generates following objects: `NotExpression ( EqualsTo ( NotExpression (...

xsgao-github