Changeset: 295431d8b05d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=295431d8b05d
Removed Files:
sql/test/snodgrass/Tests/interval_table.test
Modified Files:
sql/test/snodgrass/Tests/cast_select.test
sql/test/snodgrass/Tests/interval_parsing.test
Branch: mtest
Log Message:
Interval values not correctly converted
diffs (105 lines):
diff --git a/sql/test/snodgrass/Tests/cast_select.test
b/sql/test/snodgrass/Tests/cast_select.test
--- a/sql/test/snodgrass/Tests/cast_select.test
+++ b/sql/test/snodgrass/Tests/cast_select.test
@@ -39,7 +39,7 @@ True
query T rowsort
SELECT CAST('2' AS INTERVAL MONTH )
----
-(empty)
+2
statement error
SELECT CAST('3-7' AS INTERVAL MONTH )
@@ -55,7 +55,7 @@ SELECT CAST( 103 AS INTERVAL MONTH ) = I
query T rowsort
SELECT CAST('2 12:34' AS INTERVAL DAY TO MINUTE )
----
-18040.00
+2 days, 12:34:00
statement error
SELECT CAST('12:34' AS INTERVAL DAY TO MINUTE )
diff --git a/sql/test/snodgrass/Tests/interval_parsing.test
b/sql/test/snodgrass/Tests/interval_parsing.test
--- a/sql/test/snodgrass/Tests/interval_parsing.test
+++ b/sql/test/snodgrass/Tests/interval_parsing.test
@@ -1,35 +1,35 @@
query T rowsort
SELECT INTERVAL '3' YEAR
----
-(empty)
+36
query T rowsort
SELECT INTERVAL '7' MONTH
----
-(empty)
+7
query T rowsort
SELECT INTERVAL '3-7' YEAR TO MONTH
----
-(empty)
+43
query T rowsort
SELECT INTERVAL -'3-7' YEAR TO MONTH
----
-4
+-43
query T rowsort
SELECT INTERVAL +'0-0' YEAR TO MONTH
----
-(empty)
+0
query T rowsort
SELECT INTERVAL -'0-0' YEAR TO MONTH
----
-(empty)
+0
query T rowsort
SELECT INTERVAL '1 23:45:12' DAY TO SECOND
----
-71912.00
+1 day, 23:45:12
diff --git a/sql/test/snodgrass/Tests/interval_table.test
b/sql/test/snodgrass/Tests/interval_table.test
deleted file mode 100644
--- a/sql/test/snodgrass/Tests/interval_table.test
+++ /dev/null
@@ -1,33 +0,0 @@
-statement ok
-CREATE TABLE Employee( Id INTEGER, BirthDate DATE )
-
-statement ok
-INSERT INTO Employee VALUES( 77, '1970-01-01')
-
-statement ok
-INSERT INTO Employee VALUES( 88, '1971-12-13')
-
-statement error
-SELECT * FROM Employee WHERE ( BirthDate, INTERVAL '0' DAY ) OVERLAPS ( DATE
'1970-01-01', INTERVAL '0' DAY )
-
-statement error
-SELECT * FROM Employee WHERE ( BirthDate, BirthDate ) OVERLAPS ( DATE
'1970-01-01', INTERVAL '0' DAY )
-
-statement error
-SELECT * FROM Employee WHERE ( BirthDate, INTERVAL '0' DAY ) OVERLAPS ( DATE
'1970-01-01', DATE '1970-01-01')
-
-statement error
-SELECT * FROM Employee WHERE ( BirthDate, BirthDate ) OVERLAPS ( DATE
'1970-01-01', DATE '1970-01-01')
-
-statement error
-SELECT * FROM Employee WHERE ( BirthDate, NULL ) OVERLAPS ( DATE '1970-01-01',
INTERVAL '0' DAY )
-
-statement error
-SELECT * FROM Employee WHERE ( BirthDate, NULL ) OVERLAPS ( DATE '1970-01-01',
NULL )
-
-statement error
-SELECT * FROM Employee WHERE ( BirthDate, NULL ) OVERLAPS ( NULL ,
DATE '1970-01-01')
-
-statement ok
-DROP TABLE Employee
-
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
