[jira] [Created] (IGNITE-15616) Calcite. Failed to parse UPDATE query.

[Evgeny Stanilovsky (Jira)]

Evgeny Stanilovsky created IGNITE-15616:
-------------------------------------------

             Summary: Calcite. Failed to parse UPDATE query.
                 Key: IGNITE-15616
                 URL: https://issues.apache.org/jira/browse/IGNITE-15616
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Evgeny Stanilovsky



{noformat}
statement ok
UPDATE integers i1 SET i=DEFAULT WHERE i=(SELECT MIN(i) FROM integers WHERE 
i1.id<id);

query II
SELECT id, i FROM integers ORDER BY id
----
1       NULL
2       NULL
3       2
4       3
{noformat}


{noformat}
Statement [queries=ArrayList [UPDATE integers i1 SET i=DEFAULT WHERE i=(SELECT 
MIN(i) FROM integers WHERE i1.id<id);], expected=OK]

        at 
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Statement.execute(SqlScriptRunner.java:404)
        at 
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner.run(SqlScriptRunner.java:115)
        at 
org.apache.ignite.internal.processors.query.calcite.logical.ScriptTestRunner$1.run(ScriptTestRunner.java:219)
        at java.lang.Thread.run(Thread.java:748)
Caused by: class 
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse 
query.
        at 
org.apache.ignite.internal.processors.query.calcite.util.Commons.parse(Commons.java:205)
{noformat}


{noformat}
/subquery/scalar/test_update_subquery.test
{noformat}





--
This message was sent by Atlassian Jira
(v8.3.4#803005)