Changeset: 8baaf0cc7426 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8baaf0cc7426
Modified Files:
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
Branch: nospare
Log Message:
output changes because of new objects.sub column
diffs (71 lines):
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
@@ -26,6 +26,6 @@ WHERE columns.table_id = tables.id
'objects', 'keys', 'modules', 'sequences')
ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION
----
-1121 values hashing to 819cace9654bce8e750b5e69795d0f62
+1121 values hashing to 1fc5cedc3ec39c84398358ba3997b3be
diff --git
a/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
b/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
--- a/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
+++ b/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
@@ -6,7 +6,7 @@ query TI rowsort
SELECT type,COUNT(id) FROM cols_6624 GROUP BY type HAVING COUNT(id)>5 ORDER BY
COUNT(id) DESC
----
int
-19
+20
smallint
6
varchar
@@ -16,7 +16,7 @@ query TI rowsort
SELECT type,COUNT(id) FROM cols_6624 GROUP BY type HAVING COUNT(id)>5 ORDER BY
2 DESC
----
int
-19
+20
smallint
6
varchar
@@ -26,7 +26,7 @@ query TI rowsort
SELECT type,COUNT(id) as cnt FROM cols_6624 GROUP BY type HAVING COUNT(id)>5
ORDER BY cnt DESC
----
int
-19
+20
smallint
6
varchar
diff --git
a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
--- a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
+++ b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
@@ -10,7 +10,7 @@ query IIITII rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables)
----
-query ITI rowsort
+query ITII rowsort
SELECT * FROM sys.objects WHERE id NOT IN (SELECT id FROM sys.ids)
----
@@ -110,7 +110,7 @@ query IIITII rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables)
----
-query ITI rowsort
+query ITII rowsort
SELECT * FROM sys.objects WHERE id NOT IN (SELECT id FROM sys.ids)
----
@@ -141,7 +141,7 @@ query IIITII rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables)
----
-query ITI rowsort
+query ITII rowsort
SELECT * FROM sys.objects WHERE id NOT IN (SELECT id FROM sys.ids)
----
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
