[
https://issues.apache.org/jira/browse/IGNITE-23230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ilya Shishkov updated IGNITE-23230:
-----------------------------------
Description:
Such query:
{code}
INSERT INTO THIRD SELECT 0, (SELECT 1 FROM FIRST UNION ALL SELECT 2 FROM SECOND)
{code}
will fail with a following error:
{code}
class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
parse query.
{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
>
> Such query:
> {code}
> INSERT INTO THIRD SELECT 0, (SELECT 1 FROM FIRST UNION ALL SELECT 2 FROM
> SECOND)
> {code}
> will fail with a following error:
> {code}
> class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed
> to parse query.
> {code}
> Reproducer:
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
