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)

Reply via email to