[
https://issues.apache.org/jira/browse/IGNITE-22347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-22347:
----------------------------------------
Description:
According to standard:
_6.19 <datetime value function>_
Feature F411, syntax like :
{noformat}
If <time precision> TP is specified, then LOCALTIME(TP) is equivalent to:
CAST (CURRENT_TIME(TP) AS TIME(TP) WITHOUT TIME ZONE)
{noformat}
need to be supported, seems it fixed in calcite 1.37, issue [1].
We need to check it after calcite ver update and append new tests
[1] https://issues.apache.org/jira/browse/CALCITE-6138
was:
According to standard:
_6.19 <datetime value function>_
syntax like :
{noformat}
If <time precision> TP is specified, then LOCALTIME(TP) is equivalent to:
CAST (CURRENT_TIME(TP) AS TIME(TP) WITHOUT TIME ZONE)
{noformat}
need to be supported, seems it fixed in calcite 1.37, issue [1].
We need to check it after calcite ver update and append new tests
[1] https://issues.apache.org/jira/browse/CALCITE-6138
> Sql. WITH TIME ZONE syntax support.
> -----------------------------------
>
> Key: IGNITE-22347
> URL: https://issues.apache.org/jira/browse/IGNITE-22347
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
>
> According to standard:
> _6.19 <datetime value function>_
> Feature F411, syntax like :
> {noformat}
> If <time precision> TP is specified, then LOCALTIME(TP) is equivalent to:
> CAST (CURRENT_TIME(TP) AS TIME(TP) WITHOUT TIME ZONE)
> {noformat}
> need to be supported, seems it fixed in calcite 1.37, issue [1].
> We need to check it after calcite ver update and append new tests
> [1] https://issues.apache.org/jira/browse/CALCITE-6138
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
