Skip to content

Cannot parse column rename sql without COLUMN keyword #1516

Closed
@jackiezh

Description

@jackiezh

Describe the bug
Cannot parse column rename sql without COLUMN keyword.

To Reproduce
Steps to reproduce the behavior:

  1. Example SQL
    ALTER TABLE table_a RENAME col_a TO col_b;

  2. Parsing this SQL using JSqlParser with this statements
    CCJSqlParserUtil.parse("ALTER TABLE table_a RENAME col_a TO col_b");

  3. Exception
    net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "col_a" <S_IDENTIFIER>
    at line 1, column 28.

Was expecting:

"TO"

at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
at net.sf.jsqlparser.parser.CCJSqlParser.AlterExpression(CCJSqlParser.java:17874)
at net.sf.jsqlparser.parser.CCJSqlParser.AlterTable(CCJSqlParser.java:17947)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:267)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:153)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)

System

  • Database you are using: PostgreSQL
  • Java Version: java-1.8
  • JSqlParser version: 4.4

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions