You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Alexander Belyak (Jira)" <ji...@apache.org> on 2023/04/13 06:18:00 UTC

[jira] [Created] (IGNITE-19282) SQL Support SELECT FOR UPDATE

Alexander Belyak created IGNITE-19282:
-----------------------------------------

             Summary: SQL Support SELECT FOR UPDATE
                 Key: IGNITE-19282
                 URL: https://issues.apache.org/jira/browse/IGNITE-19282
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Alexander Belyak


SQL:
{noformat}
create table tu3(id int primary key, val int);
  select * from tu3 for update;{noformat}
return error:
{noformat}
[Code: 0, SQL State: 50000]  Exception while executing query [query=select * from tu3 for update]. Error message:IGN-SQL-3 TraceId:aefd2182-ac47-4a6c-ae59-98461c7726d8 Failed to parse query: Encountered " "UPDATE" "update "" at line 1, column 23.
Was expecting one of:
    <EOF> 
    "," ...
    {noformat}
If FOR UPDATE syntax have no sense in the AI3 tx model - why not ignore it for better compatibility with the others?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)