[ https://issues.apache.org/jira/browse/IGNITE-19804 ]
Yury Gerzhedovich deleted comment on IGNITE-19804:
--------------------------------------------
was (Author: jooger):
[~zstan] LGTM
> Sql. Fix timestamp|datetime processing errors
> ---------------------------------------------
>
> Key: IGNITE-19804
> URL: https://issues.apache.org/jira/browse/IGNITE-19804
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: calcite3-required, ignite-3
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Some cases are failed:
> case 1:
> {noformat}
> CREATE TABLE IF NOT EXISTS timestamp (t TIMESTAMP);
> INSERT INTO timestamp VALUES ('2008-01-01 00:00:01'), (NULL), ('2007-01-01
> 00:00:01')
> {noformat}
> *Values passed to VALUES operator must have compatible types*
> case 2:
> SELECT timestamp '2017-07-23 13:10:11';
> *Not expected result at: (test_timestamp.test_ignore:15). [row=0, col=0,
> expected=2017-07-23 13:10:11, actual=2017-07-23T13:10:11]*
> case 3:
> SELECT TIMESTAMP '2001-04-20 14:42:11.12300000000000000000';
> *Not expected result at: (test_timestamp_ms.test_ignore:6). [row=0, col=0,
> expected=2001-04-20 14:42:11.123, actual=2001-04-20T14:42:11.123]*
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
