Changeset: e29b78b4acd2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e29b78b4acd2
Modified Files:
sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.test
sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.test
sql/test/BugTracker-2017/Tests/date-arithmetic.Bug-6415.test
sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.test
sql/test/bugs/Tests/default_with_cast.SF-1334486.test
Branch: mtest
Log Message:
changed test output for interval days (just the numer of days). Requires pull
request on pymonetdb to be merged.
diffs (81 lines):
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
--- a/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
+++ b/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
@@ -1,9 +1,9 @@
query T
select current_date - current_date
----
-1 day
+0
query T
select current_date() - current_date()
----
-1 day
+0
diff --git a/sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.test
b/sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.test
--- a/sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.test
+++ b/sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.test
@@ -15,5 +15,4 @@ drop table foo
query T
select sum(i) from (select interval '1' day) x(i)
----
-1 day
-
+1
diff --git
a/sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.test
b/sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.test
---
a/sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.test
+++
b/sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.test
@@ -13,11 +13,11 @@ INSERT INTO foo VALUES ('2016-01-01', '2
query TT
SELECT (dat2-dat1), (dat2-dat1) < interval '10' day FROM foo
----
-1 day
+1
True
-00:00:00
+0
True
-1 day
+30
False
statement ok
diff --git a/sql/test/BugTracker-2017/Tests/date-arithmetic.Bug-6415.test
b/sql/test/BugTracker-2017/Tests/date-arithmetic.Bug-6415.test
--- a/sql/test/BugTracker-2017/Tests/date-arithmetic.Bug-6415.test
+++ b/sql/test/BugTracker-2017/Tests/date-arithmetic.Bug-6415.test
@@ -1,8 +1,8 @@
query TT
select cast('2017-10-10' as date) - cast('2017-10-01' as date), date
'2017-10-10' - date '2017-10-01'
----
-1 day
-1 day
+9
+9
query TT rowsort
select cast('2017-10-01' as date) + interval '9' day, date '2017-10-01' +
interval '9' day
diff --git a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.test
b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.test
--- a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.test
+++ b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.test
@@ -161,7 +161,7 @@ 0:00:05
query T rowsort
SELECT INTERVAL '-100' DAY / cast(23.34 as real)
----
-1 day
+-5
query T rowsort
SELECT INTERVAL '32' MINUTE / cast(45.5677 as real)
diff --git a/sql/test/bugs/Tests/default_with_cast.SF-1334486.test
b/sql/test/bugs/Tests/default_with_cast.SF-1334486.test
--- a/sql/test/bugs/Tests/default_with_cast.SF-1334486.test
+++ b/sql/test/bugs/Tests/default_with_cast.SF-1334486.test
@@ -10,7 +10,7 @@ insert into t
query T rowsort
select cast(now() as date) - d from t
----
-0.000
+0
statement ok
drop table t
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
