diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/r/signal_demo3.result | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-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.result | 152 |
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 |