[jira] [Created] (IGNITE-23230) H2 fails to parse INSERT statement with UNION ALL subquery

["Ilya Shishkov (Jira)" <ji...@apache.org>]

Ilya Shishkov created IGNITE-23230:
--------------------------------------

             Summary: H2 fails to parse INSERT statement with UNION ALL subquery
                 Key: IGNITE-23230
                 URL: https://issues.apache.org/jira/browse/IGNITE-23230
             Project: Ignite
          Issue Type: Bug
            Reporter: Ilya Shishkov


Last query will fail with an error
{{org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query. }}:
{code}
CREATE TABLE first(id INT PRIMARY KEY, name VARCHAR, city VARCHAR)
INSERT INTO first VALUES (?, ?, ?)
 
CREATE TABLE second(id INT PRIMARY KEY, name VARCHAR, city VARCHAR)
 
CREATE TABLE third(id1 INT PRIMARY KEY, id2 INT)
 
INSERT INTO THIRD SELECT 0, (SELECT 1 FROM FIRST UNION ALL SELECT 2 FROM SECOND)
{code}

Reproducer: 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)