[
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)
