Changeset: 6e1766ee0039 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6e1766ee0039
Modified Files:
sql/test/proto_loader/odbc/Tests/All
sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test
Branch: Mar2025
Log Message:
Remove old failing test. The interval_day tests are now part of the
monetodbc_datatypes.test
diffs (64 lines):
diff --git a/sql/test/proto_loader/odbc/Tests/All
b/sql/test/proto_loader/odbc/Tests/All
--- a/sql/test/proto_loader/odbc/Tests/All
+++ b/sql/test/proto_loader/odbc/Tests/All
@@ -4,4 +4,3 @@ HAVE_ODBC?monetodbc
HAVE_SQLITE3ODBC&HAVE_DATA_PATH?sqlite3odbc
HAVE_ODBC?monetodbc_datatypes
KNOWNFAIL&HAVE_ODBC?monetodbc_bigdec_failure
-KNOWNFAIL&HAVE_ODBC?monetodbc_interval_day_overflow
diff --git
a/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test
b/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test
--- a/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test
+++ b/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test
@@ -1,16 +1,30 @@
-query II
-select cast('99' as interval day) as val1, cast('-99' as interval day) as val2
+query III
+select cast('99' as interval day) as val1, cast('-99' as interval day) as
val2, cast(null as interval day) as valnil
+----
+99
+-99
+NULL
+
+query III
+select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''99'' as interval day)
as val1, cast(''-99'' as interval day) as val2, cast(null as interval day) as
valnil'
----
99
-99
+NULL
query II
-select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''99'' as interval day)
as val1, cast(''-99'' as interval day) as val2'
+select cast('101' as interval day) as val1, cast('-102' as interval day) as
val2
----
-99
--99
+101
+-102
-query II
+query RR
+select cast('101' as interval day) as val1, cast('-102' as interval day) as
val2
+----
+101.000
+-102.000
+
+query TT
select cast('101' as interval day) as val1, cast('-102' as interval day) as
val2
----
101
@@ -25,3 +39,15 @@ select * from 'odbc:DSN=MonetDB-Test;QUE
101
-102
+query RR
+select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''101'' as interval
day) as val1, cast(''-102'' as interval day) as val2'
+----
+101.000
+-102.000
+
+query TT
+select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''101'' as interval
day) as val1, cast(''-102'' as interval day) as val2'
+----
+101
+-102
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
