Changeset: 314919f8979a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=314919f8979a
Modified Files:
sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
sql/test/BugTracker-2018/Tests/truncate_geom_tables.Bug-6543.test
sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.test
Branch: default
Log Message:
Fix tests.
diffs (131 lines):
diff --git
a/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
b/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
--- a/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
+++ b/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
@@ -14,9 +14,13 @@ query TTTT rowsort
select "name", "query", "type", "remark" from describe_table('sys', 'x')
----
-statement ok
+query TTTT rowsort
select "name", "type", "language", "remark" from describe_function('sys',
'test')
----
+test
+PROCEDURE
+NULL
+NULL
statement ok
drop procedure test
@@ -34,9 +38,13 @@ query TTTT rowsort
select "name", "query", "type", "remark" from describe_table('sys', 'x')
----
-statement ok
+query TTTT rowsort
select "name", "type", "language", "remark" from describe_function('sys',
'test')
----
+test
+PROCEDURE
+NULL
+NULL
statement ok
drop procedure test
diff --git a/sql/test/BugTracker-2018/Tests/truncate_geom_tables.Bug-6543.test
b/sql/test/BugTracker-2018/Tests/truncate_geom_tables.Bug-6543.test
--- a/sql/test/BugTracker-2018/Tests/truncate_geom_tables.Bug-6543.test
+++ b/sql/test/BugTracker-2018/Tests/truncate_geom_tables.Bug-6543.test
@@ -1,9 +1,13 @@
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.spatial_ref_sys
+----
+1
statement error
TRUNCATE TABLE sys.spatial_ref_sys
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.spatial_ref_sys
+----
+1
diff --git
a/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.test
b/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.test
--- a/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.test
+++ b/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.test
@@ -1,45 +1,65 @@
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vars
+----
+0
statement error
TRUNCATE TABLE sys.netcdf_vars
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vars
+----
+0
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vardim
+----
+0
statement error
TRUNCATE TABLE sys.netcdf_vardim
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vardim
+----
+0
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_files
+----
+0
statement error
TRUNCATE TABLE sys.netcdf_files
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_files
+----
+0
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_dims
+----
+0
statement error
TRUNCATE TABLE sys.netcdf_dims
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_dims
+----
+0
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_attrs
+----
+0
statement error
TRUNCATE TABLE sys.netcdf_attrs
-statement ok
+query I rowsort
SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_attrs
+----
+0
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
