You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Enrico Olivelli <eo...@gmail.com> on 2017/11/16 14:01:50 UTC
Columns with name "value"
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
Re: Columns with name "value"
Posted by Enrico Olivelli <eo...@gmail.com>.
Il ven 17 nov 2017, 18:59 Michael Mior <mm...@uwaterloo.ca> ha scritto:
> You could certainly do this by modifying the parser to remove sequence
> expressions (where the VALUE keyword is used) if you don't need them.
> However, this wouldn't be something I would recommend and
not something
> that we would merge into Calcite.
>
Oh, I don't like forks. I think I will try to live without this
Cheers
Enrico
>
> --
> Michael Mior
> mmior@apache.org
>
> 2017-11-17 3:32 GMT-05:00 Enrico Olivelli <eo...@gmail.com>:
>
> > I see, but unfortunately MySQL allows such id.
> > Do you think it is not possible at all to add a flag to allow it?
> > Enrico
> >
> > Il ven 17 nov 2017, 02:02 Julian Hyde <jh...@apache.org> ha scritto:
> >
> > > No, it isn’t possible. VALUE is a reserved keyword in Calcite and in
> > > standard SQL.
> > >
> > > Either quote it or rename the column.
> > >
> > > Julian
> > >
> > >
> > > > On Nov 16, 2017, at 6:01 AM, Enrico Olivelli <eo...@gmail.com>
> > > wrote:
> > > >
> > > > 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.secondaryIndexPrefixScanInSubq
> > uery(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
> > >
> > > --
> >
> >
> > -- Enrico Olivelli
> >
>
--
-- Enrico Olivelli
Re: Columns with name "value"
Posted by Michael Mior <mm...@uwaterloo.ca>.
You could certainly do this by modifying the parser to remove sequence
expressions (where the VALUE keyword is used) if you don't need them.
However, this wouldn't be something I would recommend and not something
that we would merge into Calcite.
--
Michael Mior
mmior@apache.org
2017-11-17 3:32 GMT-05:00 Enrico Olivelli <eo...@gmail.com>:
> I see, but unfortunately MySQL allows such id.
> Do you think it is not possible at all to add a flag to allow it?
> Enrico
>
> Il ven 17 nov 2017, 02:02 Julian Hyde <jh...@apache.org> ha scritto:
>
> > No, it isn’t possible. VALUE is a reserved keyword in Calcite and in
> > standard SQL.
> >
> > Either quote it or rename the column.
> >
> > Julian
> >
> >
> > > On Nov 16, 2017, at 6:01 AM, Enrico Olivelli <eo...@gmail.com>
> > wrote:
> > >
> > > 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.secondaryIndexPrefixScanInSubq
> uery(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
> >
> > --
>
>
> -- Enrico Olivelli
>
Re: Columns with name "value"
Posted by Enrico Olivelli <eo...@gmail.com>.
I see, but unfortunately MySQL allows such id.
Do you think it is not possible at all to add a flag to allow it?
Enrico
Il ven 17 nov 2017, 02:02 Julian Hyde <jh...@apache.org> ha scritto:
> No, it isn’t possible. VALUE is a reserved keyword in Calcite and in
> standard SQL.
>
> Either quote it or rename the column.
>
> Julian
>
>
> > On Nov 16, 2017, at 6:01 AM, Enrico Olivelli <eo...@gmail.com>
> wrote:
> >
> > 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
>
> --
-- Enrico Olivelli
Re: Columns with name "value"
Posted by Julian Hyde <jh...@apache.org>.
No, it isn’t possible. VALUE is a reserved keyword in Calcite and in standard SQL.
Either quote it or rename the column.
Julian
> On Nov 16, 2017, at 6:01 AM, Enrico Olivelli <eo...@gmail.com> wrote:
>
> 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