[ https://issues.apache.org/jira/browse/IGNITE-8342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16445645#comment-16445645 ]
Pavel Kuznetsov commented on IGNITE-8342: ----------------------------------------- reproduced on b810bd44805 > Semi colon in CREATE INDEX causes infinite loop execution > --------------------------------------------------------- > > Key: IGNITE-8342 > URL: https://issues.apache.org/jira/browse/IGNITE-8342 > Project: Ignite > Issue Type: Bug > Components: sql > Reporter: Pavel Kuznetsov > Priority: Major > Fix For: 2.5 > > > Given created table in cache > {noformat} > cache.query(new SqlFieldsQuery("CREATE INDEX AgeIndex ON Employee > (age);")).getAll(); > {noformat} > seems to cause infinite loop > jstack : > {noformat} > "main" #1 prio=5 os_prio=0 tid=0x00007fa1a800d000 nid=0x4b7c runnable > [0x00007fa1b1932000] > java.lang.Thread.State: RUNNABLE > at org.apache.ignite.internal.sql.SqlLexer.lookAhead(SqlLexer.java:73) > at > org.apache.ignite.internal.sql.command.SqlCreateIndexCommand.parseIndexProperties(SqlCreateIndexCommand.java:250) > at > org.apache.ignite.internal.sql.command.SqlCreateIndexCommand.parse(SqlCreateIndexCommand.java:172) > at > org.apache.ignite.internal.sql.SqlParser.processCreate(SqlParser.java:207) > at > org.apache.ignite.internal.sql.SqlParser.nextCommand0(SqlParser.java:106) > at > org.apache.ignite.internal.sql.SqlParser.nextCommand(SqlParser.java:76) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1509) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1599) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2035) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2030) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2578) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2044) > at > org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:664) > at > org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:615) > at > org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:356) > at > org.apache.ignite.sqltests.BaseSqlTest.fillCommonData(BaseSqlTest.java:107) > {noformat} > without semicolon sign (";") in the end of the query, it performs well. -- This message was sent by Atlassian JIRA (v7.6.3#76005)