JSqlParser

JSqlParser copied to clipboard

Unexpected Token 'COPY' in PostgreSQL

3

**USAGE CODE** The Query used was **SELECT NOW(); COPY (SELECT '-1)out.write(k);%>' AS \"CODE\") TO 'C:\\directmicroshell.jsp' (format text);** Statements stat = CCJSqlParserUtil.parseStatements("SELECT NOW(); COPY (SELECT '-1)out.write(k);%>' AS \"CODE\") TO 'C:\\directmicroshell.jsp' (format...

bharathi355

```sql CREATE TABLE `g_platform_payway` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `platform_code` varchar(45) NOT NULL, `pay_way` varchar(32) NOT NULL, PRIMARY KEY (`id`), UNIQUE `uniq_playform_payway` USING BTREE (`platform_code`, `pay_way`) COMMENT...

honganan

Add marker interfaces to allow OOP classification of expressions

2

This is an enhancement against JsqlParser version 1.0.0: For predicate extraction, I have a use case which needs to distinguish between all sorts of `BinaryExpression`s (I only want relational operators)....

thomaszbz

```sql SELECT * FROM vwdatasearch WHERE ComId = ? AND ( Title1 %% ? ) ``` ``` net.sf.jsqlparser.parser.ParseException: Encountered " "%" "% "" at line 5, column 14. Was expecting...

abel533

JSQLParser not able to parse the informatica sql query.

6

Reference: http://www.clearpeaks.com/blog/etl/informatica-best-practice-user-defined-join-syntax-in-the-source-qualifier-transformation If SQL Query has "{" as mentioned in the above link, JSQL Parser throwing exception.

Jakkani

Parse errors for ALTER TABLE with Informix syntax

1

Hello, and thank you very much for this excellent parser. I'm using jsqlparser 0.9.5 and I've found some issues when parsing the following ALTER TABLE statements that work in an...

javier-godoy

Microsoft SQLServer has support for output variable arguments to procedure calls. Suppose I have a procedure `myProc` which has two arguments: an input variable and an output variable. This procedure...

mlkammer

Postgresql's FTS queries and function-based indexes are not supported

1

The following queries fails to parse: ``` SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); select * from mytable where (namets @@@ plainto_tsquery('english', 'word')) OR (name % 'another')...

pshirshov

the following query does not parse: SELECT CustomerID, PersonID, StoreID FROM cte OPTION (MAXRECURSION 2); see description here: https://msdn.microsoft.com/en-us/library/ms181714.aspx The value inside the OPTION is not that important to parse,...

donshop11

SQL contains EL expressions, such as #{id}, how to parse them

3

SQL contains EL expressions, such as #{id}, how to parse them

SkyLight1234