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)
