diff options
Diffstat (limited to 'mysql-test/main/signal_demo3.result')
| -rw-r--r-- | mysql-test/main/signal_demo3.result | 152 |
1 files changed, 152 insertions, 0 deletions
diff --git a/mysql-test/main/signal_demo3.result b/mysql-test/main/signal_demo3.result new file mode 100644 index 00000000..fe425f64 --- /dev/null +++ b/mysql-test/main/signal_demo3.result @@ -0,0 +1,152 @@ +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 |