Chris Baynes created CALCITE-1793:
-------------------------------------
Summary: Allow RelBuilder to make calls to EXTRACT
Key: CALCITE-1793
URL: https://issues.apache.org/jira/browse/CALCITE-1793
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.11.0, 1.12.0
Reporter: Chris Baynes
Assignee: Julian Hyde
Priority: Minor
EXTRACT_DATE was originally intended
to be an internal function, always created by translating a call to
EXTRACT.
Currently this makes the EXTRACT_DATE function rather awkward to use:
{code}
SqlOperator op = new SqlSpecialOperator("EXTRACT_DATE", SqlKind.EXTRACT, 2,
true, ReturnTypes.INTEGER, null, null);
builder.call(op, builder.getRexBuilder().makeFlag(TimeUnitRange.YEAR),
builder.field(1, 0, "my_date"));
{code}
[~julianhyde] suggests calling EXTRACT directly and then have
RelBuilder invoke a convertlet to translate into calls to
EXTRACT_DATE or date-time arithmetic:
[http://mail-archives.apache.org/mod_mbox/calcite-dev/201705.mbox/%3CCAPSgeET9OVWkvGsGXAezqhqP3Zd2dmXxs0k-J92WZM32%2BMq3kw%40mail.gmail.com%3E]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
