[
https://issues.apache.org/jira/browse/IGNITE-24576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17952102#comment-17952102
]
Pavel Tupitsyn commented on IGNITE-24576:
-----------------------------------------
Merged to main:
https://github.com/apache/ignite-3/commit/0bb6a754cfa3194f5f8e3e530d51292e1ccbd1bc
> 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
> Assignee: Tiago Marques Godinho
> Priority: Major
> Labels: ignite-3
> 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}
> Generated SQL:
> {code:sql}
> CREATE TABLE PUBLIC.Person2 (ID int, NAME varchar, PRIMARY KEY (ID));
> CREATE INDEX IF NOT EXISTS IDX_NAME ON PUBLIC.Person2 USING HASH (NAME asc);
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
