Is it possible to make Calcite SqlParser accept queries on column with name
"value" without quoting ?
like
insert into mytable(name,value values(1,2)
I am using Mysql 5.5 conformance and lex
below the error
Cheers
Enrico
org.apache.calcite.sql.parser.SqlParseException: Encountered ", value" at
line 1, column 37.
Was expecting one of:
")" ...
"CHARACTER" ...
"CHAR" ...
"VARCHAR" ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"DECIMAL" ...
"DEC" ...
"NUMERIC" ...
"BOOLEAN" ...
"INTEGER" ...
"INT" ...
"BINARY" ...
"VARBINARY" ...
"TINYINT" ...
"SMALLINT" ...
"BIGINT" ...
"REAL" ...
"DOUBLE" ...
"FLOAT" ...
"ANY" ...
"MULTISET" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"." ...
"," <IDENTIFIER> ...
"," <QUOTED_IDENTIFIER> ...
"," <BACK_QUOTED_IDENTIFIER> ...
"," <BRACKET_QUOTED_IDENTIFIER> ...
"," <UNICODE_QUOTED_IDENTIFIER> ...
herddb.model.StatementExecutionException
org.apache.calcite.sql.parser.SqlParseException: Encountered ", value" at
line 1, column 37.
Was expecting one of:
")" ...
"CHARACTER" ...
"CHAR" ...
"VARCHAR" ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"DECIMAL" ...
"DEC" ...
"NUMERIC" ...
"BOOLEAN" ...
"INTEGER" ...
"INT" ...
"BINARY" ...
"VARBINARY" ...
"TINYINT" ...
"SMALLINT" ...
"BIGINT" ...
"REAL" ...
"DOUBLE" ...
"FLOAT" ...
"ANY" ...
"MULTISET" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"." ...
"," <IDENTIFIER> ...
"," <QUOTED_IDENTIFIER> ...
"," <BACK_QUOTED_IDENTIFIER> ...
"," <BRACKET_QUOTED_IDENTIFIER> ...
"," <UNICODE_QUOTED_IDENTIFIER> ...
at herddb.sql.CalcitePlanner.translate(CalcitePlanner.java:249)
at herddb.core.TestUtils.executeUpdate(TestUtils.java:43)
at
herddb.core.SecondaryIndexAccessSuite.secondaryIndexPrefixScanInSubquery(SecondaryIndexAccessSuite.java:396)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:369)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:275)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:239)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:160)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:373)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:334)
at
org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:119)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:407)
Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered ",
value" at line 1, column 37.
Was expecting one of:
")" ...
"CHARACTER" ...
"CHAR" ...
"VARCHAR" ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"DECIMAL" ...
"DEC" ...
"NUMERIC" ...
"BOOLEAN" ...
"INTEGER" ...
"INT" ...
"BINARY" ...
"VARBINARY" ...
"TINYINT" ...
"SMALLINT" ...
"BIGINT" ...
"REAL" ...
"DOUBLE" ...
"FLOAT" ...
"ANY" ...
"MULTISET" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"." ...
"," <IDENTIFIER> ...
"," <QUOTED_IDENTIFIER> ...
"," <BACK_QUOTED_IDENTIFIER> ...
"," <BRACKET_QUOTED_IDENTIFIER> ...
"," <UNICODE_QUOTED_IDENTIFIER> ...
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:350)
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:131)
at
org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:138)
at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:163)
at org.apache.calcite.prepare.PlannerImpl.parse(PlannerImpl.java:179)
at herddb.sql.CalcitePlanner.runPlanner(CalcitePlanner.java:256)
at herddb.sql.CalcitePlanner.translate(CalcitePlanner.java:234)
... 27 more
Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered
", value" at line 1, column 37.
Was expecting one of:
")" ...
"CHARACTER" ...
"CHAR" ...
"VARCHAR" ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"DECIMAL" ...
"DEC" ...
"NUMERIC" ...
"BOOLEAN" ...
"INTEGER" ...
"INT" ...
"BINARY" ...
"VARBINARY" ...
"TINYINT" ...
"SMALLINT" ...
"BIGINT" ...
"REAL" ...
"DOUBLE" ...
"FLOAT" ...
"ANY" ...
"MULTISET" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"." ...
"," <IDENTIFIER> ...
"," <QUOTED_IDENTIFIER> ...
"," <BACK_QUOTED_IDENTIFIER> ...
"," <BRACKET_QUOTED_IDENTIFIER> ...
"," <UNICODE_QUOTED_IDENTIFIER> ...
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.generateParseException(SqlParserImpl.java:22557)
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImpl.java:22374)
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.ParenthesizedCompoundIdentifierList(SqlParserImpl.java:4436)
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlInsert(SqlParserImpl.java:1147)
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:792)
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:814)
at
org.apache.calcite.sql.parser.impl.SqlParserImpl.parseSqlStmtEof(SqlParserImpl.java:187)
at
org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:131)
... 31 more
