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

["Stamatis Zampetakis (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stamatis Zampetakis updated CALCITE-2395:
-----------------------------------------
    Labels: pull-request-available  (was: )

> 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
>            Priority: Major
>              Labels: pull-request-available
>
> 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)