JSqlParser

JSqlParser copied to clipboard

PGSQL CCJSqlParserUtil.parse can't parse ||

1

**Describe the bug** PGSQL CCJSqlParserUtil.parse can't parse || **To Reproduce** Steps to reproduce the behavior: 1. select id,name from test where name like '%'||?||'%' 2. JSqlParser 4.3 3. net.sf.jsqlparser.parser.ParseException: Encountered...

cjran704

Get fingerprint from a sql?

3

How to get the fingerprint from a specified sql? Is there any implemention in JSqlParser?

roseduan

special character "?" support issues

9

**Describe the bug** In PGSQL, the special character "?" Is used. An error occurred during order parsing(use with mybatisplus), error message: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "?" "?" **To Reproduce** Steps...

worthy-commits

Statement deep cloning

8

Hello. I can't seem to find a way to deep-clone an already parsed statement. Does such functionality exist?

wheredevel

Error when parsing switch expressions with OR or AND.

3

**Describe the bug** First things first: thank you for your work! A switch expression of a CASE, if containing a OR or a AND, makes the parsing crash. **To Reproduce**...

mgoeminne

CCJSqlParserUtil fails on different variable names

6

**Describe the bug** When I want to parse the following query ```sql select p from Customer c join c.productOrder p where p.delayed = true ``` using `(Select) CCJSqlParserUtil.parse(query);` I get...

DiegoKrupitza

ParseException: Encountered unexpected token: "EXCHANGE"

1

### sql alter table total_issue_info exchange partition P0001 with table total_issue_info_tmp ### Expected Behavior the sql runs well on Navicat, I expect jsqlparser parses it also well ### Actual Behavior...

proteen

**Describe the bug** CREATE TRIGGER sql queries do NOT get parsed nor validated. **To Reproduce** Steps to reproduce the behavior: 1. Example SQL: _create trigger stud_marks before INSERT on Student...

atharmutallib

4.3Release：Error SQL:select database() from dual

2

**DB : mysql5.7** **JSqlParser : 4.3** ``` public static void main(String[] args) { String sql = "select database() from dual"; try { Statement statement = CCJSqlParserUtil.parse(sql); System.out.println(statement.toString()); } catch (JSQLParserException...

ahgaoyong

Parse sql error with offset and limit

1

**Describe the bug** parse sql error with offset and limit **To Reproduce** Steps to reproduce the behavior: 1. Example SQL：`select * from dual OFFSET ? LIMIT ?;` 2. Parsing this...

ldbmcs