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)