Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.21.186.117
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
1st.result
597
B
-rw-r--r--
acl_tables_errors_debug.result
8.93
KB
-rw-r--r--
alias.result
13.58
KB
-rw-r--r--
almost_full.result
1.11
KB
-rw-r--r--
alter_table-big.result
5.45
KB
-rw-r--r--
alter_table.result
154.41
KB
-rw-r--r--
analyze.result
3.69
KB
-rw-r--r--
ansi.result
1.92
KB
-rw-r--r--
archive-big.result
616
B
-rw-r--r--
archive.result
525.18
KB
-rw-r--r--
archive_bitfield.result
4.26
KB
-rw-r--r--
archive_debug.result
355
B
-rw-r--r--
archive_gis.result
25.98
KB
-rw-r--r--
archive_no_symlink.result
882
B
-rw-r--r--
archive_plugin.result
531
B
-rw-r--r--
archive_symlink.result
2.3
KB
-rw-r--r--
auth_rpl.result
1.85
KB
-rw-r--r--
auto_increment.result
12.11
KB
-rw-r--r--
backup.result
4.29
KB
-rw-r--r--
bench_count_distinct.result
557
B
-rw-r--r--
big_test.require
17
B
-rw-r--r--
bigint.result
23.33
KB
-rw-r--r--
binary.result
6.09
KB
-rw-r--r--
binary_to_hex.result
5.87
KB
-rw-r--r--
binlog_tx_isolation.result
1.71
KB
-rw-r--r--
blackhole.result
613
B
-rw-r--r--
blackhole_plugin.result
565
B
-rw-r--r--
bool.result
2.67
KB
-rw-r--r--
bootstrap.result
525
B
-rw-r--r--
bug12368203.result
2.77
KB
-rw-r--r--
bug12427262.result
1.86
KB
-rw-r--r--
bug12969156.result
952
B
-rw-r--r--
bug17076131.result
322
B
-rw-r--r--
bug33509.result
2.31
KB
-rw-r--r--
bug39022.result
1.2
KB
-rw-r--r--
bug46080.result
669
B
-rw-r--r--
bug46261.result
353
B
-rw-r--r--
bug46760.result
1.26
KB
-rw-r--r--
bug47671.result
287
B
-rw-r--r--
bug58669.result
480
B
-rw-r--r--
bulk_replace.result
281
B
-rw-r--r--
cache_innodb.result
6.96
KB
-rw-r--r--
case.result
10.63
KB
-rw-r--r--
case_insensitive_file_system.r...
46
B
-rw-r--r--
case_sensitive_file_system.req...
47
B
-rw-r--r--
cast.result
16.27
KB
-rw-r--r--
change_user.result
2.82
KB
-rw-r--r--
charset.result
2.14
KB
-rw-r--r--
check.result
2.05
KB
-rw-r--r--
check_auto_permission.result
261
B
-rw-r--r--
check_var_limit.require
8
B
-rw-r--r--
client_xml.result
2.38
KB
-rw-r--r--
comment_column.result
141.21
KB
-rw-r--r--
comment_column2.result
355.68
KB
-rw-r--r--
comment_index.result
173.32
KB
-rw-r--r--
comment_table.result
28.95
KB
-rw-r--r--
comments.result
2.34
KB
-rw-r--r--
commit.result
14.83
KB
-rw-r--r--
commit_1innodb.result
19.59
KB
-rw-r--r--
compare.result
5.07
KB
-rw-r--r--
compress.result
66.24
KB
-rw-r--r--
concurrent_innodb_safelog.resu...
32.01
KB
-rw-r--r--
concurrent_innodb_unsafelog.re...
31.74
KB
-rw-r--r--
condition_filter.result
2.17
KB
-rw-r--r--
connect.result
11.02
KB
-rw-r--r--
connect_debug.result
1.46
KB
-rw-r--r--
consistent_snapshot.result
1.14
KB
-rw-r--r--
constraints.result
2.56
KB
-rw-r--r--
count_distinct.result
8.04
KB
-rw-r--r--
count_distinct2.result
2.21
KB
-rw-r--r--
count_distinct3.result
278
B
-rw-r--r--
create-big.result
7.6
KB
-rw-r--r--
create.result
71.42
KB
-rw-r--r--
create_not_windows.result
961
B
-rw-r--r--
create_select_tmp.result
846
B
-rw-r--r--
create_w_max_indexes_64.result
84.46
KB
-rw-r--r--
csv.result
59.08
KB
-rw-r--r--
csv_alter_table.result
1.17
KB
-rw-r--r--
csv_not_null.result
1.93
KB
-rw-r--r--
ctype_ascii.result
2.5
KB
-rw-r--r--
ctype_big5.result
34.28
KB
-rw-r--r--
ctype_binary.result
82.78
KB
-rw-r--r--
ctype_collate.result
18.3
KB
-rw-r--r--
ctype_cp1250_ch.result
22.29
KB
-rw-r--r--
ctype_cp1251.result
96.48
KB
-rw-r--r--
ctype_cp932.result
996
B
-rw-r--r--
ctype_cp932_binlog_row.result
734
B
-rw-r--r--
ctype_cp932_binlog_stm.result
251.36
KB
-rw-r--r--
ctype_create.result
3.12
KB
-rw-r--r--
ctype_errors.result
1.66
KB
-rw-r--r--
ctype_eucjpms.result
400.48
KB
-rw-r--r--
ctype_euckr.result
435.54
KB
-rw-r--r--
ctype_filename.result
324
B
-rw-r--r--
ctype_filesystem.result
341
B
-rw-r--r--
ctype_gb18030.result
69.33
KB
-rw-r--r--
ctype_gb18030_binlog.result
909
B
-rw-r--r--
ctype_gb18030_conversion.resul...
1.17
MB
-rw-r--r--
ctype_gb18030_encoding_cn.resu...
41.39
KB
-rw-r--r--
ctype_gb18030_encoding_utf8.re...
40.64
KB
-rw-r--r--
ctype_gb18030_ligatures.result
24.81
KB
-rw-r--r--
ctype_gb2312.result
33.73
KB
-rw-r--r--
ctype_gbk.result
50.07
KB
-rw-r--r--
ctype_gbk_binlog.result
633
B
-rw-r--r--
ctype_hebrew.result
254
B
-rw-r--r--
ctype_latin1.result
119.29
KB
-rw-r--r--
ctype_latin1_de.result
15.74
KB
-rw-r--r--
ctype_latin2.result
13.71
KB
-rw-r--r--
ctype_latin2_ch.result
25.11
KB
-rw-r--r--
ctype_ldml.result
28.13
KB
-rw-r--r--
ctype_like_range.result
80.89
KB
-rw-r--r--
ctype_many.result
41.87
KB
-rw-r--r--
ctype_mb.result
2.13
KB
-rw-r--r--
ctype_recoding.result
9.6
KB
-rw-r--r--
ctype_sjis.result
195.81
KB
-rw-r--r--
ctype_tis620.result
101.02
KB
-rw-r--r--
ctype_uca.result
155.4
KB
-rw-r--r--
ctype_ucs.result
143.96
KB
-rw-r--r--
ctype_ucs2_def.result
1.05
KB
-rw-r--r--
ctype_ujis.result
365.3
KB
-rw-r--r--
ctype_ujis_ucs2.result
548.6
KB
-rw-r--r--
ctype_utf16.result
47.3
KB
-rw-r--r--
ctype_utf16_def.result
273
B
-rw-r--r--
ctype_utf16_uca.result
72.47
KB
-rw-r--r--
ctype_utf16le.result
52.96
KB
-rw-r--r--
ctype_utf32.result
50.55
KB
-rw-r--r--
ctype_utf32_uca.result
75.29
KB
-rw-r--r--
ctype_utf8.result
169.69
KB
-rw-r--r--
ctype_utf8mb4.result
83.57
KB
-rw-r--r--
ctype_utf8mb4_heap.result
75.01
KB
-rw-r--r--
ctype_utf8mb4_innodb.result
77.85
KB
-rw-r--r--
ctype_utf8mb4_myisam.result
77.43
KB
-rw-r--r--
ctype_utf8mb4_uca.result
38.82
KB
-rw-r--r--
daemonize_opt.result
14
B
-rw-r--r--
datadir_permission.result
1.09
KB
-rw-r--r--
date_formats.result
28.69
KB
-rw-r--r--
ddl_i18n_koi8r.result
123.56
KB
-rw-r--r--
ddl_i18n_utf8.result
126.58
KB
-rw-r--r--
deadlock_innodb.result
2.35
KB
-rw-r--r--
debug_sync.result
12.18
KB
-rw-r--r--
debug_sync2.result
1.15
KB
-rw-r--r--
default.result
8.17
KB
-rw-r--r--
delete.result
22.7
KB
-rw-r--r--
delete_all_rows.result
2.26
KB
-rw-r--r--
deprecate_eof.result
8
KB
-rw-r--r--
deprecated_features.result
2.03
KB
-rw-r--r--
derived.result
172.18
KB
-rw-r--r--
dirty_close.result
345
B
-rw-r--r--
disabled_replication.result
4.82
KB
-rw-r--r--
disabled_storage_engines.resul...
3.28
KB
-rw-r--r--
disconnect_on_expired_password...
1.42
KB
-rw-r--r--
disconnect_on_expired_password...
1.49
KB
-rw-r--r--
distinct.result
80.43
KB
-rw-r--r--
drop-no_root.result
454
B
-rw-r--r--
drop.result
6.71
KB
-rw-r--r--
drop_debug.result
485
B
-rw-r--r--
ds_mrr-big.result
2.93
KB
-rw-r--r--
dynamic_tracing.result
813
B
-rw-r--r--
empty_table.result
229
B
-rw-r--r--
enable_cleartext_plugin.result
1.4
KB
-rw-r--r--
endspace.result
7.25
KB
-rw-r--r--
eq_range_idx_stat.result
6.56
KB
-rw-r--r--
error_simulation.result
3.17
KB
-rw-r--r--
errors.result
6.11
KB
-rw-r--r--
events_1.result
28.3
KB
-rw-r--r--
events_2.result
17.79
KB
-rw-r--r--
events_and_binlog.result
297
B
-rw-r--r--
events_bugs.result
40.94
KB
-rw-r--r--
events_embedded.result
86
B
-rw-r--r--
events_grant.result
10.33
KB
-rw-r--r--
events_logs_tests.result
2.37
KB
-rw-r--r--
events_microsec.result
810
B
-rw-r--r--
events_restart.result
4.36
KB
-rw-r--r--
events_scheduling.result
3.11
KB
-rw-r--r--
events_stress.result
2.39
KB
-rw-r--r--
events_time_zone.result
5.4
KB
-rw-r--r--
events_trans.result
3.61
KB
-rw-r--r--
events_trans_notembedded.resul...
1.88
KB
-rw-r--r--
examined_rows.result
6.73
KB
-rw-r--r--
execution_constants.result
1.03
KB
-rw-r--r--
explain.result
39.39
KB
-rw-r--r--
explain_for_connection_crash.r...
1004
B
-rw-r--r--
explain_for_connection_rqg_jso...
87.48
KB
-rw-r--r--
explain_for_connection_rqg_tra...
35.98
KB
-rw-r--r--
explain_for_connection_small_j...
25.46
KB
-rw-r--r--
explain_for_connection_small_t...
10.3
KB
-rw-r--r--
explain_json_all.result
98.36
KB
-rw-r--r--
explain_json_none.result
102.18
KB
-rw-r--r--
explain_other.result
42.23
KB
-rw-r--r--
file_contents.result
181
B
-rw-r--r--
filesort_debug.result
4.59
KB
-rw-r--r--
filesort_merge.result
2.02
KB
-rw-r--r--
filesort_pack.result
675
B
-rw-r--r--
filter_single_col_idx_big.resu...
38.05
KB
-rw-r--r--
filter_single_col_idx_small.re...
42.99
KB
-rw-r--r--
fix_priv_tables.result
1.96
KB
-rw-r--r--
flush.result
13.78
KB
-rw-r--r--
flush2.result
1.06
KB
-rw-r--r--
flush_block_commit.result
1.47
KB
-rw-r--r--
flush_block_commit_notembedded...
872
B
-rw-r--r--
flush_read_lock.result
73.94
KB
-rw-r--r--
flush_read_lock_kill.result
1.12
KB
-rw-r--r--
flush_table.result
12.33
KB
-rw-r--r--
foreign_key.result
4.84
KB
-rw-r--r--
fulltext.result
32.93
KB
-rw-r--r--
fulltext2.result
7.54
KB
-rw-r--r--
fulltext3.result
815
B
-rw-r--r--
fulltext_cache.result
2.67
KB
-rw-r--r--
fulltext_distinct.result
1.45
KB
-rw-r--r--
fulltext_left_join.result
4
KB
-rw-r--r--
fulltext_multi.result
766
B
-rw-r--r--
fulltext_order_by.result
6.05
KB
-rw-r--r--
fulltext_plugin.result
229
B
-rw-r--r--
fulltext_update.result
1.11
KB
-rw-r--r--
fulltext_var.result
1.3
KB
-rw-r--r--
func_aes.result
12.97
KB
-rw-r--r--
func_aes_cfb1.result
4.5
KB
-rw-r--r--
func_aes_cfb128.result
4.57
KB
-rw-r--r--
func_aes_cfb8.result
4.5
KB
-rw-r--r--
func_aes_kdf_hkdf.result
3.94
KB
-rw-r--r--
func_aes_kdf_pbkdf2_hmac.resul...
6.79
KB
-rw-r--r--
func_aes_misc.result
8.46
KB
-rw-r--r--
func_aes_ofb.result
4.47
KB
-rw-r--r--
func_analyse.result
23.09
KB
-rw-r--r--
func_bitwise_ops.result
80.6
KB
-rw-r--r--
func_compress.result
5.46
KB
-rw-r--r--
func_concat.result
4.37
KB
-rw-r--r--
func_crypt.result
2.05
KB
-rw-r--r--
func_date_add.result
3.74
KB
-rw-r--r--
func_default.result
1.45
KB
-rw-r--r--
func_des_encrypt.result
2.68
KB
-rw-r--r--
func_digest.result
122.35
KB
-rw-r--r--
func_encrypt.result
19.82
KB
-rw-r--r--
func_encrypt_nossl.result
7.75
KB
-rw-r--r--
func_encrypt_ucs2.result
1.21
KB
-rw-r--r--
func_equal.result
1.27
KB
-rw-r--r--
func_found_rows.result
285
B
-rw-r--r--
func_gconcat.result
49.9
KB
-rw-r--r--
func_group.result
66.46
KB
-rw-r--r--
func_group_innodb.result
6.07
KB
-rw-r--r--
func_group_innodb_16k.result
693
B
-rw-r--r--
func_if.result
6.29
KB
-rw-r--r--
func_in_all.result
49.27
KB
-rw-r--r--
func_in_icp.result
48.91
KB
-rw-r--r--
func_in_icp_mrr.result
49.21
KB
-rw-r--r--
func_in_mrr.result
48.93
KB
-rw-r--r--
func_in_mrr_cost.result
48.65
KB
-rw-r--r--
func_in_none.result
48.6
KB
-rw-r--r--
func_isnull.result
827
B
-rw-r--r--
func_like.result
7.78
KB
-rw-r--r--
func_math.result
42.22
KB
-rw-r--r--
func_misc.result
36.8
KB
-rw-r--r--
func_op.result
2.12
KB
-rw-r--r--
func_regexp.result
4.47
KB
-rw-r--r--
func_rollback.result
13.02
KB
-rw-r--r--
func_sapdb.result
12.49
KB
-rw-r--r--
func_set.result
8.9
KB
-rw-r--r--
func_str.result
174.94
KB
-rw-r--r--
func_str_debug.result
349
B
-rw-r--r--
func_str_no_ps.result
1.3
KB
-rw-r--r--
func_system.result
2.9
KB
-rw-r--r--
func_test.result
14.47
KB
-rw-r--r--
func_time.result
71.47
KB
-rw-r--r--
func_timestamp.result
518
B
-rw-r--r--
func_weight_string.result
11.56
KB
-rw-r--r--
function_defaults.result
109.58
KB
-rw-r--r--
gcc296.result
528
B
-rw-r--r--
get_diagnostics.result
28.42
KB
-rw-r--r--
get_table_share.result
20.56
KB
-rw-r--r--
gis-debug.result
10.1
KB
-rw-r--r--
gis-precise.result
162.17
KB
-rw-r--r--
gis-rt-precise.result
2.42
KB
-rw-r--r--
gis-rtree.result
102.08
KB
-rw-r--r--
gis.result
131.8
KB
-rw-r--r--
grant.result
121.17
KB
-rw-r--r--
grant2.result
36.52
KB
-rw-r--r--
grant3.result
8.41
KB
-rw-r--r--
grant4.result
9.36
KB
-rw-r--r--
grant_alter_user.result
40.96
KB
-rw-r--r--
grant_alter_user_qa.result
98.38
KB
-rw-r--r--
grant_cache.result
6.71
KB
-rw-r--r--
grant_debug.result
8.5
KB
-rw-r--r--
grant_explain_non_select.resul...
10.27
KB
-rw-r--r--
grant_lowercase_fs.result
1.2
KB
-rw-r--r--
grant_user_lock.result
16.9
KB
-rw-r--r--
grant_user_lock_qa.result
41.4
KB
-rw-r--r--
greedy_optimizer.result
632.59
KB
-rw-r--r--
greedy_search.result
31.05
KB
-rw-r--r--
group_by.result
120.07
KB
-rw-r--r--
group_by_fd_no_prot.result
81.15
KB
-rw-r--r--
group_by_fd_ps_prot.result
61.28
KB
-rw-r--r--
group_min_max.result
189.52
KB
-rw-r--r--
group_min_max_innodb.result
25.09
KB
-rw-r--r--
gtid_next_xa_binlog_off.result
30.9
KB
-rw-r--r--
gtids_anonymous_trxs_violation...
687
B
-rw-r--r--
handler_innodb.result
41.58
KB
-rw-r--r--
handler_myisam.result
45.48
KB
-rw-r--r--
handler_read_last.result
1.15
KB
-rw-r--r--
have_big5.require
79
B
-rw-r--r--
have_binlog_format_mixed.requi...
40
B
-rw-r--r--
have_binlog_format_row.require
38
B
-rw-r--r--
have_binlog_format_statement.r...
44
B
-rw-r--r--
have_compress.require
38
B
-rw-r--r--
have_cp1250_ch.require
79
B
-rw-r--r--
have_cp1251.require
84
B
-rw-r--r--
have_cp866.require
82
B
-rw-r--r--
have_cp932.require
83
B
-rw-r--r--
have_crypt.require
35
B
-rw-r--r--
have_debug.require
8
B
-rw-r--r--
have_debug_sync.require
13
B
-rw-r--r--
have_eucjpms.require
87
B
-rw-r--r--
have_euckr.require
81
B
-rw-r--r--
have_gb18030.require
87
B
-rw-r--r--
have_gb2312.require
84
B
-rw-r--r--
have_gbk.require
78
B
-rw-r--r--
have_geometry.require
38
B
-rw-r--r--
have_koi8r.require
81
B
-rw-r--r--
have_latin2_ch.require
78
B
-rw-r--r--
have_local_infile.require
36
B
-rw-r--r--
have_log_bin.require
31
B
-rw-r--r--
have_met_timezone.require
43
B
-rw-r--r--
have_moscow_leap_timezone.requ...
46
B
-rw-r--r--
have_mysql_upgrade.result
21
B
-rw-r--r--
have_ndb_debug.require
17
B
-rw-r--r--
have_ndb_extra.require
14
B
-rw-r--r--
have_ndbapi_examples.require
19
B
-rw-r--r--
have_nodebug.require
8
B
-rw-r--r--
have_optimizer_switch.require
19
B
-rw-r--r--
have_outfile.require
55
B
-rw-r--r--
have_partition.require
42
B
-rw-r--r--
have_perror.require
14
B
-rw-r--r--
have_profiling.require
39
B
-rw-r--r--
have_query_cache.require
41
B
-rw-r--r--
have_sjis.require
81
B
-rw-r--r--
have_ssl.require
33
B
-rw-r--r--
have_ssl_is_yes_or_disabled_on...
43
B
-rw-r--r--
have_statement_timeout.require
47
B
-rw-r--r--
have_symlink.require
37
B
-rw-r--r--
have_tis620.require
81
B
-rw-r--r--
have_ucs2.require
80
B
-rw-r--r--
have_ujis.require
81
B
-rw-r--r--
have_utf16.require
82
B
-rw-r--r--
have_utf32.require
82
B
-rw-r--r--
have_utf8.require
80
B
-rw-r--r--
have_utf8mb4.require
86
B
-rw-r--r--
having.result
24.34
KB
-rw-r--r--
heap.result
24.75
KB
-rw-r--r--
heap_auto_increment.result
894
B
-rw-r--r--
heap_btree.result
11.76
KB
-rw-r--r--
heap_hash.result
20.83
KB
-rw-r--r--
help.result
6.64
KB
-rw-r--r--
help_verbose.result
326
B
-rw-r--r--
host_cache_size_functionality....
3.32
KB
-rw-r--r--
ignore_strict.result
30.82
KB
-rw-r--r--
implicit_char_to_num_conversio...
6.44
KB
-rw-r--r--
implicit_commit.result
18.33
KB
-rw-r--r--
import_schema_mismatch.result
478
B
-rw-r--r--
index_merge_delete.result
25.04
KB
-rw-r--r--
index_merge_innodb.result
124.56
KB
-rw-r--r--
index_merge_insert-and-replace...
14.54
KB
-rw-r--r--
index_merge_intersect_dml.resu...
5.85
KB
-rw-r--r--
index_merge_myisam.result
144.52
KB
-rw-r--r--
index_merge_update.result
17.22
KB
-rw-r--r--
information_schema-big.result
2.81
KB
-rw-r--r--
information_schema.result
107.92
KB
-rw-r--r--
information_schema_chmod.resul...
182
B
-rw-r--r--
information_schema_db.result
9.98
KB
-rw-r--r--
information_schema_inno.result
4.33
KB
-rw-r--r--
information_schema_parameters....
22.49
KB
-rw-r--r--
information_schema_part.result
11.97
KB
-rw-r--r--
information_schema_routines.re...
30.81
KB
-rw-r--r--
init_connect.result
3.57
KB
-rw-r--r--
init_file.result
323
B
-rw-r--r--
initialize-bug20350099.result
1.04
KB
-rw-r--r--
initialize-bug20504142.result
1.17
KB
-rw-r--r--
initialize-bug21335821.result
895
B
-rw-r--r--
initialize-errors.result
578
B
-rw-r--r--
initialize-ignore-db.result
742
B
-rw-r--r--
initialize-init-acls.result
1.12
KB
-rw-r--r--
initialize-sha256.result
1.09
KB
-rw-r--r--
initialize.result
3.89
KB
-rw-r--r--
initialize_gtid.result
465
B
-rw-r--r--
innodb_deadlock.result
1.25
KB
-rw-r--r--
innodb_disabled.result
208
B
-rw-r--r--
innodb_explain_json_non_select...
293.06
KB
-rw-r--r--
innodb_explain_json_non_select...
299.29
KB
-rw-r--r--
innodb_explain_non_select_all....
136.52
KB
-rw-r--r--
innodb_explain_non_select_none...
136.37
KB
-rw-r--r--
innodb_icp.result
32.81
KB
-rw-r--r--
innodb_icp_all.result
32.88
KB
-rw-r--r--
innodb_icp_none.result
32.72
KB
-rw-r--r--
innodb_ignore_builtin.result
354
B
-rw-r--r--
innodb_log_file_size_functiona...
2.79
KB
-rw-r--r--
innodb_mrr.result
25.74
KB
-rw-r--r--
innodb_mrr_all.result
25.88
KB
-rw-r--r--
innodb_mrr_cost.result
25.71
KB
-rw-r--r--
innodb_mrr_cost_all.result
25.85
KB
-rw-r--r--
innodb_mrr_cost_icp.result
25.82
KB
-rw-r--r--
innodb_mrr_icp.result
25.85
KB
-rw-r--r--
innodb_mrr_none.result
25.66
KB
-rw-r--r--
innodb_mysql_lock.result
4.05
KB
-rw-r--r--
innodb_mysql_lock2.result
21.4
KB
-rw-r--r--
innodb_mysql_sync.result
25.87
KB
-rw-r--r--
innodb_pk_extension_off.result
20.33
KB
-rw-r--r--
innodb_pk_extension_on.result
20.58
KB
-rw-r--r--
innodb_recovery_with_upper_cas...
1.21
KB
-rw-r--r--
insert.result
30.75
KB
-rw-r--r--
insert_debug.result
1.29
KB
-rw-r--r--
insert_notembedded.result
5.58
KB
-rw-r--r--
insert_select.result
15.34
KB
-rw-r--r--
insert_update.result
18.89
KB
-rw-r--r--
installdb-bad-cipher.result
128
B
-rw-r--r--
internal_tmp_disk_storage_engi...
146.97
KB
-rw-r--r--
ipv4_as_ipv6.result
23.83
KB
-rw-r--r--
ipv6.result
13.89
KB
-rw-r--r--
is_debug_build.require
32
B
-rw-r--r--
is_deprecation.result
558
B
-rw-r--r--
is_embedded.require
16
B
-rw-r--r--
isam.result
15.65
KB
-rw-r--r--
join.result
55.68
KB
-rw-r--r--
join_cache_bka.result
108.89
KB
-rw-r--r--
join_cache_bka_nixbnl.result
108.17
KB
-rw-r--r--
join_cache_bkaunique.result
109.32
KB
-rw-r--r--
join_cache_bnl.result
107.23
KB
-rw-r--r--
join_cache_nojb.result
106.25
KB
-rw-r--r--
join_crash.result
4.53
KB
-rw-r--r--
join_file_handler.result
1.04
KB
-rw-r--r--
join_nested.result
86.66
KB
-rw-r--r--
join_nested_bka.result
92.75
KB
-rw-r--r--
join_nested_bka_nixbnl.result
89.71
KB
-rw-r--r--
join_optimizer.result
2.54
KB
-rw-r--r--
join_outer.result
96.52
KB
-rw-r--r--
join_outer_bka.result
96.89
KB
-rw-r--r--
join_outer_bka_nixbnl.result
94.69
KB
-rw-r--r--
join_outer_innodb.result
3.27
KB
-rw-r--r--
key.result
22.58
KB
-rw-r--r--
key_cache.result
11.88
KB
-rw-r--r--
key_diff.result
1.15
KB
-rw-r--r--
key_primary.result
890
B
-rw-r--r--
keywords.result
6.63
KB
-rw-r--r--
kill.result
8.88
KB
-rw-r--r--
kill_debug.result
1.58
KB
-rw-r--r--
limit.result
8.31
KB
-rw-r--r--
loaddata.result
20.8
KB
-rw-r--r--
loaddata_autocom_innodb.result
651
B
-rw-r--r--
loadxml.result
2.7
KB
-rw-r--r--
locale.result
5.59
KB
-rw-r--r--
lock.result
14.09
KB
-rw-r--r--
lock_multi.result
63.2
KB
-rw-r--r--
lock_multi_bug38499.result
964
B
-rw-r--r--
lock_multi_bug38691.result
812
B
-rw-r--r--
lock_sync.result
27.44
KB
-rw-r--r--
lock_tables_lost_commit.result
150
B
-rw-r--r--
locking_service.result
31.09
KB
-rw-r--r--
log_errchk.result
663
B
-rw-r--r--
log_state.result
9.66
KB
-rw-r--r--
log_state_bug33693.result
111
B
-rw-r--r--
log_tables-big.result
996
B
-rw-r--r--
log_tables.result
41.81
KB
-rw-r--r--
log_tables_debug.result
770
B
-rw-r--r--
log_tables_upgrade.result
2.35
KB
-rw-r--r--
log_timestamps.result
71
B
-rw-r--r--
long_tmpdir.result
99
B
-rw-r--r--
lowercase0.require
45
B
-rw-r--r--
lowercase1.require
45
B
-rw-r--r--
lowercase2.require
45
B
-rw-r--r--
lowercase_fs_off.result
3.46
KB
-rw-r--r--
lowercase_fs_on.result
75
B
-rw-r--r--
lowercase_mixed_tmpdir.result
162
B
-rw-r--r--
lowercase_mixed_tmpdir_innodb....
190
B
-rw-r--r--
lowercase_table.result
3.24
KB
-rw-r--r--
lowercase_table2.result
8.66
KB
-rw-r--r--
lowercase_table4.result
4.63
KB
-rw-r--r--
lowercase_table5.result
673
B
-rw-r--r--
lowercase_table_grant.result
2.01
KB
-rw-r--r--
lowercase_table_qcache.result
847
B
-rw-r--r--
lowercase_utf8.result
173
B
-rw-r--r--
lowercase_view.result
10.21
KB
-rw-r--r--
m_i_db.result
15.5
KB
-rw-r--r--
max_statement_time.result
12.81
KB
-rw-r--r--
mdl_sync.result
113.92
KB
-rw-r--r--
mdl_tablespace.result
34.72
KB
-rw-r--r--
merge-big.result
728
B
-rw-r--r--
merge.result
100.14
KB
-rw-r--r--
merge_innodb.result
1.31
KB
-rw-r--r--
merge_mmap.result
3.33
KB
-rw-r--r--
metadata.result
17.03
KB
-rw-r--r--
mix2_myisam.result
66.36
KB
-rw-r--r--
mix2_myisam_ucs2.result
15.35
KB
-rw-r--r--
multi_plugin_load.result
347
B
-rw-r--r--
multi_plugin_load_add.result
455
B
-rw-r--r--
multi_plugin_load_add2.result
455
B
-rw-r--r--
multi_statement.result
563
B
-rw-r--r--
multi_update.result
26.47
KB
-rw-r--r--
multi_update2.result
1016
B
-rw-r--r--
multi_update_innodb.result
4.52
KB
-rw-r--r--
multi_update_tiny_hash.result
1.5
KB
-rw-r--r--
myisam-blob.result
1.41
KB
-rw-r--r--
myisam-system.result
394
B
-rw-r--r--
myisam.result
96.84
KB
-rw-r--r--
myisam_crash_before_flush_keys...
1.15
KB
-rw-r--r--
myisam_debug.result
1.21
KB
-rw-r--r--
myisam_explain_json_non_select...
287.97
KB
-rw-r--r--
myisam_explain_json_non_select...
294.08
KB
-rw-r--r--
myisam_explain_non_select_all....
133.64
KB
-rw-r--r--
myisam_explain_non_select_none...
133.36
KB
-rw-r--r--
myisam_icp.result
31.96
KB
-rw-r--r--
myisam_icp_all.result
32.02
KB
-rw-r--r--
myisam_icp_none.result
31.84
KB
-rw-r--r--
myisam_mrr.result
24.26
KB
-rw-r--r--
myisam_mrr_all.result
24.43
KB
-rw-r--r--
myisam_mrr_cost.result
24.21
KB
-rw-r--r--
myisam_mrr_cost_all.result
24.38
KB
-rw-r--r--
myisam_mrr_cost_icp.result
24.35
KB
-rw-r--r--
myisam_mrr_icp.result
24.4
KB
-rw-r--r--
myisam_mrr_none.result
24.16
KB
-rw-r--r--
myisam_recover.result
4.57
KB
-rw-r--r--
myisam_row_rpl.result
2.04
KB
-rw-r--r--
myisampack.result
7.56
KB
-rw-r--r--
mysql-bug41486.result
465
B
-rw-r--r--
mysql-bug45236.result
329
B
-rw-r--r--
mysql.result
9.77
KB
-rw-r--r--
mysql_batch_mode.result
84
B
-rw-r--r--
mysql_binary_mode.result
1.52
KB
-rw-r--r--
mysql_client_test.result
8.92
KB
-rw-r--r--
mysql_client_test_embedded.res...
111
B
-rw-r--r--
mysql_client_test_qcache.resul...
500
B
-rw-r--r--
mysql_comments.result
6.68
KB
-rw-r--r--
mysql_config_editor.result
8.01
KB
-rw-r--r--
mysql_cp932.result
37
B
-rw-r--r--
mysql_embedded.result
181
B
-rw-r--r--
mysql_embedded_client_test.res...
153
B
-rw-r--r--
mysql_locale_posix.result
973
B
-rw-r--r--
mysql_not_windows.result
477
B
-rw-r--r--
mysql_plugin.result
4.92
KB
-rw-r--r--
mysql_protocols.result
208
B
-rw-r--r--
mysql_ssl.result
152
B
-rw-r--r--
mysql_ssl_default.result
889
B
-rw-r--r--
mysql_tzinfo_to_sql.result
22.11
KB
-rw-r--r--
mysql_tzinfo_to_sql_sys.result
1.28
KB
-rw-r--r--
mysql_upgrade.result
136.32
KB
-rw-r--r--
mysql_upgrade_slave_master_inf...
5
KB
-rw-r--r--
mysql_upgrade_ssl.result
5.65
KB
-rw-r--r--
mysql_upgrade_with_session_use...
2.77
KB
-rw-r--r--
mysqladmin.result
1.22
KB
-rw-r--r--
mysqladmin_shutdown.result
170
B
-rw-r--r--
mysqlbinlog.result
31.28
KB
-rw-r--r--
mysqlbinlog_base64_flag.result
3.89
KB
-rw-r--r--
mysqlbinlog_debug.result
235
B
-rw-r--r--
mysqlbinlog_hexdump.result
6.5
KB
-rw-r--r--
mysqlbinlog_mixed_or_statment....
855
B
-rw-r--r--
mysqlbinlog_raw_mode.result
8.32
KB
-rw-r--r--
mysqlbinlog_raw_mode_win.resul...
8.08
KB
-rw-r--r--
mysqlbinlog_row_big.result
2.42
KB
-rw-r--r--
mysqlcheck.result
19.17
KB
-rw-r--r--
mysqld--defaults-file.result
908
B
-rw-r--r--
mysqld--help-notwin.result
67.99
KB
-rw-r--r--
mysqld--help-win.result
68.06
KB
-rw-r--r--
mysqld_daemon.result
66
B
-rw-r--r--
mysqld_safe.result
142
B
-rw-r--r--
mysqldump-binary.result
3.51
KB
-rw-r--r--
mysqldump-compat.result
111
B
-rw-r--r--
mysqldump-max.result
11.33
KB
-rw-r--r--
mysqldump-no-binlog.result
50
B
-rw-r--r--
mysqldump.result
295.21
KB
-rw-r--r--
mysqldump_bug29998457.result
3.47
KB
-rw-r--r--
mysqldump_bug30042589.result
3.05
KB
-rw-r--r--
mysqldump_bugs.result
5.04
KB
-rw-r--r--
mysqldump_gtid_state.result
2.69
KB
-rw-r--r--
mysqldump_restore.result
4.01
KB
-rw-r--r--
mysqldumpslow.result
1.13
KB
-rw-r--r--
mysqlimport.result
833
B
-rw-r--r--
mysqlpump.result
16.38
KB
-rw-r--r--
mysqlpump_basic.result
23.91
KB
-rw-r--r--
mysqlpump_bugs.result
850
B
-rw-r--r--
mysqlpump_charset.result
15.54
KB
-rw-r--r--
mysqlpump_concurrency.result
11.41
KB
-rw-r--r--
mysqlpump_extended.result
13.01
KB
-rw-r--r--
mysqlpump_filters.result
11.34
KB
-rw-r--r--
mysqlpump_multi_thread.result
11.53
KB
-rw-r--r--
mysqlpump_partial_bkp.result
797
B
-rw-r--r--
mysqlshow.result
9.96
KB
-rw-r--r--
mysqlslap.result
7.53
KB
-rw-r--r--
mysqltest.result
33.29
KB
-rw-r--r--
named_pipe.result
65.98
KB
-rw-r--r--
negation_elimination.result
13
KB
-rw-r--r--
no-threads.result
329
B
-rw-r--r--
no_binlog.result
64
B
-rw-r--r--
no_binlog_gtid_empty_statement...
675
B
-rw-r--r--
no_binlog_gtid_empty_transacti...
683
B
-rw-r--r--
no_binlog_gtid_mode_on.result
4.75
KB
-rw-r--r--
no_binlog_gtid_mode_on_explici...
3.84
KB
-rw-r--r--
no_binlog_gtid_next_begin_caus...
1.4
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
11.91
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
1.13
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
2.3
KB
-rw-r--r--
no_binlog_gtid_next_single_stm...
9.6
KB
-rw-r--r--
no_binlog_gtid_next_temporary_...
1.1
KB
-rw-r--r--
no_engine_substitution.result
6.01
KB
-rw-r--r--
not_asan.require
7
B
-rw-r--r--
not_embedded.require
16
B
-rw-r--r--
not_embedded_server.result
5.86
KB
-rw-r--r--
not_ndb.require
39
B
-rw-r--r--
not_openssl.require
36
B
-rw-r--r--
not_partition.result
5.75
KB
-rw-r--r--
not_ssl.require
32
B
-rw-r--r--
not_true.require
10
B
-rw-r--r--
not_valgrind.require
17
B
-rw-r--r--
not_windows.require
7
B
-rw-r--r--
null.result
16.17
KB
-rw-r--r--
null_key_all.result
27.81
KB
-rw-r--r--
null_key_icp.result
27.74
KB
-rw-r--r--
null_key_none.result
27.68
KB
-rw-r--r--
odbc.result
1.41
KB
-rw-r--r--
olap.result
20.44
KB
-rw-r--r--
one_thread_per_connection.requ...
44
B
-rw-r--r--
openssl.require
37
B
-rw-r--r--
openssl_1.result
9.65
KB
-rw-r--r--
opt_costmodel.result
11.47
KB
-rw-r--r--
opt_costmodel_downgrade.result
2.55
KB
-rw-r--r--
opt_costmodel_flush.result
27.03
KB
-rw-r--r--
opt_costmodel_pfs.result
296
B
-rw-r--r--
opt_costmodel_restart.result
7.52
KB
-rw-r--r--
opt_costmodel_tables.result
5.59
KB
-rw-r--r--
opt_costmodel_warnings.result
2.52
KB
-rw-r--r--
opt_hint_timeout.result
3.21
KB
-rw-r--r--
opt_hints.result
110.61
KB
-rw-r--r--
opt_hints_lowercase.result
1.95
KB
-rw-r--r--
opt_hints_pfs.result
1.93
KB
-rw-r--r--
opt_hints_subquery.result
135.37
KB
-rw-r--r--
optimizer_bug12837084.result
13.97
KB
-rw-r--r--
optimizer_debug_sync.result
1.32
KB
-rw-r--r--
optimizer_switch.result
30.14
KB
-rw-r--r--
order_by_all.result
78.98
KB
-rw-r--r--
order_by_icp_mrr.result
78.93
KB
-rw-r--r--
order_by_limit.result
18.46
KB
-rw-r--r--
order_by_none.result
78.59
KB
-rw-r--r--
order_by_sortkey.result
3.19
KB
-rw-r--r--
order_fill_sortbuf.result
262
B
-rw-r--r--
outfile.result
2.2
KB
-rw-r--r--
outfile_loaddata.result
11.02
KB
-rw-r--r--
overflow.result
235
B
-rw-r--r--
packet.result
9.48
KB
-rw-r--r--
parser-big-32bit.result
1.35
KB
-rw-r--r--
parser-big-64bit.result
1.35
KB
-rw-r--r--
parser.result
60.1
KB
-rw-r--r--
parser_bug21114_innodb.result
25.39
KB
-rw-r--r--
parser_not_embedded.result
4.42
KB
-rw-r--r--
parser_precedence.result
23.96
KB
-rw-r--r--
parser_stack.result
9.54
KB
-rw-r--r--
partition.result
124.74
KB
-rw-r--r--
partition_archive.result
7.74
KB
-rw-r--r--
partition_binlog.result
2.41
KB
-rw-r--r--
partition_binlog_stmt.result
955
B
-rw-r--r--
partition_blackhole.result
531
B
-rw-r--r--
partition_bug18198.result
8.07
KB
-rw-r--r--
partition_cache.result
7.16
KB
-rw-r--r--
partition_charset.result
434
B
-rw-r--r--
partition_column.result
25.2
KB
-rw-r--r--
partition_column_prune.result
4.39
KB
-rw-r--r--
partition_csv.result
2.69
KB
-rw-r--r--
partition_datatype.result
47.14
KB
-rw-r--r--
partition_debug.result
985
B
-rw-r--r--
partition_debug_sync.result
6.26
KB
-rw-r--r--
partition_debug_sync_stmt.resu...
3.65
KB
-rw-r--r--
partition_deprecation.result
4.88
KB
-rw-r--r--
partition_error.result
84.03
KB
-rw-r--r--
partition_exchange.result
65.43
KB
-rw-r--r--
partition_explicit_prune.resul...
57.97
KB
-rw-r--r--
partition_federated.result
271
B
-rw-r--r--
partition_grant.result
1.67
KB
-rw-r--r--
partition_hash.result
11.15
KB
-rw-r--r--
partition_index_innodb.result
6.16
KB
-rw-r--r--
partition_index_myisam.result
5.35
KB
-rw-r--r--
partition_innodb.result
50.73
KB
-rw-r--r--
partition_innodb_plugin.result
3.11
KB
-rw-r--r--
partition_innodb_semi_consiste...
2.92
KB
-rw-r--r--
partition_innodb_stmt.result
1.12
KB
-rw-r--r--
partition_innodb_tablespace.re...
35.12
KB
-rw-r--r--
partition_key_cache.result
22.78
KB
-rw-r--r--
partition_list.result
13.93
KB
-rw-r--r--
partition_locking.result
246.59
KB
-rw-r--r--
partition_locking_4.result
1.7
KB
-rw-r--r--
partition_mgm.result
9.83
KB
-rw-r--r--
partition_mgm_err.result
7.48
KB
-rw-r--r--
partition_mgm_err2.result
373
B
-rw-r--r--
partition_myisam.result
10.25
KB
-rw-r--r--
partition_not_blackhole.result
456
B
-rw-r--r--
partition_not_windows.result
4.27
KB
-rw-r--r--
partition_order.result
16.29
KB
-rw-r--r--
partition_plugin.result
4.48
KB
-rw-r--r--
partition_pruning.result
290.58
KB
-rw-r--r--
partition_range.result
46.69
KB
-rw-r--r--
partition_rename_longfilename....
1.91
KB
-rw-r--r--
partition_symlink.result
6.25
KB
-rw-r--r--
partition_sync.result
1.35
KB
-rw-r--r--
partition_truncate.result
675
B
-rw-r--r--
partition_utf8.result
2.01
KB
-rw-r--r--
partition_windows.result
3.3
KB
-rw-r--r--
per_thread_connection_handler....
1.45
KB
-rw-r--r--
perror-win.result
453
B
-rw-r--r--
perror.result
471
B
-rw-r--r--
plugin.result
8.52
KB
-rw-r--r--
plugin_auth.result
33.72
KB
-rw-r--r--
plugin_auth_expire.result
644
B
-rw-r--r--
plugin_auth_qa.result
24.47
KB
-rw-r--r--
plugin_auth_qa_1.result
16.11
KB
-rw-r--r--
plugin_auth_qa_2.result
11.17
KB
-rw-r--r--
plugin_auth_qa_3.result
1.29
KB
-rw-r--r--
plugin_auth_sha256.result
5.52
KB
-rw-r--r--
plugin_auth_sha256_2.result
1.96
KB
-rw-r--r--
plugin_auth_sha256_server_defa...
3.7
KB
-rw-r--r--
plugin_auth_sha256_server_defa...
4.02
KB
-rw-r--r--
plugin_auth_sha256_tls.result
2.53
KB
-rw-r--r--
plugin_auth_user_lock.result
1
KB
-rw-r--r--
plugin_load.result
76
B
-rw-r--r--
plugin_load_option.result
321
B
-rw-r--r--
plugin_not_embedded.result
995
B
-rw-r--r--
preload.result
3.84
KB
-rw-r--r--
profiling.result
16.4
KB
-rw-r--r--
ps.result
125.1
KB
-rw-r--r--
ps_10nestset.result
2.08
KB
-rw-r--r--
ps_11bugs.result
6.01
KB
-rw-r--r--
ps_1general.result
35.8
KB
-rw-r--r--
ps_2myisam.result
103.52
KB
-rw-r--r--
ps_3innodb.result
103.06
KB
-rw-r--r--
ps_4heap.result
102.98
KB
-rw-r--r--
ps_5merge.result
201.74
KB
-rw-r--r--
ps_ddl.result
53.74
KB
-rw-r--r--
ps_ddl1.result
11.06
KB
-rw-r--r--
ps_grant.result
3.99
KB
-rw-r--r--
ps_not_windows.result
516
B
-rw-r--r--
ps_w_max_indexes_64.result
189.58
KB
-rw-r--r--
python_with_json.require
27
B
-rw-r--r--
query_cache.result
89.5
KB
-rw-r--r--
query_cache_28249.result
3.58
KB
-rw-r--r--
query_cache_debug.result
11.1
KB
-rw-r--r--
query_cache_disabled.result
1.96
KB
-rw-r--r--
query_cache_merge.result
32.8
KB
-rw-r--r--
query_cache_notembedded.result
11.37
KB
-rw-r--r--
query_cache_ps_no_prot.result
12.26
KB
-rw-r--r--
query_cache_ps_ps_prot.result
11.09
KB
-rw-r--r--
query_cache_size_functionality...
7.69
KB
-rw-r--r--
query_cache_type_functionality...
9.19
KB
-rw-r--r--
query_cache_with_views.result
6.02
KB
-rw-r--r--
range_all.result
145.86
KB
-rw-r--r--
range_icp.result
145.41
KB
-rw-r--r--
range_icp_mrr.result
145.8
KB
-rw-r--r--
range_mrr.result
145.32
KB
-rw-r--r--
range_mrr_cost.result
144.95
KB
-rw-r--r--
range_none.result
144.9
KB
-rw-r--r--
range_with_memory_limit.result
190.38
KB
-rw-r--r--
read_many_rows_innodb.result
2.83
KB
-rw-r--r--
read_only.result
23.09
KB
-rw-r--r--
read_only_innodb.result
5.42
KB
-rw-r--r--
relay_log_index_variables.resu...
469
B
-rw-r--r--
relay_log_variables.result
475
B
-rw-r--r--
rename.result
1.58
KB
-rw-r--r--
renamedb.result
880
B
-rw-r--r--
repair.result
6.43
KB
-rw-r--r--
replace.result
1.27
KB
-rw-r--r--
reset_connection.result
6.46
KB
-rw-r--r--
rewrite_general_log.result
6.48
KB
-rw-r--r--
rewrite_slow_log.result
3.75
KB
-rw-r--r--
rollback.result
574
B
-rw-r--r--
round.result
6.92
KB
-rw-r--r--
row.result
23.11
KB
-rw-r--r--
rowid_order_innodb.result
3.6
KB
-rw-r--r--
rpl_colSize.result
4.39
KB
-rw-r--r--
rpl_connect_attr.result
1.21
KB
-rw-r--r--
rpl_extraColmaster_innodb.resu...
23.85
KB
-rw-r--r--
rpl_extraColmaster_myisam.resu...
23.85
KB
-rw-r--r--
rpl_multi_source_mysqldump_sla...
1.5
KB
-rw-r--r--
rpl_mysqldump_slave.result
867
B
-rw-r--r--
schema.result
2.34
KB
-rw-r--r--
secure_file_priv_win.result
1.43
KB
-rw-r--r--
select_all.result
180.1
KB
-rw-r--r--
select_all_bka.result
180.83
KB
-rw-r--r--
select_all_bka_nixbnl.result
180.1
KB
-rw-r--r--
select_for_update.result
755
B
-rw-r--r--
select_found.result
6.96
KB
-rw-r--r--
select_icp_mrr.result
180.04
KB
-rw-r--r--
select_icp_mrr_bka.result
180.77
KB
-rw-r--r--
select_icp_mrr_bka_nixbnl.resu...
180.04
KB
-rw-r--r--
select_none.result
179.38
KB
-rw-r--r--
select_none_bka.result
179.47
KB
-rw-r--r--
select_none_bka_nixbnl.result
178.64
KB
-rw-r--r--
select_safe.result
9.97
KB
-rw-r--r--
server_id.require
32
B
-rw-r--r--
server_id1.require
34
B
-rw-r--r--
server_offline_1.result
2.03
KB
-rw-r--r--
server_offline_2.result
1.28
KB
-rw-r--r--
server_offline_3.result
1.31
KB
-rw-r--r--
server_offline_4.result
958
B
-rw-r--r--
server_offline_5.result
7.23
KB
-rw-r--r--
server_offline_6.result
1.2
KB
-rw-r--r--
server_uuid.result
785
B
-rw-r--r--
server_uuid_embedded.result
325
B
-rw-r--r--
session_tracker.result
23.61
KB
-rw-r--r--
session_tracker_trx_state.resu...
38.38
KB
-rw-r--r--
shm.result
66.48
KB
-rw-r--r--
shm_server_restart.result
20
B
-rw-r--r--
show_check.result
78.63
KB
-rw-r--r--
show_processlist_state.result
150
B
-rw-r--r--
show_profile.result
491
B
-rw-r--r--
show_variables.result
372
B
-rw-r--r--
shutdown.result
325
B
-rw-r--r--
signal.result
71.01
KB
-rw-r--r--
signal_code.result
1020
B
-rw-r--r--
signal_demo1.result
6.25
KB
-rw-r--r--
signal_demo2.result
3.86
KB
-rw-r--r--
signal_demo3.result
3.33
KB
-rw-r--r--
signal_sqlmode.result
2.63
KB
-rw-r--r--
single_delete_update.result
24.5
KB
-rw-r--r--
skip_grants.result
2.7
KB
-rw-r--r--
skip_grants_flush.result
352
B
-rw-r--r--
skip_log_bin.result
167
B
-rw-r--r--
skip_name_resolve.result
2.51
KB
-rw-r--r--
slave-running.result
71
B
-rw-r--r--
slave-stopped.result
72
B
-rw-r--r--
slow_log.result
2.57
KB
-rw-r--r--
sort_buffer_size_functionality...
6.61
KB
-rw-r--r--
sp-big.result
1.47
KB
-rw-r--r--
sp-bugs.result
11.46
KB
-rw-r--r--
sp-code.result
29.86
KB
-rw-r--r--
sp-destruct.result
7.02
KB
-rw-r--r--
sp-dynamic.result
9.73
KB
-rw-r--r--
sp-error.result
84.05
KB
-rw-r--r--
sp-fib.result
656
B
-rw-r--r--
sp-lock.result
21.56
KB
-rw-r--r--
sp-no-code.result
307
B
-rw-r--r--
sp-prelocking.result
7
KB
-rw-r--r--
sp-security.result
26.42
KB
-rw-r--r--
sp-threads.result
2.01
KB
-rw-r--r--
sp-ucs2.result
5.45
KB
-rw-r--r--
sp-vars.result
30.01
KB
-rw-r--r--
sp.result
192.98
KB
-rw-r--r--
sp_debug.result
735
B
-rw-r--r--
sp_gis.result
853
B
-rw-r--r--
sp_notembedded.result
14.61
KB
-rw-r--r--
sp_stress_case.result
2.53
KB
-rw-r--r--
sp_sync.result
3.17
KB
-rw-r--r--
sp_trans.result
14.83
KB
-rw-r--r--
sp_trans_log.result
891
B
-rw-r--r--
sp_validation.result
34.85
KB
-rw-r--r--
sql_mode.result
23.42
KB
-rw-r--r--
sql_mode_default.result
3.39
KB
-rw-r--r--
ssl-big.result
69
B
-rw-r--r--
ssl-crl-revoked-crl.result
76
B
-rw-r--r--
ssl-sha512.result
636
B
-rw-r--r--
ssl.result
66.63
KB
-rw-r--r--
ssl_8k_key.result
42
B
-rw-r--r--
ssl_and_innodb.result
306
B
-rw-r--r--
ssl_auto_detect_openssl.result
361
B
-rw-r--r--
ssl_ca.result
857
B
-rw-r--r--
ssl_cipher.result
295
B
-rw-r--r--
ssl_compress.result
66.25
KB
-rw-r--r--
ssl_connect.result
10
B
-rw-r--r--
ssl_crl.result
1.21
KB
-rw-r--r--
ssl_crl_clients-valid.result
1.01
KB
-rw-r--r--
ssl_crl_clients.result
427
B
-rw-r--r--
ssl_crl_clients_valid.result
673
B
-rw-r--r--
ssl_crl_crlpath.result
808
B
-rw-r--r--
ssl_deprecated_tls_versions.re...
334
B
-rw-r--r--
ssl_verify_identity.result
1.35
KB
-rw-r--r--
status.result
11.15
KB
-rw-r--r--
status2.result
1.35
KB
-rw-r--r--
status_bug17954.result
582
B
-rw-r--r--
status_debug.result
3.48
KB
-rw-r--r--
strict.result
78.07
KB
-rw-r--r--
strict_autoinc_1myisam.result
1.05
KB
-rw-r--r--
strict_autoinc_2innodb.result
1.05
KB
-rw-r--r--
strict_autoinc_3heap.result
1.05
KB
-rw-r--r--
subquery_all.result
298.58
KB
-rw-r--r--
subquery_all_bka.result
298.82
KB
-rw-r--r--
subquery_all_bka_nixbnl.result
298.37
KB
-rw-r--r--
subquery_bugs.result
4.36
KB
-rw-r--r--
subquery_mat.result
133.51
KB
-rw-r--r--
subquery_mat_all.result
123.66
KB
-rw-r--r--
subquery_mat_none.result
122.3
KB
-rw-r--r--
subquery_nomat_nosj.result
297.96
KB
-rw-r--r--
subquery_nomat_nosj_bka.result
298.16
KB
-rw-r--r--
subquery_nomat_nosj_bka_nixbnl...
297.81
KB
-rw-r--r--
subquery_none.result
297.84
KB
-rw-r--r--
subquery_none_bka.result
297.94
KB
-rw-r--r--
subquery_none_bka_nixbnl.resul...
297.58
KB
-rw-r--r--
subquery_sj_all.result
500.49
KB
-rw-r--r--
subquery_sj_all_bka.result
502.11
KB
-rw-r--r--
subquery_sj_all_bka_nixbnl.res...
490.45
KB
-rw-r--r--
subquery_sj_all_bkaunique.resu...
498.68
KB
-rw-r--r--
subquery_sj_dupsweed.result
502.87
KB
-rw-r--r--
subquery_sj_dupsweed_bka.resul...
502.97
KB
-rw-r--r--
subquery_sj_dupsweed_bka_nixbn...
484.75
KB
-rw-r--r--
subquery_sj_dupsweed_bkaunique...
503
KB
-rw-r--r--
subquery_sj_firstmatch.result
487.96
KB
-rw-r--r--
subquery_sj_firstmatch_bka.res...
488.05
KB
-rw-r--r--
subquery_sj_firstmatch_bka_nix...
480.97
KB
-rw-r--r--
subquery_sj_firstmatch_bkauniq...
488.09
KB
-rw-r--r--
subquery_sj_innodb_all.result
6.38
KB
-rw-r--r--
subquery_sj_innodb_all_bka.res...
6.57
KB
-rw-r--r--
subquery_sj_innodb_all_bka_nix...
6.6
KB
-rw-r--r--
subquery_sj_innodb_all_bkauniq...
6.63
KB
-rw-r--r--
subquery_sj_innodb_none.result
6.66
KB
-rw-r--r--
subquery_sj_innodb_none_bka.re...
6.75
KB
-rw-r--r--
subquery_sj_innodb_none_bka_ni...
6.74
KB
-rw-r--r--
subquery_sj_innodb_none_bkauni...
6.79
KB
-rw-r--r--
subquery_sj_loosescan.result
502.69
KB
-rw-r--r--
subquery_sj_loosescan_bka.resu...
502.79
KB
-rw-r--r--
subquery_sj_loosescan_bka_nixb...
484.38
KB
-rw-r--r--
subquery_sj_loosescan_bkauniqu...
502.82
KB
-rw-r--r--
subquery_sj_mat.result
522.25
KB
-rw-r--r--
subquery_sj_mat_bka.result
522.34
KB
-rw-r--r--
subquery_sj_mat_bka_nixbnl.res...
505.5
KB
-rw-r--r--
subquery_sj_mat_bkaunique.resu...
522.38
KB
-rw-r--r--
subquery_sj_mat_nosj.result
549.88
KB
-rw-r--r--
subquery_sj_none.result
516.26
KB
-rw-r--r--
subquery_sj_none_bka.result
516.35
KB
-rw-r--r--
subquery_sj_none_bka_nixbnl.re...
509.41
KB
-rw-r--r--
subquery_sj_none_bkaunique.res...
516.38
KB
-rw-r--r--
subselect_debug.result
662
B
-rw-r--r--
subselect_gis.result
320
B
-rw-r--r--
subselect_innodb.result
28.76
KB
-rw-r--r--
subselect_notembedded.result
752
B
-rw-r--r--
sum_distinct-big.result
2
KB
-rw-r--r--
sum_distinct.result
3.14
KB
-rw-r--r--
symlink.result
8.12
KB
-rw-r--r--
synchronization.result
4.05
KB
-rw-r--r--
sysdate_is_now.result
76
B
-rw-r--r--
system_mysql_db.result
13.71
KB
-rw-r--r--
system_mysql_db_refs.result
3.14
KB
-rw-r--r--
table_definition_cache_functio...
6.9
KB
-rw-r--r--
table_open_cache_functionality...
12.92
KB
-rw-r--r--
tablelock.result
1.5
KB
-rw-r--r--
tablespace.result
10.57
KB
-rw-r--r--
temp_pool.result
646
B
-rw-r--r--
temp_table.result
8.18
KB
-rw-r--r--
temporal_literal.result
13.62
KB
-rw-r--r--
test_security_context.result
1.06
KB
-rw-r--r--
testdb_only.require
45
B
-rw-r--r--
timezone.result
2.58
KB
-rw-r--r--
timezone2.result
13.21
KB
-rw-r--r--
timezone3.result
2.21
KB
-rw-r--r--
timezone4.result
148
B
-rw-r--r--
timezone_debug.result
926
B
-rw-r--r--
timezone_grant.result
4.42
KB
-rw-r--r--
trans_read_only.result
1.38
KB
-rw-r--r--
transaction_isolation.result
4.3
KB
-rw-r--r--
transaction_read_only.result
5.39
KB
-rw-r--r--
trigger-compat.result
7.98
KB
-rw-r--r--
trigger-trans.result
6.45
KB
-rw-r--r--
trigger.result
87.73
KB
-rw-r--r--
trigger_debug.result
627
B
-rw-r--r--
trigger_notembedded.result
19.95
KB
-rw-r--r--
trigger_wl3253.result
26.27
KB
-rw-r--r--
trigger_wl6030.result
53.61
KB
-rw-r--r--
true.require
7
B
-rw-r--r--
truncate.result
3.7
KB
-rw-r--r--
truncate_coverage.result
2.4
KB
-rw-r--r--
type_binary.result
9.62
KB
-rw-r--r--
type_bit.result
18.23
KB
-rw-r--r--
type_bit_innodb.result
8.2
KB
-rw-r--r--
type_blob.result
40.47
KB
-rw-r--r--
type_date.result
21.96
KB
-rw-r--r--
type_datetime.result
34.39
KB
-rw-r--r--
type_decimal.result
36.16
KB
-rw-r--r--
type_enum.result
101.64
KB
-rw-r--r--
type_float.result
12.43
KB
-rw-r--r--
type_nchar.result
1.44
KB
-rw-r--r--
type_newdecimal-big.result
678
B
-rw-r--r--
type_newdecimal.result
68.9
KB
-rw-r--r--
type_ranges.result
17.61
KB
-rw-r--r--
type_set.result
4.58
KB
-rw-r--r--
type_string.result
139
B
-rw-r--r--
type_temporal_fractional.resul...
645.37
KB
-rw-r--r--
type_temporal_upgrade.result
13.45
KB
-rw-r--r--
type_time.result
120.35
KB
-rw-r--r--
type_timestamp.result
25.71
KB
-rw-r--r--
type_timestamp_explicit.result
31.6
KB
-rw-r--r--
type_uint.result
380
B
-rw-r--r--
type_varchar.result
22.85
KB
-rw-r--r--
type_year.result
7.16
KB
-rw-r--r--
udf.result
17.31
KB
-rw-r--r--
udf_services.result
499
B
-rw-r--r--
udf_skip_grants.result
223
B
-rw-r--r--
union.result
87.33
KB
-rw-r--r--
unsafe_binlog_innodb.result
4.36
KB
-rw-r--r--
update.result
24.32
KB
-rw-r--r--
upgrade.result
5.28
KB
-rw-r--r--
user_if_exists.result
9.13
KB
-rw-r--r--
user_limits.result
5.82
KB
-rw-r--r--
user_lock.result
23.14
KB
-rw-r--r--
user_var-binlog.result
2.21
KB
-rw-r--r--
user_var.result
18.95
KB
-rw-r--r--
utility_warnings.result
7
KB
-rw-r--r--
validate_password_plugin.resul...
12.25
KB
-rw-r--r--
validate_password_plugin_check...
3.69
KB
-rw-r--r--
varbinary.result
58
KB
-rw-r--r--
variables-big.result
972
B
-rw-r--r--
variables-notembedded.result
5.97
KB
-rw-r--r--
variables-win.result
347
B
-rw-r--r--
variables.result
63.66
KB
-rw-r--r--
variables_community.result
182
B
-rw-r--r--
variables_debug.result
2.13
KB
-rw-r--r--
version_token.result
11.29
KB
-rw-r--r--
version_token_bug21280801.resu...
2.72
KB
-rw-r--r--
version_token_errors.result
2.21
KB
-rw-r--r--
view.result
258
KB
-rw-r--r--
view_alias.result
6.19
KB
-rw-r--r--
view_grant.result
126.95
KB
-rw-r--r--
view_gtid_mode_on_debug.result
1.37
KB
-rw-r--r--
wait_timeout.result
1.07
KB
-rw-r--r--
warnings.result
11.89
KB
-rw-r--r--
warnings_engine_disabled.resul...
475
B
-rw-r--r--
windows.require
7
B
-rw-r--r--
windows.result
1.98
KB
-rw-r--r--
wl3836.result
2.71
KB
-rw-r--r--
wl5928.result
15.47
KB
-rw-r--r--
wl6219-csv.result
5.16
KB
-rw-r--r--
wl6219-innodb.result
5.18
KB
-rw-r--r--
wl6219-memory.result
5.18
KB
-rw-r--r--
wl6219-merge.result
3.87
KB
-rw-r--r--
wl6219-myisam.result
5.18
KB
-rw-r--r--
wl6219-upgrade.result
10.52
KB
-rw-r--r--
wl6301_1_not_windows.result
44
B
-rw-r--r--
wl6301_2_not_windows.result
46
B
-rw-r--r--
wl6301_3.result
89
B
-rw-r--r--
wl6443_deprecation.result
10.81
KB
-rw-r--r--
wl6661.result
6.33
KB
-rw-r--r--
wl6711_heap_to_disk.result
6.07
KB
-rw-r--r--
wl6978.result
214
B
-rw-r--r--
xa.result
13.51
KB
-rw-r--r--
xa_deadlock_binlog.result
3.08
KB
-rw-r--r--
xa_debug.result
3.18
KB
-rw-r--r--
xa_gtid.result
878
B
-rw-r--r--
xa_prepared_binlog_off.result
19.77
KB
-rw-r--r--
xml.result
41.94
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : signal.result
# # PART 1: syntax # # # Test every new reserved and non reserved keywords # drop table if exists signal_non_reserved; create table signal_non_reserved ( class_origin int, subclass_origin int, constraint_catalog int, constraint_schema int, constraint_name int, catalog_name int, schema_name int, table_name int, column_name int, cursor_name int, message_text int, sqlcode int ); drop table signal_non_reserved; drop table if exists diag_non_reserved; create table diag_non_reserved ( diagnostics int, current int, stacked int, exception int ); drop table diag_non_reserved; drop table if exists diag_cond_non_reserved; create table diag_cond_non_reserved ( condition_identifier int, condition_number int, condition_name int, connection_name int, message_length int, message_octet_length int, parameter_mode int, parameter_name int, parameter_ordinal_position int, returned_sqlstate int, routine_catalog int, routine_name int, routine_schema int, server_name int, specific_name int, trigger_catalog int, trigger_name int, trigger_schema int ); drop table diag_cond_non_reserved; drop table if exists diag_stmt_non_reserved; create table diag_stmt_non_reserved ( number int, more int, command_function int, command_function_code int, dynamic_function int, dynamic_function_code int, row_count int, transactions_committed int, transactions_rolled_back int, transaction_active int ); drop table diag_stmt_non_reserved; drop table if exists test_reserved; create table test_reserved (signal int); ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'signal int)' at line 1 create table test_reserved (resignal int); ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'resignal int)' at line 1 create table test_reserved (condition int); ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition int)' at line 1 # # Test the SIGNAL syntax # drop procedure if exists test_invalid; drop procedure if exists test_signal_syntax; drop function if exists test_signal_func; create procedure test_invalid() begin SIGNAL; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; end' at line 3 create procedure test_invalid() begin SIGNAL foo; end $$ ERROR 42000: Undefined CONDITION: foo create procedure test_invalid() begin DECLARE foo CONDITION FOR 1234; SIGNAL foo; end $$ ERROR HY000: SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin SIGNAL SQLSTATE '23000'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin SIGNAL SQLSTATE VALUE '23000'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CLASS_ORIGIN = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET SUBCLASS_ORIGIN = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CONSTRAINT_CATALOG = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CONSTRAINT_SCHEMA = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CONSTRAINT_NAME = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CATALOG_NAME = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET SCHEMA_NAME = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET TABLE_NAME = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET COLUMN_NAME = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CURSOR_NAME = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MESSAGE_TEXT = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 'foo'; end $$ drop procedure test_signal_syntax $$ create procedure test_invalid() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CLASS_ORIGIN = 'foo', CLASS_ORIGIN = 'bar'; end $$ ERROR 42000: Duplicate condition information item 'CLASS_ORIGIN' create procedure test_invalid() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MESSAGE_TEXT = 'foo', MESSAGE_TEXT = 'bar'; end $$ ERROR 42000: Duplicate condition information item 'MESSAGE_TEXT' create procedure test_invalid() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 'foo', MYSQL_ERRNO = 'bar'; end $$ ERROR 42000: Duplicate condition information item 'MYSQL_ERRNO' create procedure test_signal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET CLASS_ORIGIN = 'foo', SUBCLASS_ORIGIN = 'foo', CONSTRAINT_CATALOG = 'foo', CONSTRAINT_SCHEMA = 'foo', CONSTRAINT_NAME = 'foo', CATALOG_NAME = 'foo', SCHEMA_NAME = 'foo', TABLE_NAME = 'foo', COLUMN_NAME = 'foo', CURSOR_NAME = 'foo', MESSAGE_TEXT = 'foo', MYSQL_ERRNO = 'foo'; end $$ drop procedure test_signal_syntax $$ SIGNAL SQLSTATE '00000' $$ ERROR 42000: Bad SQLSTATE: '00000' SIGNAL SQLSTATE '00001' $$ ERROR 42000: Bad SQLSTATE: '00001' create procedure test_invalid() begin SIGNAL SQLSTATE '00000'; end $$ ERROR 42000: Bad SQLSTATE: '00000' create procedure test_invalid() begin SIGNAL SQLSTATE '00001'; end $$ ERROR 42000: Bad SQLSTATE: '00001' # # Test conditions information that SIGNAL can not set # create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET bla_bla = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bla_bla = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET CONDITION_IDENTIFIER = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION_IDENTIFIER = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET CONDITION_NUMBER = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION_NUMBER = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET CONNECTION_NAME = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONNECTION_NAME = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET MESSAGE_LENGTH = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MESSAGE_LENGTH = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET MESSAGE_OCTET_LENGTH = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MESSAGE_OCTET_LENGTH = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET PARAMETER_MODE = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PARAMETER_MODE = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET PARAMETER_NAME = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PARAMETER_NAME = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET PARAMETER_ORDINAL_POSITION = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PARAMETER_ORDINAL_POSITION = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET RETURNED_SQLSTATE = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RETURNED_SQLSTATE = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET ROUTINE_CATALOG = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROUTINE_CATALOG = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET ROUTINE_NAME = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROUTINE_NAME = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET ROUTINE_SCHEMA = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROUTINE_SCHEMA = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET SERVER_NAME = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SERVER_NAME = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET SPECIFIC_NAME = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SPECIFIC_NAME = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET TRIGGER_CATALOG = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER_CATALOG = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET TRIGGER_NAME = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER_NAME = 'foo'; end' at line 3 create procedure test_invalid() begin SIGNAL SQLSTATE '12345' SET TRIGGER_SCHEMA = 'foo'; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER_SCHEMA = 'foo'; end' at line 3 # # Test the RESIGNAL syntax # drop procedure if exists test_invalid; drop procedure if exists test_resignal_syntax; create procedure test_invalid() begin RESIGNAL foo; end $$ ERROR 42000: Undefined CONDITION: foo create procedure test_resignal_syntax() begin RESIGNAL; end $$ drop procedure test_resignal_syntax $$ create procedure test_invalid() begin DECLARE foo CONDITION FOR 1234; RESIGNAL foo; end $$ ERROR HY000: SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SQLSTATE '23000'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SQLSTATE VALUE '23000'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET CLASS_ORIGIN = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CLASS_ORIGIN = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET SUBCLASS_ORIGIN = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET SUBCLASS_ORIGIN = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET CONSTRAINT_CATALOG = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CONSTRAINT_CATALOG = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET CONSTRAINT_SCHEMA = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CONSTRAINT_SCHEMA = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET CONSTRAINT_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CONSTRAINT_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET CATALOG_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CATALOG_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET SCHEMA_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET SCHEMA_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET TABLE_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET TABLE_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET COLUMN_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET COLUMN_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET CURSOR_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CURSOR_NAME = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET MESSAGE_TEXT = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET MESSAGE_TEXT = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin RESIGNAL SET MYSQL_ERRNO = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET MYSQL_ERRNO = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_invalid() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CLASS_ORIGIN = 'foo', CLASS_ORIGIN = 'bar'; end $$ ERROR 42000: Duplicate condition information item 'CLASS_ORIGIN' create procedure test_invalid() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET MESSAGE_TEXT = 'foo', MESSAGE_TEXT = 'bar'; end $$ ERROR 42000: Duplicate condition information item 'MESSAGE_TEXT' create procedure test_invalid() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET MYSQL_ERRNO = 'foo', MYSQL_ERRNO = 'bar'; end $$ ERROR 42000: Duplicate condition information item 'MYSQL_ERRNO' create procedure test_resignal_syntax() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; RESIGNAL foo SET CLASS_ORIGIN = 'foo', SUBCLASS_ORIGIN = 'foo', CONSTRAINT_CATALOG = 'foo', CONSTRAINT_SCHEMA = 'foo', CONSTRAINT_NAME = 'foo', CATALOG_NAME = 'foo', SCHEMA_NAME = 'foo', TABLE_NAME = 'foo', COLUMN_NAME = 'foo', CURSOR_NAME = 'foo', MESSAGE_TEXT = 'foo'; end $$ drop procedure test_resignal_syntax $$ create procedure test_invalid() begin RESIGNAL SQLSTATE '00000'; end $$ ERROR 42000: Bad SQLSTATE: '00000' create procedure test_invalid() begin RESIGNAL SQLSTATE '00001'; end $$ ERROR 42000: Bad SQLSTATE: '00001' # # PART 2: non preparable statements # prepare stmt from 'SIGNAL SQLSTATE \'23000\''; ERROR HY000: This command is not supported in the prepared statement protocol yet prepare stmt from 'RESIGNAL SQLSTATE \'23000\''; ERROR HY000: This command is not supported in the prepared statement protocol yet # # PART 3: runtime execution # drop procedure if exists test_signal; drop procedure if exists test_resignal; drop table if exists t_warn; drop table if exists t_cursor; create table t_warn(a integer(2)); create table t_cursor(a integer); # # SIGNAL can also appear in a query # SIGNAL foo; ERROR 42000: Undefined CONDITION: foo SIGNAL SQLSTATE '01000'; Warnings: Warning 1642 Unhandled user-defined warning condition SIGNAL SQLSTATE '02000'; ERROR 02000: Unhandled user-defined not found condition SIGNAL SQLSTATE '23000'; ERROR 23000: Unhandled user-defined exception condition SIGNAL SQLSTATE VALUE '23000'; ERROR 23000: Unhandled user-defined exception condition SIGNAL SQLSTATE 'HY000' SET MYSQL_ERRNO = 65536; ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of '65536' SIGNAL SQLSTATE 'HY000' SET MYSQL_ERRNO = 99999; ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of '99999' SIGNAL SQLSTATE 'HY000' SET MYSQL_ERRNO = 4294967295; ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of '4294967295' SIGNAL SQLSTATE 'HY000' SET MYSQL_ERRNO = 0; ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of '0' SIGNAL SQLSTATE 'HY000' SET MYSQL_ERRNO = -1; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1 SIGNAL SQLSTATE 'HY000' SET MYSQL_ERRNO = 65535; ERROR HY000: Unhandled user-defined exception condition # # RESIGNAL can also appear in a query # RESIGNAL; ERROR 0K000: RESIGNAL when handler not active RESIGNAL foo; ERROR 42000: Undefined CONDITION: foo RESIGNAL SQLSTATE '12345'; ERROR 0K000: RESIGNAL when handler not active RESIGNAL SQLSTATE VALUE '12345'; ERROR 0K000: RESIGNAL when handler not active # # Different kind of SIGNAL conditions # create procedure test_signal() begin # max range DECLARE foo CONDITION FOR SQLSTATE 'AABBB'; SIGNAL foo SET MYSQL_ERRNO = 65535; end $$ call test_signal() $$ ERROR AABBB: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # max range DECLARE foo CONDITION FOR SQLSTATE 'AABBB'; SIGNAL foo SET MYSQL_ERRNO = 65536; end $$ call test_signal() $$ ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of '65536' drop procedure test_signal $$ create procedure test_signal() begin # Error DECLARE foo CONDITION FOR SQLSTATE '99999'; SIGNAL foo SET MYSQL_ERRNO = 9999; end $$ call test_signal() $$ ERROR 99999: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # warning DECLARE too_few_records CONDITION FOR SQLSTATE '01000'; SIGNAL too_few_records SET MYSQL_ERRNO = 1261; end $$ call test_signal() $$ Warnings: Warning 1261 Unhandled user-defined warning condition drop procedure test_signal $$ create procedure test_signal() begin # Not found DECLARE sp_fetch_no_data CONDITION FOR SQLSTATE '02000'; SIGNAL sp_fetch_no_data SET MYSQL_ERRNO = 1329; end $$ call test_signal() $$ ERROR 02000: Unhandled user-defined not found condition drop procedure test_signal $$ create procedure test_signal() begin # Error DECLARE sp_cursor_already_open CONDITION FOR SQLSTATE '24000'; SIGNAL sp_cursor_already_open SET MYSQL_ERRNO = 1325; end $$ call test_signal() $$ ERROR 24000: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # Severe error DECLARE lock_deadlock CONDITION FOR SQLSTATE '40001'; SIGNAL lock_deadlock SET MYSQL_ERRNO = 1213; end $$ call test_signal() $$ ERROR 40001: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # Unknown -> error DECLARE foo CONDITION FOR SQLSTATE "99999"; SIGNAL foo; end $$ call test_signal() $$ ERROR 99999: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # warning, no subclass DECLARE warn CONDITION FOR SQLSTATE "01000"; SIGNAL warn; end $$ call test_signal() $$ Warnings: Warning 1642 Unhandled user-defined warning condition drop procedure test_signal $$ create procedure test_signal() begin # warning, with subclass DECLARE warn CONDITION FOR SQLSTATE "01123"; SIGNAL warn; end $$ call test_signal() $$ Warnings: Warning 1642 Unhandled user-defined warning condition drop procedure test_signal $$ create procedure test_signal() begin # Not found, no subclass DECLARE not_found CONDITION FOR SQLSTATE "02000"; SIGNAL not_found; end $$ call test_signal() $$ ERROR 02000: Unhandled user-defined not found condition drop procedure test_signal $$ create procedure test_signal() begin # Not found, with subclass DECLARE not_found CONDITION FOR SQLSTATE "02XXX"; SIGNAL not_found; end $$ call test_signal() $$ ERROR 02XXX: Unhandled user-defined not found condition drop procedure test_signal $$ create procedure test_signal() begin # Error, no subclass DECLARE error CONDITION FOR SQLSTATE "12000"; SIGNAL error; end $$ call test_signal() $$ ERROR 12000: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # Error, with subclass DECLARE error CONDITION FOR SQLSTATE "12ABC"; SIGNAL error; end $$ call test_signal() $$ ERROR 12ABC: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # Severe error, no subclass DECLARE error CONDITION FOR SQLSTATE "40000"; SIGNAL error; end $$ call test_signal() $$ ERROR 40000: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin # Severe error, with subclass DECLARE error CONDITION FOR SQLSTATE "40001"; SIGNAL error; end $$ call test_signal() $$ ERROR 40001: Unhandled user-defined exception condition drop procedure test_signal $$ # # Test the scope of condition # create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '99999'; begin DECLARE foo CONDITION FOR 8888; end; SIGNAL foo SET MYSQL_ERRNO=9999; /* outer */ end $$ call test_signal() $$ ERROR 99999: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR 9999; begin DECLARE foo CONDITION FOR SQLSTATE '88888'; SIGNAL foo SET MYSQL_ERRNO=8888; /* inner */ end; end $$ call test_signal() $$ ERROR 88888: Unhandled user-defined exception condition drop procedure test_signal $$ # # Test SET MYSQL_ERRNO # create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '99999'; SIGNAL foo SET MYSQL_ERRNO = 1111; end $$ call test_signal() $$ ERROR 99999: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE warn CONDITION FOR SQLSTATE "01000"; SIGNAL warn SET MYSQL_ERRNO = 1111; end $$ call test_signal() $$ Warnings: Warning 1111 Unhandled user-defined warning condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE not_found CONDITION FOR SQLSTATE "02000"; SIGNAL not_found SET MYSQL_ERRNO = 1111; end $$ call test_signal() $$ ERROR 02000: Unhandled user-defined not found condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE "55000"; SIGNAL error SET MYSQL_ERRNO = 1111; end $$ call test_signal() $$ ERROR 55000: Unhandled user-defined exception condition drop procedure test_signal $$ # # Test SET MESSAGE_TEXT # SIGNAL SQLSTATE '77777' SET MESSAGE_TEXT='' $$ ERROR 77777: create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '77777'; SIGNAL foo SET MESSAGE_TEXT = "", MYSQL_ERRNO=5678; end $$ call test_signal() $$ ERROR 77777: drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '99999'; SIGNAL foo SET MESSAGE_TEXT = "Something bad happened", MYSQL_ERRNO=9999; end $$ call test_signal() $$ ERROR 99999: Something bad happened drop procedure test_signal $$ create procedure test_signal() begin DECLARE warn CONDITION FOR SQLSTATE "01000"; SIGNAL warn SET MESSAGE_TEXT = "Something bad happened"; end $$ call test_signal() $$ Warnings: Warning 1642 Something bad happened drop procedure test_signal $$ create procedure test_signal() begin DECLARE not_found CONDITION FOR SQLSTATE "02000"; SIGNAL not_found SET MESSAGE_TEXT = "Something bad happened"; end $$ call test_signal() $$ ERROR 02000: Something bad happened drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE "55000"; SIGNAL error SET MESSAGE_TEXT = "Something bad happened"; end $$ call test_signal() $$ ERROR 55000: Something bad happened drop procedure test_signal $$ create procedure test_signal() begin DECLARE something CONDITION FOR SQLSTATE "01000"; SIGNAL something SET MESSAGE_TEXT = _utf8 "This is a UTF8 text"; end $$ call test_signal() $$ Warnings: Warning 1642 This is a UTF8 text drop procedure test_signal $$ create procedure test_signal() begin DECLARE something CONDITION FOR SQLSTATE "01000"; SIGNAL something SET MESSAGE_TEXT = ""; end $$ call test_signal() $$ Warnings: Warning 1642 drop procedure test_signal $$ create procedure test_signal() begin DECLARE warn CONDITION FOR SQLSTATE "01111"; SIGNAL warn SET MESSAGE_TEXT = "á a"; end $$ call test_signal() $$ Warnings: Warning 1642 á a show warnings $$ Level Code Message Warning 1642 á a drop procedure test_signal $$ # # Test SET complex expressions # create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET MYSQL_ERRNO = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET CLASS_ORIGIN = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'CLASS_ORIGIN' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET SUBCLASS_ORIGIN = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'SUBCLASS_ORIGIN' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET CONSTRAINT_CATALOG = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'CONSTRAINT_CATALOG' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET CONSTRAINT_SCHEMA = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'CONSTRAINT_SCHEMA' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET CONSTRAINT_NAME = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'CONSTRAINT_NAME' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET CATALOG_NAME = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'CATALOG_NAME' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET SCHEMA_NAME = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'SCHEMA_NAME' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET TABLE_NAME = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'TABLE_NAME' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET COLUMN_NAME = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'COLUMN_NAME' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET CURSOR_NAME = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'CURSOR_NAME' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE '99999'; SIGNAL error SET MESSAGE_TEXT = NULL; end $$ call test_signal() $$ ERROR 42000: Variable 'MESSAGE_TEXT' can't be set to the value of 'NULL' drop procedure test_signal $$ create procedure test_signal() begin DECLARE something CONDITION FOR SQLSTATE '99999'; DECLARE message_text VARCHAR(64) DEFAULT "Local string variable"; DECLARE sqlcode INTEGER DEFAULT 1234; SIGNAL something SET MESSAGE_TEXT = message_text, MYSQL_ERRNO = sqlcode; end $$ call test_signal() $$ ERROR 99999: Local string variable drop procedure test_signal $$ create procedure test_signal(message_text VARCHAR(64), sqlcode INTEGER) begin DECLARE something CONDITION FOR SQLSTATE "12345"; SIGNAL something SET MESSAGE_TEXT = message_text, MYSQL_ERRNO = sqlcode; end $$ call test_signal("Parameter string", NULL) $$ ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of 'NULL' call test_signal(NULL, 1234) $$ ERROR 42000: Variable 'MESSAGE_TEXT' can't be set to the value of 'NULL' call test_signal("Parameter string", 5678) $$ ERROR 12345: Parameter string drop procedure test_signal $$ create procedure test_signal() begin DECLARE something CONDITION FOR SQLSTATE "AABBB"; SIGNAL something SET MESSAGE_TEXT = @message_text, MYSQL_ERRNO = @sqlcode; end $$ call test_signal() $$ ERROR 42000: Variable 'MESSAGE_TEXT' can't be set to the value of 'NULL' set @sqlcode= 12 $$ call test_signal() $$ ERROR 42000: Variable 'MESSAGE_TEXT' can't be set to the value of 'NULL' set @message_text= "User variable" $$ call test_signal() $$ ERROR AABBB: User variable drop procedure test_signal $$ create procedure test_invalid() begin DECLARE something CONDITION FOR SQLSTATE "AABBB"; SIGNAL something SET MESSAGE_TEXT = @message_text := 'illegal', MYSQL_ERRNO = @sqlcode := 1234; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' MYSQL_ERRNO = @sqlcode := 1234; end' at line 5 create procedure test_signal() begin DECLARE aaa VARCHAR(64); DECLARE bbb VARCHAR(64); DECLARE ccc VARCHAR(64); DECLARE ddd VARCHAR(64); DECLARE eee VARCHAR(64); DECLARE fff VARCHAR(64); DECLARE ggg VARCHAR(64); DECLARE hhh VARCHAR(64); DECLARE iii VARCHAR(64); DECLARE jjj VARCHAR(64); DECLARE kkk VARCHAR(64); DECLARE warn CONDITION FOR SQLSTATE "01234"; set aaa= repeat("A", 64); set bbb= repeat("B", 64); set ccc= repeat("C", 64); set ddd= repeat("D", 64); set eee= repeat("E", 64); set fff= repeat("F", 64); set ggg= repeat("G", 64); set hhh= repeat("H", 64); set iii= repeat("I", 64); set jjj= repeat("J", 64); set kkk= repeat("K", 64); SIGNAL warn SET CLASS_ORIGIN = aaa, SUBCLASS_ORIGIN = bbb, CONSTRAINT_CATALOG = ccc, CONSTRAINT_SCHEMA = ddd, CONSTRAINT_NAME = eee, CATALOG_NAME = fff, SCHEMA_NAME = ggg, TABLE_NAME = hhh, COLUMN_NAME = iii, CURSOR_NAME = jjj, MESSAGE_TEXT = kkk, MYSQL_ERRNO = 65535; end $$ call test_signal() $$ Warnings: Warning 65535 KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK drop procedure test_signal $$ create procedure test_signal() begin DECLARE warn CONDITION FOR SQLSTATE "01234"; SIGNAL warn SET MYSQL_ERRNO = 999999999999999999999999999999999999999999999999999; end $$ call test_signal() $$ ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of '999999999999999999999999999999999999999999999999999' drop procedure test_signal $$ SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create procedure test_signal() begin DECLARE aaax VARCHAR(65); DECLARE bbbx VARCHAR(65); DECLARE cccx VARCHAR(65); DECLARE dddx VARCHAR(65); DECLARE eeex VARCHAR(65); DECLARE fffx VARCHAR(65); DECLARE gggx VARCHAR(65); DECLARE hhhx VARCHAR(65); DECLARE iiix VARCHAR(65); DECLARE jjjx VARCHAR(65); DECLARE kkkx VARCHAR(65); DECLARE lllx VARCHAR(129); DECLARE warn CONDITION FOR SQLSTATE "01234"; set aaax= concat(repeat("A", 64), "X"); set bbbx= concat(repeat("B", 64), "X"); set cccx= concat(repeat("C", 64), "X"); set dddx= concat(repeat("D", 64), "X"); set eeex= concat(repeat("E", 64), "X"); set fffx= concat(repeat("F", 64), "X"); set gggx= concat(repeat("G", 64), "X"); set hhhx= concat(repeat("H", 64), "X"); set iiix= concat(repeat("I", 64), "X"); set jjjx= concat(repeat("J", 64), "X"); set kkkx= concat(repeat("K", 64), "X"); set lllx= concat(repeat("1", 100), repeat("2", 20), repeat("8", 8), "X"); SIGNAL warn SET CLASS_ORIGIN = aaax, SUBCLASS_ORIGIN = bbbx, CONSTRAINT_CATALOG = cccx, CONSTRAINT_SCHEMA = dddx, CONSTRAINT_NAME = eeex, CATALOG_NAME = fffx, SCHEMA_NAME = gggx, TABLE_NAME = hhhx, COLUMN_NAME = iiix, CURSOR_NAME = jjjx, MESSAGE_TEXT = lllx, MYSQL_ERRNO = 10000; end $$ call test_signal() $$ Warnings: Warning 1647 Data truncated for condition item 'CLASS_ORIGIN' Warning 1647 Data truncated for condition item 'SUBCLASS_ORIGIN' Warning 1647 Data truncated for condition item 'CONSTRAINT_CATALOG' Warning 1647 Data truncated for condition item 'CONSTRAINT_SCHEMA' Warning 1647 Data truncated for condition item 'CONSTRAINT_NAME' Warning 1647 Data truncated for condition item 'CATALOG_NAME' Warning 1647 Data truncated for condition item 'SCHEMA_NAME' Warning 1647 Data truncated for condition item 'TABLE_NAME' Warning 1647 Data truncated for condition item 'COLUMN_NAME' Warning 1647 Data truncated for condition item 'CURSOR_NAME' Warning 1647 Data truncated for condition item 'MESSAGE_TEXT' Warning 10000 11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111112222222222222222222288888888 drop procedure test_signal $$ SET sql_mode = default; # Test that HANDLER can catch conditions raised by SIGNAL create procedure test_signal() begin DECLARE warn CONDITION FOR SQLSTATE "01234"; DECLARE CONTINUE HANDLER for SQLSTATE "01234" begin select "Caught by SQLSTATE"; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by SQLSTATE Caught by SQLSTATE drop procedure test_signal $$ create procedure test_signal() begin DECLARE warn CONDITION FOR SQLSTATE "01234"; DECLARE CONTINUE HANDLER for 1012 begin select "Caught by number"; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by number Caught by number drop procedure test_signal $$ create procedure test_signal() begin DECLARE warn CONDITION FOR SQLSTATE "01234"; DECLARE CONTINUE HANDLER for SQLWARNING begin select "Caught by SQLWARNING"; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by SQLWARNING Caught by SQLWARNING drop procedure test_signal $$ create procedure test_signal() begin DECLARE not_found CONDITION FOR SQLSTATE "02ABC"; DECLARE CONTINUE HANDLER for SQLSTATE "02ABC" begin select "Caught by SQLSTATE"; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by SQLSTATE Caught by SQLSTATE drop procedure test_signal $$ create procedure test_signal() begin DECLARE not_found CONDITION FOR SQLSTATE "02ABC"; DECLARE CONTINUE HANDLER for 1012 begin select "Caught by number"; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by number Caught by number drop procedure test_signal $$ create procedure test_signal() begin DECLARE not_found CONDITION FOR SQLSTATE "02ABC"; DECLARE CONTINUE HANDLER for NOT FOUND begin select "Caught by NOT FOUND"; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by NOT FOUND Caught by NOT FOUND drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE "55555"; DECLARE CONTINUE HANDLER for SQLSTATE "55555" begin select "Caught by SQLSTATE"; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by SQLSTATE Caught by SQLSTATE drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE "55555"; DECLARE CONTINUE HANDLER for 1012 begin select "Caught by number"; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by number Caught by number drop procedure test_signal $$ create procedure test_signal() begin DECLARE error CONDITION FOR SQLSTATE "55555"; DECLARE CONTINUE HANDLER for SQLEXCEPTION begin select "Caught by SQLEXCEPTION"; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_signal() $$ Caught by SQLEXCEPTION Caught by SQLEXCEPTION drop procedure test_signal $$ # # Test where SIGNAL can be used # # RETURN statement clears Diagnostics Area, thus # the warnings raised in a stored function are not # visible outsidef the stored function. So, we're using # @@warning_count variable to check that SIGNAL succeeded. create function test_signal_func() returns integer begin DECLARE v INT; DECLARE warn CONDITION FOR SQLSTATE "01XXX"; SIGNAL warn SET MESSAGE_TEXT = "This function SIGNAL a warning", MYSQL_ERRNO = 1012; SELECT @@warning_count INTO v; return v; end $$ select test_signal_func() $$ test_signal_func() 1 drop function test_signal_func $$ create function test_signal_func() returns integer begin DECLARE not_found CONDITION FOR SQLSTATE "02XXX"; SIGNAL not_found SET MESSAGE_TEXT = "This function SIGNAL not found", MYSQL_ERRNO = 1012; return 5; end $$ select test_signal_func() $$ ERROR 02XXX: This function SIGNAL not found drop function test_signal_func $$ create function test_signal_func() returns integer begin DECLARE error CONDITION FOR SQLSTATE "50000"; SIGNAL error SET MESSAGE_TEXT = "This function SIGNAL an error", MYSQL_ERRNO = 1012; return 5; end $$ select test_signal_func() $$ ERROR 50000: This function SIGNAL an error drop function test_signal_func $$ drop table if exists t1 $$ create table t1 (a integer) $$ create trigger t1_ai after insert on t1 for each row begin DECLARE msg VARCHAR(128); DECLARE warn CONDITION FOR SQLSTATE "01XXX"; set msg= concat("This trigger SIGNAL a warning, a=", NEW.a); SIGNAL warn SET MESSAGE_TEXT = msg, MYSQL_ERRNO = 1012; end $$ insert into t1 values (1), (2) $$ drop trigger t1_ai $$ create trigger t1_ai after insert on t1 for each row begin DECLARE msg VARCHAR(128); DECLARE not_found CONDITION FOR SQLSTATE "02XXX"; set msg= concat("This trigger SIGNAL a not found, a=", NEW.a); SIGNAL not_found SET MESSAGE_TEXT = msg, MYSQL_ERRNO = 1012; end $$ insert into t1 values (3), (4) $$ ERROR 02XXX: This trigger SIGNAL a not found, a=3 drop trigger t1_ai $$ create trigger t1_ai after insert on t1 for each row begin DECLARE msg VARCHAR(128); DECLARE error CONDITION FOR SQLSTATE "03XXX"; set msg= concat("This trigger SIGNAL an error, a=", NEW.a); SIGNAL error SET MESSAGE_TEXT = msg, MYSQL_ERRNO = 1012; end $$ insert into t1 values (5), (6) $$ ERROR 03XXX: This trigger SIGNAL an error, a=5 drop table t1 $$ create table t1 (errno integer, msg varchar(128)) $$ create trigger t1_ai after insert on t1 for each row begin DECLARE warn CONDITION FOR SQLSTATE "01XXX"; SIGNAL warn SET MESSAGE_TEXT = NEW.msg, MYSQL_ERRNO = NEW.errno; end $$ insert into t1 set errno=1012, msg='Warning message 1 in trigger' $$ insert into t1 set errno=1013, msg='Warning message 2 in trigger' $$ drop table t1 $$ drop table if exists t1 $$ drop procedure if exists p1 $$ drop function if exists f1 $$ create table t1 (s1 int) $$ insert into t1 values (1) $$ create procedure p1() begin declare a int; declare c cursor for select f1() from t1; declare continue handler for sqlstate '03000' select "caught 03000"; declare continue handler for 1326 select "caught cursor is not open"; select "Before open"; open c; select "Before fetch"; fetch c into a; select "Before close"; close c; end $$ create function f1() returns int begin signal sqlstate '03000'; return 5; end $$ drop table t1 $$ drop procedure p1 $$ drop function f1 $$ # # Test the RESIGNAL runtime # create procedure test_resignal() begin DECLARE warn CONDITION FOR SQLSTATE "01234"; DECLARE CONTINUE HANDLER for 1012 begin select "handler called"; RESIGNAL; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ handler called handler called Warnings: Warning 1012 Raising a warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE not_found CONDITION FOR SQLSTATE "02222"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL; select "after RESIGNAL"; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02222: Raising a not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE error CONDITION FOR SQLSTATE "55555"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL; select "after RESIGNAL"; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 55555: Raising an error drop procedure test_resignal $$ SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlwarning begin select "handler called"; RESIGNAL; end; insert into t_warn set a= 9999999999999999; end $$ call test_resignal() $$ handler called handler called Warnings: Warning 1264 Out of range value for column 'a' at row 1 drop procedure test_resignal $$ SET sql_mode = default; create procedure test_resignal() begin DECLARE x integer; DECLARE c cursor for select * from t_cursor; DECLARE CONTINUE HANDLER for not found begin select "before RESIGNAL"; RESIGNAL; select "after RESIGNAL"; end; open c; fetch c into x; close c; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02000: No data - zero rows fetched, selected, or processed drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlexception begin select "before RESIGNAL"; RESIGNAL; select "after RESIGNAL"; end; drop table no_such_table; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 42S02: Unknown table 'test.no_such_table' drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE warn CONDITION FOR SQLSTATE "01234"; DECLARE CONTINUE HANDLER for 1012 begin select "handler called"; RESIGNAL SET MESSAGE_TEXT = "RESIGNAL of a warning", MYSQL_ERRNO = 5555 ; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ handler called handler called Warnings: Warning 5555 RESIGNAL of a warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE not_found CONDITION FOR SQLSTATE "02111"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SET MESSAGE_TEXT = "RESIGNAL of a not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02111: RESIGNAL of a not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE error CONDITION FOR SQLSTATE "33333"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SET MESSAGE_TEXT = "RESIGNAL of an error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 33333: RESIGNAL of an error drop procedure test_resignal $$ SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlwarning begin select "handler called"; RESIGNAL SET MESSAGE_TEXT = "RESIGNAL of a warning", MYSQL_ERRNO = 5555 ; end; insert into t_warn set a= 9999999999999999; end $$ call test_resignal() $$ handler called handler called Warnings: Warning 5555 RESIGNAL of a warning drop procedure test_resignal $$ SET sql_mode = default; create procedure test_resignal() begin DECLARE x integer; DECLARE c cursor for select * from t_cursor; DECLARE CONTINUE HANDLER for not found begin select "before RESIGNAL"; RESIGNAL SET MESSAGE_TEXT = "RESIGNAL of not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; open c; fetch c into x; close c; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02000: RESIGNAL of not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlexception begin select "before RESIGNAL"; RESIGNAL SET MESSAGE_TEXT = "RESIGNAL of an error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; drop table no_such_table; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 42S02: RESIGNAL of an error drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE warn CONDITION FOR SQLSTATE "01111"; DECLARE CONTINUE HANDLER for 1012 begin select "handler called"; RESIGNAL SQLSTATE "01222" SET MESSAGE_TEXT = "RESIGNAL to warning", MYSQL_ERRNO = 5555 ; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ handler called handler called Warnings: Warning 1012 Raising a warning Warning 5555 RESIGNAL to warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE warn CONDITION FOR SQLSTATE "01111"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SQLSTATE "02222" SET MESSAGE_TEXT = "RESIGNAL to not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02222: RESIGNAL to not found show warnings $$ Level Code Message Warning 1012 Raising a warning Error 5555 RESIGNAL to not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE warn CONDITION FOR SQLSTATE "01111"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SQLSTATE "33333" SET MESSAGE_TEXT = "RESIGNAL to error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL warn SET MESSAGE_TEXT = "Raising a warning", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 33333: RESIGNAL to error show warnings $$ Level Code Message Warning 1012 Raising a warning Error 5555 RESIGNAL to error drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE not_found CONDITION FOR SQLSTATE "02ABC"; DECLARE CONTINUE HANDLER for 1012 begin select "handler called"; RESIGNAL SQLSTATE "01222" SET MESSAGE_TEXT = "RESIGNAL to warning", MYSQL_ERRNO = 5555 ; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ handler called handler called Warnings: Error 1012 Raising a not found Warning 5555 RESIGNAL to warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE not_found CONDITION FOR SQLSTATE "02ABC"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SQLSTATE "02222" SET MESSAGE_TEXT = "RESIGNAL to not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02222: RESIGNAL to not found show warnings $$ Level Code Message Error 1012 Raising a not found Error 5555 RESIGNAL to not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE not_found CONDITION FOR SQLSTATE "02ABC"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SQLSTATE "33333" SET MESSAGE_TEXT = "RESIGNAL to error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL not_found SET MESSAGE_TEXT = "Raising a not found", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 33333: RESIGNAL to error show warnings $$ Level Code Message Error 1012 Raising a not found Error 5555 RESIGNAL to error drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE error CONDITION FOR SQLSTATE "AAAAA"; DECLARE CONTINUE HANDLER for 1012 begin select "handler called"; RESIGNAL SQLSTATE "01222" SET MESSAGE_TEXT = "RESIGNAL to warning", MYSQL_ERRNO = 5555 ; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ handler called handler called Warnings: Error 1012 Raising an error Warning 5555 RESIGNAL to warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE error CONDITION FOR SQLSTATE "AAAAA"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SQLSTATE "02222" SET MESSAGE_TEXT = "RESIGNAL to not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02222: RESIGNAL to not found show warnings $$ Level Code Message Error 1012 Raising an error Error 5555 RESIGNAL to not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE error CONDITION FOR SQLSTATE "AAAAA"; DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"; RESIGNAL SQLSTATE "33333" SET MESSAGE_TEXT = "RESIGNAL to error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; SIGNAL error SET MESSAGE_TEXT = "Raising an error", MYSQL_ERRNO = 1012; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 33333: RESIGNAL to error show warnings $$ Level Code Message Error 1012 Raising an error Error 5555 RESIGNAL to error drop procedure test_resignal $$ SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlwarning begin select "handler called"; RESIGNAL SQLSTATE "01111" SET MESSAGE_TEXT = "RESIGNAL to a warning", MYSQL_ERRNO = 5555 ; end; insert into t_warn set a= 9999999999999999; end $$ call test_resignal() $$ handler called handler called Warnings: Warning 1264 Out of range value for column 'a' at row 1 Warning 5555 RESIGNAL to a warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlwarning begin select "before RESIGNAL"; RESIGNAL SQLSTATE "02444" SET MESSAGE_TEXT = "RESIGNAL to a not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; insert into t_warn set a= 9999999999999999; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02444: RESIGNAL to a not found show warnings $$ Level Code Message Warning 1264 Out of range value for column 'a' at row 1 Error 5555 RESIGNAL to a not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlwarning begin select "before RESIGNAL"; RESIGNAL SQLSTATE "44444" SET MESSAGE_TEXT = "RESIGNAL to an error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; insert into t_warn set a= 9999999999999999; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 44444: RESIGNAL to an error show warnings $$ Level Code Message Warning 1264 Out of range value for column 'a' at row 1 Error 5555 RESIGNAL to an error drop procedure test_resignal $$ SET sql_mode = default; # 3 tests: # {not found} # --> RESIGNAL SQLSTATE {warning, not found, error} SET ... create procedure test_resignal() begin DECLARE x integer; DECLARE c cursor for select * from t_cursor; DECLARE CONTINUE HANDLER for not found begin select "handler called"; RESIGNAL SQLSTATE "01111" SET MESSAGE_TEXT = "RESIGNAL to a warning", MYSQL_ERRNO = 5555 ; end; open c; fetch c into x; # We don't explicitly close for once, but rely on the end-of-scope clean-up # because we don't want for CLOSE to reset the diagnostics area ... # close c; end $$ call test_resignal() $$ handler called handler called Warnings: Error 1329 No data - zero rows fetched, selected, or processed Warning 5555 RESIGNAL to a warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE x integer; DECLARE c cursor for select * from t_cursor; DECLARE CONTINUE HANDLER for not found begin select "before RESIGNAL"; RESIGNAL SQLSTATE "02444" SET MESSAGE_TEXT = "RESIGNAL to a not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; open c; fetch c into x; close c; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02444: RESIGNAL to a not found show warnings $$ Level Code Message Error 1329 No data - zero rows fetched, selected, or processed Error 5555 RESIGNAL to a not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE x integer; DECLARE c cursor for select * from t_cursor; DECLARE CONTINUE HANDLER for not found begin select "before RESIGNAL"; RESIGNAL SQLSTATE "44444" SET MESSAGE_TEXT = "RESIGNAL to an error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; open c; fetch c into x; close c; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 44444: RESIGNAL to an error show warnings $$ Level Code Message Error 1329 No data - zero rows fetched, selected, or processed Error 5555 RESIGNAL to an error drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlexception begin select "handler called"; RESIGNAL SQLSTATE "01111" SET MESSAGE_TEXT = "RESIGNAL to a warning", MYSQL_ERRNO = 5555 ; end; drop table no_such_table; end $$ call test_resignal() $$ handler called handler called Warnings: Error 1051 Unknown table 'test.no_such_table' Warning 5555 RESIGNAL to a warning drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlexception begin select "before RESIGNAL"; RESIGNAL SQLSTATE "02444" SET MESSAGE_TEXT = "RESIGNAL to a not found", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; drop table no_such_table; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 02444: RESIGNAL to a not found show warnings $$ Level Code Message Error 1051 Unknown table 'test.no_such_table' Error 5555 RESIGNAL to a not found drop procedure test_resignal $$ create procedure test_resignal() begin DECLARE CONTINUE HANDLER for sqlexception begin select "before RESIGNAL"; RESIGNAL SQLSTATE "44444" SET MESSAGE_TEXT = "RESIGNAL to an error", MYSQL_ERRNO = 5555 ; select "after RESIGNAL"; end; drop table no_such_table; end $$ call test_resignal() $$ before RESIGNAL before RESIGNAL ERROR 44444: RESIGNAL to an error show warnings $$ Level Code Message Error 1051 Unknown table 'test.no_such_table' Error 5555 RESIGNAL to an error drop procedure test_resignal $$ # # More complex cases # drop procedure if exists peter_p1 $$ drop procedure if exists peter_p2 $$ CREATE PROCEDURE peter_p1 () BEGIN DECLARE x CONDITION FOR 1231; DECLARE EXIT HANDLER FOR x BEGIN SELECT '2'; RESIGNAL SET MYSQL_ERRNO = 9999; END; BEGIN DECLARE EXIT HANDLER FOR x BEGIN SELECT '1'; RESIGNAL SET SCHEMA_NAME = 'test'; END; SET @@sql_mode=NULL; END; END $$ CREATE PROCEDURE peter_p2 () BEGIN DECLARE x CONDITION for 9999; DECLARE EXIT HANDLER FOR x BEGIN SELECT '3'; RESIGNAL SET MESSAGE_TEXT = 'Hi, I am a useless error message'; END; CALL peter_p1(); END $$ CALL peter_p2() $$ 1 1 2 2 3 3 ERROR 42000: Hi, I am a useless error message show warnings $$ Level Code Message Error 9999 Hi, I am a useless error message drop procedure peter_p1 $$ drop procedure peter_p2 $$ CREATE PROCEDURE peter_p1 () BEGIN DECLARE x CONDITION FOR SQLSTATE '42000'; DECLARE EXIT HANDLER FOR x BEGIN SHOW WARNINGS; RESIGNAL x SET MYSQL_ERRNO = 9999; END; BEGIN DECLARE EXIT HANDLER FOR x BEGIN SHOW WARNINGS; RESIGNAL x SET SCHEMA_NAME = 'test', MYSQL_ERRNO= 1232; END; /* Raises ER_WRONG_VALUE_FOR_VAR : 1231, SQLSTATE 42000 */ SET @@sql_mode=NULL; END; END $$ CREATE PROCEDURE peter_p2 () BEGIN DECLARE x CONDITION for SQLSTATE '42000'; DECLARE EXIT HANDLER FOR x BEGIN SHOW WARNINGS; RESIGNAL x SET MESSAGE_TEXT = 'Hi, I am a useless error message', MYSQL_ERRNO = 9999; END; CALL peter_p1(); END $$ CALL peter_p2() $$ Level Code Message Error 1231 Variable 'sql_mode' can't be set to the value of 'NULL' Level Code Message Error 1231 Variable 'sql_mode' can't be set to the value of 'NULL' Error 1232 Variable 'sql_mode' can't be set to the value of 'NULL' Level Code Message Error 1231 Variable 'sql_mode' can't be set to the value of 'NULL' Error 1232 Variable 'sql_mode' can't be set to the value of 'NULL' Error 9999 Variable 'sql_mode' can't be set to the value of 'NULL' ERROR 42000: Hi, I am a useless error message show warnings $$ Level Code Message Error 1231 Variable 'sql_mode' can't be set to the value of 'NULL' Error 1232 Variable 'sql_mode' can't be set to the value of 'NULL' Error 9999 Variable 'sql_mode' can't be set to the value of 'NULL' Error 9999 Hi, I am a useless error message drop procedure peter_p1 $$ drop procedure peter_p2 $$ drop procedure if exists peter_p3 $$ Warnings: Note 1305 PROCEDURE test.peter_p3 does not exist create procedure peter_p3() begin declare continue handler for sqlexception resignal sqlstate '99002' set mysql_errno = 2; signal sqlstate '99001' set mysql_errno = 1, message_text = "Original"; end $$ call peter_p3() $$ ERROR 99002: Original show warnings $$ Level Code Message Error 1 Original Error 2 Original drop procedure peter_p3 $$ drop table t_warn; drop table t_cursor; # # Miscelaneous test cases # create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 0x12; /* 18 */ end $$ call test_signal $$ ERROR 12345: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 0b00010010; /* 18 */ end $$ call test_signal $$ ERROR 12345: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = '65'; /* 65 */ end $$ call test_signal $$ ERROR 12345: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 'A'; /* illegal */ end $$ call test_signal $$ ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of 'A' drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = "65"; /* 65 */ end $$ call test_signal $$ ERROR 12345: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = "A"; /* illegal */ end $$ call test_signal $$ ERROR 42000: Variable 'MYSQL_ERRNO' can't be set to the value of 'A' drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = `65`; /* illegal */ end $$ call test_signal $$ ERROR 42S22: Unknown column '65' in 'field list' drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = `A`; /* illegal */ end $$ call test_signal $$ ERROR 42S22: Unknown column 'A' in 'field list' drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 3.141592; /* 3 */ end $$ call test_signal $$ ERROR 12345: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 1000, MESSAGE_TEXT= 0x41; /* A */ end $$ call test_signal $$ ERROR 12345: A drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 1000, MESSAGE_TEXT= 0b01000001; /* A */ end $$ call test_signal $$ ERROR 12345: A drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 1000, MESSAGE_TEXT = "Hello"; end $$ call test_signal $$ ERROR 12345: Hello drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 1000, MESSAGE_TEXT = 'Hello'; end $$ call test_signal $$ ERROR 12345: Hello drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 1000, MESSAGE_TEXT = `Hello`; end $$ call test_signal $$ ERROR 42S22: Unknown column 'Hello' in 'field list' drop procedure test_signal $$ create procedure test_signal() begin DECLARE foo CONDITION FOR SQLSTATE '12345'; SIGNAL foo SET MYSQL_ERRNO = 1000, MESSAGE_TEXT = 65.4321; end $$ call test_signal $$ ERROR 12345: 65.4321 drop procedure test_signal $$ create procedure test_signal() begin DECLARE céèçà foo CONDITION FOR SQLSTATE '12345'; SIGNAL céèçà SET MYSQL_ERRNO = 1000; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '�èçà foo CONDITION FOR SQLSTATE '12345'; SIGNAL céèçà SET ' at line 3 create procedure test_signal() begin DECLARE "céèçà" CONDITION FOR SQLSTATE '12345'; SIGNAL "céèçà" SET MYSQL_ERRNO = 1000; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"céèçà" CONDITION FOR SQLSTATE '12345'; SIGNAL "céèçà" S' at line 3 create procedure test_signal() begin DECLARE 'céèçà' CONDITION FOR SQLSTATE '12345'; SIGNAL 'céèçà' SET MYSQL_ERRNO = 1000; end $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''céèçà' CONDITION FOR SQLSTATE '12345'; SIGNAL 'céèçà' S' at line 3 create procedure test_signal() begin DECLARE `céèçà` CONDITION FOR SQLSTATE '12345'; SIGNAL `céèçà` SET MYSQL_ERRNO = 1000; end $$ call test_signal $$ ERROR 12345: Unhandled user-defined exception condition drop procedure test_signal $$ create procedure test_signal() begin SIGNAL SQLSTATE '77777' SET MYSQL_ERRNO = 1000, MESSAGE_TEXT='ÁÂÃÅÄ'; end $$ drop procedure test_signal $$ # # WL#6406 Stacked diagnostic areas # # Double RESIGNAL of warning # SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING BEGIN RESIGNAL; RESIGNAL; END; SELECT 10 + 'a'; END $$ CALL p1(); 10 + 'a' 10 Warnings: Warning 1292 Truncated incorrect DOUBLE value: 'a' DROP PROCEDURE p1; CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING BEGIN RESIGNAL SET MESSAGE_TEXT= '1st resignal'; RESIGNAL SET MESSAGE_TEXT= '2nd resignal'; END; SELECT 10 + 'a'; END $$ CALL p1(); 10 + 'a' 10 Warnings: Warning 1292 2nd resignal DROP PROCEDURE p1; CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING BEGIN RESIGNAL SQLSTATE '01000' SET MESSAGE_TEXT= '1st resignal'; RESIGNAL SQLSTATE '01000' SET MESSAGE_TEXT= '2nd resignal'; END; SELECT 10 + 'a'; END $$ CALL p1(); 10 + 'a' 10 Warnings: Warning 1292 Truncated incorrect DOUBLE value: 'a' Warning 1642 1st resignal Warning 1642 2nd resignal DROP PROCEDURE p1; # RESIGNAL warning + RESIGNAL error # CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING BEGIN RESIGNAL SQLSTATE '01000' SET MESSAGE_TEXT= '1st resignal'; RESIGNAL SQLSTATE 'HY000' SET MESSAGE_TEXT= '2nd resignal'; END; SELECT 10 + 'a'; END $$ CALL p1(); 10 + 'a' 10 ERROR HY000: 2nd resignal SHOW WARNINGS; Level Code Message Warning 1292 Truncated incorrect DOUBLE value: 'a' Warning 1642 1st resignal Error 1644 2nd resignal DROP PROCEDURE p1; # Unhandled errors raised in nested handlers # CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR 1051 BEGIN DROP DATABASE none; # Error 1008 END; DROP TABLE none; # Error 1051 END $$ CALL p1(); ERROR HY000: Can't drop database 'none'; database doesn't exist SHOW WARNINGS; Level Code Message Error 1008 Can't drop database 'none'; database doesn't exist DROP PROCEDURE p1; # RESIGNAL of warning which fails # CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SET MESSAGE_TEXT = asdf; SELECT 10 + 'a'; END $$ CREATE PROCEDURE p2() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SET MESSAGE_TEXT = asdf; SELECT 10 + 'a'; END; END $$ CREATE PROCEDURE p3() BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SET MESSAGE_TEXT = asdf; SELECT 10 + 'a'; END; END $$ CREATE PROCEDURE p4() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = asdf; SELECT 10 + 'a'; END $$ CREATE PROCEDURE p5() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = asdf; SELECT 10 + 'a'; END; END $$ CREATE PROCEDURE p6() BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = asdf; SELECT 10 + 'a'; END; END $$ CALL p1(); 10 + 'a' 10 ERROR 42S22: Unknown column 'asdf' in 'field list' CALL p2(); 10 + 'a' 10 Msg handled CALL p3(); 10 + 'a' 10 Msg handled CALL p4(); 10 + 'a' 10 ERROR 42S22: Unknown column 'asdf' in 'field list' CALL p5(); 10 + 'a' 10 Msg handled CALL p6(); 10 + 'a' 10 Msg handled DROP PROCEDURE p1; DROP PROCEDURE p2; DROP PROCEDURE p3; DROP PROCEDURE p4; DROP PROCEDURE p5; DROP PROCEDURE p6; # RESIGNAL of error which fails # CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SET MESSAGE_TEXT = asdf; DROP TABLE none; END $$ CREATE PROCEDURE p2() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SET MESSAGE_TEXT = asdf; DROP TABLE none; END; END $$ CREATE PROCEDURE p3() BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SET MESSAGE_TEXT = asdf; DROP TABLE none; END; END $$ CREATE PROCEDURE p4() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = asdf; DROP TABLE none; END $$ CREATE PROCEDURE p5() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = asdf; DROP TABLE none; END; END $$ CREATE PROCEDURE p6() BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT 'handled' as Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = asdf; DROP TABLE none; END; END $$ CALL p1(); ERROR 42S22: Unknown column 'asdf' in 'field list' CALL p2(); Msg handled CALL p3(); Msg handled CALL p4(); ERROR 42S22: Unknown column 'asdf' in 'field list' CALL p5(); Msg handled CALL p6(); Msg handled DROP PROCEDURE p1; DROP PROCEDURE p2; DROP PROCEDURE p3; DROP PROCEDURE p4; DROP PROCEDURE p5; DROP PROCEDURE p6; # Error condition originating from a DA which has been destroyed # when the condition is handled. # CREATE FUNCTION f1() RETURNS INTEGER BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION RESIGNAL; INSERT INTO none VALUES (NULL); RETURN 1; END| CREATE PROCEDURE p1() BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION RESIGNAL; SELECT f1(); END| CALL p1(); f1() ERROR 42S02: Table 'test.none' doesn't exist DROP PROCEDURE p1; DROP FUNCTION f1; # RESIGNAL with max_error_count = 0 # CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL; SIGNAL SQLSTATE 'HY000'; END| CREATE PROCEDURE p2() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL; SIGNAL SQLSTATE '01000'; END| CREATE PROCEDURE p3() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SET MESSAGE_TEXT= 'custom error msg'; SIGNAL SQLSTATE 'HY000'; END| CREATE PROCEDURE p4() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SET MESSAGE_TEXT= 'custom warning msg'; SIGNAL SQLSTATE '01000'; END| CREATE PROCEDURE p5() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT= 'custom error msg'; SIGNAL SQLSTATE 'HY000'; END| CREATE PROCEDURE p6() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT= 'custom warning msg'; SIGNAL SQLSTATE '01000'; END| CREATE PROCEDURE p7() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' AS Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL; SIGNAL SQLSTATE 'HY000'; END; END| CREATE PROCEDURE p8() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING SELECT 'handled' AS Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL; SIGNAL SQLSTATE '01000'; END; END| CREATE PROCEDURE p9() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' AS Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SET MESSAGE_TEXT= 'custom error msg'; SIGNAL SQLSTATE 'HY000'; END; END| CREATE PROCEDURE p10() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING SELECT 'handled' AS Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SET MESSAGE_TEXT= 'custom warning msg'; SIGNAL SQLSTATE '01000'; END; END| CREATE PROCEDURE p11() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' AS Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT= 'custom error msg'; SIGNAL SQLSTATE 'HY000'; END; END| CREATE PROCEDURE p12() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'handled' AS Msg; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING RESIGNAL SQLSTATE '45000' SET MESSAGE_TEXT= 'custom warning msg'; SIGNAL SQLSTATE '01000'; END; END| SET max_error_count= 0; CALL p1(); ERROR HY000: Unhandled user-defined exception condition CALL p2(); CALL p3(); ERROR HY000: custom error msg CALL p4(); CALL p5(); ERROR 45000: custom error msg CALL p6(); CALL p7(); Msg handled CALL p8(); CALL p9(); Msg handled CALL p10(); CALL p11(); Msg handled CALL p12(); SET max_error_count= DEFAULT; DROP PROCEDURE p1; DROP PROCEDURE p2; DROP PROCEDURE p3; DROP PROCEDURE p4; DROP PROCEDURE p5; DROP PROCEDURE p6; DROP PROCEDURE p7; DROP PROCEDURE p8; DROP PROCEDURE p9; DROP PROCEDURE p10; DROP PROCEDURE p11; DROP PROCEDURE p12; SET sql_mode = default;
Close