Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
2.5
-
None
-
None
Description
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]
Attachments
Issue Links
- depends upon
-
IGNITE-4150 B-Tree index cannot be used efficiently with IN clause.
- Resolved