[
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 id FROM first UNION ALL SELECT id FROM
second)
{code}
will fail with a following error:
{code}
class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
parse query.
{code}
Query fails only in H2 engine, see attached reproducer: [^IGNITE-23230.patch]
was:
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}
Query fails only in H2 engine, see attached reproducer: [^IGNITE-23230.patch]
> 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
> Attachments: IGNITE-23230.patch
>
>
> Such query:
> {code}
> INSERT INTO third SELECT 0, (SELECT id FROM first UNION ALL SELECT id FROM
> second)
> {code}
> will fail with a following error:
> {code}
> class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed
> to parse query.
> {code}
> Query fails only in H2 engine, see attached reproducer:
> [^IGNITE-23230.patch]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
