JSqlParser

JSqlParser copied to clipboard

support for (date({fn timestampadd(SQL_TSI_YEAR, 2, date("travel_date"))}))

4

Hi Want to know, do we have support for expressions like (date({fn timestampadd(SQL_TSI_YEAR, 2, date("travel_date"))})) i want to extract column name from the given expression i.e travel_date whenever i parse...

karth06

Support complex expressions in select clause

1

The SELECT clause can contain complex expressions, for example "(condition) OR (condition)", which actually returns a boolean. Sample query: `SELECT (CASE WHEN col IS NULL THEN False ELSE True END)...

tomershay

Like statement does not support ESCAPE with parameter

8

the following sql fails to parse: > SELECT last_name FROM employees WHERE last_name LIKE ? ESCAPE ? this one works: > SELECT last_name FROM employees WHERE last_name LIKE ? ESCAPE...

dondank

subtract int from date doesn't work

2

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: 1. `SELECT true WHERE '2001-09-28' < date '2001-09-28' + integer...

sixinli

`= BINARY ` AND `LIKE BINARY` are not support

1

### Actual Behavior ```java String sql = "SELECT Name FROM T_User WHERE Name = BINARY 'test' OR Name LIKE BINARY 'test-%'"; Statement stmt = CCJSqlParserUtil.parse(sql); ``` When I ran these...

lastmayday

Modify column with "NULL" or "NOT NULL" is not getting parsed.

3

### Actual Behavior On parsing statement ALTER TABLE MODIFY NOT NULL getting ParseException `Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "NOT" "NOT "" at line 1, column 51. Was expecting one of:...

VaibhavJain

Unable to wrap expression in brackets

2

**Bug** The following (Postgres?) queries cannot be parsed: ```sql SELECT (integer '1'); -- Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\'1\'" -- at line 1, column 17. SELECT * FROM tmp2...

SerialVelocity

PostgreSQL nextval()

2

PostgreSQL reversed engineer schema includes nextval as a function, like below. Is it possible to support this? CREATE TABLE pagila_dev.actor ( actor_id integer DEFAULT nextval('pagila_dev.actor_actor_id_seq'::regclass) NOT NULL, first_name text NOT...

dprutean

SQL "update" statement does not recognize queries as array indexes

2

**Describe the bug** SQL "update" statement with an array index are not recognized **To Reproduce** Steps to reproduce the behavior: 1. Example SQL `update utilisateur set listes[(select cardinality(listes))] = 1;`...

freya022

Unexpected token: apply

3

**Describe the bug** There is a sql which i can run with mysql success, but if with jsqlparser, got an exception **To Reproduce** Steps to reproduce the behavior: 1. Example...

Fioooooooo