Pavel Tupitsyn created IGNITE-24576:
---------------------------------------
Summary: Catalog API: Failed to parse query: Encountered asc
Key: IGNITE-24576
URL: https://issues.apache.org/jira/browse/IGNITE-24576
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.0
Reporter: Pavel Tupitsyn
Fix For: 3.1
The following code fails with *SqlException*:
{code:java}
TableDefinition tableDefinition = TableDefinition.builder("TBL")
.columns(
ColumnDefinition.column("ID", ColumnType.INT32),
ColumnDefinition.column("NAME", ColumnType.VARCHAR))
.primaryKey("ID")
.index("IDX_NAME", IndexType.HASH, ColumnSorted.column("NAME",
SortOrder.ASC))
.build();
Table table = client.catalog().createTable(tableDefinition);
{code}
Exception:
{code}
IGN-SQL-3 TraceId:941e19fe-72f9-495f-966d-fe54d7b6908b Failed to parse query:
Encountered "asc" at line 2, column 72
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.convertException(IgniteSqlParser.java:220)
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.parse(IgniteSqlParser.java:129)
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.parse(IgniteSqlParser.java:91)
at
org.apache.ignite.internal.sql.engine.sql.ParserServiceImpl.parseScript(ParserServiceImpl.java:89)
at
org.apache.ignite.internal.sql.engine.exec.fsm.QueryExecutor.parseScript(QueryExecutor.java:260)
at
org.apache.ignite.internal.sql.engine.exec.fsm.ParsingPhaseHandler.lambda$handle$0(ParsingPhaseHandler.java:48)
at
org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:86)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.base/java.lang.Thread.run(Unknown Source){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
