You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi:
when use JSqlParser to parse sql then occur exception
Test create table ddl with range partition code like blew:
@test
public void test_CreateTablePartition() throws JSQLParserException {
String sqlString = "CREATE TABLE t1 (\n"
+ " id INT,\n"
+ " year_col INT\n"
+ ")\n"
+ "PARTITION BY RANGE (year_col) (\n"
+ " PARTITION p0 VALUES LESS THAN (1991),\n"
+ " PARTITION p1 VALUES LESS THAN (1995),\n"
+ " PARTITION p2 VALUES LESS THAN (1999)\n"
+ ");";
Statement statement = CCJSqlParserUtil.parse(sqlString);
}
Exception like blew:
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "RANGE" "RANGE"
at line 5, column 14.
Was expecting one of:
";"
"AS"
"DISABLE"
"ENABLE"
"LIKE"
<EOF>
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:258)
... 74 more
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "RANGE" "RANGE"
at line 5, column 14.
Was expecting one of:
";"
"AS"
"DISABLE"
"ENABLE"
"LIKE"
<EOF>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:33398)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:33231)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:167)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:253)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:250)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Test alter table ddl with range partition code like blew:
@test
public void test_alterTablePartition() throws JSQLParserException {
String sqlString = "ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002))";
Statement statement = CCJSqlParserUtil.parse(sqlString);
}
`
Exception blew:
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 1, column 30.
Was expecting:
"COMMENT"
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:258)
... 74 more
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 1, column 30.
The text was updated successfully, but these errors were encountered:
PARTITION is not supported/implemented for both CREATE TABLE and ALTER TABLE statements.
Please either send a PR or sponsor an implementation, when you are interested in this feature.
Hi:
when use JSqlParser to parse sql then occur exception
Test create table ddl with range partition code like blew:
@test
public void test_CreateTablePartition() throws JSQLParserException {
String sqlString = "CREATE TABLE t1 (\n"
+ " id INT,\n"
+ " year_col INT\n"
+ ")\n"
+ "PARTITION BY RANGE (year_col) (\n"
+ " PARTITION p0 VALUES LESS THAN (1991),\n"
+ " PARTITION p1 VALUES LESS THAN (1995),\n"
+ " PARTITION p2 VALUES LESS THAN (1999)\n"
+ ");";
Statement statement = CCJSqlParserUtil.parse(sqlString);
}
Exception like blew:
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "RANGE" "RANGE"
at line 5, column 14.
Was expecting one of:
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "RANGE" "RANGE"
at line 5, column 14.
Was expecting one of:
=======================================================
Test alter table ddl with range partition code like blew:
@test
public void test_alterTablePartition() throws JSQLParserException {
`
Exception blew:
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 1, column 30.
Was expecting:
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 1, column 30.
The text was updated successfully, but these errors were encountered: