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