[ https://issues.apache.org/jira/browse/IGNITE-8716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16502924#comment-16502924 ]
Vladimir Ozerov commented on IGNITE-8716: ----------------------------------------- As per H2 docs now it supports column name inference. Most probably update to newer version will resolve this problem. > SQL query and WITH caluse produces syntax error > ----------------------------------------------- > > Key: IGNITE-8716 > URL: https://issues.apache.org/jira/browse/IGNITE-8716 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 2.5 > Reporter: Pavel Vinokurov > Priority: Major > > Initial script: > CREATE TABLE Person(ID INTEGER PRIMARY KEY, NAME VARCHAR(100)); > Query: > WITH usr AS ( > SELECT * FROM Person p > ) > select u.* from usr as u > Result: > Error: Syntax error in SQL statement "WITH USR AS[*] ( SELECT * FROM PERSON P > ) SELECT U.* FROM USR AS U "; expected "., ("; SQL statement: WITH usr AS ( > SELECT * FROM Person p ) select u.* from usr as u [42001-195] -- This message was sent by Atlassian JIRA (v7.6.3#76005)