[jira] [Created] (IGNITE-8716) SQL query and WITH caluse produces syntax error

[Anton Vinogradov (Jira)]

Pavel Vinokurov created IGNITE-8716:
---------------------------------------

             Summary: 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


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)