[jira] [Created] (CALCITE-2395) Support SELECT xxx FROM TABLE FOR UPDATE syntax

Tue, 03 Jul 2018 02:25:07 -0700 

Enrico Olivelli created CALCITE-2395:
----------------------------------------

             Summary: Support SELECT xxx FROM TABLE FOR UPDATE syntax
                 Key: CALCITE-2395
                 URL: https://issues.apache.org/jira/browse/CALCITE-2395
             Project: Calcite
          Issue Type: New Feature
          Components: core
    Affects Versions: 1.16.0
            Reporter: Enrico Olivelli
            Assignee: Julian Hyde


I am using Calcite SQL Parser and Volcano Planner.

I need to support SQL syntax

SELECT ... FROM table FOR UPDATE

 

see for instance PostGre docs

[https://www.postgresql.org/docs/9.5/static/sql-select.html.]

 

I would like at least to support this syntax at SQL Parser level, the 'for 
update' spec should be reported by the RelNode so that the system can take it 
into account and perform explicit locking.

 

Linked downstream project issue:

https://github.com/diennea/herddb/issues/228

 

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to