summaryrefslogtreecommitdiff
path: root/mysql-test/r/signal_demo3.result
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/r/signal_demo3.result
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/r/signal_demo3.result')
-rw-r--r--mysql-test/r/signal_demo3.result152
1 files changed, 0 insertions, 152 deletions
diff --git a/mysql-test/r/signal_demo3.result b/mysql-test/r/signal_demo3.result
deleted file mode 100644
index fe425f6412d..00000000000
--- a/mysql-test/r/signal_demo3.result
+++ /dev/null
@@ -1,152 +0,0 @@
-SET @start_global_value = @@global.max_error_count;
-SELECT @start_global_value;
-@start_global_value
-64
-SET @start_session_value = @@session.max_error_count;
-SELECT @start_session_value;
-@start_session_value
-64
-drop database if exists demo;
-create database demo;
-use demo;
-create procedure proc_1()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_1';
-call proc_2();
-end
-$$
-create procedure proc_2()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_2';
-call proc_3();
-end
-$$
-create procedure proc_3()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_3';
-call proc_4();
-end
-$$
-create procedure proc_4()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_4';
-call proc_5();
-end
-$$
-create procedure proc_5()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_5';
-call proc_6();
-end
-$$
-create procedure proc_6()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_6';
-call proc_7();
-end
-$$
-create procedure proc_7()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_7';
-call proc_8();
-end
-$$
-create procedure proc_8()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_8';
-call proc_9();
-end
-$$
-create procedure proc_9()
-begin
-declare exit handler for sqlexception
-resignal sqlstate '45000' set message_text='Oops in proc_9';
-## Do something that fails, to see how errors are reported
-drop table oops_it_is_not_here;
-end
-$$
-call proc_1();
-ERROR 45000: Oops in proc_1
-show warnings;
-Level Code Message
-Error 1051 Unknown table 'demo.oops_it_is_not_here'
-Error 1644 Oops in proc_9
-Note 4094 At line 4 in demo.proc_9
-Error 1644 Oops in proc_8
-Note 4094 At line 4 in demo.proc_8
-Error 1644 Oops in proc_7
-Note 4094 At line 4 in demo.proc_7
-Error 1644 Oops in proc_6
-Note 4094 At line 4 in demo.proc_6
-Error 1644 Oops in proc_5
-Note 4094 At line 4 in demo.proc_5
-Error 1644 Oops in proc_4
-Note 4094 At line 4 in demo.proc_4
-Error 1644 Oops in proc_3
-Note 4094 At line 4 in demo.proc_3
-Error 1644 Oops in proc_2
-Note 4094 At line 4 in demo.proc_2
-Error 1644 Oops in proc_1
-Note 4094 At line 4 in demo.proc_1
-SET @@session.max_error_count = 5;
-SELECT @@session.max_error_count;
-@@session.max_error_count
-5
-call proc_1();
-ERROR 45000: Oops in proc_1
-show warnings;
-Level Code Message
-Note 4094 At line 4 in demo.proc_3
-Error 1644 Oops in proc_2
-Note 4094 At line 4 in demo.proc_2
-Error 1644 Oops in proc_1
-Note 4094 At line 4 in demo.proc_1
-SET @@session.max_error_count = 7;
-SELECT @@session.max_error_count;
-@@session.max_error_count
-7
-call proc_1();
-ERROR 45000: Oops in proc_1
-show warnings;
-Level Code Message
-Note 4094 At line 4 in demo.proc_4
-Error 1644 Oops in proc_3
-Note 4094 At line 4 in demo.proc_3
-Error 1644 Oops in proc_2
-Note 4094 At line 4 in demo.proc_2
-Error 1644 Oops in proc_1
-Note 4094 At line 4 in demo.proc_1
-SET @@session.max_error_count = 9;
-SELECT @@session.max_error_count;
-@@session.max_error_count
-9
-call proc_1();
-ERROR 45000: Oops in proc_1
-show warnings;
-Level Code Message
-Note 4094 At line 4 in demo.proc_5
-Error 1644 Oops in proc_4
-Note 4094 At line 4 in demo.proc_4
-Error 1644 Oops in proc_3
-Note 4094 At line 4 in demo.proc_3
-Error 1644 Oops in proc_2
-Note 4094 At line 4 in demo.proc_2
-Error 1644 Oops in proc_1
-Note 4094 At line 4 in demo.proc_1
-drop database demo;
-SET @@global.max_error_count = @start_global_value;
-SELECT @@global.max_error_count;
-@@global.max_error_count
-64
-SET @@session.max_error_count = @start_session_value;
-SELECT @@session.max_error_count;
-@@session.max_error_count
-64