Changeset: 7526ac847a6a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7526ac847a6a
Modified Files:
sql/backends/monet5/sql_scenario.c
sql/test/Triggers/Tests/recursive_triggers.stable.err
Branch: default
Log Message:
Merge with Dec2011 branch.
diffs (truncated from 2262 to 300 lines):
diff --git a/sql/backends/monet5/sql_scenario.c
b/sql/backends/monet5/sql_scenario.c
--- a/sql/backends/monet5/sql_scenario.c
+++ b/sql/backends/monet5/sql_scenario.c
@@ -1367,7 +1367,7 @@ SQLparser(Client c)
be->q = qc_find(m->qc, m->sym->data.lval->h->data.i_val);
if (!be->q) {
err = -1;
- mnstr_printf(out, "!07003:EXEC: no prepared statement
with id: %d\n",
+ mnstr_printf(out, "!07003!EXEC: no prepared statement
with id: %d\n",
m->sym->data.lval->h->data.i_val);
msg = createException(SQL, "PREPARE",
"no prepared statement with id: %d",
@@ -1377,7 +1377,7 @@ SQLparser(Client c)
goto finalize;
} else if (be->q->type != Q_PREPARE) {
err = -1;
- mnstr_printf(out, "!07005:EXEC: given handle id is not
for a "
+ mnstr_printf(out, "!07005!EXEC: given handle id is not
for a "
"prepared statement: %d\n",
m->sym->data.lval->h->data.i_val);
msg = createException(SQL, "PREPARE",
diff --git a/sql/test/Triggers/Tests/cascaded_triggers.stable.out
b/sql/test/Triggers/Tests/cascaded_triggers.stable.out
--- a/sql/test/Triggers/Tests/cascaded_triggers.stable.out
+++ b/sql/test/Triggers/Tests/cascaded_triggers.stable.out
@@ -25,36 +25,36 @@ Ready.
# 14:51:08 >
[ 1 ]
-% sys.t1, sys.t1, sys.t1 # table_name
+% sys.t_0_1, sys.t_0_1, sys.t_0_1 # table_name
% id, name, age # name
% int, varchar, int # type
% 1, 2, 2 # length
[ 1, "mo", 25 ]
-% sys.t2, sys.t2 # table_name
+% sys.t_0_2, sys.t_0_2 # table_name
% id, age # name
% int, int # type
% 1, 2 # length
[ 1, 25 ]
[ 1 ]
-% sys.t1, sys.t1, sys.t1 # table_name
+% sys.t_0_1, sys.t_0_1, sys.t_0_1 # table_name
% id, name, age # name
% int, varchar, int # type
% 1, 2, 2 # length
[ 3, "mo", 27 ]
-% sys.t2, sys.t2 # table_name
+% sys.t_0_2, sys.t_0_2 # table_name
% id, age # name
% int, int # type
% 1, 2 # length
[ 1, 25 ]
[ 3, 27 ]
[ 0 ]
-% sys.t1, sys.t1, sys.t1 # table_name
+% sys.t_0_1, sys.t_0_1, sys.t_0_1 # table_name
% id, name, age # name
% int, varchar, int # type
% 1, 2, 2 # length
[ 3, "mo", 27 ]
[ 1, "mo", 25 ]
-% sys.t2, sys.t2 # table_name
+% sys.t_0_2, sys.t_0_2 # table_name
% id, age # name
% int, int # type
% 1, 2 # length
diff --git a/sql/test/Triggers/Tests/referencing_clause_new.stable.out
b/sql/test/Triggers/Tests/referencing_clause_new.stable.out
--- a/sql/test/Triggers/Tests/referencing_clause_new.stable.out
+++ b/sql/test/Triggers/Tests/referencing_clause_new.stable.out
@@ -20,34 +20,34 @@ Ready.
# 16:00:56 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35011 < referencing_clause_new.sql
# 16:00:56 >
-#create table t1 (id int, name varchar(1024));
-#create table t2 (id int, name varchar(1024));
-#insert into t1 values(10, 'monetdb');
+#create table t_2_1 (id int, name varchar(1024));
+#create table t_2_2 (id int, name varchar(1024));
+#insert into t_2_1 values(10, 'monetdb');
[ 1 ]
-#insert into t1 values(20, 'monet');
+#insert into t_2_1 values(20, 'monet');
[ 1 ]
-#create trigger test1
-# after update on t1 referencing new row as new_row
-# for each row insert into t2 values(0, 'update_new_row');
-#create trigger test2
-# after update on t1 referencing new row new_row
-# for each row insert into t2 values(1, 'update_new_row');
-#create trigger test3
-# after update on t1 referencing new as new_row
-# for each row insert into t2 values(2, 'update_new_row');
-#create trigger test4
-# after update on t1 referencing new new_row
-# for each row insert into t2 values(3, 'update_new_row');
-#update t1 set name = 'mo' where id = 10;
+#create trigger test_2_1
+# after update on t_2_1 referencing new row as new_row
+# for each row insert into t_2_2 values(0, 'update_new_row');
+#create trigger test_2_2
+# after update on t_2_1 referencing new row new_row
+# for each row insert into t_2_2 values(1, 'update_new_row');
+#create trigger test_2_3
+# after update on t_2_1 referencing new as new_row
+# for each row insert into t_2_2 values(2, 'update_new_row');
+#create trigger test_2_4
+# after update on t_2_1 referencing new new_row
+# for each row insert into t_2_2 values(3, 'update_new_row');
+#update t_2_1 set name = 'mo' where id = 10;
[ 1 ]
-#select * from t1;
-% sys.t1, sys.t1 # table_name
+#select * from t_2_1;
+% sys.t_2_1, sys.t_2_1 # table_name
% id, name # name
% int, varchar # type
% 2, 5 # length
[ 10, "mo" ]
[ 20, "monet" ]
-% sys.t2, sys.t2 # table_name
+% sys.t_2_2, sys.t_2_2 # table_name
% id, name # name
% int, varchar # type
% 1, 14 # length
@@ -57,33 +57,33 @@ Ready.
[ 3, "update_new_row" ]
[ 2 ]
[ 4 ]
-#drop trigger test1;
-#drop trigger test2;
-#drop trigger test3;
-#drop trigger test4;
-#insert into t1 values(10, 'monetdb');
+#drop trigger test_2_1;
+#drop trigger test_2_2;
+#drop trigger test_2_3;
+#drop trigger test_2_4;
+#insert into t_2_1 values(10, 'monetdb');
[ 1 ]
-#insert into t1 values(20, 'monet');
+#insert into t_2_1 values(20, 'monet');
[ 1 ]
-#create trigger test1
-# after delete on t1 referencing new row as new_row
-# for each row insert into t2 values(0, 'delete_new_row');
-#create trigger test2
-# after delete on t1 referencing new row new_row
-# for each row insert into t2 values(1, 'delete_new_row');
-#create trigger test3
-# after delete on t1 referencing new as new_row
-# for each row insert into t2 values(2, 'delete_new_row');
-#create trigger test4
-# after delete on t1 referencing new new_row
-# for each row insert into t2 values(3, 'delete_new_row');
-#delete from t1 where id >-1;
+#create trigger test_2_1
+# after delete on t_2_1 referencing new row as new_row
+# for each row insert into t_2_2 values(0, 'delete_new_row');
+#create trigger test_2_2
+# after delete on t_2_1 referencing new row new_row
+# for each row insert into t_2_2 values(1, 'delete_new_row');
+#create trigger test_2_3
+# after delete on t_2_1 referencing new as new_row
+# for each row insert into t_2_2 values(2, 'delete_new_row');
+#create trigger test_2_4
+# after delete on t_2_1 referencing new new_row
+# for each row insert into t_2_2 values(3, 'delete_new_row');
+#delete from t_2_1 where id >-1;
[ 2 ]
-% sys.t1, sys.t1 # table_name
+% sys.t_2_1, sys.t_2_1 # table_name
% id, name # name
% int, varchar # type
% 1, 0 # length
-% sys.t2, sys.t2 # table_name
+% sys.t_2_2, sys.t_2_2 # table_name
% id, name # name
% int, varchar # type
% 1, 14 # length
@@ -94,13 +94,13 @@ Ready.
[ 4 ]
[ 1 ]
[ 1 ]
-% sys.t1, sys.t1 # table_name
+% sys.t_2_1, sys.t_2_1 # table_name
% id, name # name
% int, varchar # type
% 2, 7 # length
[ 10, "monetdb" ]
[ 20, "monet" ]
-% sys.t2, sys.t2 # table_name
+% sys.t_2_2, sys.t_2_2 # table_name
% id, name # name
% int, varchar # type
% 1, 14 # length
@@ -110,39 +110,39 @@ Ready.
[ 3, "insert_new_row" ]
[ 2 ]
[ 4 ]
-#drop trigger test1;
-#drop trigger test2;
-#drop trigger test3;
-#drop trigger test4;
-#insert into t1 values(10, 'monetdb');
+#drop trigger test_2_1;
+#drop trigger test_2_2;
+#drop trigger test_2_3;
+#drop trigger test_2_4;
+#insert into t_2_1 values(10, 'monetdb');
[ 1 ]
-#insert into t1 values(20, 'monet');
+#insert into t_2_1 values(20, 'monet');
[ 1 ]
-#create trigger test1
-# after update on t1 referencing new row as new_row new table as new_table
-# for each row insert into t2 values(0, 'insert_new_row_table');
-#create trigger test2
-# after update on t1 referencing new row new_row new row as new_row
-# for each row insert into t2 values(1, 'insert_new_new_row');
-#create trigger test3
-# after update on t1 referencing new table as new_table new table as
new_table
-# for each row insert into t2 values(2, 'insert_new__new_table');
-#create trigger test4
-# after update on t1 referencing new row as new_row new table as new_table
-# for each row insert into t2 values(3, 'insert_new_row_new_table');
-#create trigger test5
-# after update on t1 referencing new table as new_table new row as new_row
-# for each row insert into t2 values(4, 'insert_new_table_new_row');
-#update t1 set name = 'mo' where id = 10;
+#create trigger test_2_1
+# after update on t_2_1 referencing new row as new_row new table as
new_table
+# for each row insert into t_2_2 values(0, 'insert_new_row_table');
+#create trigger test_2_2
+# after update on t_2_1 referencing new row new_row new row as new_row
+# for each row insert into t_2_2 values(1, 'insert_new_new_row');
+#create trigger test_2_3
+# after update on t_2_1 referencing new table as new_table new table as
new_table
+# for each row insert into t_2_2 values(2, 'insert_new__new_table');
+#create trigger test_2_4
+# after update on t_2_1 referencing new row as new_row new table as
new_table
+# for each row insert into t_2_2 values(3, 'insert_new_row_new_table');
+#create trigger test_2_5
+# after update on t_2_1 referencing new table as new_table new row as
new_row
+# for each row insert into t_2_2 values(4, 'insert_new_table_new_row');
+#update t_2_1 set name = 'mo' where id = 10;
[ 1 ]
-#select * from t1;
-% sys.t1, sys.t1 # table_name
+#select * from t_2_1;
+% sys.t_2_1, sys.t_2_1 # table_name
% id, name # name
% int, varchar # type
% 2, 5 # length
[ 10, "mo" ]
[ 20, "monet" ]
-% sys.t2, sys.t2 # table_name
+% sys.t_2_2, sys.t_2_2 # table_name
% id, name # name
% int, varchar # type
% 1, 24 # length
@@ -153,51 +153,51 @@ Ready.
[ 4, "insert_new_table_new_row" ]
[ 2 ]
[ 5 ]
-#drop trigger test1;
-#drop trigger test2;
-#drop trigger test3;
-#drop trigger test4;
-#drop trigger test5;
-#insert into t1 values(10, 'monetdb');
+#drop trigger test_2_1;
+#drop trigger test_2_2;
+#drop trigger test_2_3;
+#drop trigger test_2_4;
+#drop trigger test_2_5;
+#insert into t_2_1 values(10, 'monetdb');
[ 1 ]
-#create trigger test1
-# after update on t1 referencing new row as new_row new table as new_table
-# for each row insert into t2 values(0, 'update_new_row_new_table');
-#create trigger test2
-# after insert on t1 referencing new row new_row new row as new_row
-# for each row insert into t2 values(1, 'insert_new_new_row');
-#create trigger test3
-# after delete on t1 referencing new row new_row new row as new_row
-# for each row insert into t2 values(2, 'delete_new_new_row');
-#create trigger test4
-# after delete on t1 referencing new row as new_row new table as new_table
-# for each row insert into t2 values(3, 'delete_new_row_new_table');
-#create trigger test5
-# after insert on t1 referencing new table as new_table new row as new_row
-# for each row insert into t2 values(4, 'insert_new_table_new_row');
-#insert into t1 values(20, 'monet');
+#create trigger test_2_1
+# after update on t_2_1 referencing new row as new_row new table as
new_table
+# for each row insert into t_2_2 values(0, 'update_new_row_new_table');
+#create trigger test_2_2
+# after insert on t_2_1 referencing new row new_row new row as new_row
+# for each row insert into t_2_2 values(1, 'insert_new_new_row');
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
