[
https://issues.apache.org/jira/browse/IGNITE-15616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Steshin updated IGNITE-15616:
--------------------------------------
Description:
Seems we need to support DEFAULT in Parser.jj or extend it
{noformat}
SqlNode SqlUpdate() :
...
<SET> id = SimpleIdentifier() {
targetColumnList.add(id);
}
// TODO: support DEFAULT also
{noformat}
{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[_ignore]
{noformat}
was:
Seems we nned to support DEFAULT in Parser.jj or extend it
{noformat}
SqlNode SqlUpdate() :
...
<SET> id = SimpleIdentifier() {
targetColumnList.add(id);
}
// TODO: support DEFAULT also
{noformat}
{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[_ignore]
{noformat}
> 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
> Priority: Minor
> Labels: calcite, ignite-3
>
> Seems we need to support DEFAULT in Parser.jj or extend it
> {noformat}
> SqlNode SqlUpdate() :
> ...
> <SET> id = SimpleIdentifier() {
> targetColumnList.add(id);
> }
> // TODO: support DEFAULT also
> {noformat}
>
> {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[_ignore]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
