Changeset: 30f67e9f95e2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=30f67e9f95e2
Added Files:
sql/test/BugTracker-2018/Tests/comment-on-table-is-null.Bug-6639.test
sql/test/BugTracker-2018/Tests/prepared-statement-with-udf.Bug-6650.test
sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
sql/test/BugTracker-2018/Tests/truncate_add_user.test
sql/test/BugTracker-2018/Tests/truncate_geom_tables.Bug-6543.test
sql/test/BugTracker-2018/Tests/truncate_remove_user.reqtests
sql/test/BugTracker-2018/Tests/truncate_remove_user.test
sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.test
sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.test
sql/test/BugTracker-2018/Tests/truncate_tmp_tables.Bug-6543.test
Branch: mtest
Log Message:
fixes for sql/test/BugTracker-2018
diffs (truncated from 697 to 300 lines):
diff --git
a/sql/test/BugTracker-2018/Tests/comment-on-table-is-null.Bug-6639.test
b/sql/test/BugTracker-2018/Tests/comment-on-table-is-null.Bug-6639.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/comment-on-table-is-null.Bug-6639.test
@@ -0,0 +1,66 @@
+query T rowsort
+select remark from comments where id in (select id from sys._tables where name
= 'abc_6639')
+----
+
+statement ok
+create table abc_6639 (nr int)
+
+statement ok
+comment on table abc_6639 is 'abc_rem'
+
+query T rowsort
+select remark from comments where id in (select id from sys._tables where name
= 'abc_6639')
+----
+abc_rem
+
+statement error
+\dt abc_6639
+comment on table abc_6639 is null
+
+query T rowsort
+select remark from comments where id in (select id from sys._tables where name
= 'abc_6639')
+----
+abc_rem
+
+statement error
+\dt abc_6639
+-- show that the comment column id and remark are both set to NOT NULL
+select number, name, type, type_digits, "null" from sys._columns where
table_id in (select id from sys._tables where name = 'comments' and system)
+
+statement error
+\dt comments
+comment on table abc_6639 is ''
+
+query T rowsort
+select remark from comments where id in (select id from sys._tables where name
= 'abc_6639')
+----
+abc_rem
+
+statement error
+\dt abc_6639
+comment on table abc_6639 is null
+
+query T rowsort
+select remark from comments where id in (select id from sys._tables where name
= 'abc_6639')
+----
+abc_rem
+
+statement error
+\dt abc_6639
+comment on table abc_6639 is 'abc_rem2'
+
+query T rowsort
+select remark from comments where id in (select id from sys._tables where name
= 'abc_6639')
+----
+abc_rem
+
+statement error
+\dt abc_6639
+drop table abc_6639
+
+query T rowsort
+select remark from comments where id in (select id from sys._tables where name
= 'abc_6639')
+----
+abc_rem
+
+
diff --git
a/sql/test/BugTracker-2018/Tests/prepared-statement-with-udf.Bug-6650.test
b/sql/test/BugTracker-2018/Tests/prepared-statement-with-udf.Bug-6650.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/prepared-statement-with-udf.Bug-6650.test
@@ -0,0 +1,46 @@
+statement ok
+start transaction
+
+statement ok
+create table onet (a text, b text, c text)
+
+statement ok
+insert into onet values ('a', 'b', 'c')
+
+statement ok
+create function get_onet(d text) returns table (aa text, bb text, cc text)
return table(select * from onet where a = d)
+
+statement error
+prepare select * from get_onet(?)
+
+statement error
+exec **('a')
+
+statement error
+prepare select * from get_onet(?) tt where tt.aa = ?
+
+statement error
+exec **('a', 'b')
+
+statement error
+prepare with something as (select a from onet where a = ?) select * from
get_onet(?), something
+
+statement error
+exec **('a', 'a')
+
+statement error
+drop function get_onet
+
+statement error
+drop table onet
+
+statement error
+CREATE FUNCTION twoargs(input1 INT, input2 CLOB) RETURNS TABLE (outt CLOB)
BEGIN RETURN TABLE(SELECT input1 || input2); END
+
+statement error
+prepare select 1 from twoargs(?,?)
+
+statement ok
+rollback
+
+
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
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
@@ -0,0 +1,32 @@
+statement ok
+create procedure test() begin create table x (i int); insert into x values
(1), (2); end
+
+statement error
+create procedure test() begin create table x as select name from sys.functions
with data; end
+
+statement ok
+call test()
+
+statement error
+select i from x limit 1
+
+statement error
+\d x
+\df test
+drop procedure test
+
+statement error
+create procedure test() begin create table x as select name from sys.functions
with data; end
+
+statement ok
+call test()
+
+statement error
+select name from x limit 1
+
+statement error
+\d x
+\df test
+drop procedure test
+
+
diff --git a/sql/test/BugTracker-2018/Tests/truncate_add_user.test
b/sql/test/BugTracker-2018/Tests/truncate_add_user.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/truncate_add_user.test
@@ -0,0 +1,4 @@
+statement ok
+CREATE USER "testuser" WITH PASSWORD 'testpassword' NAME 'Test User' SCHEMA
"sys"
+
+
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
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/truncate_geom_tables.Bug-6543.test
@@ -0,0 +1,10 @@
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.spatial_ref_sys
+
+statement error
+TRUNCATE TABLE sys.spatial_ref_sys
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.spatial_ref_sys
+
+
diff --git a/sql/test/BugTracker-2018/Tests/truncate_remove_user.reqtests
b/sql/test/BugTracker-2018/Tests/truncate_remove_user.reqtests
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/truncate_remove_user.reqtests
@@ -0,0 +1,1 @@
+truncate_add_user
diff --git a/sql/test/BugTracker-2018/Tests/truncate_remove_user.test
b/sql/test/BugTracker-2018/Tests/truncate_remove_user.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/truncate_remove_user.test
@@ -0,0 +1,4 @@
+statement ok
+DROP USER testuser
+
+
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
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.test
@@ -0,0 +1,46 @@
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vars
+
+statement error
+TRUNCATE TABLE sys.netcdf_vars
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vars
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vardim
+
+statement error
+TRUNCATE TABLE sys.netcdf_vardim
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_vardim
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_files
+
+statement error
+TRUNCATE TABLE sys.netcdf_files
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_files
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_dims
+
+statement error
+TRUNCATE TABLE sys.netcdf_dims
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_dims
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_attrs
+
+statement error
+TRUNCATE TABLE sys.netcdf_attrs
+
+statement ok
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.netcdf_attrs
+
+
diff --git a/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.test
b/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.test
@@ -0,0 +1,353 @@
+query T rowsort
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.user_role
+----
+False
+
+statement error
+TRUNCATE TABLE sys.user_role
+
+query T rowsort
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.user_role
+----
+False
+
+query T rowsort
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.types
+----
+True
+
+statement error
+TRUNCATE TABLE sys.types
+
+query T rowsort
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.types
+----
+True
+
+query T rowsort
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.triggers
+----
+True
+
+statement error
+TRUNCATE TABLE sys.triggers
+
+query T rowsort
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.triggers
+----
+True
+
+query T rowsort
+SELECT (COUNT(*) > 0) AS has_rows FROM sys.table_types
+----
+True
+
+statement error
+TRUNCATE TABLE sys.table_types
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
