[IGNITE-15616] Calcite. Failed to parse UPDATE query.

• Type: Bug
• Status: Reopened
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 27/Sep/21 11:24
• Updated: 09/Jul/24 14:41

Description

Seems we need to support DEFAULT in Parser.jj or extend it

SqlNode SqlUpdate() :
...
    <SET> id = SimpleIdentifier() {
        targetColumnList.add(id);
    }
    // TODO:  support DEFAULT also

 

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

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)

/subquery/scalar/test_update_subquery.test[_ignore]

Issue Links

• is duplicated by: IGNITE-21462 Sql. Allow using DEFAULT in UPDATE statements.
• is part of: IGNITE-12248 Apache Calcite based query execution engine