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 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
1st.test
271
B
-rw-r--r--
acl_tables_errors_debug.test
7.98
KB
-rw-r--r--
alias.test
9.17
KB
-rw-r--r--
almost_full.test
936
B
-rw-r--r--
alter_table-big.test
8.11
KB
-rw-r--r--
alter_table.test
102.27
KB
-rw-r--r--
analyze.test
3.17
KB
-rw-r--r--
ansi.test
1.25
KB
-rw-r--r--
archive-big.test
41.09
KB
-rw-r--r--
archive.test
105.99
KB
-rw-r--r--
archive_bitfield.test
3.94
KB
-rw-r--r--
archive_debug.test
395
B
-rw-r--r--
archive_gis.test
103
B
-rw-r--r--
archive_no_symlink-master.opt
22
B
-rw-r--r--
archive_no_symlink.test
810
B
-rw-r--r--
archive_plugin-master.opt
33
B
-rw-r--r--
archive_plugin.test
1016
B
-rw-r--r--
archive_symlink.test
2.48
KB
-rw-r--r--
auth_rpl-master.opt
35
B
-rw-r--r--
auth_rpl-slave.opt
36
B
-rw-r--r--
auth_rpl.test
1.86
KB
-rw-r--r--
auto_increment.test
11.27
KB
-rw-r--r--
bench_count_distinct.test
641
B
-rw-r--r--
bigint.test
15.61
KB
-rw-r--r--
binary.test
4.79
KB
-rw-r--r--
binary_to_hex.test
2.24
KB
-rw-r--r--
blackhole.test
762
B
-rw-r--r--
blackhole_plugin-master.opt
35
B
-rw-r--r--
blackhole_plugin.test
1.03
KB
-rw-r--r--
bool.test
2.47
KB
-rw-r--r--
bootstrap.test
2.49
KB
-rw-r--r--
bug12368203-master.opt
88
B
-rw-r--r--
bug12368203.test
5.75
KB
-rw-r--r--
bug12427262.test
1.7
KB
-rw-r--r--
bug12969156-master.opt
32
B
-rw-r--r--
bug12969156.test
498
B
-rw-r--r--
bug17076131-master.opt
57
B
-rw-r--r--
bug17076131.test
1.06
KB
-rw-r--r--
bug33509-master.opt
33
B
-rw-r--r--
bug33509.test
2.52
KB
-rw-r--r--
bug39022.test
1.62
KB
-rw-r--r--
bug46080-master.opt
69
B
-rw-r--r--
bug46080.test
723
B
-rw-r--r--
bug46261-master.opt
40
B
-rw-r--r--
bug46261.test
488
B
-rw-r--r--
bug46760-master.opt
53
B
-rw-r--r--
bug46760.test
970
B
-rw-r--r--
bug47671-master.opt
66
B
-rw-r--r--
bug47671.test
448
B
-rw-r--r--
bug58669-master.opt
12
B
-rw-r--r--
bug58669.test
495
B
-rw-r--r--
bulk_replace.test
311
B
-rw-r--r--
cache_innodb-master.opt
21
B
-rw-r--r--
cache_innodb.test
899
B
-rw-r--r--
case.test
6.56
KB
-rw-r--r--
cast.test
9.78
KB
-rw-r--r--
change_user-master.opt
16
B
-rw-r--r--
change_user.test
3.78
KB
-rw-r--r--
charset.test
2.4
KB
-rw-r--r--
check.test
2.26
KB
-rw-r--r--
check_auto_permission.test
2.06
KB
-rw-r--r--
client_xml.test
1.47
KB
-rw-r--r--
comment_column.test
36.48
KB
-rw-r--r--
comment_column2.test
131.05
KB
-rw-r--r--
comment_index.test
22.22
KB
-rw-r--r--
comment_table.test
14.01
KB
-rw-r--r--
comments.test
1.37
KB
-rw-r--r--
commit.test
15.16
KB
-rw-r--r--
commit_1innodb.test
324
B
-rw-r--r--
compare.test
3.26
KB
-rw-r--r--
compress.test
1.05
KB
-rw-r--r--
concurrent_innodb_safelog-mast...
29
B
-rw-r--r--
concurrent_innodb_safelog.test
716
B
-rw-r--r--
concurrent_innodb_unsafelog-ma...
62
B
-rw-r--r--
concurrent_innodb_unsafelog.te...
718
B
-rw-r--r--
condition_filter.test
1.14
KB
-rw-r--r--
connect.test
14.5
KB
-rw-r--r--
connect_debug.test
2.08
KB
-rw-r--r--
consistent_snapshot.test
2.02
KB
-rw-r--r--
constraints.test
1.84
KB
-rw-r--r--
count_distinct.test
8.05
KB
-rw-r--r--
count_distinct2-master.opt
28
B
-rw-r--r--
count_distinct2.test
1.87
KB
-rw-r--r--
count_distinct3.test
1.55
KB
-rw-r--r--
create-big.test
17.21
KB
-rw-r--r--
create.test
53.55
KB
-rw-r--r--
create_not_windows.test
1.25
KB
-rw-r--r--
create_select_tmp.test
1.33
KB
-rw-r--r--
create_w_max_indexes_64.test
18.57
KB
-rw-r--r--
csv-master.opt
21
B
-rw-r--r--
csv.test
106.92
KB
-rw-r--r--
csv_alter_table.test
1.78
KB
-rw-r--r--
csv_not_null.test
3.28
KB
-rw-r--r--
ctype_ascii.test
1.21
KB
-rw-r--r--
ctype_big5.test
5.36
KB
-rw-r--r--
ctype_binary.test
543
B
-rw-r--r--
ctype_collate.test
11.45
KB
-rw-r--r--
ctype_cp1250_ch.test
2.96
KB
-rw-r--r--
ctype_cp1251.test
2.82
KB
-rw-r--r--
ctype_cp932.test
1.01
KB
-rw-r--r--
ctype_cp932_binlog_row.test
237
B
-rw-r--r--
ctype_cp932_binlog_stm.test
4.65
KB
-rw-r--r--
ctype_create.test
3.43
KB
-rw-r--r--
ctype_errors.test
1.34
KB
-rw-r--r--
ctype_eucjpms.test
30.18
KB
-rw-r--r--
ctype_euckr.test
5.49
KB
-rw-r--r--
ctype_filename.test
368
B
-rw-r--r--
ctype_filesystem-master.opt
73
B
-rw-r--r--
ctype_filesystem.test
233
B
-rw-r--r--
ctype_gb18030.test
11.14
KB
-rw-r--r--
ctype_gb18030_binlog.test
1.09
KB
-rw-r--r--
ctype_gb18030_conversion.test
6.31
KB
-rw-r--r--
ctype_gb18030_encoding_cn.test
19.84
KB
-rw-r--r--
ctype_gb18030_encoding_utf8.te...
20.2
KB
-rw-r--r--
ctype_gb18030_ligatures.test
20.69
KB
-rw-r--r--
ctype_gb2312.test
4.77
KB
-rw-r--r--
ctype_gbk.test
6.22
KB
-rw-r--r--
ctype_gbk_binlog.test
1.01
KB
-rw-r--r--
ctype_hebrew.test
399
B
-rw-r--r--
ctype_latin1.test
7.3
KB
-rw-r--r--
ctype_latin1_de-master.opt
67
B
-rw-r--r--
ctype_latin1_de.test
5.99
KB
-rw-r--r--
ctype_latin2.test
3.2
KB
-rw-r--r--
ctype_latin2_ch.test
7.57
KB
-rw-r--r--
ctype_ldml-master.opt
129
B
-rw-r--r--
ctype_ldml.test
16.22
KB
-rw-r--r--
ctype_like_range.test
3.91
KB
-rw-r--r--
ctype_many.test
15.19
KB
-rw-r--r--
ctype_mb.test
699
B
-rw-r--r--
ctype_recoding.test
7.75
KB
-rw-r--r--
ctype_sjis.test
5.73
KB
-rw-r--r--
ctype_tis620.test
64.69
KB
-rw-r--r--
ctype_uca.test
27.37
KB
-rw-r--r--
ctype_ucs.test
23.83
KB
-rw-r--r--
ctype_ucs2_def-master.opt
70
B
-rw-r--r--
ctype_ucs2_def.test
1.57
KB
-rw-r--r--
ctype_ujis.test
40.68
KB
-rw-r--r--
ctype_ujis_ucs2.test
83.65
KB
-rw-r--r--
ctype_utf16.test
22.58
KB
-rw-r--r--
ctype_utf16_def-master.opt
36
B
-rw-r--r--
ctype_utf16_def.test
228
B
-rw-r--r--
ctype_utf16_uca.test
6.78
KB
-rw-r--r--
ctype_utf16le.test
22.27
KB
-rw-r--r--
ctype_utf32.test
25.42
KB
-rw-r--r--
ctype_utf32_uca.test
7.74
KB
-rw-r--r--
ctype_utf8-master.opt
32
B
-rw-r--r--
ctype_utf8.test
52.54
KB
-rw-r--r--
ctype_utf8mb4-master.opt
68
B
-rw-r--r--
ctype_utf8mb4.test
59.69
KB
-rw-r--r--
ctype_utf8mb4_heap.test
108
B
-rw-r--r--
ctype_utf8mb4_innodb-master.op...
32
B
-rw-r--r--
ctype_utf8mb4_innodb.test
237
B
-rw-r--r--
ctype_utf8mb4_myisam.test
93
B
-rw-r--r--
ctype_utf8mb4_uca.test
2.74
KB
-rw-r--r--
daemonize_opt-master.opt
54
B
-rw-r--r--
daemonize_opt.test
189
B
-rw-r--r--
datadir_permission.test
2.63
KB
-rw-r--r--
date_formats-master.opt
46
B
-rw-r--r--
date_formats.test
13.9
KB
-rw-r--r--
ddl_i18n_koi8r.test
23.39
KB
-rw-r--r--
ddl_i18n_utf8.test
23.67
KB
-rw-r--r--
deadlock_innodb.test
358
B
-rw-r--r--
debug_sync.test
14.22
KB
-rw-r--r--
debug_sync2-master.opt
29
B
-rw-r--r--
debug_sync2.test
1.41
KB
-rw-r--r--
default.test
5.8
KB
-rw-r--r--
delete.test
20.6
KB
-rw-r--r--
delete_all_rows.test
1.35
KB
-rw-r--r--
deprecate_eof-master.opt
21
B
-rw-r--r--
deprecate_eof.test
5.64
KB
-rw-r--r--
deprecated_features.test
731
B
-rw-r--r--
derived.test
81.78
KB
-rw-r--r--
dirty_close.test
1.55
KB
-rw-r--r--
disabled.def
1.31
KB
-rw-r--r--
disabled_replication-master.op...
29
B
-rw-r--r--
disabled_replication.test
2.79
KB
-rw-r--r--
disabled_storage_engines-maste...
52
B
-rw-r--r--
disabled_storage_engines.test
3.93
KB
-rw-r--r--
disconnect_on_expired_password...
1.39
KB
-rw-r--r--
disconnect_on_expired_password...
37
B
-rw-r--r--
disconnect_on_expired_password...
1.46
KB
-rw-r--r--
distinct.test
27.63
KB
-rw-r--r--
drop-no_root.test
2.59
KB
-rw-r--r--
drop.test
9.47
KB
-rw-r--r--
drop_debug.test
989
B
-rw-r--r--
ds_mrr-big.test
2.2
KB
-rw-r--r--
dynamic_tracing.test
3.92
KB
-rw-r--r--
empty_table.test
303
B
-rw-r--r--
enable_cleartext_plugin-master...
35
B
-rw-r--r--
enable_cleartext_plugin.test
2.48
KB
-rw-r--r--
endspace.test
4.36
KB
-rw-r--r--
eq_range_idx_stat.test
2.24
KB
-rw-r--r--
error_simulation.test
3.42
KB
-rw-r--r--
errors.test
4.97
KB
-rw-r--r--
events_1.test
18.96
KB
-rw-r--r--
events_2.test
15.97
KB
-rw-r--r--
events_and_binlog.test
445
B
-rw-r--r--
events_bugs-master.opt
18
B
-rw-r--r--
events_bugs.test
43.59
KB
-rw-r--r--
events_embedded.test
289
B
-rw-r--r--
events_grant.test
5.29
KB
-rw-r--r--
events_logs_tests-master.opt
41
B
-rw-r--r--
events_logs_tests.test
3.08
KB
-rw-r--r--
events_microsec.test
749
B
-rw-r--r--
events_restart-master.opt
18
B
-rw-r--r--
events_restart.test
4.51
KB
-rw-r--r--
events_scheduling.test
4.36
KB
-rw-r--r--
events_stress.test
4.57
KB
-rw-r--r--
events_time_zone.test
11.38
KB
-rw-r--r--
events_trans.test
3.33
KB
-rw-r--r--
events_trans_notembedded.test
1.82
KB
-rw-r--r--
examined_rows.test
3.84
KB
-rw-r--r--
execution_constants.test
3.32
KB
-rw-r--r--
explain.test
12.41
KB
-rw-r--r--
explain_for_connection_crash.t...
2.68
KB
-rw-r--r--
explain_for_connection_rqg_jso...
1.79
KB
-rw-r--r--
explain_for_connection_rqg_tra...
1.8
KB
-rw-r--r--
explain_for_connection_small_j...
24
B
-rw-r--r--
explain_for_connection_small_j...
2.18
KB
-rw-r--r--
explain_for_connection_small_t...
24
B
-rw-r--r--
explain_for_connection_small_t...
2.19
KB
-rw-r--r--
explain_json_all.test
518
B
-rw-r--r--
explain_json_none.test
617
B
-rw-r--r--
explain_other-master.opt
24
B
-rw-r--r--
explain_other.test
14.81
KB
-rw-r--r--
file_contents.test
2.89
KB
-rw-r--r--
filesort_debug-master.opt
0
B
-rw-r--r--
filesort_debug.test
5.54
KB
-rw-r--r--
filesort_merge.test
1.89
KB
-rw-r--r--
filesort_pack.test
801
B
-rw-r--r--
filter_single_col_idx_big.test
2.72
KB
-rw-r--r--
filter_single_col_idx_small.te...
3.64
KB
-rw-r--r--
fix_priv_tables.test
2.55
KB
-rw-r--r--
flush.test
17.3
KB
-rw-r--r--
flush2-master.opt
15
B
-rw-r--r--
flush2.test
689
B
-rw-r--r--
flush_block_commit.test
2.87
KB
-rw-r--r--
flush_block_commit_notembedded...
1.84
KB
-rw-r--r--
flush_read_lock.test
75.93
KB
-rw-r--r--
flush_read_lock_kill.test
2.32
KB
-rw-r--r--
flush_table-master.opt
21
B
-rw-r--r--
flush_table.test
15.92
KB
-rw-r--r--
foreign_key.test
3.91
KB
-rw-r--r--
fulltext.test
22.77
KB
-rw-r--r--
fulltext2.test
8.42
KB
-rw-r--r--
fulltext3.test
1.35
KB
-rw-r--r--
fulltext_cache.test
1.74
KB
-rw-r--r--
fulltext_distinct.test
1.55
KB
-rw-r--r--
fulltext_left_join.test
4.13
KB
-rw-r--r--
fulltext_multi.test
982
B
-rw-r--r--
fulltext_order_by.test
5.72
KB
-rw-r--r--
fulltext_plugin-master.opt
19
B
-rw-r--r--
fulltext_plugin.test
689
B
-rw-r--r--
fulltext_update.test
1.26
KB
-rw-r--r--
fulltext_var.test
1.41
KB
-rw-r--r--
func_aes.test
5.76
KB
-rw-r--r--
func_aes_cfb1.test
445
B
-rw-r--r--
func_aes_cfb128.test
455
B
-rw-r--r--
func_aes_cfb8.test
445
B
-rw-r--r--
func_aes_kdf_hkdf.test
2.5
KB
-rw-r--r--
func_aes_kdf_pbkdf2_hmac.test
3.88
KB
-rw-r--r--
func_aes_misc.test
6.11
KB
-rw-r--r--
func_aes_ofb.test
440
B
-rw-r--r--
func_analyse.test
9.59
KB
-rw-r--r--
func_bitwise_ops.test
18.39
KB
-rw-r--r--
func_compress.test
3.63
KB
-rw-r--r--
func_concat.test
4
KB
-rw-r--r--
func_crypt.test
1.68
KB
-rw-r--r--
func_date_add.test
3.36
KB
-rw-r--r--
func_default.test
1.21
KB
-rw-r--r--
func_des_encrypt.test
886
B
-rw-r--r--
func_digest.test
109.41
KB
-rw-r--r--
func_encrypt-master.opt
59
B
-rw-r--r--
func_encrypt.test
5.55
KB
-rw-r--r--
func_encrypt_nossl.test
1.37
KB
-rw-r--r--
func_encrypt_ucs2.test
546
B
-rw-r--r--
func_equal.test
1.1
KB
-rw-r--r--
func_found_rows.test
288
B
-rw-r--r--
func_gconcat.test
28.1
KB
-rw-r--r--
func_group.test
39.21
KB
-rw-r--r--
func_group_innodb.test
3.57
KB
-rw-r--r--
func_group_innodb_16k.test
605
B
-rw-r--r--
func_if.test
5.32
KB
-rw-r--r--
func_in_all.test
749
B
-rw-r--r--
func_in_icp.test
822
B
-rw-r--r--
func_in_icp_mrr.test
795
B
-rw-r--r--
func_in_mrr.test
820
B
-rw-r--r--
func_in_mrr_cost.test
830
B
-rw-r--r--
func_in_none.test
862
B
-rw-r--r--
func_isnull.test
1010
B
-rw-r--r--
func_like.test
6.39
KB
-rw-r--r--
func_math.test
26.62
KB
-rw-r--r--
func_misc-master.opt
21
B
-rw-r--r--
func_misc.test
27.43
KB
-rw-r--r--
func_op.test
965
B
-rw-r--r--
func_regexp.test
3.09
KB
-rw-r--r--
func_rollback.test
14.3
KB
-rw-r--r--
func_sapdb.test
7.58
KB
-rw-r--r--
func_set.test
5.87
KB
-rw-r--r--
func_str.test
63.27
KB
-rw-r--r--
func_str_debug.test
421
B
-rw-r--r--
func_str_no_ps.test
1.02
KB
-rw-r--r--
func_system.test
1.82
KB
-rw-r--r--
func_test.test
9.41
KB
-rw-r--r--
func_time.test
44.53
KB
-rw-r--r--
func_timestamp.test
662
B
-rw-r--r--
func_weight_string.test
6.36
KB
-rw-r--r--
function_defaults.test
825
B
-rw-r--r--
gcc296.test
527
B
-rw-r--r--
get_diagnostics.test
21.19
KB
-rw-r--r--
get_table_share.test
24.82
KB
-rw-r--r--
gis-debug.test
309
B
-rw-r--r--
gis-precise.test
103.82
KB
-rw-r--r--
gis-rt-precise.test
1.5
KB
-rw-r--r--
gis-rtree.test
46.36
KB
-rw-r--r--
gis.test
102
KB
-rw-r--r--
grant.test
82.65
KB
-rw-r--r--
grant2.test
33.81
KB
-rw-r--r--
grant3-master.opt
19
B
-rw-r--r--
grant3.test
6.85
KB
-rw-r--r--
grant4.test
8.44
KB
-rw-r--r--
grant_alter_user.test
28.77
KB
-rw-r--r--
grant_alter_user_qa-master.opt
68
B
-rw-r--r--
grant_alter_user_qa.test
67.2
KB
-rw-r--r--
grant_cache-master.opt
21
B
-rw-r--r--
grant_cache.test
591
B
-rw-r--r--
grant_debug.test
7.87
KB
-rw-r--r--
grant_explain_non_select.test
7.63
KB
-rw-r--r--
grant_lowercase_fs.test
1.02
KB
-rw-r--r--
grant_user_lock.test
15.07
KB
-rw-r--r--
grant_user_lock_qa-master.opt
32
B
-rw-r--r--
grant_user_lock_qa.test
33.86
KB
-rw-r--r--
greedy_optimizer-master.opt
21
B
-rw-r--r--
greedy_optimizer.test
30.83
KB
-rw-r--r--
greedy_search.test
9.91
KB
-rw-r--r--
group_by.test
77.53
KB
-rw-r--r--
group_by_fd_no_prot.test
411
B
-rw-r--r--
group_by_fd_ps_prot.test
160
B
-rw-r--r--
group_min_max.test
70.06
KB
-rw-r--r--
group_min_max_innodb.test
13.85
KB
-rw-r--r--
gtid_next_xa_binlog_off-master...
15
B
-rw-r--r--
gtid_next_xa_binlog_off.test
268
B
-rw-r--r--
gtids_anonymous_trxs_violation...
2.31
KB
-rw-r--r--
handler_innodb.test
571
B
-rw-r--r--
handler_myisam.test
4.46
KB
-rw-r--r--
handler_read_last.test
733
B
-rw-r--r--
having.test
25.07
KB
-rw-r--r--
heap.test
15.62
KB
-rw-r--r--
heap_auto_increment.test
927
B
-rw-r--r--
heap_btree.test
8.3
KB
-rw-r--r--
heap_hash.test
9.77
KB
-rw-r--r--
help.test
4.89
KB
-rw-r--r--
help_verbose.test
3.38
KB
-rw-r--r--
host_cache_size_functionality....
7.61
KB
-rw-r--r--
ignore_strict.test
20.23
KB
-rw-r--r--
implicit_char_to_num_conversio...
7.63
KB
-rw-r--r--
implicit_commit-master.opt
32
B
-rw-r--r--
implicit_commit.test
19.77
KB
-rw-r--r--
import_schema_mismatch.test
956
B
-rw-r--r--
index_merge_delete.test
306
B
-rw-r--r--
index_merge_innodb.test
2.21
KB
-rw-r--r--
index_merge_insert-and-replace...
330
B
-rw-r--r--
index_merge_intersect_dml.test
157
B
-rw-r--r--
index_merge_myisam.test
5.53
KB
-rw-r--r--
index_merge_update.test
307
B
-rw-r--r--
information_schema-big.test
1.77
KB
-rw-r--r--
information_schema.test
61.02
KB
-rw-r--r--
information_schema_chmod.test
835
B
-rw-r--r--
information_schema_db.test
7.18
KB
-rw-r--r--
information_schema_inno.test
3.61
KB
-rw-r--r--
information_schema_parameters....
12.73
KB
-rw-r--r--
information_schema_part.test
4.15
KB
-rw-r--r--
information_schema_routines.te...
13.75
KB
-rw-r--r--
init_connect-master.opt
32
B
-rw-r--r--
init_connect.test
6.9
KB
-rw-r--r--
init_file-master.opt
51
B
-rw-r--r--
init_file.test
1.06
KB
-rw-r--r--
initialize-bug20350099-master....
23
B
-rw-r--r--
initialize-bug20350099.test
3.51
KB
-rw-r--r--
initialize-bug20504142.test
3.8
KB
-rw-r--r--
initialize-bug21335821-master....
23
B
-rw-r--r--
initialize-bug21335821.test
3.06
KB
-rw-r--r--
initialize-errors.test
2.67
KB
-rw-r--r--
initialize-ignore-db.test
2.96
KB
-rw-r--r--
initialize-init-acls.test
3.26
KB
-rw-r--r--
initialize-sha256.test
3.51
KB
-rw-r--r--
initialize.test
9.45
KB
-rw-r--r--
initialize_gtid.test
2.8
KB
-rw-r--r--
innodb_deadlock-master.opt
29
B
-rw-r--r--
innodb_deadlock.test
1.43
KB
-rw-r--r--
innodb_disabled-master.opt
96
B
-rw-r--r--
innodb_disabled.test
2.1
KB
-rw-r--r--
innodb_explain_json_non_select...
1.02
KB
-rw-r--r--
innodb_explain_json_non_select...
1.03
KB
-rw-r--r--
innodb_explain_non_select_all....
855
B
-rw-r--r--
innodb_explain_non_select_none...
892
B
-rw-r--r--
innodb_icp.test
784
B
-rw-r--r--
innodb_icp_all.test
679
B
-rw-r--r--
innodb_icp_none.test
817
B
-rw-r--r--
innodb_ignore_builtin-master.o...
38
B
-rw-r--r--
innodb_ignore_builtin.test
442
B
-rw-r--r--
innodb_log_file_size_functiona...
5.43
KB
-rw-r--r--
innodb_mrr-master.opt
35
B
-rw-r--r--
innodb_mrr.test
870
B
-rw-r--r--
innodb_mrr_all-master.opt
35
B
-rw-r--r--
innodb_mrr_all.test
756
B
-rw-r--r--
innodb_mrr_cost-master.opt
35
B
-rw-r--r--
innodb_mrr_cost.test
869
B
-rw-r--r--
innodb_mrr_cost_all-master.opt
35
B
-rw-r--r--
innodb_mrr_cost_all.test
755
B
-rw-r--r--
innodb_mrr_cost_icp-master.opt
35
B
-rw-r--r--
innodb_mrr_cost_icp.test
824
B
-rw-r--r--
innodb_mrr_icp-master.opt
35
B
-rw-r--r--
innodb_mrr_icp.test
825
B
-rw-r--r--
innodb_mrr_none-master.opt
35
B
-rw-r--r--
innodb_mrr_none.test
876
B
-rw-r--r--
innodb_mysql_lock-master.opt
31
B
-rw-r--r--
innodb_mysql_lock.test
7.18
KB
-rw-r--r--
innodb_mysql_lock2.test
29.15
KB
-rw-r--r--
innodb_mysql_sync.test
31.39
KB
-rw-r--r--
innodb_pk_extension_off.test
298
B
-rw-r--r--
innodb_pk_extension_on.test
296
B
-rw-r--r--
innodb_recovery_with_upper_cas...
25
B
-rw-r--r--
innodb_recovery_with_upper_cas...
1.75
KB
-rw-r--r--
insert.test
19.57
KB
-rw-r--r--
insert_debug-master.opt
29
B
-rw-r--r--
insert_debug.test
2.39
KB
-rw-r--r--
insert_notembedded.test
5.47
KB
-rw-r--r--
insert_select.test
14.79
KB
-rw-r--r--
insert_update.test
14.27
KB
-rw-r--r--
installdb-bad-cipher.test
875
B
-rw-r--r--
internal_tmp_disk_storage_engi...
102.07
KB
-rw-r--r--
ipv4_as_ipv6-master.opt
43
B
-rw-r--r--
ipv4_as_ipv6.test
2.18
KB
-rw-r--r--
ipv6-master.opt
20
B
-rw-r--r--
ipv6.test
1.28
KB
-rw-r--r--
is_deprecation.test
166
B
-rw-r--r--
join.test
41.36
KB
-rw-r--r--
join_cache_bka.test
341
B
-rw-r--r--
join_cache_bka_nixbnl.test
408
B
-rw-r--r--
join_cache_bkaunique.test
408
B
-rw-r--r--
join_cache_bnl.test
435
B
-rw-r--r--
join_cache_nojb.test
504
B
-rw-r--r--
join_crash.test
4.99
KB
-rw-r--r--
join_file_handler.test
1
KB
-rw-r--r--
join_nested.test
43.89
KB
-rw-r--r--
join_nested_bka.test
2.5
KB
-rw-r--r--
join_nested_bka_nixbnl.test
2.52
KB
-rw-r--r--
join_outer.test
60.27
KB
-rw-r--r--
join_outer_bka.test
379
B
-rw-r--r--
join_outer_bka_nixbnl.test
401
B
-rw-r--r--
join_outer_innodb.test
2.23
KB
-rw-r--r--
key.test
17.2
KB
-rw-r--r--
key_cache-master.opt
95
B
-rw-r--r--
key_cache.test
8.48
KB
-rw-r--r--
key_diff.test
573
B
-rw-r--r--
key_primary.test
461
B
-rw-r--r--
keywords.test
5.47
KB
-rw-r--r--
kill.test
17.11
KB
-rw-r--r--
kill_debug-master.opt
21
B
-rw-r--r--
kill_debug.test
1.55
KB
-rw-r--r--
limit.test
7.26
KB
-rw-r--r--
loaddata.test
22.6
KB
-rw-r--r--
loaddata_autocom_innodb.test
98
B
-rw-r--r--
loadxml.test
3.75
KB
-rw-r--r--
locale.test
3.23
KB
-rw-r--r--
lock.test
14.35
KB
-rw-r--r--
lock_multi.test
114.87
KB
-rw-r--r--
lock_multi_bug38499.test
4.7
KB
-rw-r--r--
lock_multi_bug38691.test
2.98
KB
-rw-r--r--
lock_sync-master.opt
58
B
-rw-r--r--
lock_sync.test
35.79
KB
-rw-r--r--
lock_tables_lost_commit-master...
24
B
-rw-r--r--
lock_tables_lost_commit.test
845
B
-rw-r--r--
locking_service-master.opt
21
B
-rw-r--r--
locking_service.test
35.37
KB
-rw-r--r--
log_errchk.test
2.09
KB
-rw-r--r--
log_state-master.opt
59
B
-rw-r--r--
log_state.test
10.29
KB
-rw-r--r--
log_state_bug33693-master.opt
60
B
-rw-r--r--
log_state_bug33693.test
568
B
-rw-r--r--
log_tables-big-master.opt
17
B
-rw-r--r--
log_tables-big.test
1.32
KB
-rw-r--r--
log_tables-master.opt
41
B
-rw-r--r--
log_tables.test
30.83
KB
-rw-r--r--
log_tables_debug.test
2.83
KB
-rw-r--r--
log_tables_upgrade.test
989
B
-rw-r--r--
log_timestamps-master.opt
21
B
-rw-r--r--
log_timestamps.test
89
B
-rw-r--r--
long_tmpdir-master.opt
141
B
-rw-r--r--
long_tmpdir-master.sh
190
B
-rwxr-xr-x
long_tmpdir.test
216
B
-rw-r--r--
lowercase_fs_off.test
2.82
KB
-rw-r--r--
lowercase_fs_on.test
1.33
KB
-rw-r--r--
lowercase_mixed_tmpdir-master....
68
B
-rw-r--r--
lowercase_mixed_tmpdir-master....
179
B
-rwxr-xr-x
lowercase_mixed_tmpdir.test
292
B
-rw-r--r--
lowercase_mixed_tmpdir_innodb-...
68
B
-rw-r--r--
lowercase_mixed_tmpdir_innodb-...
180
B
-rwxr-xr-x
lowercase_mixed_tmpdir_innodb....
299
B
-rw-r--r--
lowercase_table-master.opt
25
B
-rw-r--r--
lowercase_table.test
3.68
KB
-rw-r--r--
lowercase_table2.test
8.28
KB
-rw-r--r--
lowercase_table4-master.opt
27
B
-rw-r--r--
lowercase_table4.test
4.01
KB
-rw-r--r--
lowercase_table5.test
1009
B
-rw-r--r--
lowercase_table_grant-master.o...
25
B
-rw-r--r--
lowercase_table_grant.test
1.05
KB
-rw-r--r--
lowercase_table_qcache-master....
46
B
-rw-r--r--
lowercase_table_qcache.test
698
B
-rw-r--r--
lowercase_utf8-master.opt
58
B
-rw-r--r--
lowercase_utf8.test
207
B
-rw-r--r--
lowercase_view-master.opt
27
B
-rw-r--r--
lowercase_view.test
6.29
KB
-rw-r--r--
m_i_db.test
9.24
KB
-rw-r--r--
m_i_db_config.cnf
38
B
-rw-r--r--
m_i_db_createschema.sql
10.29
KB
-rw-r--r--
main.lowercase_table_qcache-ma...
21
B
-rw-r--r--
max_statement_time-master.opt
21
B
-rw-r--r--
max_statement_time.test
14.33
KB
-rw-r--r--
mdl_sync-master.opt
53
B
-rw-r--r--
mdl_sync.test
183.93
KB
-rw-r--r--
mdl_tablespace.test
41.99
KB
-rw-r--r--
merge-big.test
3.11
KB
-rw-r--r--
merge.test
83.59
KB
-rw-r--r--
merge_innodb.test
1.06
KB
-rw-r--r--
merge_mmap-master.opt
18
B
-rw-r--r--
merge_mmap.test
4.1
KB
-rw-r--r--
metadata.test
7.31
KB
-rw-r--r--
mix2_myisam-master.opt
33
B
-rw-r--r--
mix2_myisam.test
961
B
-rw-r--r--
mix2_myisam_ucs2.test
940
B
-rw-r--r--
multi_plugin_load-master.opt
92
B
-rw-r--r--
multi_plugin_load.test
774
B
-rw-r--r--
multi_plugin_load_add-master.o...
68
B
-rw-r--r--
multi_plugin_load_add.test
495
B
-rw-r--r--
multi_plugin_load_add2-master....
111
B
-rw-r--r--
multi_plugin_load_add2.test
495
B
-rw-r--r--
multi_statement-master.opt
80
B
-rw-r--r--
multi_statement.test
971
B
-rw-r--r--
multi_update-master.opt
22
B
-rw-r--r--
multi_update.test
26.93
KB
-rw-r--r--
multi_update2-master.opt
22
B
-rw-r--r--
multi_update2.test
2.1
KB
-rw-r--r--
multi_update_innodb.test
4.41
KB
-rw-r--r--
multi_update_tiny_hash-master....
28
B
-rw-r--r--
multi_update_tiny_hash.test
1.6
KB
-rw-r--r--
myisam-blob-master.opt
60
B
-rw-r--r--
myisam-blob.test
1.42
KB
-rw-r--r--
myisam-system.test
692
B
-rw-r--r--
myisam.test
66.93
KB
-rw-r--r--
myisam_crash_before_flush_keys...
36
B
-rw-r--r--
myisam_crash_before_flush_keys...
1.7
KB
-rw-r--r--
myisam_debug.test
1.57
KB
-rw-r--r--
myisam_explain_json_non_select...
931
B
-rw-r--r--
myisam_explain_json_non_select...
1.02
KB
-rw-r--r--
myisam_explain_non_select_all....
794
B
-rw-r--r--
myisam_explain_non_select_none...
885
B
-rw-r--r--
myisam_icp.test
880
B
-rw-r--r--
myisam_icp_all.test
775
B
-rw-r--r--
myisam_icp_none.test
912
B
-rw-r--r--
myisam_mrr.test
1.03
KB
-rw-r--r--
myisam_mrr_all.test
943
B
-rw-r--r--
myisam_mrr_cost.test
1.04
KB
-rw-r--r--
myisam_mrr_cost_all.test
942
B
-rw-r--r--
myisam_mrr_cost_icp.test
1021
B
-rw-r--r--
myisam_mrr_icp.test
1011
B
-rw-r--r--
myisam_mrr_none.test
1.04
KB
-rw-r--r--
myisam_recover-master.opt
31
B
-rw-r--r--
myisam_recover.test
5.73
KB
-rw-r--r--
myisam_row_rpl-master.opt
54
B
-rw-r--r--
myisam_row_rpl-slave.opt
54
B
-rw-r--r--
myisam_row_rpl.test
1.93
KB
-rw-r--r--
myisampack.test
12.57
KB
-rw-r--r--
mysql-bug41486.test
1.54
KB
-rw-r--r--
mysql-bug45236.test
1.41
KB
-rw-r--r--
mysql.test
24.5
KB
-rw-r--r--
mysql_batch_mode.test
441
B
-rw-r--r--
mysql_binary_mode.test
5.56
KB
-rw-r--r--
mysql_client_test-master.opt
150
B
-rw-r--r--
mysql_client_test.test
1.34
KB
-rw-r--r--
mysql_client_test_embedded.tes...
887
B
-rw-r--r--
mysql_client_test_qcache-maste...
21
B
-rw-r--r--
mysql_client_test_qcache.test
856
B
-rw-r--r--
mysql_comments.sql
4.58
KB
-rw-r--r--
mysql_comments.test
1.63
KB
-rw-r--r--
mysql_config_editor.test
9.41
KB
-rw-r--r--
mysql_cp932.test
1.04
KB
-rw-r--r--
mysql_delimiter.sql
1.48
KB
-rw-r--r--
mysql_delimiter_19799.sql
13
B
-rw-r--r--
mysql_delimiter_source.sql
122
B
-rw-r--r--
mysql_embedded.test
2.07
KB
-rw-r--r--
mysql_embedded_client_test.tes...
1.55
KB
-rw-r--r--
mysql_locale_posix.test
7.21
KB
-rw-r--r--
mysql_not_windows-master.opt
28
B
-rw-r--r--
mysql_not_windows.test
923
B
-rw-r--r--
mysql_plugin-master.opt
32
B
-rw-r--r--
mysql_plugin.test
12.17
KB
-rw-r--r--
mysql_protocols.test
716
B
-rw-r--r--
mysql_ssl-master.opt
11
B
-rw-r--r--
mysql_ssl.test
788
B
-rw-r--r--
mysql_ssl_default.test
1.6
KB
-rw-r--r--
mysql_tzinfo_to_sql.test
2.49
KB
-rw-r--r--
mysql_tzinfo_to_sql_sys.test
4.8
KB
-rw-r--r--
mysql_upgrade.test
43.56
KB
-rw-r--r--
mysql_upgrade_slave_master_inf...
6.35
KB
-rw-r--r--
mysql_upgrade_ssl.test
2.15
KB
-rw-r--r--
mysql_upgrade_with_session_use...
2.18
KB
-rw-r--r--
mysqladmin.test
3.12
KB
-rw-r--r--
mysqladmin_shutdown.test
868
B
-rw-r--r--
mysqlbinlog-master.opt
65
B
-rw-r--r--
mysqlbinlog.test
18.92
KB
-rw-r--r--
mysqlbinlog_base64_flag.test
5.53
KB
-rw-r--r--
mysqlbinlog_debug.test
981
B
-rw-r--r--
mysqlbinlog_hexdump.test
225
B
-rw-r--r--
mysqlbinlog_mixed_or_statment....
1.18
KB
-rw-r--r--
mysqlbinlog_raw_mode.test
1.98
KB
-rw-r--r--
mysqlbinlog_raw_mode_win.test
356
B
-rw-r--r--
mysqlbinlog_row_big.test
4.21
KB
-rw-r--r--
mysqlcheck.test
10.45
KB
-rw-r--r--
mysqld--defaults-file.test
1.19
KB
-rw-r--r--
mysqld--help-notwin.test
161
B
-rw-r--r--
mysqld--help-win.test
366
B
-rw-r--r--
mysqld_daemon.test
2.05
KB
-rw-r--r--
mysqld_safe.sh
40
B
-rwxr-xr-x
mysqld_safe.test
3.06
KB
-rw-r--r--
mysqldump-binary.test
2.24
KB
-rw-r--r--
mysqldump-compat.opt
31
B
-rw-r--r--
mysqldump-compat.test
447
B
-rw-r--r--
mysqldump-max-master.opt
32
B
-rw-r--r--
mysqldump-max.test
39.96
KB
-rw-r--r--
mysqldump-no-binlog-master.opt
15
B
-rw-r--r--
mysqldump-no-binlog.test
195
B
-rw-r--r--
mysqldump.test
92.39
KB
-rw-r--r--
mysqldump_bug29998457.test
1.22
KB
-rw-r--r--
mysqldump_bug30042589.test
987
B
-rw-r--r--
mysqldump_bugs.test
3.27
KB
-rw-r--r--
mysqldump_gtid_state-master.op...
72
B
-rw-r--r--
mysqldump_gtid_state.test
4.23
KB
-rw-r--r--
mysqldump_restore.test
3.85
KB
-rw-r--r--
mysqldumpslow.test
1.81
KB
-rw-r--r--
mysqlimport.test
1.29
KB
-rw-r--r--
mysqlpump.test
8.3
KB
-rw-r--r--
mysqlpump_basic.test
22.51
KB
-rw-r--r--
mysqlpump_bugs.test
1.63
KB
-rw-r--r--
mysqlpump_charset.test
4.22
KB
-rw-r--r--
mysqlpump_concurrency.test
1.94
KB
-rw-r--r--
mysqlpump_extended.test
13.79
KB
-rw-r--r--
mysqlpump_filters.test
5.95
KB
-rw-r--r--
mysqlpump_multi_thread.test
4.09
KB
-rw-r--r--
mysqlpump_partial_bkp.test
1.63
KB
-rw-r--r--
mysqlshow.test
3.05
KB
-rw-r--r--
mysqlslap.test
6.96
KB
-rw-r--r--
mysqltest.test
77.87
KB
-rw-r--r--
named_pipe-master.opt
26
B
-rw-r--r--
named_pipe.test
807
B
-rw-r--r--
negation_elimination.test
4.13
KB
-rw-r--r--
no-threads-master.opt
29
B
-rw-r--r--
no-threads.test
408
B
-rw-r--r--
no_binlog.test
166
B
-rw-r--r--
no_binlog_gtid_empty_statement...
1.94
KB
-rw-r--r--
no_binlog_gtid_empty_transacti...
42
B
-rw-r--r--
no_binlog_gtid_empty_transacti...
1.49
KB
-rw-r--r--
no_binlog_gtid_mode_on-master....
42
B
-rw-r--r--
no_binlog_gtid_mode_on.test
9.1
KB
-rw-r--r--
no_binlog_gtid_mode_on_explici...
42
B
-rw-r--r--
no_binlog_gtid_mode_on_explici...
3.29
KB
-rw-r--r--
no_binlog_gtid_next_begin_caus...
42
B
-rw-r--r--
no_binlog_gtid_next_begin_caus...
864
B
-rw-r--r--
no_binlog_gtid_next_partially_...
42
B
-rw-r--r--
no_binlog_gtid_next_partially_...
18.58
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
2.35
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
42
B
-rw-r--r--
no_binlog_gtid_next_partially_...
4.94
KB
-rw-r--r--
no_binlog_gtid_next_single_stm...
1017
B
-rw-r--r--
no_binlog_gtid_next_temporary_...
2.7
KB
-rw-r--r--
no_engine_substitution-master....
54
B
-rw-r--r--
no_engine_substitution.test
4.7
KB
-rw-r--r--
not_embedded_server-master.opt
16
B
-rw-r--r--
not_embedded_server.test
5.61
KB
-rw-r--r--
not_partition-master.opt
23
B
-rw-r--r--
not_partition.test
3.12
KB
-rw-r--r--
null.test
9.02
KB
-rw-r--r--
null_key_all.test
687
B
-rw-r--r--
null_key_icp.test
779
B
-rw-r--r--
null_key_none.test
819
B
-rw-r--r--
odbc.test
942
B
-rw-r--r--
olap.test
14.29
KB
-rw-r--r--
openssl_1.test
10.34
KB
-rw-r--r--
opt_costmodel.test
6.89
KB
-rw-r--r--
opt_costmodel_downgrade.test
793
B
-rw-r--r--
opt_costmodel_flush.test
7.71
KB
-rw-r--r--
opt_costmodel_pfs.test
394
B
-rw-r--r--
opt_costmodel_restart.test
3.46
KB
-rw-r--r--
opt_costmodel_tables.test
5.53
KB
-rw-r--r--
opt_costmodel_warnings.test
4.93
KB
-rw-r--r--
opt_hint_timeout.test
2.07
KB
-rw-r--r--
opt_hints.test
29.22
KB
-rw-r--r--
opt_hints_lowercase.test
1.06
KB
-rw-r--r--
opt_hints_pfs.test
1.17
KB
-rw-r--r--
opt_hints_subquery.test
36.32
KB
-rw-r--r--
optimizer_bug12837084.test
14.36
KB
-rw-r--r--
optimizer_debug_sync.test
2.23
KB
-rw-r--r--
optimizer_switch.test
10.35
KB
-rw-r--r--
order_by_all.test
752
B
-rw-r--r--
order_by_icp_mrr.test
797
B
-rw-r--r--
order_by_limit.test
7.82
KB
-rw-r--r--
order_by_none.test
864
B
-rw-r--r--
order_by_sortkey.test
2.56
KB
-rw-r--r--
order_fill_sortbuf-master.opt
25
B
-rw-r--r--
order_fill_sortbuf.test
579
B
-rw-r--r--
outfile.test
4.23
KB
-rw-r--r--
outfile_loaddata.test
10.92
KB
-rw-r--r--
overflow.test
578
B
-rw-r--r--
packet.test
6.32
KB
-rw-r--r--
parser-big-32bit.test
145
B
-rw-r--r--
parser-big-64bit.test
145
B
-rw-r--r--
parser-master.opt
30
B
-rw-r--r--
parser.test
36.07
KB
-rw-r--r--
parser_bug21114_innodb.test
11.79
KB
-rw-r--r--
parser_not_embedded.test
2.53
KB
-rw-r--r--
parser_precedence.test
12.39
KB
-rw-r--r--
parser_stack.test
12.07
KB
-rw-r--r--
partition.test
68.35
KB
-rw-r--r--
partition_archive.test
4.19
KB
-rw-r--r--
partition_binlog.test
1.2
KB
-rw-r--r--
partition_binlog_stmt.test
985
B
-rw-r--r--
partition_blackhole.test
661
B
-rw-r--r--
partition_bug18198.test
7.88
KB
-rw-r--r--
partition_cache-master.opt
21
B
-rw-r--r--
partition_cache.test
1.41
KB
-rw-r--r--
partition_charset.test
675
B
-rw-r--r--
partition_column.test
16.25
KB
-rw-r--r--
partition_column_prune.test
2.35
KB
-rw-r--r--
partition_csv.test
2.52
KB
-rw-r--r--
partition_datatype.test
19.03
KB
-rw-r--r--
partition_debug.test
2.07
KB
-rw-r--r--
partition_debug_sync.test
7.01
KB
-rw-r--r--
partition_debug_sync_stmt.test
3.35
KB
-rw-r--r--
partition_deprecation.test
3.87
KB
-rw-r--r--
partition_error.test
62.95
KB
-rw-r--r--
partition_exchange.test
31.54
KB
-rw-r--r--
partition_explicit_prune.test
29.83
KB
-rw-r--r--
partition_federated.test
531
B
-rw-r--r--
partition_grant.test
2.4
KB
-rw-r--r--
partition_hash.test
5.07
KB
-rw-r--r--
partition_index_innodb.test
5.9
KB
-rw-r--r--
partition_index_myisam.test
3.88
KB
-rw-r--r--
partition_innodb.test
41.82
KB
-rw-r--r--
partition_innodb_plugin.test
4.73
KB
-rw-r--r--
partition_innodb_semi_consiste...
61
B
-rw-r--r--
partition_innodb_semi_consiste...
4.09
KB
-rw-r--r--
partition_innodb_stmt.test
1.22
KB
-rw-r--r--
partition_innodb_tablespace.te...
16.16
KB
-rw-r--r--
partition_key_cache.test
11.03
KB
-rw-r--r--
partition_list.test
8.14
KB
-rw-r--r--
partition_locking.test
63.4
KB
-rw-r--r--
partition_locking_4.test
1.53
KB
-rw-r--r--
partition_mgm.test
4.59
KB
-rw-r--r--
partition_mgm_err.test
6.47
KB
-rw-r--r--
partition_mgm_err2.test
940
B
-rw-r--r--
partition_myisam.test
8.17
KB
-rw-r--r--
partition_not_blackhole-master...
23
B
-rw-r--r--
partition_not_blackhole.test
875
B
-rw-r--r--
partition_not_windows-master.o...
19
B
-rw-r--r--
partition_not_windows.test
7.68
KB
-rw-r--r--
partition_order.test
17.9
KB
-rw-r--r--
partition_plugin-master.opt
22
B
-rw-r--r--
partition_plugin.test
3.82
KB
-rw-r--r--
partition_pruning.test
72.39
KB
-rw-r--r--
partition_range.test
31.76
KB
-rw-r--r--
partition_rename_longfilename....
2.02
KB
-rw-r--r--
partition_symlink.test
7.38
KB
-rw-r--r--
partition_sync.test
2.16
KB
-rw-r--r--
partition_truncate.test
742
B
-rw-r--r--
partition_utf8.test
1.63
KB
-rw-r--r--
partition_windows.test
1.28
KB
-rw-r--r--
per_thread_connection_handler....
1.99
KB
-rw-r--r--
perror-win.test
1.1
KB
-rw-r--r--
perror.test
778
B
-rw-r--r--
plugin-master.opt
20
B
-rw-r--r--
plugin.test
8.24
KB
-rw-r--r--
plugin_auth-master.opt
35
B
-rw-r--r--
plugin_auth.test
28.96
KB
-rw-r--r--
plugin_auth_expire-master.opt
35
B
-rw-r--r--
plugin_auth_expire.test
706
B
-rw-r--r--
plugin_auth_qa-master.opt
35
B
-rw-r--r--
plugin_auth_qa.test
12.3
KB
-rw-r--r--
plugin_auth_qa_1-master.opt
35
B
-rw-r--r--
plugin_auth_qa_1.test
14.55
KB
-rw-r--r--
plugin_auth_qa_2-master.opt
55
B
-rw-r--r--
plugin_auth_qa_2.test
7.94
KB
-rw-r--r--
plugin_auth_qa_3-master.opt
49
B
-rw-r--r--
plugin_auth_qa_3.test
1.51
KB
-rw-r--r--
plugin_auth_sha256-master.opt
170
B
-rw-r--r--
plugin_auth_sha256.test
4.83
KB
-rw-r--r--
plugin_auth_sha256_2-master.op...
224
B
-rw-r--r--
plugin_auth_sha256_2.test
1.95
KB
-rw-r--r--
plugin_auth_sha256_server_defa...
224
B
-rw-r--r--
plugin_auth_sha256_server_defa...
2.93
KB
-rw-r--r--
plugin_auth_sha256_server_defa...
48
B
-rw-r--r--
plugin_auth_sha256_server_defa...
3.68
KB
-rw-r--r--
plugin_auth_sha256_tls.test
2.16
KB
-rw-r--r--
plugin_auth_user_lock-master.o...
34
B
-rw-r--r--
plugin_auth_user_lock.test
1.27
KB
-rw-r--r--
plugin_load-master.opt
76
B
-rw-r--r--
plugin_load.test
125
B
-rw-r--r--
plugin_load_option-master.opt
85
B
-rw-r--r--
plugin_load_option.test
265
B
-rw-r--r--
plugin_not_embedded-master.opt
20
B
-rw-r--r--
plugin_not_embedded.test
1
KB
-rw-r--r--
preload-master.opt
21
B
-rw-r--r--
preload.test
2.65
KB
-rw-r--r--
profiling.test
9.24
KB
-rw-r--r--
ps-master.opt
73
B
-rw-r--r--
ps.test
93.48
KB
-rw-r--r--
ps_10nestset.test
2.75
KB
-rw-r--r--
ps_11bugs.test
7.05
KB
-rw-r--r--
ps_1general.test
28.24
KB
-rw-r--r--
ps_2myisam-master.opt
21
B
-rw-r--r--
ps_2myisam.test
1.24
KB
-rw-r--r--
ps_3innodb-master.opt
53
B
-rw-r--r--
ps_3innodb.test
638
B
-rw-r--r--
ps_4heap-master.opt
21
B
-rw-r--r--
ps_4heap.test
1.62
KB
-rw-r--r--
ps_5merge-master.opt
21
B
-rw-r--r--
ps_5merge.test
2.8
KB
-rw-r--r--
ps_ddl-master.opt
43
B
-rw-r--r--
ps_ddl.test
53.8
KB
-rw-r--r--
ps_ddl1.test
11.04
KB
-rw-r--r--
ps_grant.test
4.03
KB
-rw-r--r--
ps_not_windows.test
755
B
-rw-r--r--
ps_w_max_indexes_64.test
5.64
KB
-rw-r--r--
query_cache-master.opt
21
B
-rw-r--r--
query_cache.test
45.66
KB
-rw-r--r--
query_cache_28249-master.opt
21
B
-rw-r--r--
query_cache_28249.test
4.2
KB
-rw-r--r--
query_cache_debug-master.opt
21
B
-rw-r--r--
query_cache_debug.test
10.91
KB
-rw-r--r--
query_cache_disabled-master.op...
21
B
-rw-r--r--
query_cache_disabled.test
1.17
KB
-rw-r--r--
query_cache_merge-master.opt
21
B
-rw-r--r--
query_cache_merge.test
4.68
KB
-rw-r--r--
query_cache_notembedded-master...
21
B
-rw-r--r--
query_cache_notembedded.test
7.5
KB
-rw-r--r--
query_cache_ps_no_prot-master....
21
B
-rw-r--r--
query_cache_ps_no_prot.test
907
B
-rw-r--r--
query_cache_ps_ps_prot-master....
21
B
-rw-r--r--
query_cache_ps_ps_prot.test
1.18
KB
-rw-r--r--
query_cache_size_functionality...
21
B
-rw-r--r--
query_cache_size_functionality...
11.14
KB
-rw-r--r--
query_cache_type_functionality...
21
B
-rw-r--r--
query_cache_type_functionality...
11.18
KB
-rw-r--r--
query_cache_with_views-master....
21
B
-rw-r--r--
query_cache_with_views.test
4.17
KB
-rw-r--r--
range_all.test
700
B
-rw-r--r--
range_icp.test
773
B
-rw-r--r--
range_icp_mrr.test
746
B
-rw-r--r--
range_mrr.test
771
B
-rw-r--r--
range_mrr_cost.test
781
B
-rw-r--r--
range_none.test
813
B
-rw-r--r--
range_with_memory_limit.test
880
B
-rw-r--r--
read_many_rows_innodb.test
417
B
-rw-r--r--
read_only.test
12.77
KB
-rw-r--r--
read_only_innodb.test
5.5
KB
-rw-r--r--
relay_log_index_variables-mast...
86
B
-rw-r--r--
relay_log_index_variables.test
184
B
-rw-r--r--
relay_log_variables-master.opt
24
B
-rw-r--r--
relay_log_variables.test
184
B
-rw-r--r--
rename.test
2.26
KB
-rw-r--r--
renamedb.test
1.25
KB
-rw-r--r--
repair.test
5.29
KB
-rw-r--r--
replace.test
1.48
KB
-rw-r--r--
reset_connection.test
5.48
KB
-rw-r--r--
rewrite_general_log.test
5.14
KB
-rw-r--r--
rewrite_slow_log.test
4.32
KB
-rw-r--r--
rollback.test
683
B
-rw-r--r--
round.test
4.73
KB
-rw-r--r--
row.test
10.61
KB
-rw-r--r--
rowid_order_innodb.test
382
B
-rw-r--r--
rpl_connect_attr.test
2.36
KB
-rw-r--r--
rpl_multi_source_mysqldump_sla...
2.56
KB
-rw-r--r--
rpl_mysqldump_slave.test
1.06
KB
-rw-r--r--
schema.test
4.7
KB
-rw-r--r--
secure_file_priv_win-master.op...
34
B
-rw-r--r--
secure_file_priv_win.test
2.77
KB
-rw-r--r--
select_all.test
801
B
-rw-r--r--
select_all_bka.test
478
B
-rw-r--r--
select_all_bka_nixbnl.test
500
B
-rw-r--r--
select_for_update-master.opt
29
B
-rw-r--r--
select_for_update.test
996
B
-rw-r--r--
select_found.test
6.36
KB
-rw-r--r--
select_icp_mrr.test
847
B
-rw-r--r--
select_icp_mrr_bka.test
486
B
-rw-r--r--
select_icp_mrr_bka_nixbnl.test
508
B
-rw-r--r--
select_none.test
914
B
-rw-r--r--
select_none_bka.test
480
B
-rw-r--r--
select_none_bka_nixbnl.test
502
B
-rw-r--r--
select_safe.test
4.8
KB
-rw-r--r--
server_offline_1.test
2.83
KB
-rw-r--r--
server_offline_2.test
2.2
KB
-rw-r--r--
server_offline_3.test
2.33
KB
-rw-r--r--
server_offline_4.test
2.33
KB
-rw-r--r--
server_offline_5.test
2.41
KB
-rw-r--r--
server_offline_6-master.opt
18
B
-rw-r--r--
server_offline_6.test
1.68
KB
-rw-r--r--
server_uuid.test
2.53
KB
-rw-r--r--
server_uuid_embedded.test
1.34
KB
-rw-r--r--
session_tracker-master.opt
24
B
-rw-r--r--
session_tracker.test
14.72
KB
-rw-r--r--
session_tracker_trx_state-mast...
21
B
-rw-r--r--
session_tracker_trx_state.test
25.82
KB
-rw-r--r--
shm-master.opt
173
B
-rw-r--r--
shm.test
1.67
KB
-rw-r--r--
shm_server_restart-master.opt
23
B
-rw-r--r--
shm_server_restart.test
999
B
-rw-r--r--
show_check-master.opt
101
B
-rw-r--r--
show_check.test
33.97
KB
-rw-r--r--
show_processlist_state.test
208
B
-rw-r--r--
show_profile.test
496
B
-rw-r--r--
show_variables.test
367
B
-rw-r--r--
shutdown.test
1.9
KB
-rw-r--r--
signal.test
63.46
KB
-rw-r--r--
signal_code.test
1.04
KB
-rw-r--r--
signal_demo1.test
6.97
KB
-rw-r--r--
signal_demo2.test
3.34
KB
-rw-r--r--
signal_demo3-master.opt
55
B
-rw-r--r--
signal_demo3.test
2.67
KB
-rw-r--r--
signal_sqlmode.test
1.85
KB
-rw-r--r--
single_delete_update.test
13.54
KB
-rw-r--r--
skip_grants-master.opt
20
B
-rw-r--r--
skip_grants.test
2.74
KB
-rw-r--r--
skip_grants_flush-master.opt
20
B
-rw-r--r--
skip_grants_flush.test
540
B
-rw-r--r--
skip_log_bin-master.opt
21
B
-rw-r--r--
skip_log_bin.test
646
B
-rw-r--r--
skip_name_resolve-master.opt
20
B
-rw-r--r--
skip_name_resolve.test
2.77
KB
-rw-r--r--
slow_log.test
2.27
KB
-rw-r--r--
sort_buffer_size_functionality...
21
B
-rw-r--r--
sort_buffer_size_functionality...
9.56
KB
-rw-r--r--
sp-big.test
2.15
KB
-rw-r--r--
sp-bugs.test
8.47
KB
-rw-r--r--
sp-code.test
21.61
KB
-rw-r--r--
sp-destruct.test
8.12
KB
-rw-r--r--
sp-dynamic.test
9.25
KB
-rw-r--r--
sp-error.test
87.47
KB
-rw-r--r--
sp-fib-master.opt
33
B
-rw-r--r--
sp-fib.test
1.33
KB
-rw-r--r--
sp-lock-master.opt
33
B
-rw-r--r--
sp-lock.test
31.39
KB
-rw-r--r--
sp-master.opt
54
B
-rw-r--r--
sp-no-code.test
216
B
-rw-r--r--
sp-prelocking-master.opt
33
B
-rw-r--r--
sp-prelocking.test
8.43
KB
-rw-r--r--
sp-security.test
25.43
KB
-rw-r--r--
sp-threads.test
4
KB
-rw-r--r--
sp-ucs2.test
3.38
KB
-rw-r--r--
sp-vars.test
28.72
KB
-rw-r--r--
sp.test
196.05
KB
-rw-r--r--
sp_debug.test
1.03
KB
-rw-r--r--
sp_gis.test
923
B
-rw-r--r--
sp_notembedded-master.opt
21
B
-rw-r--r--
sp_notembedded.test
17.08
KB
-rw-r--r--
sp_stress_case.test
2.07
KB
-rw-r--r--
sp_sync.test
4.88
KB
-rw-r--r--
sp_trans.test
17.11
KB
-rw-r--r--
sp_trans_log.test
1.35
KB
-rw-r--r--
sp_validation.test
40.19
KB
-rw-r--r--
sql_mode.test
16.94
KB
-rw-r--r--
sql_mode_default.test
3.14
KB
-rw-r--r--
ssl-big.test
1.68
KB
-rw-r--r--
ssl-sha512-master.opt
196
B
-rw-r--r--
ssl-sha512.test
432
B
-rw-r--r--
ssl.test
1.77
KB
-rw-r--r--
ssl_8k_key-master.opt
118
B
-rw-r--r--
ssl_8k_key.test
560
B
-rw-r--r--
ssl_and_innodb.test
261
B
-rw-r--r--
ssl_ca-master.opt
160
B
-rw-r--r--
ssl_ca.test
2.07
KB
-rw-r--r--
ssl_cipher-master.opt
32
B
-rw-r--r--
ssl_cipher.test
933
B
-rw-r--r--
ssl_compress.test
1.24
KB
-rw-r--r--
ssl_connect.test
368
B
-rw-r--r--
ssl_crl-master.opt
218
B
-rw-r--r--
ssl_crl.test
2.73
KB
-rw-r--r--
ssl_crl_clients-master.opt
234
B
-rw-r--r--
ssl_crl_clients.test
1.9
KB
-rw-r--r--
ssl_crl_clients_valid-master.o...
218
B
-rw-r--r--
ssl_crl_clients_valid.test
1.24
KB
-rw-r--r--
ssl_crl_crlpath-master.opt
206
B
-rw-r--r--
ssl_crl_crlpath.test
1.46
KB
-rw-r--r--
ssl_deprecated_tls_versions-ma...
28
B
-rw-r--r--
ssl_deprecated_tls_versions.te...
1.31
KB
-rw-r--r--
ssl_verify_identity-master.opt
181
B
-rw-r--r--
ssl_verify_identity.test
4.66
KB
-rw-r--r--
status-master.opt
76
B
-rw-r--r--
status.test
15
KB
-rw-r--r--
status2.test
1.54
KB
-rw-r--r--
status_bug17954.test
1.74
KB
-rw-r--r--
status_debug.test
3.7
KB
-rw-r--r--
strict-master.opt
32
B
-rw-r--r--
strict.test
49.24
KB
-rw-r--r--
strict_autoinc_1myisam.test
283
B
-rw-r--r--
strict_autoinc_2innodb.test
152
B
-rw-r--r--
strict_autoinc_3heap.test
227
B
-rw-r--r--
subquery_all.test
751
B
-rw-r--r--
subquery_all_bka.test
383
B
-rw-r--r--
subquery_all_bka_nixbnl.test
405
B
-rw-r--r--
subquery_bugs.test
1.7
KB
-rw-r--r--
subquery_mat.test
862
B
-rw-r--r--
subquery_mat_all.test
770
B
-rw-r--r--
subquery_mat_none.test
827
B
-rw-r--r--
subquery_nomat_nosj.test
774
B
-rw-r--r--
subquery_nomat_nosj_bka.test
397
B
-rw-r--r--
subquery_nomat_nosj_bka_nixbnl...
419
B
-rw-r--r--
subquery_none.test
819
B
-rw-r--r--
subquery_none_bka.test
385
B
-rw-r--r--
subquery_none_bka_nixbnl.test
407
B
-rw-r--r--
subquery_sj_all-master.opt
22
B
-rw-r--r--
subquery_sj_all.test
712
B
-rw-r--r--
subquery_sj_all_bka-master.opt
22
B
-rw-r--r--
subquery_sj_all_bka.test
389
B
-rw-r--r--
subquery_sj_all_bka_nixbnl-mas...
22
B
-rw-r--r--
subquery_sj_all_bka_nixbnl.tes...
411
B
-rw-r--r--
subquery_sj_all_bkaunique-mast...
22
B
-rw-r--r--
subquery_sj_all_bkaunique.test
530
B
-rw-r--r--
subquery_sj_dupsweed-master.op...
22
B
-rw-r--r--
subquery_sj_dupsweed.test
1019
B
-rw-r--r--
subquery_sj_dupsweed_bka-maste...
22
B
-rw-r--r--
subquery_sj_dupsweed_bka.test
399
B
-rw-r--r--
subquery_sj_dupsweed_bka_nixbn...
22
B
-rw-r--r--
subquery_sj_dupsweed_bka_nixbn...
421
B
-rw-r--r--
subquery_sj_dupsweed_bkaunique...
22
B
-rw-r--r--
subquery_sj_dupsweed_bkaunique...
517
B
-rw-r--r--
subquery_sj_firstmatch-master....
22
B
-rw-r--r--
subquery_sj_firstmatch.test
2.67
KB
-rw-r--r--
subquery_sj_firstmatch_bka-mas...
22
B
-rw-r--r--
subquery_sj_firstmatch_bka.tes...
403
B
-rw-r--r--
subquery_sj_firstmatch_bka_nix...
425
B
-rw-r--r--
subquery_sj_firstmatch_bkauniq...
476
B
-rw-r--r--
subquery_sj_innodb_all.test
550
B
-rw-r--r--
subquery_sj_innodb_all_bka.tes...
194
B
-rw-r--r--
subquery_sj_innodb_all_bka_nix...
216
B
-rw-r--r--
subquery_sj_innodb_all_bkauniq...
476
B
-rw-r--r--
subquery_sj_innodb_none.test
663
B
-rw-r--r--
subquery_sj_innodb_none_bka.te...
196
B
-rw-r--r--
subquery_sj_innodb_none_bka_ni...
218
B
-rw-r--r--
subquery_sj_innodb_none_bkauni...
478
B
-rw-r--r--
subquery_sj_loosescan.test
1.05
KB
-rw-r--r--
subquery_sj_loosescan_bka.test
401
B
-rw-r--r--
subquery_sj_loosescan_bka_nixb...
423
B
-rw-r--r--
subquery_sj_loosescan_bkauniqu...
519
B
-rw-r--r--
subquery_sj_mat.test
1.06
KB
-rw-r--r--
subquery_sj_mat_bka.test
389
B
-rw-r--r--
subquery_sj_mat_bka_nixbnl.tes...
411
B
-rw-r--r--
subquery_sj_mat_bkaunique.test
507
B
-rw-r--r--
subquery_sj_mat_nosj.test
805
B
-rw-r--r--
subquery_sj_none.test
825
B
-rw-r--r--
subquery_sj_none_bka.test
391
B
-rw-r--r--
subquery_sj_none_bka_nixbnl.te...
413
B
-rw-r--r--
subquery_sj_none_bkaunique.tes...
509
B
-rw-r--r--
subselect_debug.test
977
B
-rw-r--r--
subselect_gis.test
589
B
-rw-r--r--
subselect_innodb.test
24.42
KB
-rw-r--r--
subselect_notembedded-master.o...
33
B
-rw-r--r--
subselect_notembedded.test
1.73
KB
-rw-r--r--
sum_distinct-big.test
2.21
KB
-rw-r--r--
sum_distinct.test
3.43
KB
-rw-r--r--
symlink.test
9.82
KB
-rw-r--r--
synchronization.test
1.14
KB
-rw-r--r--
sysdate_is_now-master.opt
17
B
-rw-r--r--
sysdate_is_now.test
298
B
-rw-r--r--
system_mysql_db.test
311
B
-rw-r--r--
system_mysql_db_fix30020-maste...
30
B
-rw-r--r--
system_mysql_db_fix40123-maste...
30
B
-rw-r--r--
system_mysql_db_fix40123.test
9.84
KB
-rw-r--r--
system_mysql_db_fix50030-maste...
30
B
-rw-r--r--
system_mysql_db_fix50030.test
14.34
KB
-rw-r--r--
system_mysql_db_fix50117-maste...
30
B
-rw-r--r--
system_mysql_db_fix50117.test
15.1
KB
-rw-r--r--
system_mysql_db_refs.test
3.35
KB
-rw-r--r--
table_definition_cache_functio...
8.84
KB
-rw-r--r--
table_open_cache_functionality...
52
B
-rw-r--r--
table_open_cache_functionality...
13.44
KB
-rw-r--r--
tablelock.test
1.37
KB
-rw-r--r--
tablespace.test
5.76
KB
-rw-r--r--
temp_pool-master.opt
31
B
-rw-r--r--
temp_pool.test
1.44
KB
-rw-r--r--
temp_table-master.opt
32
B
-rw-r--r--
temp_table.test
8.48
KB
-rw-r--r--
temporal_literal.test
6.77
KB
-rw-r--r--
test_security_context-master.o...
27
B
-rw-r--r--
test_security_context.test
1.11
KB
-rw-r--r--
timezone-master.opt
15
B
-rw-r--r--
timezone.test
2.37
KB
-rw-r--r--
timezone2.test
11.04
KB
-rw-r--r--
timezone3-master.opt
49
B
-rw-r--r--
timezone3.test
2.74
KB
-rw-r--r--
timezone4-master.opt
18
B
-rw-r--r--
timezone4.test
311
B
-rw-r--r--
timezone_debug.test
1.13
KB
-rw-r--r--
timezone_grant.test
4.64
KB
-rw-r--r--
trans_read_only-master.opt
29
B
-rw-r--r--
trans_read_only.test
1.05
KB
-rw-r--r--
transaction_isolation-master.o...
37
B
-rw-r--r--
transaction_isolation.test
1.57
KB
-rw-r--r--
transaction_read_only-master.o...
24
B
-rw-r--r--
transaction_read_only.test
1.88
KB
-rw-r--r--
trigger-compat.test
8.46
KB
-rw-r--r--
trigger-trans.test
6.78
KB
-rw-r--r--
trigger.test
85.5
KB
-rw-r--r--
trigger_debug.test
538
B
-rw-r--r--
trigger_notembedded.test
26.82
KB
-rw-r--r--
trigger_wl3253.test
12.35
KB
-rw-r--r--
trigger_wl6030.test
42.25
KB
-rw-r--r--
truncate.test
3.36
KB
-rw-r--r--
truncate_coverage.test
5.79
KB
-rw-r--r--
type_binary.test
6.09
KB
-rw-r--r--
type_bit.test
13.4
KB
-rw-r--r--
type_bit_innodb.test
4.54
KB
-rw-r--r--
type_blob.test
31.16
KB
-rw-r--r--
type_date.test
14.53
KB
-rw-r--r--
type_datetime.test
21.85
KB
-rw-r--r--
type_decimal.test
29.97
KB
-rw-r--r--
type_enum.test
90.04
KB
-rw-r--r--
type_float.test
9.8
KB
-rw-r--r--
type_nchar.test
1.4
KB
-rw-r--r--
type_newdecimal-big.test
1.16
KB
-rw-r--r--
type_newdecimal.test
45.73
KB
-rw-r--r--
type_ranges.test
9.2
KB
-rw-r--r--
type_set.test
4.29
KB
-rw-r--r--
type_string-master.opt
10
B
-rw-r--r--
type_string.test
531
B
-rw-r--r--
type_temporal_fractional.test
289.34
KB
-rw-r--r--
type_temporal_upgrade.test
5.25
KB
-rw-r--r--
type_time.test
11.67
KB
-rw-r--r--
type_timestamp-master.opt
36
B
-rw-r--r--
type_timestamp.test
19.19
KB
-rw-r--r--
type_timestamp_explicit-master...
34
B
-rw-r--r--
type_timestamp_explicit.test
4.21
KB
-rw-r--r--
type_uint.test
309
B
-rw-r--r--
type_varchar.test
6.83
KB
-rw-r--r--
type_year.test
5.18
KB
-rw-r--r--
udf-master.opt
42
B
-rw-r--r--
udf.test
16.26
KB
-rw-r--r--
udf_services-master.opt
21
B
-rw-r--r--
udf_services.test
765
B
-rw-r--r--
udf_skip_grants-master.opt
41
B
-rw-r--r--
udf_skip_grants.test
1.45
KB
-rw-r--r--
union-master.opt
49
B
-rw-r--r--
union.test
62.39
KB
-rw-r--r--
unsafe_binlog_innodb-master.op...
67
B
-rw-r--r--
unsafe_binlog_innodb.test
432
B
-rw-r--r--
update.test
20.23
KB
-rw-r--r--
upgrade.test
5.3
KB
-rw-r--r--
user_if_exists.test
8.02
KB
-rw-r--r--
user_limits-master.opt
21
B
-rw-r--r--
user_limits.test
6.97
KB
-rw-r--r--
user_lock.test
22.39
KB
-rw-r--r--
user_var-binlog.test
1.04
KB
-rw-r--r--
user_var.test
14.42
KB
-rw-r--r--
utility_warnings-master.opt
147
B
-rw-r--r--
utility_warnings.test
17.92
KB
-rw-r--r--
validate_password_plugin-maste...
23
B
-rw-r--r--
validate_password_plugin.test
10.41
KB
-rw-r--r--
validate_password_plugin_check...
47
B
-rw-r--r--
validate_password_plugin_check...
3.75
KB
-rw-r--r--
varbinary.test
7.71
KB
-rw-r--r--
variables-big.test
2.13
KB
-rw-r--r--
variables-master.opt
21
B
-rw-r--r--
variables-notembedded-master.o...
47
B
-rw-r--r--
variables-notembedded.test
11.21
KB
-rw-r--r--
variables-win.test
393
B
-rw-r--r--
variables.test
50.07
KB
-rw-r--r--
variables_community.test
242
B
-rw-r--r--
variables_debug.test
2.96
KB
-rw-r--r--
version_token-master.opt
19
B
-rw-r--r--
version_token.test
10.36
KB
-rw-r--r--
version_token_bug21280801-mast...
19
B
-rw-r--r--
version_token_bug21280801.test
3.23
KB
-rw-r--r--
version_token_errors-master.op...
19
B
-rw-r--r--
version_token_errors.test
2.3
KB
-rw-r--r--
view.test
137.35
KB
-rw-r--r--
view_alias.test
4.03
KB
-rw-r--r--
view_grant.test
93.83
KB
-rw-r--r--
view_gtid_mode_on_debug-master...
66
B
-rw-r--r--
view_gtid_mode_on_debug.test
3.48
KB
-rw-r--r--
wait_timeout.test
5.31
KB
-rw-r--r--
warnings-master.opt
14
B
-rw-r--r--
warnings.test
5.95
KB
-rw-r--r--
warnings_engine_disabled.test
763
B
-rw-r--r--
windows.test
2.45
KB
-rw-r--r--
wl3836.test
3.92
KB
-rw-r--r--
wl4435_generated.inc
10.43
KB
-rw-r--r--
wl5928.test
15.04
KB
-rw-r--r--
wl6219-csv.test
109
B
-rw-r--r--
wl6219-innodb.test
322
B
-rw-r--r--
wl6219-memory.test
112
B
-rw-r--r--
wl6219-merge.test
111
B
-rw-r--r--
wl6219-myisam.test
424
B
-rw-r--r--
wl6219-upgrade.test
5.39
KB
-rw-r--r--
wl6301_1_not_windows-master.op...
20
B
-rw-r--r--
wl6301_1_not_windows.test
456
B
-rw-r--r--
wl6301_2_not_windows-master.op...
43
B
-rw-r--r--
wl6301_2_not_windows.test
494
B
-rw-r--r--
wl6301_3-master.opt
52
B
-rw-r--r--
wl6301_3.test
904
B
-rw-r--r--
wl6443_deprecation-master.opt
23
B
-rw-r--r--
wl6443_deprecation.test
4.18
KB
-rw-r--r--
wl6661-master.opt
209
B
-rw-r--r--
wl6661.test
6.92
KB
-rw-r--r--
wl6711_heap_to_disk.test
4.21
KB
-rw-r--r--
wl6978.test
478
B
-rw-r--r--
xa.test
14.62
KB
-rw-r--r--
xa_deadlock_binlog.test
2.26
KB
-rw-r--r--
xa_debug.test
5.47
KB
-rw-r--r--
xa_gtid-master.opt
55
B
-rw-r--r--
xa_gtid.test
917
B
-rw-r--r--
xa_prepared_binlog_off-master....
15
B
-rw-r--r--
xa_prepared_binlog_off.test
527
B
-rw-r--r--
xml.test
24.95
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : mysqltest.test
# ---------------------------------------------------------------------------- # $mysql_errno contains the return code of the last command # sent to the server. # ---------------------------------------------------------------------------- # get $mysql_errno before the first statement # $mysql_errno should be -1 # get $mysql_errname as well echo $mysql_errno before test; echo $mysql_errname before test; -- source include/have_log_bin.inc # This test should work in embedded server after mysqltest is fixed -- source include/not_embedded.inc # This test uses chmod, can't be run with root permissions -- source include/not_as_root.inc # Save the initial number of concurrent sessions --source include/count_sessions.inc # ============================================================================ # # Test of mysqltest itself # # There are three rules that determines what belong to each command # 1. A normal command is delimited by the <delimiter> which by default is # set to ';' # # ex: | select * # | from t1; # | # Command: "select * from t1" # # 2. Special case is a line that starts with "--", this is a comment # ended when the new line character is reached. But the first word # in the comment may contain a valid command, which then will be # executed. This can be useful when sending commands that # contains <delimiter> # # 3. Special case is also a line that starts with '#' which is treated # as a comment and will be ended by new line character # # ============================================================================ # ---------------------------------------------------------------------------- # Positive case(statement) # ---------------------------------------------------------------------------- select otto from (select 1 as otto) as t1; # expectation = response --error 0 select otto from (select 1 as otto) as t1; # ---------------------------------------------------------------------------- # Negative case(statement): # The derived table t1 does not contain a column named 'friedrich' . # --> ERROR 42S22: Unknown column 'friedrich' in 'field list and # --> 1054: Unknown column 'friedrich' in 'field list' # ---------------------------------------------------------------------------- # expectation <> response #--error 0 #select friedrich from (select 1 as otto) as t1 --error 1 --exec echo "select friedrich from (select 1 as otto) as t1;" | $MYSQL_TEST 2>&1 # expectation = response --error ER_BAD_FIELD_ERROR select friedrich from (select 1 as otto) as t1; # The following unmasked unsuccessful statement must give # 1. mysqltest gives a 'failed' # 2. does not produce a r/<test case>.reject file !!! # PLEASE uncomment it and check its effect #select friedrich from (select 1 as otto) as t1; # ---------------------------------------------------------------------------- # Tests for the new feature - SQLSTATE error code matching # Positive case(statement) # ---------------------------------------------------------------------------- # This syntax not allowed anymore, use --error S00000, see below # expectation = response #!S00000 select otto from (select 1 as otto) as t1; --error S00000 select otto from (select 1 as otto) as t1; # expectation <> response #!S42S22 select otto from (select 1 as otto) as t1; #--error S42S22 #select otto from (select 1 as otto) as t1; --error 1 --exec echo "error S42S22; select otto from (select 1 as otto) as t1;" | $MYSQL_TEST 2>&1 # expecting a SQL-state for a command that can't give one should fail --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec echo "error S00000; remove_file $MYSQLTEST_VARDIR/tmp/test_nonexistent.tmp;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Negative case(statement) # ---------------------------------------------------------------------------- # This syntax not allowed anymore, use --error S42S22, see below # expectation = response #!S42S22 select friedrich from (select 1 as otto) as t1; --error S42S22 select friedrich from (select 1 as otto) as t1; # expectation !=response #!S00000 select friedrich from (select 1 as otto) as t1; #--error S00000 #select friedrich from (select 1 as otto) as t1; --error 1 --exec echo "error S00000; select friedrich from (select 1 as otto) as t1;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # test cases for $mysql_errno # # $mysql_errno is a builtin variable of mysqltest and contains the return code # of the last command sent to the server. # # The following test cases often initialize $mysql_errno to 1064 by # a command with wrong syntax. # Example: --error 1064 To prevent the abort after the error. # garbage ; # ---------------------------------------------------------------------------- # ---------------------------------------------------------------------------- # check mysql_errno = 0 after successful statement # ---------------------------------------------------------------------------- select otto from (select 1 as otto) as t1; echo $mysql_errname; eval select $mysql_errno as "after_successful_stmt_errno" ; #---------------------------------------------------------------------------- # check mysql_errno = 1064 after statement with wrong syntax # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; echo $mysql_errname; eval select $mysql_errno as "after_wrong_syntax_errno" ; # ---------------------------------------------------------------------------- # check if let $my_var= 'abc' ; affects $mysql_errno # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; let $my_var= 'abc' ; echo $mysql_errname; eval select $mysql_errno as "after_let_var_equal_value" ; # ---------------------------------------------------------------------------- # check if set @my_var= 'abc' ; affects $mysql_errno # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; set @my_var= 'abc' ; echo $mysql_errname; eval select $mysql_errno as "after_set_var_equal_value" ; # ---------------------------------------------------------------------------- # check if the setting of --disable-warnings itself affects $mysql_errno # (May be --<whatever> modifies $mysql_errno.) # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; --disable_warnings echo $mysql_errname; eval select $mysql_errno as "after_disable_warnings_command" ; # ---------------------------------------------------------------------------- # check if --disable-warnings + command with warning affects the errno # stored within $mysql_errno # (May be disabled warnings affect $mysql_errno.) # ---------------------------------------------------------------------------- drop table if exists t1 ; --error ER_PARSE_ERROR garbage ; drop table if exists t1 ; echo $mysql_errname; eval select $mysql_errno as "after_disable_warnings" ; --enable_warnings # ---------------------------------------------------------------------------- # check if masked errors affect $mysql_errno # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; --error ER_NO_SUCH_TABLE select 3 from t1 ; echo $mysql_errname; eval select $mysql_errno as "after_minus_masked" ; --error ER_PARSE_ERROR garbage ; --error ER_NO_SUCH_TABLE select 3 from t1 ; echo $mysql_errname; eval select $mysql_errno as "after_!_masked" ; # ---------------------------------------------------------------------------- # Will manipulations of $mysql_errno be possible and visible ? # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; let $mysql_errno= -1; eval select $mysql_errno as "after_let_errno_equal_value" ; # ---------------------------------------------------------------------------- # How affect actions on prepared statements $mysql_errno ? # ---------------------------------------------------------------------------- # failing prepare --error ER_PARSE_ERROR garbage ; --error ER_NO_SUCH_TABLE prepare stmt from "select 3 from t1" ; echo $mysql_errname; eval select $mysql_errno as "after_failing_prepare" ; create table t1 ( f1 char(10)); # successful prepare --error ER_PARSE_ERROR garbage ; prepare stmt from "select 3 from t1" ; echo $mysql_errname; eval select $mysql_errno as "after_successful_prepare" ; # successful execute --error ER_PARSE_ERROR garbage ; execute stmt; echo $mysql_errname; eval select $mysql_errno as "after_successful_execute" ; # failing execute (table has been dropped) drop table t1; --error ER_PARSE_ERROR garbage ; --error ER_NO_SUCH_TABLE execute stmt; echo $mysql_errname; eval select $mysql_errno as "after_failing_execute" ; # failing execute (unknown statement) --error ER_PARSE_ERROR garbage ; --error ER_UNKNOWN_STMT_HANDLER execute __stmt_; echo $mysql_errname; eval select $mysql_errno as "after_failing_execute" ; # successful deallocate --error ER_PARSE_ERROR garbage ; deallocate prepare stmt; echo $mysql_errname; eval select $mysql_errno as "after_successful_deallocate" ; # failing deallocate ( statement handle does not exist ) --error ER_PARSE_ERROR garbage ; --error ER_UNKNOWN_STMT_HANDLER deallocate prepare __stmt_; echo $mysql_errname; eval select $mysql_errno as "after_failing_deallocate" ; # ---------------------------------------------------------------------------- # test cases for "--disable_abort_on_error" # # "--disable_abort_on_error" switches off the abort of mysqltest # after "unmasked" failing statements. # # The default is "--enable_abort_on_error". # # "Maskings" are # --error <error number> and --error <error number> # in the line before the failing statement. # # There are some additional test cases for $mysql_errno # because "--disable_abort_on_error" enables a new situation. # Example: "unmasked" statement fails + analysis of $mysql_errno # ---------------------------------------------------------------------------- # ---------------------------------------------------------------------------- # Switch off the abort on error and check the effect on $mysql_errno # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; --disable_abort_on_error echo $mysql_errname; eval select $mysql_errno as "after_--disable_abort_on_error" ; # ---------------------------------------------------------------------------- # "unmasked" failing statement should not cause an abort # ---------------------------------------------------------------------------- select 3 from t1 ; # ---------------------------------------------------------------------------- # masked failing statements # ---------------------------------------------------------------------------- # expected error = response --error ER_NO_SUCH_TABLE select 3 from t1 ; --error ER_NO_SUCH_TABLE select 3 from t1 ; echo $mysql_errname; eval select $mysql_errno as "after_!errno_masked_error" ; # expected error <> response # --error 1000 # select 3 from t1 ; # --error 1000 # select 3 from t1 ; --error 1 --exec echo "disable_abort_on_error; error 1000; select 3 from t1; error 1000; select 3 from t1;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Check some non-query statements that would fail # ---------------------------------------------------------------------------- --exec illegal_command --cat_file does_not_exist --perl exit(2); EOF # ---------------------------------------------------------------------------- # Check backtick and query_get_value, result should be empty # ---------------------------------------------------------------------------- let $empty= `garbage`; echo $empty is empty; let $empty= query_get_value(nonsense, blabla, 1); echo $empty is empty; # ---------------------------------------------------------------------------- # Switch the abort on error on and check the effect on $mysql_errno # ---------------------------------------------------------------------------- --error ER_PARSE_ERROR garbage ; --enable_abort_on_error echo $mysql_errname; eval select $mysql_errno as "after_--enable_abort_on_error" ; # ---------------------------------------------------------------------------- # masked failing statements # ---------------------------------------------------------------------------- # expected error = response --error ER_NO_SUCH_TABLE select 3 from t1 ; # ---------------------------------------------------------------------------- # check that the old default behaviour is not changed # Please remove the '#' to get the abort on error # ---------------------------------------------------------------------------- #--error 1064 #select 3 from t1 ; # #select 3 from t1 ; --error 1 --exec echo "disable_abort_on_error; enable_abort_on_error; error 1064; select 3 from t1; select 3 from t1;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test --enable and --disable with ONCE # ---------------------------------------------------------------------------- --disable_abort_on_error ONCE garbage; --disable_abort_on_error ONCE --remove_file DoesNotExist --disable_result_log select 2; --enable_result_log ONCE select 3; select 5; --enable_result_log # ---------------------------------------------------------------------------- # Test cumulative ONCE # ---------------------------------------------------------------------------- --disable_abort_on_error ONCE --disable_query_log ONCE select 3 from t1; select 7; --error 1 --exec echo "--disable_info OCNE" | $MYSQL_TEST 2>&1 --enable_connect_log ONCE connect (con1,localhost,root,,); connection default; disconnect con1; # ---------------------------------------------------------------------------- # Test ONCE can be combined with --error or modifiers like lowercase # ---------------------------------------------------------------------------- --disable_result_log ONCE --error ER_NO_SUCH_TABLE select 5 from t1; --disable_query_log ONCE --lowercase_result select "CASE" as "LOWER"; --sorted_result --disable_query_log ONCE select "xyz" as name union select "abc" as name order by name desc; # ---------------------------------------------------------------------------- # Test --error with backtick operator or query_get_value # ---------------------------------------------------------------------------- --error 0,ER_NO_SUCH_TABLE let $empty= `SELECT foo from bar`; echo $empty is empty; --error 0,ER_BAD_FIELD_ERROR let $empty= query_get_value(SELECT bar as foo, baz, 1); echo $empty is empty; --error 0,ER_NO_SUCH_TABLE if (!`SELECT foo from bar`) { echo "Yes it's empty"; } # ---------------------------------------------------------------------------- #test to check conversion between error numbers and error strings # ---------------------------------------------------------------------------- let $var=convert_error(1450); let $var1=convert_error($var); let $var2=convert_error($var1); echo $var2; let $var=convert_error(ER_UNKNOWN_ERROR); let $var1=convert_error($var); let $var2=convert_error($var1); echo $var2; --error 1 --exec echo "let \$var= convert_error(NOT_A_VALID_ERROR);" | $MYSQL_TEST 2>&1 let $var=convert_error(9999999); echo $var; let $var=convert_error(9ABC9); echo $var; let $var=convert_error(0); echo $var; let $var=convert_error(); echo $var; let $var=; let $var1=convert_error($var); echo $var1; # ---------------------------------------------------------------------------- # Test comments # ---------------------------------------------------------------------------- # This is a comment # This is a ; comment # This is a -- comment # -- This is also a comment # -- # This is also a comment # -- This is also a ; comment # ---------------------------------------------------------------------------- # Test comments with embedded command # ---------------------------------------------------------------------------- --echo hello -- echo hello -- echo ;;;;;;;; --echo # MySQL: -- The # ---------------------------------------------------------------------------- # Test detect end of line "junk" # Most likely caused by a missing delimiter # ---------------------------------------------------------------------------- # Too many parameters to function --error 1 --exec echo "sleep 5 6;" | $MYSQL_TEST 2>&1 # Too many parameters to function --error 1 --exec echo "--sleep 5 6" | $MYSQL_TEST 2>&1 # # Missing delimiter # The comment will be "sucked into" the sleep command since # delimiter is missing until after "show status" --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql sleep 4 # A comment show status; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # # Missing delimiter until eof # The comment will be "sucked into" the sleep command since # delimiter is missing --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql sleep 7 # Another comment EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # # Missing delimiter until "disable_query_log" # --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql disconnect default # # comment # comment 3 disable_query_log; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # # Missing delimiter until "disable_query_log" # --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql disconnect default # # comment # comment 3 disable_query_log; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # # Missing delimiter until eof # --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql disconnect default # # comment # comment2 # comment 3 --disable_query_log EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # # Missing delimiter until eof # --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql disconnect default # comment # comment part2 # comment 3 --disable_query_log EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # # Extra delimiter # --error 1 --exec echo "--sleep 4;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--disable_query_log;" | $MYSQL_TEST 2>&1 # # Extra text after `` # # Cannot use exec echo here as ` may or may not need to be escaped --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql let $x= `select 1` BOO ; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql --let $x= `select 1`; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql # Missing ; in next line should be detected and cause failure let $x= `select 1` let $x= 2; echo $x; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # Allow trailing # comment --sleep 1 # Here is a trailing comment. --sleep 1 # Here is a trailing comment. # ---------------------------------------------------------------------------- # Test error # ---------------------------------------------------------------------------- # Missing argument --error 1 --exec echo "error;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--error" | $MYSQL_TEST 2>&1 # First char must be uppercase 'S' or 'E' or [0-9] --error 1 --exec echo "--error s99999" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--error e99999" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--error 9eeeee" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--error 1sssss" | $MYSQL_TEST 2>&1 # First char 'S' but too long --error 1 --exec echo "--error S999999" | $MYSQL_TEST 2>&1 # First char 'S' but lowercase char found --error 1 --exec echo "--error S99a99" | $MYSQL_TEST 2>&1 # First char 'S' but too short --error 1 --exec echo "--error S9999" | $MYSQL_TEST 2>&1 # First char 'E' but not found in error array --error 1 --exec echo "--error E9999" | $MYSQL_TEST 2>&1 # First char [0-9] but contains chars --error 1 --exec echo "--error 999e9" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--error 9b" | $MYSQL_TEST 2>&1 # Multiple errorcodes separated by ',' --error 1,1,1,1 #--error 9,ER_PARSE_ERROR #--error ER_PARSE_ERROR #--error 9,ER_PARSE_ERROR,9,ER_PARSE_ERROR #--error 9, ER_PARSE_ERROR, 9, ER_PARSE_ERROR #--error 9,S00000,9,ER_PARSE_ERROR #--error 9,S00000,9,ER_PARSE_ERROR,ER_PARSE_ERROR,ER_PARSE_ERROR,9,10,11,12 --error 9,S00000,9 --error 9,S00000,9,9,10,11,12 --error 9 ,10 --error 9 , 10 --error 9 , 10 --error 9 , 10 # Too many errorcodes specified --error 1 --exec echo "--error 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21" | $MYSQL_TEST 2>&1 # Bug#22135383 MYSQLTEST FAILS TO PROPERLY GROUP AN EXPECTED ERROR # CLAUSE AND ITS QUERY if (1) { --error ER_BAD_TABLE_ERROR } DROP TABLE table_does_not_exist; --error ER_BAD_TABLE_ERROR if (1) { DROP TABLE table_does_not_exist; } if (1) { if(1) { --error ER_BAD_TABLE_ERROR } } DROP TABLE table_does_not_exist; --error ER_BAD_TABLE_ERROR if (1) { if(1) { DROP TABLE table_does_not_exist; } } # BUG#13687542 MTR BEHAVES WRONG WHEN EXECUTING 'ERROR $VAR' IN A LOOP --let $i= 0 --let $error= 0 while ($i < 3) { --error $error CREATE TABLE t1 (a INT); --let $error= 1050 --inc $i } DROP TABLE t1; # ---------------------------------------------------------------------------- # Test echo command # ---------------------------------------------------------------------------- echo MySQL; echo "MySQL"; echo MySQL: The world''s most popular open source database; echo "MySQL: The world's most popular open source database"; echo MySQL: The world''s most popular open source database; echo # MySQL: The world''s # most popular open # source database; echo - MySQL: The world''s - most popular open - source database; echo - MySQL: The world''s -- most popular -- open source database; echo # MySQL: The --world''s # most popular -- open - source database; echo "MySQL: The world's most popular; open source database"; echo "MySQL: The world's most popular ; open source database"; echo "MySQL: The world's most popular ;open source database"; echo echo message echo message; echo ; # Illegal use of echo #--error 1 #--exec echo "echo \$;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test exec command # ---------------------------------------------------------------------------- # Illegal use of exec --error 1 --exec echo "--exec " | $MYSQL_TEST 2>&1 # Multi-line exec exec $MYSQL test -e "select 1"; exec $MYSQL test -e "select 2"; let $query = select 3 as X; exec $MYSQL test -e "$query"; # ---------------------------------------------------------------------------- # Test let command # ---------------------------------------------------------------------------- let $message=MySQL; echo $message; let $message="MySQL"; echo $message; let $message= MySQL: The world''s most popular open source database; echo $message; let $message= # MySQL: The # world''s most # popular open # source database; echo $message; let $message= -- MySQL: The -- world''s most -- popular -- open source database; echo $message; let $message= # MySQL: The - world''s most -- popular open # source database; echo $message; echo '$message'; echo "$message"; let $1=hej; echo $1; let $1 =hej ; echo $1; let $1 = hej; echo $1; let $1=1; let $2=$1; echo $2; let $5=$6; echo $5; echo $6; let $where=a long variable content; echo $where; let $where2= $where; echo $where2; let $where3=a long $where variable content; echo $where3; let $where3=a long \\\$where variable content; echo $where3; let $novar1= $novar2; echo $novar1; let $cat=na; let $cat=ba$cat$cat; echo banana = $cat; # ba\$cat\$cat should have been sufficient. # ba\\\$cat\\\$cat -> ba\$cat\$cat -> ba$cat$cat -> banana # Magnus' upcoming patch will fix the missing second interpretation. let $cat=ba\\\$cat\\\$cat; echo Not a banana: $cat; # Bug #55413 would cause this to fail let $escape= with\`some\"escaped\'quotes; echo $escape; --let $escape= with\`some\"escaped\'quotes echo $escape; # This only works with "--let" syntax --let $tick= single'tick`backtick echo $tick; # Test illegal uses of let --error 1 --exec echo "let ;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$=hi;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$1 hi;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$m hi;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$hi;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$ hi;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let =hi;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let hi;" | $MYSQL_TEST 2>&1 # More advanced test for Bug#17280 let $success= 1; --echo # Execute: --echo # <whatever> success: \$success --echo # <whatever> success: $success --echo # Execute: echo # <whatever> success: \$success ; echo # <whatever> success: $success ; --echo # The next two variants work fine and expand the content of \$success --echo # Execute: --echo \$success --echo $success --echo # Execute: echo \$success ; echo $success ; # ---------------------------------------------------------------------------- # Test to assign let from variable # let $<var_name>=$<var_name>; # ---------------------------------------------------------------------------- --echo # Check if let \$B = \$A is an assignment per value. # Basic preparations: --echo let \$A = initial value of A; let $A = initial value of A; # --echo # Content of \$A is: $A --echo let \$B = initial value of B; let $B = initial value of B; # --echo # Content of \$B is: $B # Assign $B to $A: --echo let \$B = \$A let $A = $B; --echo # Content of \$A is: $A # Changes of $B must NOT affect $A and Changes of $A must NOT affect $B ! --echo let \$A = changed value of A; let $A = changed value of A; --echo # Content of \$B is: $B --echo let \$B = changed value of B; let $B = changed value of B; --echo # Content of \$A is: $A # ---------------------------------------------------------------------------- # Test let from query with $variable # let $<var_name>=`<query with $variable>`; # ---------------------------------------------------------------------------- let $var1=content of variable 1; let $var2= `select "$var1"`; let $var3= `select concat("$var1", " ", "$var2")`; echo var2: $var2; echo var3: $var3; if (`select length("$var3") > 0`) { echo length of var3 is longer than 0; } # ---------------------------------------------------------------------------- # Test to assign let from query # let $<var_name>=`<query>`; # ---------------------------------------------------------------------------- echo var1; let $var1= `select "hi" as "Col", 1 as "Column1", "hi there" as Col3`; echo $var1; echo var2; let $var2= `select 2 as "Column num 2"`; echo $var2; echo var2 again; let $var2= `select 2 as "Column num 2"`; echo $var2; echo var3 two columns with same name; let $var3= `select 1 as "Col", 2 as "Col", 3 as "var3"`; echo $var3; echo var4 from query that returns NULL; let $var4= `select NULL`; echo var5 from query that returns no row; let $var5= `SHOW VARIABLES LIKE "nonexisting_variable"`; echo failing query in let; --write_file $MYSQLTEST_VARDIR/tmp/let.sql let $var2= `failing query`; echo $var2; EOF create table t1 (a varchar(100)); insert into t1 values ('`select 42`'); let $a= `select * from t1`; # This should output `select 42`, not evaluate it again to 42 echo $a; insert into t1 values ('$dollar'); # These should also output the string without evaluating it. let $a= query_get_value(select * from t1 order by a, a, 1); echo $a; let $a= query_get_value(select * from t1 order by a, a, 2); echo $a; drop table t1; --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/let.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/let.sql; # ---------------------------------------------------------------------------- # Test source command # ---------------------------------------------------------------------------- # Test illegal uses of source --error 1 --exec echo "source ;" | $MYSQL_TEST 2>&1 # Fix win paths --replace_result \\ / # Source a nonexisting file --error 1 --exec echo "source non_existingFile;" | $MYSQL_TEST 2>&1 # Too many source --exec echo "source $MYSQLTEST_VARDIR/tmp/recursive.sql;" > $MYSQLTEST_VARDIR/tmp/recursive.sql --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec echo "source $MYSQLTEST_VARDIR/tmp/recursive.sql;" | $MYSQL_TEST 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/recursive.sql; # Source a file with error --exec echo "garbage ;" > $MYSQLTEST_VARDIR/tmp/error.sql --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec echo "source $MYSQLTEST_VARDIR/tmp/error.sql;" | $MYSQL_TEST 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/error.sql; # Test execution of source in a while loop --write_file $MYSQLTEST_VARDIR/tmp/sourced.inc echo here is the sourced script; EOF --disable_query_log let $outer= 2; # Number of outer loops while ($outer) { eval SELECT '$outer = outer loop variable after while' AS ""; --source $MYSQLTEST_VARDIR/tmp/sourced.inc eval SELECT '$outer = outer loop variable before dec' AS ""; dec $outer; eval SELECT '$outer = outer loop variable after dec' AS ""; } # Test source in an if in a while which is false on 1st iteration # Also test --error and --disable_abort_on_error in same context let $outer= 2; # Number of outer loops let $ifval= 0; # false 1st time while ($outer) { echo outer=$outer ifval=$ifval; if ($ifval) { --source $MYSQLTEST_VARDIR/tmp/sourced.inc --error ER_NO_SUCH_TABLE SELECT * from nowhere; --disable_abort_on_error ONCE # Statement giving a different error, to make sure we don't mask it SELECT * FROM nowhere else; } dec $outer; inc $ifval; } # Test execution of source in a while loop --disable_abort_on_error # Sourcing of a file within while loop, sourced file will # source other file let $num= 9; while ($num) { SELECT 'In loop' AS ""; --source $MYSQLTEST_VARDIR/tmp/sourced.inc dec $num; } --enable_abort_on_error --enable_query_log # Test source $variable/<filename> --source $MYSQLTEST_VARDIR/tmp/sourced.inc --remove_file $MYSQLTEST_VARDIR/tmp/sourced.inc --write_file $MYSQLTEST_VARDIR/tmp/sourced.inc echo "hello"; EOF let $x= sourced; source $MYSQLTEST_VARDIR/tmp/$x.inc; let $x= $MYSQLTEST_VARDIR; source $x/tmp/sourced.inc; --remove_file $MYSQLTEST_VARDIR/tmp/sourced.inc # ---------------------------------------------------------------------------- # Test sleep command # ---------------------------------------------------------------------------- sleep 0.5; sleep 1; real_sleep 1; # Parameter from variable, legal and illegal let $sleep_var= 0.1; sleep $sleep_var; let $sleep_var= 1; --real_sleep $sleep_var --write_file $MYSQL_TMP_DIR/sleep.inc let $sleep_var= xyz; --sleep $sleep_var EOF --error 1 --exec $MYSQL_TEST < $MYSQL_TMP_DIR/sleep.inc 2>&1 --remove_file $MYSQL_TMP_DIR/sleep.inc --write_file $MYSQL_TMP_DIR/sleep.inc let $sleep_var= xyz; real_sleep $sleep_var; EOF --error 1 --exec $MYSQL_TEST < $MYSQL_TMP_DIR/sleep.inc 2>&1 --remove_file $MYSQL_TMP_DIR/sleep.inc # Missing parameter --error 1 --exec echo "sleep ;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "real_sleep ;" | $MYSQL_TEST 2>&1 # Illegal parameter --error 1 --exec echo "sleep abc;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "real_sleep abc;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test inc # ---------------------------------------------------------------------------- let $i= 0; inc $i; echo $i; let $i=100; inc $i; echo $i; let $i= -100; inc $i; echo $i; --error 1 --exec echo "inc;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "inc i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "inc \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$i=100; inc \$i 1000; echo \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$i=text; inc \$i; echo \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$i=10cc; inc \$i; echo \$i;" | $MYSQL_TEST 2>&1 inc $i; inc $i; inc $i; --echo $i echo $i; # ---------------------------------------------------------------------------- # Test dec # ---------------------------------------------------------------------------- let $d= 0; dec $d; echo $d; let $d=100; dec $d; echo $d; --error 1 --exec echo "dec;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "dec i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "dec \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$i=100; dec \$i 1000; echo \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$i=text; dec \$i; echo \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$i=10cc; dec \$i; echo \$i;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test system (which is now deprecated) # ---------------------------------------------------------------------------- --error 1 --exec echo "system something;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test delimiter # ---------------------------------------------------------------------------- delimiter stop; echo teststop delimiter ;stop echo test2; --delimiter stop echo test3stop --delimiter ; echo test4; # ---------------------------------------------------------------------------- # Test that delimiter within if() works in in various combinations # ---------------------------------------------------------------------------- if (0) { delimiter ||; echo false-inner|| if (0) { delimiter *|| echo false-innerer* delimiter ||* } echo false-inner again|| } echo outer; if (1) { delimiter /; echo true-inner/ if (0) { delimiter %/ echo true-innerer% } echo true-inner again/ } echo true-outer/ delimiter ;/ # ---------------------------------------------------------------------------- # Test if # ---------------------------------------------------------------------------- let $counter=10; if ($counter) { echo Counter is greater than 0, (counter=10); } if (!$counter) { echo Counter is not 0, (counter=10); } if (! $counter) { let $counter=5; } echo Counter should still be 10, is $counter; let $counter=0; if($counter) { echo Counter is greater than 0, (counter=0); } if (!$counter) { echo Counter is not 0, (counter=0); } if (! $counter) { echo Not space var works; } # ---------------------------------------------------------------------------- # Test if with some non-numerics # ---------------------------------------------------------------------------- let $counter=alpha; if ($counter) { echo Counter is true, (counter=alpha); } let $counter= ; if ($counter) { echo oops, space is true; } let $counter=-0; if ($counter) { echo oops, -0 is true; } # This is no longer allowed, as a precaution against mistyped conditionals # if (beta) # { # echo Beta is true; # } let $counter=gamma; while ($counter) { echo while with string, only once; let $counter=000; } # ---------------------------------------------------------------------------- # Test if with compare conditions # ---------------------------------------------------------------------------- let $ifvar= 5; let $ifvar2= 6; if ($ifvar < 7) { echo 5<7; } if ($ifvar< 7) { echo 5<7 again; } if ($ifvar<7) { echo 5<7 still; } if ($ifvar < $ifvar2) { echo 5<6; } if ($ifvar <= 4) { echo 5<=4; } if ($ifvar >= 5) { echo 5>=5; } if ($ifvar>=5) { echo 5>=5 again; } if ($ifvar > 3) { echo 5>3; } if ($ifvar == 4) { echo 5==4; } if ($ifvar == 5) { echo 5==5; } if ($ifvar != 8) { echo 5!=8; } # Any number should compare unequal to any string if ($ifvar != five) { echo 5!=five; } if ($ifvar == `SELECT 3+2`) { echo 5==3+2; } if ($ifvar == 5) { echo 5 == 5; } let $ifvar= hello; if ($ifvar == hello there) { echo hello == hello there; } if ($ifvar == hello) { echo hello == hello; } if ($ifvar == hell) { echo hello == hell; } if ($ifvar == hello) { echo hello == hello; } if ($ifvar != goodbye) { echo hello != goodbye; } let $ifvar= 'quoted'; if ($ifvar == ''quoted'') { echo 'quoted' == ''quoted''; } let $ifvar= two words; if ($ifvar == two words) { echo two words; } if ($ifvar == 'two words') { echo 'two words'; } if ($ifvar == "two words") { echo "two words"; } if ($ifvar == `SELECT 'two words'`) { echo two words are two words; } if (42) { echo right answer; } if (0) { echo wrong answer; } # Non-empty string treated as 'true' if (`SELECT 'something'`) { echo anything goes; } # Make sure 0 and string compare right let $ifvar= 0; if ($ifvar == string) { echo 0 == string; } if ($ifvar != string) { echo 0 != string; } --write_file $MYSQL_TMP_DIR/mysqltest.sql let $var= 5; if ($var >= four) { echo 5>=four; } EOF --error 1 --exec $MYSQL_TEST < $MYSQL_TMP_DIR/mysqltest.sql 2>&1 remove_file $MYSQL_TMP_DIR/mysqltest.sql; --write_file $MYSQL_TMP_DIR/mysqltest.sql let $var= 5; if ($var ~= 6) { echo 5~=6; } EOF --error 1 --exec $MYSQL_TEST < $MYSQL_TMP_DIR/mysqltest.sql 2>&1 remove_file $MYSQL_TMP_DIR/mysqltest.sql; --write_file $MYSQL_TMP_DIR/mysqltest.sql let $var= text; if (var == text) { echo Oops I forgot the $; } EOF --error 1 --exec $MYSQL_TEST < $MYSQL_TMP_DIR/mysqltest.sql 2>&1 remove_file $MYSQL_TMP_DIR/mysqltest.sql; --error 1 --exec echo "if (\$var ==) {" | $MYSQL_TEST 2>&1 --error 1 --exec echo "if (\$var > ) {" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test while with compare conditions # ---------------------------------------------------------------------------- let $counter= 2; while ($counter < 5) { echo counter is $counter; inc $counter; } let $ifvar=; while ($ifvar != stop) { if ($counter >= 7) { let $ifvar= stop; } echo counter is $counter; inc $counter; } # ---------------------------------------------------------------------------- # Test while, { and } # ---------------------------------------------------------------------------- let $i=1; while ($i) { echo $i; dec $i; } # One liner #let $i=1;while ($i){echo $i;dec $i;} let $i=0; while (!$i) { echo Testing while with not; inc $i; } # Exceed max nesting level --write_file $MYSQLTEST_VARDIR/tmp/mysqltest_while.inc let $1 = 10; while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { while ($1) { echo $1; dec $1; } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } EOF # Fix win path --replace_result \\ / $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec echo "source $MYSQLTEST_VARDIR/tmp/mysqltest_while.inc;" | $MYSQL_TEST 2>&1 --remove_file $MYSQLTEST_VARDIR/tmp/mysqltest_while.inc --error 1 --exec echo "while \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "while (\$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "let \$i=1; while (\$i) dec \$i;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "};" | $MYSQL_TEST 2>&1 --error 1 --exec echo "end;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "{;" | $MYSQL_TEST 2>&1 --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql while (0) echo hej; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql while (0) {echo hej; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql while (0){ echo hej; EOF --error 1 --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # ---------------------------------------------------------------------------- # Test error messages returned from comments starting with a command # ---------------------------------------------------------------------------- --error 1 --exec echo "--if the other server is down" | $MYSQL_TEST 2>&1 --error 1 --exec echo "-- end when ..." | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test replace # ---------------------------------------------------------------------------- --replace_result a b select "a" as col1, "c" as col2; --replace_result a b c d select "a" as col1, "c" as col2; --error 1 --exec echo "--replace_result a" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_result a;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "replace_result a;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "replace_result a ;" | $MYSQL_TEST 2>&1 --exec echo "replace_result a b; echo OK; exit;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_result a b c" | $MYSQL_TEST 2>&1 --error 1 --exec echo "replace_result a b c ;" | $MYSQL_TEST 2>&1 --replace_column 1 b select "a" as col1, "c" as col2; --replace_column 1 b 2 d select "a" as col1, "c" as col2; --error 1 --exec echo "--replace_column a" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_column 1" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_column a b" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_column a 1" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_column 1 b c " | $MYSQL_TEST 2>&1 let $long_rep= 1234567890123456789012345678901234567890; let $long_rep= $long_rep,$long_rep; let $long_rep= $long_rep,$long_rep; let $long_rep= $long_rep,$long_rep; let $long_rep= $long_rep,$long_rep; let $long_rep= $long_rep,$long_rep; # This tests from strings > 1024 (here 1311) --replace_result $long_rep LONG_STRING eval select "$long_rep" as x; # Test replace within `` --replace_result cat dog --let $animal= `select "cat" as pet` --echo $animal # ---------------------------------------------------------------------------- # Test sync_with_master # ---------------------------------------------------------------------------- --error 1 --exec echo "sync_with_master 10!;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "sync_with_master a;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # Test connect # ---------------------------------------------------------------------------- --error 1 --exec echo "connect;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "connect ();" | $MYSQL_TEST 2>&1 --error 1 --exec echo "connect (con2);" | $MYSQL_TEST 2>&1 --error 1 --exec echo "connect (con2,);" | $MYSQL_TEST 2>&1 --error 1 --exec echo "connect (con2,localhost,root,,illegal_db);" | $MYSQL_TEST 2>&1 --error 1 --exec echo "connect (con1,localhost,root,,,illegal_port,);" | $MYSQL_TEST 2>&1 --error 1 --exec echo "connect (con1,localhost,root,,,,,SMTP POP);" | $MYSQL_TEST 2>&1 # Repeat connect/disconnect --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql let $i=200; while ($i) { connect (test_con1,localhost,root,,); disconnect test_con1; dec $i; } echo 200 connects succeeded; EOF --exec echo "source $MYSQLTEST_VARDIR/tmp/mysqltest.sql;" | $MYSQL_TEST 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # Select disconnected connection --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql connect (test_con1,localhost,root,,); disconnect test_con1; connection test_con1; EOF --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec echo "source $MYSQLTEST_VARDIR/tmp/mysqltest.sql;" | $MYSQL_TEST 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # Connection name already used --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql connect (test_con1,localhost,root,,); connect (test_con1,localhost,root,,); EOF --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec echo "source $MYSQLTEST_VARDIR/tmp/mysqltest.sql;" | $MYSQL_TEST 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql; # connect when "disable_abort_on_error" caused "connection not found" --disable_abort_on_error connect (con1,localhost,root,,); connection default; connection con1; disconnect con1; --enable_abort_on_error # Test connect without a database connect (con2,localhost,root,,*NO-ONE*); --error ER_NO_DB_ERROR show tables; disconnect con2; connection default; # Test enable_connect_log --enable_connect_log connect (con1,localhost,root,,); connection default; connection con1; --disable_query_log # These should not be logged connect (con2,localhost,root,,*NO-ONE*); connection con2; disconnect con2; connection con1; --enable_query_log disconnect con1; connection default; --disable_connect_log # ---------------------------------------------------------------------------- # Test mysqltest arguments # ---------------------------------------------------------------------------- # -x <file_name>, use the file specified after -x as the test file --exec $MYSQL_TEST < $MYSQL_TEST_DIR/include/mysqltest-x.inc --exec $MYSQL_TEST -x $MYSQL_TEST_DIR/include/mysqltest-x.inc --exec $MYSQL_TEST --test_file=$MYSQL_TEST_DIR/include/mysqltest-x.inc # Fix Win paths --replace_result \\ / --error 1 --exec $MYSQL_TEST -x non_existing_file.inc 2>&1 # ---------------------------------------------------------------------------- # TODO Test queries, especially their errormessages... so it's easy to debug # new scripts and diagnose errors # ---------------------------------------------------------------------------- # ---------------------------------------------------------------------------- # Test Bug#12386 # ---------------------------------------------------------------------------- let $num= 2; while ($num) { --error ER_PARSE_ERROR failing_statement; dec $num; } SELECT 1 as a; # # Bug#10251 Identifiers containing quotes not handled correctly # select 1 as `a'b`, 2 as `a"b`; # Test escaping of quotes select 'aaa\\','aa''a',"aa""a"; # # Check of include/show_msg.inc and include/show_msg80.inc # # The message contains in most cases a string with the default character set let $message= Here comes a message; --source include/show_msg.inc # The message could also contain a string with character set utf8 let $message= `SELECT USER()`; --source include/show_msg.inc # The message contains more then 80 characters on multiple lines # and is kept between double quotes. let $message= "Here comes a very very long message that - is longer then 80 characters and - consists of several lines"; --source include/show_msg80.inc # The message contains more then 80 characters on multiple lines # and uses the auxiliary character "." at the beginning of the message lines. let $message= . Here comes a very very long message that . - is longer then 80 characters and . - consists of several lines; --source include/show_msg80.inc # # Test --enable_parsing / disable_parsing # --disable_query_log --disable_parsing # The following will not enable query logging --enable_query_log select "this will not be executed"; --enable_parsing select "this will be executed"; --enable_query_log # # Test zero length result file. Should not pass # --exec echo '' > $MYSQLTEST_VARDIR/tmp/zero_length_file.result --exec echo "echo ok;" > $MYSQLTEST_VARDIR/tmp/query.sql --error 1 --exec $MYSQL_TEST -x $MYSQLTEST_VARDIR/tmp/query.sql -R $MYSQLTEST_VARDIR/tmp/zero_length_file.result > /dev/null 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/zero_length_file.result; --error 0,1 remove_file $MYSQLTEST_VARDIR/tmp/zero_length_file.reject; --error 0,1 remove_file $MYSQLTEST_VARDIR/tmp/zero_length_file.log; --error 0,1 remove_file $MYSQL_TEST_DIR/r/zero_length_file.reject; # # Test that a test file that does not generate any output fails. # --exec echo "let \$i= 1;" > $MYSQLTEST_VARDIR/tmp/query.sql --error 1 --exec $MYSQL_TEST -x $MYSQLTEST_VARDIR/tmp/query.sql 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/query.sql; # # Test that mysqltest fails when there are no queries executed # but a result file exists # NOTE! This will never happen as long as it's not allowed to have # test files that produce no output #--exec echo "something" > $MYSQLTEST_VARDIR/tmp/result_file.result #--exec echo "let \$i= 1;" > $MYSQLTEST_VARDIR/tmp/query.sql #--error 1 #--exec $MYSQL_TEST -x $MYSQLTEST_VARDIR/tmp/query.sql -R $MYSQLTEST_VARDIR/tmp/result_file.result 2>&1 # # Bug#11731 mysqltest in multi-statement queries ignores errors in # non-1st queries # echo Failing multi statement query; # PS does not support multi statement --exec echo "--disable_ps_protocol" > $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "delimiter ||||;" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "create table t1 (a int primary key);" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "insert into t1 values (1);" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "select 'select-me';" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "insertz 'error query'||||" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "delimiter ;||||" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --error 1 --exec $MYSQL_TEST -x $MYSQLTEST_VARDIR/tmp/bug11731.sql 2>&1 drop table t1; --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec $MYSQL_TEST --record -x $MYSQLTEST_VARDIR/tmp/bug11731.sql -R $MYSQLTEST_VARDIR/tmp/bug11731.out 2>&1 # The .out file should be non existent --error 1 --file_exists $MYSQLTEST_VARDIR/tmp/bug11731.out drop table t1; echo Multi statement using expected error; # PS does not support multi statement --exec echo "--disable_ps_protocol" > $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "delimiter ||||;" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "--error 1064" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "create table t1 (a int primary key);" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "insert into t1 values (1);" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "select 'select-me';" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "insertz "error query"||||" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "delimiter ;||||" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql --exec echo "exit;" >> $MYSQLTEST_VARDIR/tmp/bug11731.sql # These two should work since the error is expected --exec $MYSQL_TEST -x $MYSQLTEST_VARDIR/tmp/bug11731.sql 2>&1 drop table t1; --exec $MYSQL_TEST --record -x $MYSQLTEST_VARDIR/tmp/bug11731.sql -R $MYSQLTEST_VARDIR/tmp/bug11731.out 2>&1 # The .out file should exist --file_exists $MYSQLTEST_VARDIR/tmp/bug11731.out drop table t1; remove_file $MYSQLTEST_VARDIR/tmp/bug11731.out; remove_file $MYSQLTEST_VARDIR/log/bug11731.log; remove_file $MYSQLTEST_VARDIR/tmp/bug11731.sql; # # Bug#19890 mysqltest "query" command is broken # # It should be possible to use the command "query" to force mysqltest to # send the command to the server although it's a builtin mysqltest command. --error ER_PARSE_ERROR query sleep; --error ER_PARSE_ERROR --query sleep # Just an empty query command --error ER_EMPTY_QUERY query ; # test for replace_regex --replace_regex /at/b/ select "at" as col1, "c" as col2; --replace_regex /at/b/i select "at" as col1, "AT" as col2, "c" as col3; --replace_regex /a/b/ /ct/d/ select "a" as col1, "ct" as col2; --replace_regex /(strawberry)/raspberry and \1/ /blueberry/blackberry/ /potato/tomato/; select "strawberry","blueberry","potato"; --error 1 --exec echo "--replace_regex a" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_regex a;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "replace_regex a;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "replace_regex a ;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "replace_regex a b; echo OK;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "--replace_regex /a b c" | $MYSQL_TEST 2>&1 --error 1 --exec echo "replace_regex /a /b c ;" | $MYSQL_TEST 2>&1 # REQUIREMENT # replace_regex should replace substitutions from left to right in output create table t1 (a int, b int); insert into t1 values (1,3); insert into t1 values (2,4); --replace_regex /A/C/ /B/D/i /3/2/ /2/1/ select * from t1; drop table t1; # Test usage with `` --replace_regex /x/y/ --let $result= `select "x" as col` --echo $result # Test usage with a variable as pattern list --disable_query_log --let $patt= /a /b / /less/more/ --replace_regex $patt select "a is a and less is more" as txt; --let $patt= --replace_regex $patt select "a is a and less is more" as txt; --enable_query_log #------------------------------------------------------------------------- # BUG #11754855 : Passing variable to --error #------------------------------------------------------------------------- create table t2 ( a char(10)); let $errno1=0; let $errno2=ER_PARSE_ERROR; let $errno3=ER_NO_SUCH_TABLE; --error $errno2 garbage; --error $errno2,$errno3 garbage; --error $errno2,ER_NO_SUCH_TABLE garbage; --error ER_NO_SUCH_TABLE,$errno2 insert into t1 values ("Abcd"); --error $errno1,ER_PARSE_ERROR garbage; drop table t2; # ---------------------------------------------------------------------------- # Tests of send # ---------------------------------------------------------------------------- create table t1 ( f1 char(10)); insert into t1 values ("Abcd"); # 1. Basic test send select * from t1; reap; # 2. Test with error --send select * from t2; --error ER_NO_SUCH_TABLE --reap # 3. test send of next stmt --send select * from t1; --reap # 4. Non-query stmt betwen send and reap allowed --send select * from t1; --sleep 0.05 --echo Result coming up --reap # 5. Test of send_eval --let $my_stmt= select * from t1; --send_eval $my_stmt --reap # 6. Test that mysqltest does not allow query stmt between send and reap # Untestable directly as it causes mysqltest to fail --write_file $MYSQLTEST_VARDIR/tmp/mysqltest.in --send select * from t1; select 1; --reap EOF --error 1 # Must filter unpredictable extra warning from output --exec $MYSQL_TEST < $MYSQLTEST_VARDIR/tmp/mysqltest.in > $MYSQL_TMP_DIR/mysqltest.out 2>&1 --perl my $dir= $ENV{'MYSQL_TMP_DIR'}; open (FILE, "$dir/mysqltest.out"); while (<FILE>) { print unless /Note: net_clear/; # This shows up on rare occations } EOF remove_file $MYSQL_TMP_DIR/mysqltest.out; remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.in; drop table t1; # ---------------------------------------------------------------------------- # test for remove_file # ---------------------------------------------------------------------------- --error 1 --exec echo "remove_file ;" | $MYSQL_TEST 2>&1 --error 1 remove_file non_existing_file; # ---------------------------------------------------------------------------- # test for remove_files_wildcard # ---------------------------------------------------------------------------- --error 1 --exec echo "remove_files_wildcard ;" | $MYSQL_TEST 2>&1 --error 1 remove_files_wildcard non_existing_dir; --error 1 remove_files_wildcard non_existing_dir non_existing_file; # ---------------------------------------------------------------------------- # test for write_file # ---------------------------------------------------------------------------- --error 1 --exec echo "write_file ;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "write_file filename ;" | $MYSQL_TEST 2>&1 # Comment out this test as it confuses cmd.exe with unmatched " #--error 1 #--exec echo "write_file filename \";" | $MYSQL_TEST 2>&1 write_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; Content for test_file1 EOF file_exists $MYSQLTEST_VARDIR/tmp/test_file1.tmp; cat_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; remove_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; write_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp END_DELIMITER; Content for test_file1 contains EOF END_DELIMITER file_exists $MYSQLTEST_VARDIR/tmp/test_file1.tmp; # write to already exisiting file --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR --error 1 --exec echo "write_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp;" | $MYSQL_TEST 2>&1 remove_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; # ---------------------------------------------------------------------------- # test for append_file # ---------------------------------------------------------------------------- write_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; Content for test_file1 EOF file_exists $MYSQLTEST_VARDIR/tmp/test_file1.tmp; append_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; Appended text EOF file_exists $MYSQLTEST_VARDIR/tmp/test_file1.tmp; remove_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; append_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; Appended text on nonexisting file EOF remove_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; # Test append_file within while let $outer= 2; # Number of outer loops while ($outer) { append_file $MYSQLTEST_VARDIR/tmp/app_while.tmp; These lines should be repeated, if things work as expected EOF dec $outer; } cat_file $MYSQLTEST_VARDIR/tmp/app_while.tmp; remove_file $MYSQLTEST_VARDIR/tmp/app_while.tmp; # ---------------------------------------------------------------------------- # test for cat_file # ---------------------------------------------------------------------------- --write_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp Some data for cat_file command of mysqltest EOF cat_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; remove_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; --replace_regex /my_errno=[0-9]*/(my_errno)/ --error 1 --exec echo "cat_file non_existing_file;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # test for diff_files # ---------------------------------------------------------------------------- --write_file $MYSQLTEST_VARDIR/tmp/diff1.tmp Some data for diff_file command of mysqltest EOF --write_file $MYSQLTEST_VARDIR/tmp/diff2.tmp Some data for diff_file command of mysqltest EOF --write_file $MYSQLTEST_VARDIR/tmp/diff3.tmp Some other data for diff_file command of mysqltest EOF --write_file $MYSQLTEST_VARDIR/tmp/diff4.tmp Some data for diff_file command of musqltest EOF # Compare equal files --diff_files $MYSQLTEST_VARDIR/tmp/diff1.tmp $MYSQLTEST_VARDIR/tmp/diff2.tmp --diff_files $MYSQLTEST_VARDIR/tmp/diff2.tmp $MYSQLTEST_VARDIR/tmp/diff1.tmp # Compare files that differ in size --error 2 --diff_files $MYSQLTEST_VARDIR/tmp/diff1.tmp $MYSQLTEST_VARDIR/tmp/diff3.tmp --error 2 --diff_files $MYSQLTEST_VARDIR/tmp/diff3.tmp $MYSQLTEST_VARDIR/tmp/diff1.tmp # Compare files that differ only in content --error 1 --diff_files $MYSQLTEST_VARDIR/tmp/diff1.tmp $MYSQLTEST_VARDIR/tmp/diff4.tmp --error 1 --diff_files $MYSQLTEST_VARDIR/tmp/diff4.tmp $MYSQLTEST_VARDIR/tmp/diff1.tmp # Compare equal files, again... --diff_files $MYSQLTEST_VARDIR/tmp/diff1.tmp $MYSQLTEST_VARDIR/tmp/diff2.tmp --remove_file $MYSQLTEST_VARDIR/tmp/diff1.tmp --remove_file $MYSQLTEST_VARDIR/tmp/diff2.tmp --remove_file $MYSQLTEST_VARDIR/tmp/diff3.tmp --remove_file $MYSQLTEST_VARDIR/tmp/diff4.tmp # ---------------------------------------------------------------------------- # test for file_exist # ---------------------------------------------------------------------------- --error 1 --exec echo "file_exists ;" | $MYSQL_TEST 2>&1 --error 0,1 remove_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; --error 1 file_exists $MYSQLTEST_VARDIR/tmp/test_file1.tmp; write_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; Content for test_file1 EOF file_exists $MYSQLTEST_VARDIR/tmp/test_file1.tmp; remove_file $MYSQLTEST_VARDIR/tmp/test_file1.tmp; --error 1 file_exists $MYSQLTEST_VARDIR/tmp/test_file1.tmp; # ---------------------------------------------------------------------------- # test for copy_file # ---------------------------------------------------------------------------- --write_file $MYSQLTEST_VARDIR/tmp/file1.tmp file1 EOF copy_file $MYSQLTEST_VARDIR/tmp/file1.tmp $MYSQLTEST_VARDIR/tmp/file2.tmp; file_exists $MYSQLTEST_VARDIR/tmp/file2.tmp; remove_file $MYSQLTEST_VARDIR/tmp/file1.tmp; remove_file $MYSQLTEST_VARDIR/tmp/file2.tmp; --error 1 --exec echo "copy_file ;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "copy_file from_file;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # test for move_file # ---------------------------------------------------------------------------- # - Check that if source file does not exist, nothing will be created. --error 1 file_exists $MYSQLTEST_VARDIR/tmp/file1.tmp; --error 1 file_exists $MYSQLTEST_VARDIR/tmp/file2.tmp; --error 1 move_file $MYSQLTEST_VARDIR/tmp/file1.tmp $MYSQLTEST_VARDIR/tmp/file2.tmp; --error 1 file_exists $MYSQLTEST_VARDIR/tmp/file1.tmp; --error 1 file_exists $MYSQLTEST_VARDIR/tmp/file2.tmp; # - Check that if source file exists, everything works properly. --write_file $MYSQLTEST_VARDIR/tmp/file1.tmp file1 EOF move_file $MYSQLTEST_VARDIR/tmp/file1.tmp $MYSQLTEST_VARDIR/tmp/file2.tmp; --error 1 file_exists $MYSQLTEST_VARDIR/tmp/file1.tmp; file_exists $MYSQLTEST_VARDIR/tmp/file2.tmp; # - Check that if destination file exists, everything works properly. # (file2.tmp exists from the previous check; file1.tmp needs to be created) --write_file $MYSQLTEST_VARDIR/tmp/file1.tmp file1 EOF move_file $MYSQLTEST_VARDIR/tmp/file1.tmp $MYSQLTEST_VARDIR/tmp/file2.tmp; --error 1 file_exists $MYSQLTEST_VARDIR/tmp/file1.tmp; file_exists $MYSQLTEST_VARDIR/tmp/file2.tmp; remove_file $MYSQLTEST_VARDIR/tmp/file2.tmp; # - Check usage. --error 1 --exec echo "move_file ;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "move_file from_file;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # test for chmod # ---------------------------------------------------------------------------- --write_file $MYSQLTEST_VARDIR/tmp/file1.tmp file1 EOF chmod 0000 $MYSQLTEST_VARDIR/tmp/file1.tmp; # The below write fails, but --error is not implemented # for write_file #--write_file $MYSQLTEST_VARDIR/tmp/file1.tmp #test should fail #EOF chmod 0777 $MYSQLTEST_VARDIR/tmp/file1.tmp; remove_file $MYSQLTEST_VARDIR/tmp/file1.tmp; --write_file $MYSQLTEST_VARDIR/tmp/file1.tmp test2 EOF remove_file $MYSQLTEST_VARDIR/tmp/file1.tmp; --error 1 --exec echo "chmod ;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "chmod 0 from_file;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "chmod 08 from_file;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "chmod from_file;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "chmod ABZD from_file;" | $MYSQL_TEST 2>&1 --error 1 --exec echo "chmod 06789 from_file;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # test for perl # ---------------------------------------------------------------------------- --perl print "hello\n"; EOF --perl EOF print "hello\n"; EOF --perl DELIMITER print "hello\n"; DELIMITER --error 1 --exec echo "perl TOO_LONG_DELIMITER ;" | $MYSQL_TEST 2>&1 perl; print "hello\n"; EOF perl; # Print "hello" print "hello\n"; EOF # Test perl within while, also with if being false first iteration let $outer= 3; let $ifval= 0; while ($outer) { if ($ifval) { perl UNTIL; my $val= 5; print "val is $val\n"; UNTIL } inc $ifval; dec $outer; } # ---------------------------------------------------------------------------- # test for die # ---------------------------------------------------------------------------- --error 1 --exec echo "die test of die;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # test for exit # ---------------------------------------------------------------------------- --exec echo "echo Some output; exit; echo Not this;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # test for sorted_result # ---------------------------------------------------------------------------- create table t1( a int, b char(255), c timestamp); insert into t1 values(1, 'Line 1', '2007-04-05'), (2, "Part 2", '2007-04-05'); insert into t1 values(1, 'Line 1', '2007-04-05'), (2, "Part 3", '2007-04-05'); select * from t1; --sorted_result select * from t1; # Should not be sorted select * from t1; disable_result_log; sorted_result; select * from t1; enable_result_log; --sorted_result select ''; sorted_result; select "h"; --sorted_result select "he"; --sorted_result select "hep"; --sorted_result select "hepp"; drop table t1; # 1. Assignment of result set sorting sorted_result; SELECT 2 as "my_col" UNION SELECT 1; # --sorted_result SELECT 2 as "my_col" UNION SELECT 1; --sorted_result SELECT 2 as "my_col" UNION SELECT 1; # 2. Ensure that the table header will be not sorted into the result --sorted_result SELECT '2' as "3" UNION SELECT '1'; # 3. Ensure that an empty result set does not cause problems CREATE TABLE t1( a CHAR); --sorted_result SELECT * FROM t1; DROP TABLE t1; # 4. Ensure that NULL values within the result set do not cause problems SELECT NULL as "my_col1",2 AS "my_col2" UNION SELECT NULL,1; --sorted_result SELECT NULL as "my_col1",2 AS "my_col2" UNION SELECT NULL,1; # SELECT 2 as "my_col1",NULL AS "my_col2" UNION SELECT 1,NULL; --sorted_result SELECT 2 as "my_col1",NULL AS "my_col2" UNION SELECT 1,NULL; # 5. "sorted_result" changes nothing when applied to a non query statement. sorted_result; SET @a = 17; # # 6. Show that "sorted_result;" before the "SET @a = 17;" above does not affect # the now following query. SELECT 2 as "my_col" UNION SELECT 1; # 7. Ensure that "sorted_result" in combination with $variables works let $my_stmt=SELECT 2 as "my_col" UNION SELECT 1; --sorted_result eval $my_stmt; # 8. Ensure that "sorted_result " does not change the semantics of # "--error ...." or the protocol output after such an expected failure --sorted_result --error ER_NO_SUCH_TABLE SELECT '2' as "my_col1",2 as "my_col2" UNION SELECT '1',1 from t2; # 9. Ensure that several result formatting options including "sorted_result" # - have all an effect # - "--sorted_result" does not need to be direct before the statement # - Row sorting is applied after modification of the column content --sorted_result --replace_column 1 # SELECT '1' as "my_col1",2 as "my_col2" UNION SELECT '2',1; # 10. Ensure that at least 1024 rows within a result set do not cause problems # CREATE TABLE t1 (f1 INT); INSERT INTO t1 SET f1 = 1024; INSERT INTO t1 SELECT f1 - 1 FROM t1; INSERT INTO t1 SELECT f1 - 2 FROM t1; INSERT INTO t1 SELECT f1 - 4 FROM t1; INSERT INTO t1 SELECT f1 - 8 FROM t1; INSERT INTO t1 SELECT f1 - 16 FROM t1; INSERT INTO t1 SELECT f1 - 32 FROM t1; INSERT INTO t1 SELECT f1 - 64 FROM t1; INSERT INTO t1 SELECT f1 - 128 FROM t1; INSERT INTO t1 SELECT f1 - 256 FROM t1; INSERT INTO t1 SELECT f1 - 512 FROM t1; --disable_result_log ONCE --sorted_result SELECT * FROM t1; DROP TABLE t1; # ---------------------------------------------------------------------------- # test for lowercase_result # ---------------------------------------------------------------------------- # 1. Basic test --lowercase_result SELECT "500g BL�B�RSYLTET�Y" AS "WILL BE lower cased"; # 2. test that it does not apply to next statement SELECT "UPPER" AS "WILL NOT BE lower cased"; # 3. test that it does not affect non-SQL or the following statement --lowercase_result --echo UP SELECT 0 as "UP AGAIN"; # 4. test that it works with eval and variables let $lower_stmt=SELECT "ABCdef" AS "uvwXYZ"; --lowercase_result eval $lower_stmt; # 5. test that it works in combination with sort sorted_result; lowercase_result; SELECT "Xyz" AS Name UNION SELECT "Abc" as Name ORDER BY Name DESC; # 6. Test combination with replace, and that lower casing is done first --lowercase_result --replace_result old new SELECT 1 as "SOME OLD TEXT"; # 7. Test missing lower casing of "unknown" characters --character_set utf8 --lowercase_result SELECT 0 as "WILL NOT lower case ���"; --character_set latin1 # ---------------------------------------------------------------------------- # Some coverage tests # ---------------------------------------------------------------------------- --disable_query_log --exec $MYSQL_TEST --help 2>&1 > /dev/null --exec $MYSQL_TEST --version 2>&1 > /dev/null --enable_query_log --disable_abort_on_error ONCE --error 1 --exec $MYSQL_TEST a b c 2>&1 > /dev/null # ---------------------------------------------------------------------------- # test for query_get_value # ---------------------------------------------------------------------------- CREATE TABLE t1( a int, b varchar(255), c datetime ); SHOW COLUMNS FROM t1; #------------ Positive tests ------------ # 1. constant parameters # value is simple string without spaces let $value= query_get_value(SHOW COLUMNS FROM t1, Type, 1); --echo statement=SHOW COLUMNS FROM t1 row_number=1, column_name="Type", Value=$value let $value= query_get_value("SHOW COLUMNS FROM t1", Type, 1); --echo statement="SHOW COLUMNS FROM t1" row_number=1, column_name="Type", Value=$value # # 2. $variables as parameters # value IS NULL let $my_show= SHOW COLUMNS FROM t1; let $column_name= Default; let $row_number= 1; let $value= query_get_value($my_show, $column_name, $row_number); --echo statement=$my_show row_number=$row_number, column_name=$column_name, Value=$value # # 3. result set of a SELECT (not recommended, because projection and # selection could be done much better by pure SELECT functionality) # value is string with space in the middle let $value= query_get_value(SELECT 'A B' AS "MyColumn", MyColumn, 1); --echo value= ->$value<- # # 4. column name with space let $value= query_get_value(SELECT 1 AS "My Column", My Column, 1); --echo value= $value # # 4.1 Query containing , protected by quotes, quotes also on column let $value= query_get_value('SELECT 1 as a, 2 as b', "b", 1); --echo value= $value # #------------ Negative tests ------------ # 5. Incomplete statement including missing parameters # 5.1 incomplete statement --error 1 --exec echo "let \$value= query_get_value(SHOW;" | $MYSQL_TEST 2>&1 # 5.2 missing query --error 1 --exec echo "let \$value= query_get_value;" | $MYSQL_TEST 2>&1 # 5.3 missing column name --error 1 --exec echo "let \$value= query_get_value(SHOW COLUMNS FROM t1);" | $MYSQL_TEST 2>&1 # 5.4 missing row number --error 1 --exec echo "let \$value= query_get_value(SHOW COLUMNS FROM t1, Field);" | $MYSQL_TEST 2>&1 # # 6. Somehow "wrong" value of parameters # 6.1 row parameter # 6.1.1 non sense number 0 let $value= initialized; let $value= query_get_value(SHOW COLUMNS FROM t1, Field, 0); --echo value= $value # 6.1.2 after the last row let $value= initialized; let $value= query_get_value(SHOW COLUMNS FROM t1, Field, 10); --echo value= $value # 6.1.3 invalid row number --error 1 --exec echo "let \$value= query_get_value(SHOW COLUMNS FROM t1, Field, notnumber);" | $MYSQL_TEST 2>&1 # 6.2 column name parameter, name of not existing column --error 1 --exec echo "let \$value= query_get_value(SHOW COLUMNS FROM t1, column_not_exists, 1);" | $MYSQL_TEST 2>&1 # 6.3. statement which never gives a result set --error 1 --exec echo "let \$value= query_get_value(SET @A = 1, Field, 1);" | $MYSQL_TEST 2>&1 # 6.4. statement contains a "," # Note: There is no need to improve this, because we need query_get_value # for SHOW commands only. --error 1 --exec echo "let \$value= query_get_value(SELECT 1 AS "A", 1 AS "B", 1);" | $MYSQL_TEST 2>&1 # # 7. empty result set let $value= initialized; let $value= query_get_value(SELECT a FROM t1, a, 1); --echo value= $value # # 9. failing statement --error 1 --exec echo "let \$value= query_get_value(SHOW COLNS FROM t1, Field, 1);" | $MYSQL_TEST 2>&1 # # 10. Artificial example how to process a complete SHOW result set: let $show_statement= SHOW COLUMNS FROM t1; let $rowno= 1; let $run=1; let $count= 0; --echo --echo Field Type Null Key Default Extra while ($run) { let $Field= query_get_value($show_statement, Field, $rowno); if ($Field == No such row) { let $run= 0; } if ($Field != No such row) { let $Type= query_get_value($show_statement, Type, $rowno); let $Null= query_get_value($show_statement, Null, $rowno); if ($Null == YES) { inc $count; } let $Key= query_get_value($show_statement, Key, $rowno); let $Default= query_get_value($show_statement, Default, $rowno); let $Extra= query_get_value($show_statement, Extra, $rowno); --echo $Field $Type $Null ->$Key<- $Default $Extra inc $rowno; } } --echo --echo Number of columns with Default NULL: $count --echo eval $show_statement; drop table t1; # ---------------------------------------------------------------------------- # Test change_user command # ---------------------------------------------------------------------------- --error ER_BAD_DB_ERROR --change_user root,,inexistent --error ER_ACCESS_DENIED_ERROR --change_user inexistent,,test --error ER_ACCESS_DENIED_ERROR --change_user root,inexistent,test --change_user --change_user root --change_user root,, --change_user root,,test # ---------------------------------------------------------------------------- # Test mkdir and rmdir command # ---------------------------------------------------------------------------- mkdir $MYSQLTEST_VARDIR/tmp/testdir; rmdir $MYSQLTEST_VARDIR/tmp/testdir; # Directory already exist mkdir $MYSQLTEST_VARDIR/tmp/testdir; --error 1 mkdir $MYSQLTEST_VARDIR/tmp/testdir; # Remove dir with file inside write_file $MYSQLTEST_VARDIR/tmp/testdir/file1.txt; hello EOF # Verify that --replace_result also work on list_files --replace_result file REPLACED_FILE list_files $MYSQLTEST_VARDIR/tmp/testdir; # list_files gets the directory list before creating the new file list_files_write_file $MYSQLTEST_VARDIR/tmp/testdir/file2.txt $MYSQLTEST_VARDIR/tmp/testdir *; list_files_append_file $MYSQLTEST_VARDIR/tmp/testdir/file2.txt $MYSQLTEST_VARDIR/tmp/testdir *2*; list_files_write_file $MYSQLTEST_VARDIR/tmp/testdir/file2.txt $MYSQLTEST_VARDIR/tmp/testdir file?.txt; list_files_append_file $MYSQLTEST_VARDIR/tmp/testdir/file3.txt $MYSQLTEST_VARDIR/tmp/testdir file*.txt; diff_files $MYSQLTEST_VARDIR/tmp/testdir/file2.txt $MYSQLTEST_VARDIR/tmp/testdir/file3.txt; --error 1 rmdir $MYSQLTEST_VARDIR/tmp/testdir; cat_file $MYSQLTEST_VARDIR/tmp/testdir/file3.txt; # Test replace_result and that it does not affect next SQL stmt replace_result file prefix; list_files $MYSQLTEST_VARDIR/tmp/testdir; SELECT "bla bla file" as x; list_files_write_file $MYSQLTEST_VARDIR/tmp/testdir/file11.txt $MYSQLTEST_VARDIR/tmp/testdir file?.txt; remove_files_wildcard $MYSQLTEST_VARDIR/tmp/testdir file?.txt; list_files_write_file $MYSQLTEST_VARDIR/tmp/testdir/dir-list.txt $MYSQLTEST_VARDIR/tmp/testdir file*.txt; cat_file $MYSQLTEST_VARDIR/tmp/testdir/dir-list.txt; remove_files_wildcard $MYSQLTEST_VARDIR/tmp/testdir file*.txt; list_files $MYSQLTEST_VARDIR/tmp/testdir; remove_files_wildcard $MYSQLTEST_VARDIR/tmp/testdir; list_files $MYSQLTEST_VARDIR/tmp/testdir; rmdir $MYSQLTEST_VARDIR/tmp/testdir; # # Bug#36041 mysql-test-run doesn't seem to string match 100% effectively # on Windows # --replace_result c:\\a.txt z SELECT 'c:\\a.txt' AS col; # ---------------------------------------------------------------------------- # Test that -- is not allowed as comment, only as mysqltest builtin command # ---------------------------------------------------------------------------- # valid select 1; --query select 1 --query -- a comment for the server # Not valid, "select" is not a mysqltest command --error 1 --exec echo "--select 1;" | $MYSQL_TEST 2>&1 # ---------------------------------------------------------------------------- # BUG#35701 please allow test language variables in connection and sync_slave_with_master # Test that "connection $variable" works and that $CURRENT_CONNECTION has the right value. # ---------------------------------------------------------------------------- connect (con1,localhost,root,,); --echo $CURRENT_CONNECTION connect (con2,localhost,root,,); --echo $CURRENT_CONNECTION connection default; --echo $CURRENT_CONNECTION connection con1; --echo $CURRENT_CONNECTION connection con2; --echo $CURRENT_CONNECTION let $x= con1; let $y= con2; connection $x; --echo $CURRENT_CONNECTION connection $y; --echo $CURRENT_CONNECTION # Disconnect the not selected connection disconnect $x; --echo $CURRENT_CONNECTION # Disconnect the selected connection disconnect $y; --echo $CURRENT_CONNECTION --echo End of tests connection default; # Wait till we reached the initial number of concurrent sessions --source include/wait_until_count_sessions.inc # To test \r\n in cat_file --cat_file std_data/cat_file.txt --echo --echo Bug#21963113 MYSQLTESTS REPLACE_REGEX CANNOT --echo MATCH ^ (BEGINNING OF LINE) ATOM --echo --replace_regex /^a/R/ select "a" as a; --replace_regex /a/R/ select "a" as a; --replace_regex /a$/R/ select "a" as a; --echo # --echo # Bug#23280117: 5.7 BUG XXXXX TEST REPLACE NUMBER ROUND+GIS PRECISION --echo # DIFFERENCES (CONTRIBUTION) --echo # --echo # Insert values to be tested into a table CREATE TABLE t1(f FLOAT, k DOUBLE); INSERT INTO t1 VALUES(124.7892,1.23456e200); INSERT INTO t1 VALUES(6.9999999,1.000000000); INSERT INTO t1 VALUES(12900.019,37489e-12); --replace_numeric_round 2 SELECT * FROM t1; DROP TABLE t1; --echo # Verify that the function rounds numeric values when they --echo # are padded with characters --replace_numeric_round 5 SELECT 'aaaa(12.123484502750487)'; --echo # Test case with precision 0. Value should be rounded off --echo # to nearest whole number. --replace_numeric_round 0 SELECT 19.955934879; --echo # An error is thrown if parameter count is 0 --error 1 --exec echo "replace_numeric_round;" | $MYSQL_TEST 2>&1 --echo # The maximum value which can be passed is 16 --error 1 --exec echo "replace_numeric_round 170;" | $MYSQL_TEST 2>&1 --echo # The minimum value which can be passed is 0 --error 1 --exec echo "replace_numeric_round -1;" | $MYSQL_TEST 2>&1 --echo # --echo # BUG#26630826: MTR: REPLACE_RESULT IS NOT ABLE TO REPLACE LONG --echo # STRINGS IN PATH NAME --echo # # Check whether replace_result replaces a matching long string pattern # when used with exec mysqltest command. --let $replace_string= `SELECT REPEAT('A', 550)` --replace_result $replace_string REPLACE_STRING --exec echo $replace_string # replace_result with long string pattern as argument used with exec # command which fails with error 1, pattern should get replaced. --replace_result $replace_string REPLACE_STRING tab1 t1 --error 1 --exec echo "SELECT $replace_string FROM tab1;" | $MYSQL_TEST 2>&1
Close