Changeset: 41dd321b3020 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=41dd321b3020
Added Files:
sql/test/BugTracker-2009/dumping_tables.SF-2776908.sql
sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.test
sql/test/Dump/Tests/dump-empty.stable.out
sql/test/Triggers/Tests/trigger_action.test
sql/test/Triggers/Tests/trigger_projection.test
Branch: default
Log Message:
Added missing test files.
diffs (truncated from 371 to 300 lines):
diff --git a/sql/test/BugTracker-2009/dumping_tables.SF-2776908.sql
b/sql/test/BugTracker-2009/dumping_tables.SF-2776908.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2009/dumping_tables.SF-2776908.sql
@@ -0,0 +1,8 @@
+\d
+\d triggers
+\d args
+create table node_tags (id integer);
+select * from node_tags;
+insert into node_tags values (1);
+select * from node_tags;
+drop table node_tags;
diff --git a/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.test
b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.test
@@ -0,0 +1,114 @@
+statement ok
+CREATE TABLE test101(
+ A INT NOT NULL PRIMARY KEY,
+ B INT NOT NULL,
+ C INT NOT NULL,
+ CONSTRAINT "fC" FOREIGN KEY (C) REFERENCES test101(A)
+)
+
+statement ok
+INSERT INTO test101 VALUES (101, 101, 101)
+
+statement ok
+ALTER TABLE test101 ALTER C SET NULL
+
+statement ok
+INSERT INTO test101 VALUES (100, 100, NULL)
+
+statement ok
+INSERT INTO test101 VALUES (102, 102, 102)
+
+statement ok
+INSERT INTO test101 VALUES (103, 103, 101)
+
+statement ok
+UPDATE test101 SET C = 100 WHERE C IS NULL
+
+query III rowsort
+select * from test101
+----
+100
+100
+100
+101
+101
+101
+102
+102
+102
+103
+103
+103
+
+statement ok
+ALTER TABLE test101 ALTER C SET NOT NULL
+
+statement ok
+INSERT INTO test101 VALUES (104, 104, 104)
+
+statement ok
+DROP TABLE test101
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "sys"."t1" ("c0" DOUBLE,CONSTRAINT "t1_c0_unique" UNIQUE
("c0"),CONSTRAINT "t1_c0_fkey" FOREIGN KEY ("c0") REFERENCES "sys"."t1" ("c0"))
+
+statement ok
+COPY 9 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.21248182395969406
+0.6307796692265083
+2059310235
+-6.5457821e+08
+0.743704157497456
+0.4001718453135127
+0.3935743494971655
+0.5299192301063729
+0.7609386265982908
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0"("tc0" CHARACTER LARGE OBJECT NOT NULL,CONSTRAINT
"t0_tc0_pkey" PRIMARY KEY ("tc0"),
+CONSTRAINT "t0_tc0_fkey" FOREIGN KEY ("tc0") REFERENCES "sys"."t0" ("tc0"))
+
+statement ok
+INSERT INTO t0(tc0) VALUES('b' BETWEEN 'a' AND 'c')
+
+statement ok
+ROLLBACK
+
+statement ok
+CREATE TABLE t1(c0 FLOAT)
+
+statement ok
+ALTER TABLE t1 ADD UNIQUE(c0)
+
+statement ok
+INSERT INTO t1(c0) VALUES(13.38)
+
+statement ok
+DELETE FROM t1 WHERE true
+
+statement ok
+INSERT INTO t1(c0) VALUES(0.9), (0.5), (-3), (0.4)
+
+statement ok
+ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t1(c0)
+
+statement ok
+INSERT INTO t1(c0) VALUES(null)
+
+statement ok
+DELETE FROM t1
+
+statement ok
+DROP TABLE t1
+
+
diff --git a/sql/test/Dump/Tests/dump-empty.stable.out
b/sql/test/Dump/Tests/dump-empty.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/Dump/Tests/dump-empty.stable.out
@@ -0,0 +1,34 @@
+stdout of test 'dump-empty` in directory 'sql/test/Dump` itself:
+
+
+# 17:33:41 >
+# 17:33:41 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=31345" "--set"
"mapi_usock=/var/tmp/mtest-4412/.s.monetdb.31345" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB/mTests_sql_test_Dump"
"--set" "embedded_c=true"
+# 17:33:41 >
+
+# MonetDB 5 server v11.30.0
+# This is an unreleased version
+# Serving database 'mTests_sql_test_Dump', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers
+# Found 15.386 GiB available main-memory.
+# Copyright (c) 1993 - July 2008 CWI.
+# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved
+# Visit https://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://xps13:31345/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-4412/.s.monetdb.31345
+# MonetDB/GIS module loaded
+# SQL catalog created, loading sql scripts once
+
+
+# 10:50:27 >
+# 10:50:27 > /usr/bin/python dump-empty.SQL.py dump-empty
+# 10:50:27 >
+
+#msqldump tables Wed Sep 8 10:50:27 2010
+
+START TRANSACTION;
+COMMIT;
+
+# 10:50:28 >
+# 10:50:28 > Done.
+# 10:50:28 >
+
diff --git a/sql/test/Triggers/Tests/trigger_action.test
b/sql/test/Triggers/Tests/trigger_action.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Triggers/Tests/trigger_action.test
@@ -0,0 +1,160 @@
+statement ok
+create table t_4_1 ("id" int, "name" varchar(1024))
+
+statement ok
+insert into t_4_1 values(10, 'monetdb')
+
+statement ok
+insert into t_4_1 values(20, 'monet')
+
+statement ok
+create trigger test_4_1
+ after update on t_4_1 referencing old row as old_row
+ for each statement insert into t_4_1 values(0,
'update_old_row_statement')
+
+statement ok
+create trigger test_4_2
+ after update on t_4_1 referencing new row new_row
+ for each statement insert into t_4_1 values(1,
'update_new_row_statement')
+
+statement ok
+create trigger test_4_3
+ after update on t_4_1
+ for each statement insert into t_4_1 values(2, 'update_statement')
+
+statement ok
+create trigger test_4_4
+ after update on t_4_1 referencing new row as new_row
+ for each row insert into t_4_1 values(3, 'update_row')
+
+statement error
+--error, id variable unknown
+create trigger test_4_5
+ after update on t_4_1
+ for each statement
+ when ("id">0) insert into t_4_1 values(4, 'update_when_statement_true')
+
+statement ok
+create trigger test_4_6
+ after update on t_4_1 referencing new row as new_row
+ for each row
+ when (new_row."id">0) insert into t_4_1 values(5,
'update_when_row_true')
+
+statement error
+--error, id variable unknown
+create trigger test_4_7
+ after update on t_4_1
+ for each statement
+ when ("id" >1000) insert into t_4_1 values(6,
'update_when_statement_false')
+
+statement ok
+create trigger test_4_8
+ after update on t_4_1 referencing new row as new_row
+ for each row
+ when (new_row."id">1000) insert into t_4_1 values(7,
'update_when_row_false')
+
+statement ok
+update t_4_1 set "name" = 'mo' where "id" = 10
+
+query IT rowsort
+select * from t_4_1
+----
+0
+update_old_row_statement
+1
+update_new_row_statement
+10
+mo
+2
+update_statement
+20
+monet
+3
+update_row
+5
+update_when_row_true
+
+statement ok
+delete from t_4_1 where "id" >-1
+
+statement ok
+drop trigger test_4_1
+
+statement ok
+drop trigger test_4_2
+
+statement ok
+drop trigger test_4_3
+
+statement ok
+drop trigger test_4_4
+
+statement ok
+drop trigger test_4_6
+
+statement ok
+drop trigger test_4_8
+
+statement ok
+insert into t_4_1 values(10, 'monetdb')
+
+statement ok
+insert into t_4_1 values(20, 'monet')
+
+statement ok
+create trigger test_4_1
+ after update on t_4_1
+ BEGIN ATOMIC
+ insert into t_4_1 values(1,'first_insertion');
+ insert into t_4_1 values(2,'second_insertion');
+ END
+
+statement ok
+create trigger test_4_2
+ after update on t_4_1
+ BEGIN ATOMIC
+ insert into t_4_1 values(3,'third_insertion');
+ END
+
+statement ok
+create trigger test_4_3
+ after update on t_4_1
+ BEGIN ATOMIC
+ insert into t_4_1 values(4,'fourth_insertion');
+ insert into t_4_1 values(5,'fifth_insertion');
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
