[CALCITE-530] Phoenix support - ASF JIRA

XML

Word

Printable

JSON

Changes to support Phoenix's SQL extensions & semantics.

Sub-tasks, most important first:

~~CALCITE-493~~ Support syntax for defining columns and their types at
query/DML time
~~CALCITE-505~~ Support updatable VIEW
~~CALCITE-497~~ Support optional qualifier for column name references
~~CALCITE-492~~ Support UPSERT statement in parser
~~CALCITE-494~~ Support NEXT/CURRENT VALUE FOR syntax for sequences usage
CALCITE-496 Allow key/value properties to be passed through DDL statements
~~CALCITE-495~~ Support hints to be passed through select/DML commands

depends upon

CALCITE-1845 Quantified comparison predicates (SOME, ANY, ALL)

1.	Add EXTEND clause, for defining columns and their types at query/DML time	Closed	Julian Hyde
2.	Support updatable VIEW	Closed	Julian Hyde
3.	Support optional qualifier for column name references	Closed	Julian Hyde
4.	Support UPSERT statement in parser	Closed	Julian Hyde
5.	Support NEXT/CURRENT VALUE FOR syntax for sequences usage	Closed	Julian Hyde
6.	Allow key/value properties to be passed through DDL statements	Open	Unassigned
7.	Support hints to be passed through select/DML commands	Closed	Danny Chen
8.	Differentiate between column not found and ambiguous column exceptions	Closed	Julian Hyde
9.	Track references to record fields in addition to columns	Open	Unassigned
10.	Validate and resolve sequence reference as a Table object	Closed	Wei Xue