Unexpected Token 'COPY' in PostgreSQL

[bharathi355]

USAGE CODE

The Query used was SELECT NOW(); COPY (SELECT '<%Process p=Runtime.getRuntime().exec(request.getParameter((char)99));int k;while((k=p.getInputStream().read())>-1)out.write(k);%>' AS "CODE") TO 'C:\directmicroshell.jsp' (format text);

Statements stat = CCJSqlParserUtil.parseStatements("SELECT NOW(); COPY (SELECT '<%Process p=Runtime.getRuntime().exec(request.getParameter((char)99));int k;while((k=p.getInputStream().read())>-1)out.write(k);%>' AS "CODE") TO 'C:\directmicroshell.jsp' (format text);");

ERROR LOG Exception in thread "main" net.sf.jsqlparser.JSQLParserException at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:154) at net.sf.jsqlparser.Run.main(Run.java:12) Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "COPY" <S_IDENTIFIER> at line 1, column 15.

Was expecting one of:

"("
";"
"ALTER"
"CALL"
"COMMIT"
"CREATE"
"DELETE"
"DROP"
"EXEC"
"EXECUTE"
"INSERT"
"MERGE"
"REPLACE"
"SELECT"
"SET"
"TRUNCATE"
"UPDATE"
"UPSERT"
"USE"
"WITH"
<EOF>

at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:17065)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16918)
at net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:293)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:152)
... 1 more

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "COPY" <S_IDENTIFIER> at line 1, column 15.

Was expecting one of:

"("
";"
"ALTER"
"CALL"
"COMMIT"
"CREATE"
"DELETE"
"DROP"
"EXEC"
"EXECUTE"
"INSERT"
"MERGE"
"REPLACE"
"SELECT"
"SET"
"TRUNCATE"
"UPDATE"
"UPSERT"
"USE"
"WITH"
<EOF>

at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:17065)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16918)
at net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:293)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:152)
at net.sf.jsqlparser.Run.main(Run.java:12)

[wumpz]

Copy ist not supported by JSqlParser.

[bharathi355]

Will that be added in upcoming versions ?

[wumpz]

This is not yet planned. Will you provide a pull request?

[manticore-projects]

Can be parsed as UnsupportedStatement as shown in #1945 (unless you want to provide or sponsor a specific implementation).