Changeset: 9d1eeb154a50 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9d1eeb154a50
Modified Files:
sql/test/BugTracker-2012/Tests/combination_of_theta_and_equijoins.Bug-3004.test
sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.test
sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.test
sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.test
Branch: mtest
Log Message:
Fixes for BugTracker-2012
diffs (80 lines):
diff --git
a/sql/test/BugTracker-2012/Tests/combination_of_theta_and_equijoins.Bug-3004.test
b/sql/test/BugTracker-2012/Tests/combination_of_theta_and_equijoins.Bug-3004.test
---
a/sql/test/BugTracker-2012/Tests/combination_of_theta_and_equijoins.Bug-3004.test
+++
b/sql/test/BugTracker-2012/Tests/combination_of_theta_and_equijoins.Bug-3004.test
@@ -36,7 +36,6 @@ FROM
) AS "s"
WHERE "sv" <= "er"
AND "ea" = "sa"
-
----
Simon
1
@@ -63,7 +62,6 @@ FROM
) AS "s"
WHERE "ea" = "sa"
AND "sv" <= "er"
-
----
Simon
1
@@ -89,7 +87,6 @@ FROM
) AS "s"
WHERE ("sv" <= "er") = true
AND ("ea" = "sa") = true
-
----
Simon
1
diff --git
a/sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.test
b/sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.test
---
a/sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.test
+++
b/sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.test
@@ -7,17 +7,17 @@ insert into deterministic values (now())
query T rowsort
select (select a from deterministic) + interval '1' second - (select a from
deterministic)
----
-.00
+0:00:01
query T rowsort
select (select a from deterministic) + interval '1' second - (select a from
deterministic)
----
-.00
+0:00:01
query T rowsort
select (select a from deterministic) - (select a from deterministic)
----
-.00
+0:00:00
statement ok
drop table deterministic
diff --git a/sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.test
b/sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.test
--- a/sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.test
+++ b/sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.test
@@ -19,12 +19,12 @@ True
query T rowsort
select btime - timestamp '1975-JAN-01' from time_table
----
-89302400.00
+2191 days, 0:00:00
query T rowsort
select btime - atime from time_table
----
-47068800.00
+4017 days, 0:00:00
statement ok
drop table time_table
diff --git a/sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.test
b/sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.test
--- a/sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.test
+++ b/sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.test
@@ -1,6 +1,6 @@
query T rowsort
select (cast('1970-01-01 0:00' as timestamp) - cast('1970-01-01' as date))
----
-.00
+0:00:00
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
