Julian Hyde created CALCITE-664:
-----------------------------------
Summary: Parameterized DML and DDL
Key: CALCITE-664
URL: https://issues.apache.org/jira/browse/CALCITE-664
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
The JDBC spec allows DML statements to have parameters and seems to allow DDL
(e.g. CREATE TABLE AS SELECT) to have them too. Currently Avatica only allows
queries to be parameterized.
This implies that you can do Connection.prepareStatement on query, DML, DDL,
and it would tell you the number and types of parameters. Then you can bind,
and execute using PreparedStatement.executeQuery(), execute(), executeUpdate().
(Note - there are versions of these methods in Statement which take a String
parameter. You can't use those.)
See discussion
http://mail-archives.apache.org/mod_mbox/incubator-calcite-dev/201503.mbox/%3CCANZa%3DGsJUJToo4cdygguv8h5h2XjK3eD3oP5-k6rSPvm9qTYZg%40mail.gmail.com%3E
and PHOENIX-971.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
