[
https://issues.apache.org/jira/browse/IGNITE-21462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-21462:
--------------------------------------
Summary: Sql. Allow using DEFAULT in UPDATE statements. (was: Sql. Allow
setting DEFAULT in UPDATE statements.)
> Sql. Allow using DEFAULT in UPDATE statements.
> ----------------------------------------------
>
> Key: IGNITE-21462
> URL: https://issues.apache.org/jira/browse/IGNITE-21462
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Minor
> Labels: ignite-3
>
> According to SQL standard update statement also allows to specify DEFAULT
> instead of an expression:
> {code:java}
> @Test
> public void testUpdateDefault() {
> sql("CREATE TABLE t (id INTEGER PRIMARY KEY, val INTEGER DEFAULT 42)");
> sql("INSERT INTO t VALUES(1, 0)");
> sql("UPDATE t SET val = DEFAULT WHERE id = 1");
> }
> {code}
> But SQL parser can not parse such statement an returns an err
> {code:java}
> Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-5
> TraceId:90bce644-7799-4b0e-b132-60b26e7ba2da Failed to parse query: Incorrect
> syntax near the keyword 'DEFAULT' at line 1, column 20
> at
> org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.convertException(IgniteSqlParser.java:203)
> at
> org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.parse(IgniteSqlParser.java:112)
> at
> org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.parse(IgniteSqlParser.java:77)
> at
> org.apache.ignite.internal.sql.engine.sql.ParserServiceImpl.parse(ParserServiceImpl.java:65)
> at
> org.apache.ignite.internal.sql.engine.SqlQueryProcessor.lambda$querySingle0$10(SqlQueryProcessor.java:572)
> at
> java.base/java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1072)
> ... 6 more
> {code}
> or:
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
