[IGNITE-15576] Calcite. Prepared statements support.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite calcite2-required calcite3-required ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 23/Sep/21 13:51
• Updated: 23/Sep/21 13:51

Description

Support PREPARED [1] statements. There are some differs in syntax, i found :
1. PREPARE v1 AS SELECT * FROM test2 LIMIT 3
vs
2. PREPARE v1 FROM 'SELECT * FROM test2 LIMIT 3';

[1] https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html

statement ok
PREPARE v1 FROM 'SELECT * FROM test2 LIMIT 3';

query I
EXECUTE v1
----
Hello World

/order/test_limit.test[_ignore]

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine