[
https://issues.apache.org/jira/browse/IGNITE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ilya Shishkov updated IGNITE-23230:
-----------------------------------
Labels: ise (was: )
> 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
> Priority: Minor
> Labels: ise
>
> 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)
