[
https://issues.apache.org/jira/browse/IGNITE-19804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-19804:
----------------------------------------
Description:
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]*
was:
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]*
> 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
>
> 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)
