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 | : 18.223.109.25
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 : csv.test
# # Test for the CSV engine # ### Test is Being disabled to be executed with Query Cache Enabled until BUG#11757567 is fixed # # Simple select test # --disable_warnings drop table if exists t1,t2,t3,t4; --enable_warnings CREATE TABLE t1 ( Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL, Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL ) ENGINE = CSV; INSERT INTO t1 VALUES (9410,9412); select period from t1; select * from t1; select t1.* from t1; # # Create test table # CREATE TABLE t2 ( auto int not null, fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL, companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL, fld3 char(30) DEFAULT '' NOT NULL, fld4 char(35) DEFAULT '' NOT NULL, fld5 char(35) DEFAULT '' NOT NULL, fld6 char(4) DEFAULT '' NOT NULL ) ENGINE = CSV; # # Populate table # --disable_query_log INSERT INTO t2 VALUES (1,000001,00,'Omaha','teethe','neat',''); INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W'); INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring',''); INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily',''); INSERT INTO t2 VALUES (5,011501,37,'bewilderingly','wallet','balled',''); INSERT INTO t2 VALUES (6,011701,37,'astound','parters','persist','W'); INSERT INTO t2 VALUES (7,011702,37,'admonishing','eschew','attainments',''); INSERT INTO t2 VALUES (8,011703,37,'sumac','quitter','fanatic',''); INSERT INTO t2 VALUES (9,012001,37,'flanking','neat','measures','FAS'); INSERT INTO t2 VALUES (10,012003,37,'combed','Steinberg','rightfulness',''); INSERT INTO t2 VALUES (11,012004,37,'subjective','jarring','capably',''); INSERT INTO t2 VALUES (12,012005,37,'scatterbrain','tinily','impulsive',''); INSERT INTO t2 VALUES (13,012301,37,'Eulerian','balled','starlet',''); INSERT INTO t2 VALUES (14,012302,36,'dubbed','persist','terminators',''); INSERT INTO t2 VALUES (15,012303,37,'Kane','attainments','untying',''); INSERT INTO t2 VALUES (16,012304,37,'overlay','fanatic','announces','FAS'); INSERT INTO t2 VALUES (17,012305,37,'perturb','measures','featherweight','FAS'); INSERT INTO t2 VALUES (18,012306,37,'goblins','rightfulness','pessimist','FAS'); INSERT INTO t2 VALUES (19,012501,37,'annihilates','capably','daughter',''); INSERT INTO t2 VALUES (20,012602,37,'Wotan','impulsive','decliner','FAS'); INSERT INTO t2 VALUES (21,012603,37,'snatching','starlet','lawgiver',''); INSERT INTO t2 VALUES (22,012604,37,'concludes','terminators','stated',''); INSERT INTO t2 VALUES (23,012605,37,'laterally','untying','readable',''); INSERT INTO t2 VALUES (24,012606,37,'yelped','announces','attrition',''); INSERT INTO t2 VALUES (25,012701,37,'grazing','featherweight','cascade','FAS'); INSERT INTO t2 VALUES (26,012702,37,'Baird','pessimist','motors','FAS'); INSERT INTO t2 VALUES (27,012703,37,'celery','daughter','interrogate',''); INSERT INTO t2 VALUES (28,012704,37,'misunderstander','decliner','pests','W'); INSERT INTO t2 VALUES (29,013601,37,'handgun','lawgiver','stairway',''); INSERT INTO t2 VALUES (30,013602,37,'foldout','stated','dopers','FAS'); INSERT INTO t2 VALUES (31,013603,37,'mystic','readable','testicle','W'); INSERT INTO t2 VALUES (32,013604,37,'succumbed','attrition','Parsifal','W'); INSERT INTO t2 VALUES (33,013605,37,'Nabisco','cascade','leavings',''); INSERT INTO t2 VALUES (34,013606,37,'fingerings','motors','postulation','W'); INSERT INTO t2 VALUES (35,013607,37,'aging','interrogate','squeaking',''); INSERT INTO t2 VALUES (36,013608,37,'afield','pests','contrasted',''); INSERT INTO t2 VALUES (37,013609,37,'ammonium','stairway','leftover',''); INSERT INTO t2 VALUES (38,013610,37,'boat','dopers','whiteners',''); INSERT INTO t2 VALUES (39,013801,37,'intelligibility','testicle','erases','W'); INSERT INTO t2 VALUES (40,013802,37,'Augustine','Parsifal','Punjab','W'); INSERT INTO t2 VALUES (41,013803,37,'teethe','leavings','Merritt',''); INSERT INTO t2 VALUES (42,013804,37,'dreaded','postulation','Quixotism',''); INSERT INTO t2 VALUES (43,013901,37,'scholastics','squeaking','sweetish','FAS'); INSERT INTO t2 VALUES (44,016001,37,'audiology','contrasted','dogging','FAS'); INSERT INTO t2 VALUES (45,016201,37,'wallet','leftover','scornfully','FAS'); INSERT INTO t2 VALUES (46,016202,37,'parters','whiteners','bellow',''); INSERT INTO t2 VALUES (47,016301,37,'eschew','erases','bills',''); INSERT INTO t2 VALUES (48,016302,37,'quitter','Punjab','cupboard','FAS'); INSERT INTO t2 VALUES (49,016303,37,'neat','Merritt','sureties','FAS'); INSERT INTO t2 VALUES (50,016304,37,'Steinberg','Quixotism','puddings',''); INSERT INTO t2 VALUES (51,018001,37,'jarring','sweetish','tapestry',''); INSERT INTO t2 VALUES (52,018002,37,'tinily','dogging','fetters',''); INSERT INTO t2 VALUES (53,018003,37,'balled','scornfully','bivalves',''); INSERT INTO t2 VALUES (54,018004,37,'persist','bellow','incurring',''); INSERT INTO t2 VALUES (55,018005,37,'attainments','bills','Adolph',''); INSERT INTO t2 VALUES (56,018007,37,'fanatic','cupboard','pithed',''); INSERT INTO t2 VALUES (57,018008,37,'measures','sureties','emergency',''); INSERT INTO t2 VALUES (58,018009,37,'rightfulness','puddings','Miles',''); INSERT INTO t2 VALUES (59,018010,37,'capably','tapestry','trimmings',''); INSERT INTO t2 VALUES (60,018012,37,'impulsive','fetters','tragedies','W'); INSERT INTO t2 VALUES (61,018013,37,'starlet','bivalves','skulking','W'); INSERT INTO t2 VALUES (62,018014,37,'terminators','incurring','flint',''); INSERT INTO t2 VALUES (63,018015,37,'untying','Adolph','flopping','W'); INSERT INTO t2 VALUES (64,018016,37,'announces','pithed','relaxing','FAS'); INSERT INTO t2 VALUES (65,018017,37,'featherweight','emergency','offload','FAS'); INSERT INTO t2 VALUES (66,018018,37,'pessimist','Miles','suites','W'); INSERT INTO t2 VALUES (67,018019,37,'daughter','trimmings','lists','FAS'); INSERT INTO t2 VALUES (68,018020,37,'decliner','tragedies','animized','FAS'); INSERT INTO t2 VALUES (69,018021,37,'lawgiver','skulking','multilayer','W'); INSERT INTO t2 VALUES (70,018022,37,'stated','flint','standardizes','FAS'); INSERT INTO t2 VALUES (71,018023,37,'readable','flopping','Judas',''); INSERT INTO t2 VALUES (72,018024,37,'attrition','relaxing','vacuuming','W'); INSERT INTO t2 VALUES (73,018025,37,'cascade','offload','dentally','W'); INSERT INTO t2 VALUES (74,018026,37,'motors','suites','humanness','W'); INSERT INTO t2 VALUES (75,018027,37,'interrogate','lists','inch','W'); INSERT INTO t2 VALUES (76,018028,37,'pests','animized','Weissmuller','W'); INSERT INTO t2 VALUES (77,018029,37,'stairway','multilayer','irresponsibly','W'); INSERT INTO t2 VALUES (78,018030,37,'dopers','standardizes','luckily','FAS'); INSERT INTO t2 VALUES (79,018032,37,'testicle','Judas','culled','W'); INSERT INTO t2 VALUES (80,018033,37,'Parsifal','vacuuming','medical','FAS'); INSERT INTO t2 VALUES (81,018034,37,'leavings','dentally','bloodbath','FAS'); INSERT INTO t2 VALUES (82,018035,37,'postulation','humanness','subschema','W'); INSERT INTO t2 VALUES (83,018036,37,'squeaking','inch','animals','W'); INSERT INTO t2 VALUES (84,018037,37,'contrasted','Weissmuller','Micronesia',''); INSERT INTO t2 VALUES (85,018038,37,'leftover','irresponsibly','repetitions',''); INSERT INTO t2 VALUES (86,018039,37,'whiteners','luckily','Antares',''); INSERT INTO t2 VALUES (87,018040,37,'erases','culled','ventilate','W'); INSERT INTO t2 VALUES (88,018041,37,'Punjab','medical','pityingly',''); INSERT INTO t2 VALUES (89,018042,37,'Merritt','bloodbath','interdependent',''); INSERT INTO t2 VALUES (90,018043,37,'Quixotism','subschema','Graves','FAS'); INSERT INTO t2 VALUES (91,018044,37,'sweetish','animals','neonatal',''); INSERT INTO t2 VALUES (92,018045,37,'dogging','Micronesia','scribbled','FAS'); INSERT INTO t2 VALUES (93,018046,37,'scornfully','repetitions','chafe','W'); INSERT INTO t2 VALUES (94,018048,37,'bellow','Antares','honoring',''); INSERT INTO t2 VALUES (95,018049,37,'bills','ventilate','realtor',''); INSERT INTO t2 VALUES (96,018050,37,'cupboard','pityingly','elite',''); INSERT INTO t2 VALUES (97,018051,37,'sureties','interdependent','funereal',''); INSERT INTO t2 VALUES (98,018052,37,'puddings','Graves','abrogating',''); INSERT INTO t2 VALUES (99,018053,50,'tapestry','neonatal','sorters',''); INSERT INTO t2 VALUES (100,018054,37,'fetters','scribbled','Conley',''); INSERT INTO t2 VALUES (101,018055,37,'bivalves','chafe','lectured',''); INSERT INTO t2 VALUES (102,018056,37,'incurring','honoring','Abraham',''); INSERT INTO t2 VALUES (103,018057,37,'Adolph','realtor','Hawaii','W'); INSERT INTO t2 VALUES (104,018058,37,'pithed','elite','cage',''); INSERT INTO t2 VALUES (105,018059,36,'emergency','funereal','hushes',''); INSERT INTO t2 VALUES (106,018060,37,'Miles','abrogating','Simla',''); INSERT INTO t2 VALUES (107,018061,37,'trimmings','sorters','reporters',''); INSERT INTO t2 VALUES (108,018101,37,'tragedies','Conley','Dutchman','FAS'); INSERT INTO t2 VALUES (109,018102,37,'skulking','lectured','descendants','FAS'); INSERT INTO t2 VALUES (110,018103,37,'flint','Abraham','groupings','FAS'); INSERT INTO t2 VALUES (111,018104,37,'flopping','Hawaii','dissociate',''); INSERT INTO t2 VALUES (112,018201,37,'relaxing','cage','coexist','W'); INSERT INTO t2 VALUES (113,018202,37,'offload','hushes','Beebe',''); INSERT INTO t2 VALUES (114,018402,37,'suites','Simla','Taoism',''); INSERT INTO t2 VALUES (115,018403,37,'lists','reporters','Connally',''); INSERT INTO t2 VALUES (116,018404,37,'animized','Dutchman','fetched','FAS'); INSERT INTO t2 VALUES (117,018405,37,'multilayer','descendants','checkpoints','FAS'); INSERT INTO t2 VALUES (118,018406,37,'standardizes','groupings','rusting',''); INSERT INTO t2 VALUES (119,018409,37,'Judas','dissociate','galling',''); INSERT INTO t2 VALUES (120,018601,37,'vacuuming','coexist','obliterates',''); INSERT INTO t2 VALUES (121,018602,37,'dentally','Beebe','traitor',''); INSERT INTO t2 VALUES (122,018603,37,'humanness','Taoism','resumes','FAS'); INSERT INTO t2 VALUES (123,018801,37,'inch','Connally','analyzable','FAS'); INSERT INTO t2 VALUES (124,018802,37,'Weissmuller','fetched','terminator','FAS'); INSERT INTO t2 VALUES (125,018803,37,'irresponsibly','checkpoints','gritty','FAS'); INSERT INTO t2 VALUES (126,018804,37,'luckily','rusting','firearm','W'); INSERT INTO t2 VALUES (127,018805,37,'culled','galling','minima',''); INSERT INTO t2 VALUES (128,018806,37,'medical','obliterates','Selfridge',''); INSERT INTO t2 VALUES (129,018807,37,'bloodbath','traitor','disable',''); INSERT INTO t2 VALUES (130,018808,37,'subschema','resumes','witchcraft','W'); INSERT INTO t2 VALUES (131,018809,37,'animals','analyzable','betroth','W'); INSERT INTO t2 VALUES (132,018810,37,'Micronesia','terminator','Manhattanize',''); INSERT INTO t2 VALUES (133,018811,37,'repetitions','gritty','imprint',''); INSERT INTO t2 VALUES (134,018812,37,'Antares','firearm','peeked',''); INSERT INTO t2 VALUES (135,019101,37,'ventilate','minima','swelling',''); INSERT INTO t2 VALUES (136,019102,37,'pityingly','Selfridge','interrelationships','W'); INSERT INTO t2 VALUES (137,019103,37,'interdependent','disable','riser',''); INSERT INTO t2 VALUES (138,019201,37,'Graves','witchcraft','Gandhian','W'); INSERT INTO t2 VALUES (139,030501,37,'neonatal','betroth','peacock','A'); INSERT INTO t2 VALUES (140,030502,50,'scribbled','Manhattanize','bee','A'); INSERT INTO t2 VALUES (141,030503,37,'chafe','imprint','kanji',''); INSERT INTO t2 VALUES (142,030504,37,'honoring','peeked','dental',''); INSERT INTO t2 VALUES (143,031901,37,'realtor','swelling','scarf','FAS'); INSERT INTO t2 VALUES (144,036001,37,'elite','interrelationships','chasm','A'); INSERT INTO t2 VALUES (145,036002,37,'funereal','riser','insolence','A'); INSERT INTO t2 VALUES (146,036004,37,'abrogating','Gandhian','syndicate',''); INSERT INTO t2 VALUES (147,036005,37,'sorters','peacock','alike',''); INSERT INTO t2 VALUES (148,038001,37,'Conley','bee','imperial','A'); INSERT INTO t2 VALUES (149,038002,37,'lectured','kanji','convulsion','A'); INSERT INTO t2 VALUES (150,038003,37,'Abraham','dental','railway','A'); INSERT INTO t2 VALUES (151,038004,37,'Hawaii','scarf','validate','A'); INSERT INTO t2 VALUES (152,038005,37,'cage','chasm','normalizes','A'); INSERT INTO t2 VALUES (153,038006,37,'hushes','insolence','comprehensive',''); INSERT INTO t2 VALUES (154,038007,37,'Simla','syndicate','chewing',''); INSERT INTO t2 VALUES (155,038008,37,'reporters','alike','denizen',''); INSERT INTO t2 VALUES (156,038009,37,'Dutchman','imperial','schemer',''); INSERT INTO t2 VALUES (157,038010,37,'descendants','convulsion','chronicle',''); INSERT INTO t2 VALUES (158,038011,37,'groupings','railway','Kline',''); INSERT INTO t2 VALUES (159,038012,37,'dissociate','validate','Anatole',''); INSERT INTO t2 VALUES (160,038013,37,'coexist','normalizes','partridges',''); INSERT INTO t2 VALUES (161,038014,37,'Beebe','comprehensive','brunch',''); INSERT INTO t2 VALUES (162,038015,37,'Taoism','chewing','recruited',''); INSERT INTO t2 VALUES (163,038016,37,'Connally','denizen','dimensions','W'); INSERT INTO t2 VALUES (164,038017,37,'fetched','schemer','Chicana','W'); INSERT INTO t2 VALUES (165,038018,37,'checkpoints','chronicle','announced',''); INSERT INTO t2 VALUES (166,038101,37,'rusting','Kline','praised','FAS'); INSERT INTO t2 VALUES (167,038102,37,'galling','Anatole','employing',''); INSERT INTO t2 VALUES (168,038103,37,'obliterates','partridges','linear',''); INSERT INTO t2 VALUES (169,038104,37,'traitor','brunch','quagmire',''); INSERT INTO t2 VALUES (170,038201,37,'resumes','recruited','western','A'); INSERT INTO t2 VALUES (171,038202,37,'analyzable','dimensions','relishing',''); INSERT INTO t2 VALUES (172,038203,37,'terminator','Chicana','serving','A'); INSERT INTO t2 VALUES (173,038204,37,'gritty','announced','scheduling',''); INSERT INTO t2 VALUES (174,038205,37,'firearm','praised','lore',''); INSERT INTO t2 VALUES (175,038206,37,'minima','employing','eventful',''); INSERT INTO t2 VALUES (176,038208,37,'Selfridge','linear','arteriole','A'); INSERT INTO t2 VALUES (177,042801,37,'disable','quagmire','disentangle',''); INSERT INTO t2 VALUES (178,042802,37,'witchcraft','western','cured','A'); INSERT INTO t2 VALUES (179,046101,37,'betroth','relishing','Fenton','W'); INSERT INTO t2 VALUES (180,048001,37,'Manhattanize','serving','avoidable','A'); INSERT INTO t2 VALUES (181,048002,37,'imprint','scheduling','drains','A'); INSERT INTO t2 VALUES (182,048003,37,'peeked','lore','detectably','FAS'); INSERT INTO t2 VALUES (183,048004,37,'swelling','eventful','husky',''); INSERT INTO t2 VALUES (184,048005,37,'interrelationships','arteriole','impelling',''); INSERT INTO t2 VALUES (185,048006,37,'riser','disentangle','undoes',''); INSERT INTO t2 VALUES (186,048007,37,'Gandhian','cured','evened',''); INSERT INTO t2 VALUES (187,048008,37,'peacock','Fenton','squeezes',''); INSERT INTO t2 VALUES (188,048101,37,'bee','avoidable','destroyer','FAS'); INSERT INTO t2 VALUES (189,048102,37,'kanji','drains','rudeness',''); INSERT INTO t2 VALUES (190,048201,37,'dental','detectably','beaner','FAS'); INSERT INTO t2 VALUES (191,048202,37,'scarf','husky','boorish',''); INSERT INTO t2 VALUES (192,048203,37,'chasm','impelling','Everhart',''); INSERT INTO t2 VALUES (193,048204,37,'insolence','undoes','encompass','A'); INSERT INTO t2 VALUES (194,048205,37,'syndicate','evened','mushrooms',''); INSERT INTO t2 VALUES (195,048301,37,'alike','squeezes','Alison','A'); INSERT INTO t2 VALUES (196,048302,37,'imperial','destroyer','externally','FAS'); INSERT INTO t2 VALUES (197,048303,37,'convulsion','rudeness','pellagra',''); INSERT INTO t2 VALUES (198,048304,37,'railway','beaner','cult',''); INSERT INTO t2 VALUES (199,048305,37,'validate','boorish','creek','A'); INSERT INTO t2 VALUES (200,048401,37,'normalizes','Everhart','Huffman',''); INSERT INTO t2 VALUES (201,048402,37,'comprehensive','encompass','Majorca','FAS'); INSERT INTO t2 VALUES (202,048403,37,'chewing','mushrooms','governing','A'); INSERT INTO t2 VALUES (203,048404,37,'denizen','Alison','gadfly','FAS'); INSERT INTO t2 VALUES (204,048405,37,'schemer','externally','reassigned','FAS'); INSERT INTO t2 VALUES (205,048406,37,'chronicle','pellagra','intentness','W'); INSERT INTO t2 VALUES (206,048407,37,'Kline','cult','craziness',''); INSERT INTO t2 VALUES (207,048408,37,'Anatole','creek','psychic',''); INSERT INTO t2 VALUES (208,048409,37,'partridges','Huffman','squabbled',''); INSERT INTO t2 VALUES (209,048410,37,'brunch','Majorca','burlesque',''); INSERT INTO t2 VALUES (210,048411,37,'recruited','governing','capped',''); INSERT INTO t2 VALUES (211,048412,37,'dimensions','gadfly','extracted','A'); INSERT INTO t2 VALUES (212,048413,37,'Chicana','reassigned','DiMaggio',''); INSERT INTO t2 VALUES (213,048601,37,'announced','intentness','exclamation','FAS'); INSERT INTO t2 VALUES (214,048602,37,'praised','craziness','subdirectory',''); INSERT INTO t2 VALUES (215,048603,37,'employing','psychic','fangs',''); INSERT INTO t2 VALUES (216,048604,37,'linear','squabbled','buyer','A'); INSERT INTO t2 VALUES (217,048801,37,'quagmire','burlesque','pithing','A'); INSERT INTO t2 VALUES (218,050901,37,'western','capped','transistorizing','A'); INSERT INTO t2 VALUES (219,051201,37,'relishing','extracted','nonbiodegradable',''); INSERT INTO t2 VALUES (220,056002,37,'serving','DiMaggio','dislocate',''); INSERT INTO t2 VALUES (221,056003,37,'scheduling','exclamation','monochromatic','FAS'); INSERT INTO t2 VALUES (222,056004,37,'lore','subdirectory','batting',''); INSERT INTO t2 VALUES (223,056102,37,'eventful','fangs','postcondition','A'); INSERT INTO t2 VALUES (224,056203,37,'arteriole','buyer','catalog','FAS'); INSERT INTO t2 VALUES (225,056204,37,'disentangle','pithing','Remus',''); INSERT INTO t2 VALUES (226,058003,37,'cured','transistorizing','devices','A'); INSERT INTO t2 VALUES (227,058004,37,'Fenton','nonbiodegradable','bike','A'); INSERT INTO t2 VALUES (228,058005,37,'avoidable','dislocate','qualify',''); INSERT INTO t2 VALUES (229,058006,37,'drains','monochromatic','detained',''); INSERT INTO t2 VALUES (230,058007,37,'detectably','batting','commended',''); INSERT INTO t2 VALUES (231,058101,37,'husky','postcondition','civilize',''); INSERT INTO t2 VALUES (232,058102,37,'impelling','catalog','Elmhurst',''); INSERT INTO t2 VALUES (233,058103,37,'undoes','Remus','anesthetizing',''); INSERT INTO t2 VALUES (234,058105,37,'evened','devices','deaf',''); INSERT INTO t2 VALUES (235,058111,37,'squeezes','bike','Brigham',''); INSERT INTO t2 VALUES (236,058112,37,'destroyer','qualify','title',''); INSERT INTO t2 VALUES (237,058113,37,'rudeness','detained','coarse',''); INSERT INTO t2 VALUES (238,058114,37,'beaner','commended','combinations',''); INSERT INTO t2 VALUES (239,058115,37,'boorish','civilize','grayness',''); INSERT INTO t2 VALUES (240,058116,37,'Everhart','Elmhurst','innumerable','FAS'); INSERT INTO t2 VALUES (241,058117,37,'encompass','anesthetizing','Caroline','A'); INSERT INTO t2 VALUES (242,058118,37,'mushrooms','deaf','fatty','FAS'); INSERT INTO t2 VALUES (243,058119,37,'Alison','Brigham','eastbound',''); INSERT INTO t2 VALUES (244,058120,37,'externally','title','inexperienced',''); INSERT INTO t2 VALUES (245,058121,37,'pellagra','coarse','hoarder','A'); INSERT INTO t2 VALUES (246,058122,37,'cult','combinations','scotch','W'); INSERT INTO t2 VALUES (247,058123,37,'creek','grayness','passport','A'); INSERT INTO t2 VALUES (248,058124,37,'Huffman','innumerable','strategic','FAS'); INSERT INTO t2 VALUES (249,058125,37,'Majorca','Caroline','gated',''); INSERT INTO t2 VALUES (250,058126,37,'governing','fatty','flog',''); INSERT INTO t2 VALUES (251,058127,37,'gadfly','eastbound','Pipestone',''); INSERT INTO t2 VALUES (252,058128,37,'reassigned','inexperienced','Dar',''); INSERT INTO t2 VALUES (253,058201,37,'intentness','hoarder','Corcoran',''); INSERT INTO t2 VALUES (254,058202,37,'craziness','scotch','flyers','A'); INSERT INTO t2 VALUES (255,058303,37,'psychic','passport','competitions','W'); INSERT INTO t2 VALUES (256,058304,37,'squabbled','strategic','suppliers','FAS'); INSERT INTO t2 VALUES (257,058602,37,'burlesque','gated','skips',''); INSERT INTO t2 VALUES (258,058603,37,'capped','flog','institutes',''); INSERT INTO t2 VALUES (259,058604,37,'extracted','Pipestone','troop','A'); INSERT INTO t2 VALUES (260,058605,37,'DiMaggio','Dar','connective','W'); INSERT INTO t2 VALUES (261,058606,37,'exclamation','Corcoran','denies',''); INSERT INTO t2 VALUES (262,058607,37,'subdirectory','flyers','polka',''); INSERT INTO t2 VALUES (263,060401,36,'fangs','competitions','observations','FAS'); INSERT INTO t2 VALUES (264,061701,36,'buyer','suppliers','askers',''); INSERT INTO t2 VALUES (265,066201,36,'pithing','skips','homeless','FAS'); INSERT INTO t2 VALUES (266,066501,36,'transistorizing','institutes','Anna',''); INSERT INTO t2 VALUES (267,068001,36,'nonbiodegradable','troop','subdirectories','W'); INSERT INTO t2 VALUES (268,068002,36,'dislocate','connective','decaying','FAS'); INSERT INTO t2 VALUES (269,068005,36,'monochromatic','denies','outwitting','W'); INSERT INTO t2 VALUES (270,068006,36,'batting','polka','Harpy','W'); INSERT INTO t2 VALUES (271,068007,36,'postcondition','observations','crazed',''); INSERT INTO t2 VALUES (272,068008,36,'catalog','askers','suffocate',''); INSERT INTO t2 VALUES (273,068009,36,'Remus','homeless','provers','FAS'); INSERT INTO t2 VALUES (274,068010,36,'devices','Anna','technically',''); INSERT INTO t2 VALUES (275,068011,36,'bike','subdirectories','Franklinizations',''); INSERT INTO t2 VALUES (276,068202,36,'qualify','decaying','considered',''); INSERT INTO t2 VALUES (277,068302,36,'detained','outwitting','tinnily',''); INSERT INTO t2 VALUES (278,068303,36,'commended','Harpy','uninterruptedly',''); INSERT INTO t2 VALUES (279,068401,36,'civilize','crazed','whistled','A'); INSERT INTO t2 VALUES (280,068501,36,'Elmhurst','suffocate','automate',''); INSERT INTO t2 VALUES (281,068502,36,'anesthetizing','provers','gutting','W'); INSERT INTO t2 VALUES (282,068503,36,'deaf','technically','surreptitious',''); INSERT INTO t2 VALUES (283,068602,36,'Brigham','Franklinizations','Choctaw',''); INSERT INTO t2 VALUES (284,068603,36,'title','considered','cooks',''); INSERT INTO t2 VALUES (285,068701,36,'coarse','tinnily','millivolt','FAS'); INSERT INTO t2 VALUES (286,068702,36,'combinations','uninterruptedly','counterpoise',''); INSERT INTO t2 VALUES (287,068703,36,'grayness','whistled','Gothicism',''); INSERT INTO t2 VALUES (288,076001,36,'innumerable','automate','feminine',''); INSERT INTO t2 VALUES (289,076002,36,'Caroline','gutting','metaphysically','W'); INSERT INTO t2 VALUES (290,076101,36,'fatty','surreptitious','sanding','A'); INSERT INTO t2 VALUES (291,076102,36,'eastbound','Choctaw','contributorily',''); INSERT INTO t2 VALUES (292,076103,36,'inexperienced','cooks','receivers','FAS'); INSERT INTO t2 VALUES (293,076302,36,'hoarder','millivolt','adjourn',''); INSERT INTO t2 VALUES (294,076303,36,'scotch','counterpoise','straggled','A'); INSERT INTO t2 VALUES (295,076304,36,'passport','Gothicism','druggists',''); INSERT INTO t2 VALUES (296,076305,36,'strategic','feminine','thanking','FAS'); INSERT INTO t2 VALUES (297,076306,36,'gated','metaphysically','ostrich',''); INSERT INTO t2 VALUES (298,076307,36,'flog','sanding','hopelessness','FAS'); INSERT INTO t2 VALUES (299,076402,36,'Pipestone','contributorily','Eurydice',''); INSERT INTO t2 VALUES (300,076501,36,'Dar','receivers','excitation','W'); INSERT INTO t2 VALUES (301,076502,36,'Corcoran','adjourn','presumes','FAS'); INSERT INTO t2 VALUES (302,076701,36,'flyers','straggled','imaginable','FAS'); INSERT INTO t2 VALUES (303,078001,36,'competitions','druggists','concoct','W'); INSERT INTO t2 VALUES (304,078002,36,'suppliers','thanking','peering','W'); INSERT INTO t2 VALUES (305,078003,36,'skips','ostrich','Phelps','FAS'); INSERT INTO t2 VALUES (306,078004,36,'institutes','hopelessness','ferociousness','FAS'); INSERT INTO t2 VALUES (307,078005,36,'troop','Eurydice','sentences',''); INSERT INTO t2 VALUES (308,078006,36,'connective','excitation','unlocks',''); INSERT INTO t2 VALUES (309,078007,36,'denies','presumes','engrossing','W'); INSERT INTO t2 VALUES (310,078008,36,'polka','imaginable','Ruth',''); INSERT INTO t2 VALUES (311,078101,36,'observations','concoct','tying',''); INSERT INTO t2 VALUES (312,078103,36,'askers','peering','exclaimers',''); INSERT INTO t2 VALUES (313,078104,36,'homeless','Phelps','synergy',''); INSERT INTO t2 VALUES (314,078105,36,'Anna','ferociousness','Huey','W'); INSERT INTO t2 VALUES (315,082101,36,'subdirectories','sentences','merging',''); INSERT INTO t2 VALUES (316,083401,36,'decaying','unlocks','judges','A'); INSERT INTO t2 VALUES (317,084001,36,'outwitting','engrossing','Shylock','W'); INSERT INTO t2 VALUES (318,084002,36,'Harpy','Ruth','Miltonism',''); INSERT INTO t2 VALUES (319,086001,36,'crazed','tying','hen','W'); INSERT INTO t2 VALUES (320,086102,36,'suffocate','exclaimers','honeybee','FAS'); INSERT INTO t2 VALUES (321,086201,36,'provers','synergy','towers',''); INSERT INTO t2 VALUES (322,088001,36,'technically','Huey','dilutes','W'); INSERT INTO t2 VALUES (323,088002,36,'Franklinizations','merging','numerals','FAS'); INSERT INTO t2 VALUES (324,088003,36,'considered','judges','democracy','FAS'); INSERT INTO t2 VALUES (325,088004,36,'tinnily','Shylock','Ibero-',''); INSERT INTO t2 VALUES (326,088101,36,'uninterruptedly','Miltonism','invalids',''); INSERT INTO t2 VALUES (327,088102,36,'whistled','hen','behavior',''); INSERT INTO t2 VALUES (328,088103,36,'automate','honeybee','accruing',''); INSERT INTO t2 VALUES (329,088104,36,'gutting','towers','relics','A'); INSERT INTO t2 VALUES (330,088105,36,'surreptitious','dilutes','rackets',''); INSERT INTO t2 VALUES (331,088106,36,'Choctaw','numerals','Fischbein','W'); INSERT INTO t2 VALUES (332,088201,36,'cooks','democracy','phony','W'); INSERT INTO t2 VALUES (333,088203,36,'millivolt','Ibero-','cross','FAS'); INSERT INTO t2 VALUES (334,088204,36,'counterpoise','invalids','cleanup',''); INSERT INTO t2 VALUES (335,088302,37,'Gothicism','behavior','conspirator',''); INSERT INTO t2 VALUES (336,088303,37,'feminine','accruing','label','FAS'); INSERT INTO t2 VALUES (337,088305,37,'metaphysically','relics','university',''); INSERT INTO t2 VALUES (338,088402,37,'sanding','rackets','cleansed','FAS'); INSERT INTO t2 VALUES (339,088501,36,'contributorily','Fischbein','ballgown',''); INSERT INTO t2 VALUES (340,088502,36,'receivers','phony','starlet',''); INSERT INTO t2 VALUES (341,088503,36,'adjourn','cross','aqueous',''); INSERT INTO t2 VALUES (342,098001,58,'straggled','cleanup','portrayal','A'); INSERT INTO t2 VALUES (343,098002,58,'druggists','conspirator','despising','W'); INSERT INTO t2 VALUES (344,098003,58,'thanking','label','distort','W'); INSERT INTO t2 VALUES (345,098004,58,'ostrich','university','palmed',''); INSERT INTO t2 VALUES (346,098005,58,'hopelessness','cleansed','faced',''); INSERT INTO t2 VALUES (347,098006,58,'Eurydice','ballgown','silverware',''); INSERT INTO t2 VALUES (348,141903,29,'excitation','starlet','assessor',''); INSERT INTO t2 VALUES (349,098008,58,'presumes','aqueous','spiders',''); INSERT INTO t2 VALUES (350,098009,58,'imaginable','portrayal','artificially',''); INSERT INTO t2 VALUES (351,098010,58,'concoct','despising','reminiscence',''); INSERT INTO t2 VALUES (352,098011,58,'peering','distort','Mexican',''); INSERT INTO t2 VALUES (353,098012,58,'Phelps','palmed','obnoxious',''); INSERT INTO t2 VALUES (354,098013,58,'ferociousness','faced','fragile',''); INSERT INTO t2 VALUES (355,098014,58,'sentences','silverware','apprehensible',''); INSERT INTO t2 VALUES (356,098015,58,'unlocks','assessor','births',''); INSERT INTO t2 VALUES (357,098016,58,'engrossing','spiders','garages',''); INSERT INTO t2 VALUES (358,098017,58,'Ruth','artificially','panty',''); INSERT INTO t2 VALUES (359,098018,58,'tying','reminiscence','anteater',''); INSERT INTO t2 VALUES (360,098019,58,'exclaimers','Mexican','displacement','A'); INSERT INTO t2 VALUES (361,098020,58,'synergy','obnoxious','drovers','A'); INSERT INTO t2 VALUES (362,098021,58,'Huey','fragile','patenting','A'); INSERT INTO t2 VALUES (363,098022,58,'merging','apprehensible','far','A'); INSERT INTO t2 VALUES (364,098023,58,'judges','births','shrieks',''); INSERT INTO t2 VALUES (365,098024,58,'Shylock','garages','aligning','W'); INSERT INTO t2 VALUES (366,098025,37,'Miltonism','panty','pragmatism',''); INSERT INTO t2 VALUES (367,106001,36,'hen','anteater','fevers','W'); INSERT INTO t2 VALUES (368,108001,36,'honeybee','displacement','reexamines','A'); INSERT INTO t2 VALUES (369,108002,36,'towers','drovers','occupancies',''); INSERT INTO t2 VALUES (370,108003,36,'dilutes','patenting','sweats','FAS'); INSERT INTO t2 VALUES (371,108004,36,'numerals','far','modulators',''); INSERT INTO t2 VALUES (372,108005,36,'democracy','shrieks','demand','W'); INSERT INTO t2 VALUES (373,108007,36,'Ibero-','aligning','Madeira',''); INSERT INTO t2 VALUES (374,108008,36,'invalids','pragmatism','Viennese','W'); INSERT INTO t2 VALUES (375,108009,36,'behavior','fevers','chillier','W'); INSERT INTO t2 VALUES (376,108010,36,'accruing','reexamines','wildcats','FAS'); INSERT INTO t2 VALUES (377,108011,36,'relics','occupancies','gentle',''); INSERT INTO t2 VALUES (378,108012,36,'rackets','sweats','Angles','W'); INSERT INTO t2 VALUES (379,108101,36,'Fischbein','modulators','accuracies',''); INSERT INTO t2 VALUES (380,108102,36,'phony','demand','toggle',''); INSERT INTO t2 VALUES (381,108103,36,'cross','Madeira','Mendelssohn','W'); INSERT INTO t2 VALUES (382,108111,50,'cleanup','Viennese','behaviorally',''); INSERT INTO t2 VALUES (383,108105,36,'conspirator','chillier','Rochford',''); INSERT INTO t2 VALUES (384,108106,36,'label','wildcats','mirror','W'); INSERT INTO t2 VALUES (385,108107,36,'university','gentle','Modula',''); INSERT INTO t2 VALUES (386,108108,50,'cleansed','Angles','clobbering',''); INSERT INTO t2 VALUES (387,108109,36,'ballgown','accuracies','chronography',''); INSERT INTO t2 VALUES (388,108110,36,'starlet','toggle','Eskimoizeds',''); INSERT INTO t2 VALUES (389,108201,36,'aqueous','Mendelssohn','British','W'); INSERT INTO t2 VALUES (390,108202,36,'portrayal','behaviorally','pitfalls',''); INSERT INTO t2 VALUES (391,108203,36,'despising','Rochford','verify','W'); INSERT INTO t2 VALUES (392,108204,36,'distort','mirror','scatter','FAS'); INSERT INTO t2 VALUES (393,108205,36,'palmed','Modula','Aztecan',''); INSERT INTO t2 VALUES (394,108301,36,'faced','clobbering','acuity','W'); INSERT INTO t2 VALUES (395,108302,36,'silverware','chronography','sinking','W'); INSERT INTO t2 VALUES (396,112101,36,'assessor','Eskimoizeds','beasts','FAS'); INSERT INTO t2 VALUES (397,112102,36,'spiders','British','Witt','W'); INSERT INTO t2 VALUES (398,113701,36,'artificially','pitfalls','physicists','FAS'); INSERT INTO t2 VALUES (399,116001,36,'reminiscence','verify','folksong','A'); INSERT INTO t2 VALUES (400,116201,36,'Mexican','scatter','strokes','FAS'); INSERT INTO t2 VALUES (401,116301,36,'obnoxious','Aztecan','crowder',''); INSERT INTO t2 VALUES (402,116302,36,'fragile','acuity','merry',''); INSERT INTO t2 VALUES (403,116601,36,'apprehensible','sinking','cadenced',''); INSERT INTO t2 VALUES (404,116602,36,'births','beasts','alimony','A'); INSERT INTO t2 VALUES (405,116603,36,'garages','Witt','principled','A'); INSERT INTO t2 VALUES (406,116701,36,'panty','physicists','golfing',''); INSERT INTO t2 VALUES (407,116702,36,'anteater','folksong','undiscovered',''); INSERT INTO t2 VALUES (408,118001,36,'displacement','strokes','irritates',''); INSERT INTO t2 VALUES (409,118002,36,'drovers','crowder','patriots','A'); INSERT INTO t2 VALUES (410,118003,36,'patenting','merry','rooms','FAS'); INSERT INTO t2 VALUES (411,118004,36,'far','cadenced','towering','W'); INSERT INTO t2 VALUES (412,118005,36,'shrieks','alimony','displease',''); INSERT INTO t2 VALUES (413,118006,36,'aligning','principled','photosensitive',''); INSERT INTO t2 VALUES (414,118007,36,'pragmatism','golfing','inking',''); INSERT INTO t2 VALUES (415,118008,36,'fevers','undiscovered','gainers',''); INSERT INTO t2 VALUES (416,118101,36,'reexamines','irritates','leaning','A'); INSERT INTO t2 VALUES (417,118102,36,'occupancies','patriots','hydrant','A'); INSERT INTO t2 VALUES (418,118103,36,'sweats','rooms','preserve',''); INSERT INTO t2 VALUES (419,118202,36,'modulators','towering','blinded','A'); INSERT INTO t2 VALUES (420,118203,36,'demand','displease','interactions','A'); INSERT INTO t2 VALUES (421,118204,36,'Madeira','photosensitive','Barry',''); INSERT INTO t2 VALUES (422,118302,36,'Viennese','inking','whiteness','A'); INSERT INTO t2 VALUES (423,118304,36,'chillier','gainers','pastimes','W'); INSERT INTO t2 VALUES (424,118305,36,'wildcats','leaning','Edenization',''); INSERT INTO t2 VALUES (425,118306,36,'gentle','hydrant','Muscat',''); INSERT INTO t2 VALUES (426,118307,36,'Angles','preserve','assassinated',''); INSERT INTO t2 VALUES (427,123101,36,'accuracies','blinded','labeled',''); INSERT INTO t2 VALUES (428,123102,36,'toggle','interactions','glacial','A'); INSERT INTO t2 VALUES (429,123301,36,'Mendelssohn','Barry','implied','W'); INSERT INTO t2 VALUES (430,126001,36,'behaviorally','whiteness','bibliographies','W'); INSERT INTO t2 VALUES (431,126002,36,'Rochford','pastimes','Buchanan',''); INSERT INTO t2 VALUES (432,126003,36,'mirror','Edenization','forgivably','FAS'); INSERT INTO t2 VALUES (433,126101,36,'Modula','Muscat','innuendo','A'); INSERT INTO t2 VALUES (434,126301,36,'clobbering','assassinated','den','FAS'); INSERT INTO t2 VALUES (435,126302,36,'chronography','labeled','submarines','W'); INSERT INTO t2 VALUES (436,126402,36,'Eskimoizeds','glacial','mouthful','A'); INSERT INTO t2 VALUES (437,126601,36,'British','implied','expiring',''); INSERT INTO t2 VALUES (438,126602,36,'pitfalls','bibliographies','unfulfilled','FAS'); INSERT INTO t2 VALUES (439,126702,36,'verify','Buchanan','precession',''); INSERT INTO t2 VALUES (440,128001,36,'scatter','forgivably','nullified',''); INSERT INTO t2 VALUES (441,128002,36,'Aztecan','innuendo','affects',''); INSERT INTO t2 VALUES (442,128003,36,'acuity','den','Cynthia',''); INSERT INTO t2 VALUES (443,128004,36,'sinking','submarines','Chablis','A'); INSERT INTO t2 VALUES (444,128005,36,'beasts','mouthful','betterments','FAS'); INSERT INTO t2 VALUES (445,128007,36,'Witt','expiring','advertising',''); INSERT INTO t2 VALUES (446,128008,36,'physicists','unfulfilled','rubies','A'); INSERT INTO t2 VALUES (447,128009,36,'folksong','precession','southwest','FAS'); INSERT INTO t2 VALUES (448,128010,36,'strokes','nullified','superstitious','A'); INSERT INTO t2 VALUES (449,128011,36,'crowder','affects','tabernacle','W'); INSERT INTO t2 VALUES (450,128012,36,'merry','Cynthia','silk','A'); INSERT INTO t2 VALUES (451,128013,36,'cadenced','Chablis','handsomest','A'); INSERT INTO t2 VALUES (452,128014,36,'alimony','betterments','Persian','A'); INSERT INTO t2 VALUES (453,128015,36,'principled','advertising','analog','W'); INSERT INTO t2 VALUES (454,128016,36,'golfing','rubies','complex','W'); INSERT INTO t2 VALUES (455,128017,36,'undiscovered','southwest','Taoist',''); INSERT INTO t2 VALUES (456,128018,36,'irritates','superstitious','suspend',''); INSERT INTO t2 VALUES (457,128019,36,'patriots','tabernacle','relegated',''); INSERT INTO t2 VALUES (458,128020,36,'rooms','silk','awesome','W'); INSERT INTO t2 VALUES (459,128021,36,'towering','handsomest','Bruxelles',''); INSERT INTO t2 VALUES (460,128022,36,'displease','Persian','imprecisely','A'); INSERT INTO t2 VALUES (461,128023,36,'photosensitive','analog','televise',''); INSERT INTO t2 VALUES (462,128101,36,'inking','complex','braking',''); INSERT INTO t2 VALUES (463,128102,36,'gainers','Taoist','true','FAS'); INSERT INTO t2 VALUES (464,128103,36,'leaning','suspend','disappointing','FAS'); INSERT INTO t2 VALUES (465,128104,36,'hydrant','relegated','navally','W'); INSERT INTO t2 VALUES (466,128106,36,'preserve','awesome','circus',''); INSERT INTO t2 VALUES (467,128107,36,'blinded','Bruxelles','beetles',''); INSERT INTO t2 VALUES (468,128108,36,'interactions','imprecisely','trumps',''); INSERT INTO t2 VALUES (469,128202,36,'Barry','televise','fourscore','W'); INSERT INTO t2 VALUES (470,128203,36,'whiteness','braking','Blackfoots',''); INSERT INTO t2 VALUES (471,128301,36,'pastimes','true','Grady',''); INSERT INTO t2 VALUES (472,128302,36,'Edenization','disappointing','quiets','FAS'); INSERT INTO t2 VALUES (473,128303,36,'Muscat','navally','floundered','FAS'); INSERT INTO t2 VALUES (474,128304,36,'assassinated','circus','profundity','W'); INSERT INTO t2 VALUES (475,128305,36,'labeled','beetles','Garrisonian','W'); INSERT INTO t2 VALUES (476,128307,36,'glacial','trumps','Strauss',''); INSERT INTO t2 VALUES (477,128401,36,'implied','fourscore','cemented','FAS'); INSERT INTO t2 VALUES (478,128502,36,'bibliographies','Blackfoots','contrition','A'); INSERT INTO t2 VALUES (479,128503,36,'Buchanan','Grady','mutations',''); INSERT INTO t2 VALUES (480,128504,36,'forgivably','quiets','exhibits','W'); INSERT INTO t2 VALUES (481,128505,36,'innuendo','floundered','tits',''); INSERT INTO t2 VALUES (482,128601,36,'den','profundity','mate','A'); INSERT INTO t2 VALUES (483,128603,36,'submarines','Garrisonian','arches',''); INSERT INTO t2 VALUES (484,128604,36,'mouthful','Strauss','Moll',''); INSERT INTO t2 VALUES (485,128702,36,'expiring','cemented','ropers',''); INSERT INTO t2 VALUES (486,128703,36,'unfulfilled','contrition','bombast',''); INSERT INTO t2 VALUES (487,128704,36,'precession','mutations','difficultly','A'); INSERT INTO t2 VALUES (488,138001,36,'nullified','exhibits','adsorption',''); INSERT INTO t2 VALUES (489,138002,36,'affects','tits','definiteness','FAS'); INSERT INTO t2 VALUES (490,138003,36,'Cynthia','mate','cultivation','A'); INSERT INTO t2 VALUES (491,138004,36,'Chablis','arches','heals','A'); INSERT INTO t2 VALUES (492,138005,36,'betterments','Moll','Heusen','W'); INSERT INTO t2 VALUES (493,138006,36,'advertising','ropers','target','FAS'); INSERT INTO t2 VALUES (494,138007,36,'rubies','bombast','cited','A'); INSERT INTO t2 VALUES (495,138008,36,'southwest','difficultly','congresswoman','W'); INSERT INTO t2 VALUES (496,138009,36,'superstitious','adsorption','Katherine',''); INSERT INTO t2 VALUES (497,138102,36,'tabernacle','definiteness','titter','A'); INSERT INTO t2 VALUES (498,138103,36,'silk','cultivation','aspire','A'); INSERT INTO t2 VALUES (499,138104,36,'handsomest','heals','Mardis',''); INSERT INTO t2 VALUES (500,138105,36,'Persian','Heusen','Nadia','W'); INSERT INTO t2 VALUES (501,138201,36,'analog','target','estimating','FAS'); INSERT INTO t2 VALUES (502,138302,36,'complex','cited','stuck','A'); INSERT INTO t2 VALUES (503,138303,36,'Taoist','congresswoman','fifteenth','A'); INSERT INTO t2 VALUES (504,138304,36,'suspend','Katherine','Colombo',''); INSERT INTO t2 VALUES (505,138401,29,'relegated','titter','survey','A'); INSERT INTO t2 VALUES (506,140102,29,'awesome','aspire','staffing',''); INSERT INTO t2 VALUES (507,140103,29,'Bruxelles','Mardis','obtain',''); INSERT INTO t2 VALUES (508,140104,29,'imprecisely','Nadia','loaded',''); INSERT INTO t2 VALUES (509,140105,29,'televise','estimating','slaughtered',''); INSERT INTO t2 VALUES (510,140201,29,'braking','stuck','lights','A'); INSERT INTO t2 VALUES (511,140701,29,'true','fifteenth','circumference',''); INSERT INTO t2 VALUES (512,141501,29,'disappointing','Colombo','dull','A'); INSERT INTO t2 VALUES (513,141502,29,'navally','survey','weekly','A'); INSERT INTO t2 VALUES (514,141901,29,'circus','staffing','wetness',''); INSERT INTO t2 VALUES (515,141902,29,'beetles','obtain','visualized',''); INSERT INTO t2 VALUES (516,142101,29,'trumps','loaded','Tannenbaum',''); INSERT INTO t2 VALUES (517,142102,29,'fourscore','slaughtered','moribund',''); INSERT INTO t2 VALUES (518,142103,29,'Blackfoots','lights','demultiplex',''); INSERT INTO t2 VALUES (519,142701,29,'Grady','circumference','lockings',''); INSERT INTO t2 VALUES (520,143001,29,'quiets','dull','thugs','FAS'); INSERT INTO t2 VALUES (521,143501,29,'floundered','weekly','unnerves',''); INSERT INTO t2 VALUES (522,143502,29,'profundity','wetness','abut',''); INSERT INTO t2 VALUES (523,148001,29,'Garrisonian','visualized','Chippewa','A'); INSERT INTO t2 VALUES (524,148002,29,'Strauss','Tannenbaum','stratifications','A'); INSERT INTO t2 VALUES (525,148003,29,'cemented','moribund','signaled',''); INSERT INTO t2 VALUES (526,148004,29,'contrition','demultiplex','Italianizes','A'); INSERT INTO t2 VALUES (527,148005,29,'mutations','lockings','algorithmic','A'); INSERT INTO t2 VALUES (528,148006,29,'exhibits','thugs','paranoid','FAS'); INSERT INTO t2 VALUES (529,148007,29,'tits','unnerves','camping','A'); INSERT INTO t2 VALUES (530,148009,29,'mate','abut','signifying','A'); INSERT INTO t2 VALUES (531,148010,29,'arches','Chippewa','Patrice','W'); INSERT INTO t2 VALUES (532,148011,29,'Moll','stratifications','search','A'); INSERT INTO t2 VALUES (533,148012,29,'ropers','signaled','Angeles','A'); INSERT INTO t2 VALUES (534,148013,29,'bombast','Italianizes','semblance',''); INSERT INTO t2 VALUES (535,148023,36,'difficultly','algorithmic','taxed',''); INSERT INTO t2 VALUES (536,148015,29,'adsorption','paranoid','Beatrice',''); INSERT INTO t2 VALUES (537,148016,29,'definiteness','camping','retrace',''); INSERT INTO t2 VALUES (538,148017,29,'cultivation','signifying','lockout',''); INSERT INTO t2 VALUES (539,148018,29,'heals','Patrice','grammatic',''); INSERT INTO t2 VALUES (540,148019,29,'Heusen','search','helmsman',''); INSERT INTO t2 VALUES (541,148020,29,'target','Angeles','uniform','W'); INSERT INTO t2 VALUES (542,148021,29,'cited','semblance','hamming',''); INSERT INTO t2 VALUES (543,148022,29,'congresswoman','taxed','disobedience',''); INSERT INTO t2 VALUES (544,148101,29,'Katherine','Beatrice','captivated','A'); INSERT INTO t2 VALUES (545,148102,29,'titter','retrace','transferals','A'); INSERT INTO t2 VALUES (546,148201,29,'aspire','lockout','cartographer','A'); INSERT INTO t2 VALUES (547,148401,29,'Mardis','grammatic','aims','FAS'); INSERT INTO t2 VALUES (548,148402,29,'Nadia','helmsman','Pakistani',''); INSERT INTO t2 VALUES (549,148501,29,'estimating','uniform','burglarized','FAS'); INSERT INTO t2 VALUES (550,148502,29,'stuck','hamming','saucepans','A'); INSERT INTO t2 VALUES (551,148503,29,'fifteenth','disobedience','lacerating','A'); INSERT INTO t2 VALUES (552,148504,29,'Colombo','captivated','corny',''); INSERT INTO t2 VALUES (553,148601,29,'survey','transferals','megabytes','FAS'); INSERT INTO t2 VALUES (554,148602,29,'staffing','cartographer','chancellor',''); INSERT INTO t2 VALUES (555,150701,29,'obtain','aims','bulk','A'); INSERT INTO t2 VALUES (556,152101,29,'loaded','Pakistani','commits','A'); INSERT INTO t2 VALUES (557,152102,29,'slaughtered','burglarized','meson','W'); INSERT INTO t2 VALUES (558,155202,36,'lights','saucepans','deputies',''); INSERT INTO t2 VALUES (559,155203,29,'circumference','lacerating','northeaster','A'); INSERT INTO t2 VALUES (560,155204,29,'dull','corny','dipole',''); INSERT INTO t2 VALUES (561,155205,29,'weekly','megabytes','machining','0'); INSERT INTO t2 VALUES (562,156001,29,'wetness','chancellor','therefore',''); INSERT INTO t2 VALUES (563,156002,29,'visualized','bulk','Telefunken',''); INSERT INTO t2 VALUES (564,156102,29,'Tannenbaum','commits','salvaging',''); INSERT INTO t2 VALUES (565,156301,29,'moribund','meson','Corinthianizes','A'); INSERT INTO t2 VALUES (566,156302,29,'demultiplex','deputies','restlessly','A'); INSERT INTO t2 VALUES (567,156303,29,'lockings','northeaster','bromides',''); INSERT INTO t2 VALUES (568,156304,29,'thugs','dipole','generalized','A'); INSERT INTO t2 VALUES (569,156305,29,'unnerves','machining','mishaps',''); INSERT INTO t2 VALUES (570,156306,29,'abut','therefore','quelling',''); INSERT INTO t2 VALUES (571,156501,29,'Chippewa','Telefunken','spiritual','A'); INSERT INTO t2 VALUES (572,158001,29,'stratifications','salvaging','beguiles','FAS'); INSERT INTO t2 VALUES (573,158002,29,'signaled','Corinthianizes','Trobriand','FAS'); INSERT INTO t2 VALUES (574,158101,29,'Italianizes','restlessly','fleeing','A'); INSERT INTO t2 VALUES (575,158102,29,'algorithmic','bromides','Armour','A'); INSERT INTO t2 VALUES (576,158103,29,'paranoid','generalized','chin','A'); INSERT INTO t2 VALUES (577,158201,29,'camping','mishaps','provers','A'); INSERT INTO t2 VALUES (578,158202,29,'signifying','quelling','aeronautic','A'); INSERT INTO t2 VALUES (579,158203,29,'Patrice','spiritual','voltage','W'); INSERT INTO t2 VALUES (580,158204,29,'search','beguiles','sash',''); INSERT INTO t2 VALUES (581,158301,29,'Angeles','Trobriand','anaerobic','A'); INSERT INTO t2 VALUES (582,158302,29,'semblance','fleeing','simultaneous','A'); INSERT INTO t2 VALUES (583,158303,29,'taxed','Armour','accumulating','A'); INSERT INTO t2 VALUES (584,158304,29,'Beatrice','chin','Medusan','A'); INSERT INTO t2 VALUES (585,158305,29,'retrace','provers','shouted','A'); INSERT INTO t2 VALUES (586,158306,29,'lockout','aeronautic','freakish',''); INSERT INTO t2 VALUES (587,158501,29,'grammatic','voltage','index','FAS'); INSERT INTO t2 VALUES (588,160301,29,'helmsman','sash','commercially',''); INSERT INTO t2 VALUES (589,166101,50,'uniform','anaerobic','mistiness','A'); INSERT INTO t2 VALUES (590,166102,50,'hamming','simultaneous','endpoint',''); INSERT INTO t2 VALUES (591,168001,29,'disobedience','accumulating','straight','A'); INSERT INTO t2 VALUES (592,168002,29,'captivated','Medusan','flurried',''); INSERT INTO t2 VALUES (593,168003,29,'transferals','shouted','denotative','A'); INSERT INTO t2 VALUES (594,168101,29,'cartographer','freakish','coming','FAS'); INSERT INTO t2 VALUES (595,168102,29,'aims','index','commencements','FAS'); INSERT INTO t2 VALUES (596,168103,29,'Pakistani','commercially','gentleman',''); INSERT INTO t2 VALUES (597,168104,29,'burglarized','mistiness','gifted',''); INSERT INTO t2 VALUES (598,168202,29,'saucepans','endpoint','Shanghais',''); INSERT INTO t2 VALUES (599,168301,29,'lacerating','straight','sportswriting','A'); INSERT INTO t2 VALUES (600,168502,29,'corny','flurried','sloping','A'); INSERT INTO t2 VALUES (601,168503,29,'megabytes','denotative','navies',''); INSERT INTO t2 VALUES (602,168601,29,'chancellor','coming','leaflet','A'); INSERT INTO t2 VALUES (603,173001,40,'bulk','commencements','shooter',''); INSERT INTO t2 VALUES (604,173701,40,'commits','gentleman','Joplin','FAS'); INSERT INTO t2 VALUES (605,173702,40,'meson','gifted','babies',''); INSERT INTO t2 VALUES (606,176001,40,'deputies','Shanghais','subdivision','FAS'); INSERT INTO t2 VALUES (607,176101,40,'northeaster','sportswriting','burstiness','W'); INSERT INTO t2 VALUES (608,176201,40,'dipole','sloping','belted','FAS'); INSERT INTO t2 VALUES (609,176401,40,'machining','navies','assails','FAS'); INSERT INTO t2 VALUES (610,176501,40,'therefore','leaflet','admiring','W'); INSERT INTO t2 VALUES (611,176601,40,'Telefunken','shooter','swaying','0'); INSERT INTO t2 VALUES (612,176602,40,'salvaging','Joplin','Goldstine','FAS'); INSERT INTO t2 VALUES (613,176603,40,'Corinthianizes','babies','fitting',''); INSERT INTO t2 VALUES (614,178001,40,'restlessly','subdivision','Norwalk','W'); INSERT INTO t2 VALUES (615,178002,40,'bromides','burstiness','weakening','W'); INSERT INTO t2 VALUES (616,178003,40,'generalized','belted','analogy','FAS'); INSERT INTO t2 VALUES (617,178004,40,'mishaps','assails','deludes',''); INSERT INTO t2 VALUES (618,178005,40,'quelling','admiring','cokes',''); INSERT INTO t2 VALUES (619,178006,40,'spiritual','swaying','Clayton',''); INSERT INTO t2 VALUES (620,178007,40,'beguiles','Goldstine','exhausts',''); INSERT INTO t2 VALUES (621,178008,40,'Trobriand','fitting','causality',''); INSERT INTO t2 VALUES (622,178101,40,'fleeing','Norwalk','sating','FAS'); INSERT INTO t2 VALUES (623,178102,40,'Armour','weakening','icon',''); INSERT INTO t2 VALUES (624,178103,40,'chin','analogy','throttles',''); INSERT INTO t2 VALUES (625,178201,40,'provers','deludes','communicants','FAS'); INSERT INTO t2 VALUES (626,178202,40,'aeronautic','cokes','dehydrate','FAS'); INSERT INTO t2 VALUES (627,178301,40,'voltage','Clayton','priceless','FAS'); INSERT INTO t2 VALUES (628,178302,40,'sash','exhausts','publicly',''); INSERT INTO t2 VALUES (629,178401,40,'anaerobic','causality','incidentals','FAS'); INSERT INTO t2 VALUES (630,178402,40,'simultaneous','sating','commonplace',''); INSERT INTO t2 VALUES (631,178403,40,'accumulating','icon','mumbles',''); INSERT INTO t2 VALUES (632,178404,40,'Medusan','throttles','furthermore','W'); INSERT INTO t2 VALUES (633,178501,40,'shouted','communicants','cautioned','W'); INSERT INTO t2 VALUES (634,186002,37,'freakish','dehydrate','parametrized','A'); INSERT INTO t2 VALUES (635,186102,37,'index','priceless','registration','A'); INSERT INTO t2 VALUES (636,186201,40,'commercially','publicly','sadly','FAS'); INSERT INTO t2 VALUES (637,186202,40,'mistiness','incidentals','positioning',''); INSERT INTO t2 VALUES (638,186203,40,'endpoint','commonplace','babysitting',''); INSERT INTO t2 VALUES (639,186302,37,'straight','mumbles','eternal','A'); INSERT INTO t2 VALUES (640,188007,37,'flurried','furthermore','hoarder',''); INSERT INTO t2 VALUES (641,188008,37,'denotative','cautioned','congregates',''); INSERT INTO t2 VALUES (642,188009,37,'coming','parametrized','rains',''); INSERT INTO t2 VALUES (643,188010,37,'commencements','registration','workers','W'); INSERT INTO t2 VALUES (644,188011,37,'gentleman','sadly','sags','A'); INSERT INTO t2 VALUES (645,188012,37,'gifted','positioning','unplug','W'); INSERT INTO t2 VALUES (646,188013,37,'Shanghais','babysitting','garage','A'); INSERT INTO t2 VALUES (647,188014,37,'sportswriting','eternal','boulder','A'); INSERT INTO t2 VALUES (648,188015,37,'sloping','hoarder','hollowly','A'); INSERT INTO t2 VALUES (649,188016,37,'navies','congregates','specifics',''); INSERT INTO t2 VALUES (650,188017,37,'leaflet','rains','Teresa',''); INSERT INTO t2 VALUES (651,188102,37,'shooter','workers','Winsett',''); INSERT INTO t2 VALUES (652,188103,37,'Joplin','sags','convenient','A'); INSERT INTO t2 VALUES (653,188202,37,'babies','unplug','buckboards','FAS'); INSERT INTO t2 VALUES (654,188301,40,'subdivision','garage','amenities',''); INSERT INTO t2 VALUES (655,188302,40,'burstiness','boulder','resplendent','FAS'); INSERT INTO t2 VALUES (656,188303,40,'belted','hollowly','priding','FAS'); INSERT INTO t2 VALUES (657,188401,37,'assails','specifics','configurations',''); INSERT INTO t2 VALUES (658,188402,37,'admiring','Teresa','untidiness','A'); INSERT INTO t2 VALUES (659,188503,37,'swaying','Winsett','Brice','W'); INSERT INTO t2 VALUES (660,188504,37,'Goldstine','convenient','sews','FAS'); INSERT INTO t2 VALUES (661,188505,37,'fitting','buckboards','participated',''); INSERT INTO t2 VALUES (662,190701,37,'Norwalk','amenities','Simon','FAS'); INSERT INTO t2 VALUES (663,190703,50,'weakening','resplendent','certificates',''); INSERT INTO t2 VALUES (664,191701,37,'analogy','priding','Fitzpatrick',''); INSERT INTO t2 VALUES (665,191702,37,'deludes','configurations','Evanston','A'); INSERT INTO t2 VALUES (666,191703,37,'cokes','untidiness','misted',''); INSERT INTO t2 VALUES (667,196001,37,'Clayton','Brice','textures','A'); INSERT INTO t2 VALUES (668,196002,37,'exhausts','sews','save',''); INSERT INTO t2 VALUES (669,196003,37,'causality','participated','count',''); INSERT INTO t2 VALUES (670,196101,37,'sating','Simon','rightful','A'); INSERT INTO t2 VALUES (671,196103,37,'icon','certificates','chaperone',''); INSERT INTO t2 VALUES (672,196104,37,'throttles','Fitzpatrick','Lizzy','A'); INSERT INTO t2 VALUES (673,196201,37,'communicants','Evanston','clenched','A'); INSERT INTO t2 VALUES (674,196202,37,'dehydrate','misted','effortlessly',''); INSERT INTO t2 VALUES (675,196203,37,'priceless','textures','accessed',''); INSERT INTO t2 VALUES (676,198001,37,'publicly','save','beaters','A'); INSERT INTO t2 VALUES (677,198003,37,'incidentals','count','Hornblower','FAS'); INSERT INTO t2 VALUES (678,198004,37,'commonplace','rightful','vests','A'); INSERT INTO t2 VALUES (679,198005,37,'mumbles','chaperone','indulgences','FAS'); INSERT INTO t2 VALUES (680,198006,37,'furthermore','Lizzy','infallibly','A'); INSERT INTO t2 VALUES (681,198007,37,'cautioned','clenched','unwilling','FAS'); INSERT INTO t2 VALUES (682,198008,37,'parametrized','effortlessly','excrete','FAS'); INSERT INTO t2 VALUES (683,198009,37,'registration','accessed','spools','A'); INSERT INTO t2 VALUES (684,198010,37,'sadly','beaters','crunches','FAS'); INSERT INTO t2 VALUES (685,198011,37,'positioning','Hornblower','overestimating','FAS'); INSERT INTO t2 VALUES (686,198012,37,'babysitting','vests','ineffective',''); INSERT INTO t2 VALUES (687,198013,37,'eternal','indulgences','humiliation','A'); INSERT INTO t2 VALUES (688,198014,37,'hoarder','infallibly','sophomore',''); INSERT INTO t2 VALUES (689,198015,37,'congregates','unwilling','star',''); INSERT INTO t2 VALUES (690,198017,37,'rains','excrete','rifles',''); INSERT INTO t2 VALUES (691,198018,37,'workers','spools','dialysis',''); INSERT INTO t2 VALUES (692,198019,37,'sags','crunches','arriving',''); INSERT INTO t2 VALUES (693,198020,37,'unplug','overestimating','indulge',''); INSERT INTO t2 VALUES (694,198021,37,'garage','ineffective','clockers',''); INSERT INTO t2 VALUES (695,198022,37,'boulder','humiliation','languages',''); INSERT INTO t2 VALUES (696,198023,50,'hollowly','sophomore','Antarctica','A'); INSERT INTO t2 VALUES (697,198024,37,'specifics','star','percentage',''); INSERT INTO t2 VALUES (698,198101,37,'Teresa','rifles','ceiling','A'); INSERT INTO t2 VALUES (699,198103,37,'Winsett','dialysis','specification',''); INSERT INTO t2 VALUES (700,198105,37,'convenient','arriving','regimented','A'); INSERT INTO t2 VALUES (701,198106,37,'buckboards','indulge','ciphers',''); INSERT INTO t2 VALUES (702,198201,37,'amenities','clockers','pictures','A'); INSERT INTO t2 VALUES (703,198204,37,'resplendent','languages','serpents','A'); INSERT INTO t2 VALUES (704,198301,53,'priding','Antarctica','allot','A'); INSERT INTO t2 VALUES (705,198302,53,'configurations','percentage','realized','A'); INSERT INTO t2 VALUES (706,198303,53,'untidiness','ceiling','mayoral','A'); INSERT INTO t2 VALUES (707,198304,53,'Brice','specification','opaquely','A'); INSERT INTO t2 VALUES (708,198401,37,'sews','regimented','hostess','FAS'); INSERT INTO t2 VALUES (709,198402,37,'participated','ciphers','fiftieth',''); INSERT INTO t2 VALUES (710,198403,37,'Simon','pictures','incorrectly',''); INSERT INTO t2 VALUES (711,202101,37,'certificates','serpents','decomposition','FAS'); INSERT INTO t2 VALUES (712,202301,37,'Fitzpatrick','allot','stranglings',''); INSERT INTO t2 VALUES (713,202302,37,'Evanston','realized','mixture','FAS'); INSERT INTO t2 VALUES (714,202303,37,'misted','mayoral','electroencephalography','FAS'); INSERT INTO t2 VALUES (715,202304,37,'textures','opaquely','similarities','FAS'); INSERT INTO t2 VALUES (716,202305,37,'save','hostess','charges','W'); INSERT INTO t2 VALUES (717,202601,37,'count','fiftieth','freest','FAS'); INSERT INTO t2 VALUES (718,202602,37,'rightful','incorrectly','Greenberg','FAS'); INSERT INTO t2 VALUES (719,202605,37,'chaperone','decomposition','tinting',''); INSERT INTO t2 VALUES (720,202606,37,'Lizzy','stranglings','expelled','W'); INSERT INTO t2 VALUES (721,202607,37,'clenched','mixture','warm',''); INSERT INTO t2 VALUES (722,202901,37,'effortlessly','electroencephalography','smoothed',''); INSERT INTO t2 VALUES (723,202902,37,'accessed','similarities','deductions','FAS'); INSERT INTO t2 VALUES (724,202903,37,'beaters','charges','Romano','W'); INSERT INTO t2 VALUES (725,202904,37,'Hornblower','freest','bitterroot',''); INSERT INTO t2 VALUES (726,202907,37,'vests','Greenberg','corset',''); INSERT INTO t2 VALUES (727,202908,37,'indulgences','tinting','securing',''); INSERT INTO t2 VALUES (728,203101,37,'infallibly','expelled','environing','FAS'); INSERT INTO t2 VALUES (729,203103,37,'unwilling','warm','cute',''); INSERT INTO t2 VALUES (730,203104,37,'excrete','smoothed','Crays',''); INSERT INTO t2 VALUES (731,203105,37,'spools','deductions','heiress','FAS'); INSERT INTO t2 VALUES (732,203401,37,'crunches','Romano','inform','FAS'); INSERT INTO t2 VALUES (733,203402,37,'overestimating','bitterroot','avenge',''); INSERT INTO t2 VALUES (734,203404,37,'ineffective','corset','universals',''); INSERT INTO t2 VALUES (735,203901,37,'humiliation','securing','Kinsey','W'); INSERT INTO t2 VALUES (736,203902,37,'sophomore','environing','ravines','FAS'); INSERT INTO t2 VALUES (737,203903,37,'star','cute','bestseller',''); INSERT INTO t2 VALUES (738,203906,37,'rifles','Crays','equilibrium',''); INSERT INTO t2 VALUES (739,203907,37,'dialysis','heiress','extents','0'); INSERT INTO t2 VALUES (740,203908,37,'arriving','inform','relatively',''); INSERT INTO t2 VALUES (741,203909,37,'indulge','avenge','pressure','FAS'); INSERT INTO t2 VALUES (742,206101,37,'clockers','universals','critiques','FAS'); INSERT INTO t2 VALUES (743,206201,37,'languages','Kinsey','befouled',''); INSERT INTO t2 VALUES (744,206202,37,'Antarctica','ravines','rightfully','FAS'); INSERT INTO t2 VALUES (745,206203,37,'percentage','bestseller','mechanizing','FAS'); INSERT INTO t2 VALUES (746,206206,37,'ceiling','equilibrium','Latinizes',''); INSERT INTO t2 VALUES (747,206207,37,'specification','extents','timesharing',''); INSERT INTO t2 VALUES (748,206208,37,'regimented','relatively','Aden',''); INSERT INTO t2 VALUES (749,208001,37,'ciphers','pressure','embassies',''); INSERT INTO t2 VALUES (750,208002,37,'pictures','critiques','males','FAS'); INSERT INTO t2 VALUES (751,208003,37,'serpents','befouled','shapelessly','FAS'); INSERT INTO t2 VALUES (752,208004,37,'allot','rightfully','genres','FAS'); INSERT INTO t2 VALUES (753,208008,37,'realized','mechanizing','mastering',''); INSERT INTO t2 VALUES (754,208009,37,'mayoral','Latinizes','Newtonian',''); INSERT INTO t2 VALUES (755,208010,37,'opaquely','timesharing','finishers','FAS'); INSERT INTO t2 VALUES (756,208011,37,'hostess','Aden','abates',''); INSERT INTO t2 VALUES (757,208101,37,'fiftieth','embassies','teem',''); INSERT INTO t2 VALUES (758,208102,37,'incorrectly','males','kiting','FAS'); INSERT INTO t2 VALUES (759,208103,37,'decomposition','shapelessly','stodgy','FAS'); INSERT INTO t2 VALUES (760,208104,37,'stranglings','genres','scalps','FAS'); INSERT INTO t2 VALUES (761,208105,37,'mixture','mastering','feed','FAS'); INSERT INTO t2 VALUES (762,208110,37,'electroencephalography','Newtonian','guitars',''); INSERT INTO t2 VALUES (763,208111,37,'similarities','finishers','airships',''); INSERT INTO t2 VALUES (764,208112,37,'charges','abates','store',''); INSERT INTO t2 VALUES (765,208113,37,'freest','teem','denounces',''); INSERT INTO t2 VALUES (766,208201,37,'Greenberg','kiting','Pyle','FAS'); INSERT INTO t2 VALUES (767,208203,37,'tinting','stodgy','Saxony',''); INSERT INTO t2 VALUES (768,208301,37,'expelled','scalps','serializations','FAS'); INSERT INTO t2 VALUES (769,208302,37,'warm','feed','Peruvian','FAS'); INSERT INTO t2 VALUES (770,208305,37,'smoothed','guitars','taxonomically','FAS'); INSERT INTO t2 VALUES (771,208401,37,'deductions','airships','kingdom','A'); INSERT INTO t2 VALUES (772,208402,37,'Romano','store','stint','A'); INSERT INTO t2 VALUES (773,208403,37,'bitterroot','denounces','Sault','A'); INSERT INTO t2 VALUES (774,208404,37,'corset','Pyle','faithful',''); INSERT INTO t2 VALUES (775,208501,37,'securing','Saxony','Ganymede','FAS'); INSERT INTO t2 VALUES (776,208502,37,'environing','serializations','tidiness','FAS'); INSERT INTO t2 VALUES (777,208503,37,'cute','Peruvian','gainful','FAS'); INSERT INTO t2 VALUES (778,208504,37,'Crays','taxonomically','contrary','FAS'); INSERT INTO t2 VALUES (779,208505,37,'heiress','kingdom','Tipperary','FAS'); INSERT INTO t2 VALUES (780,210101,37,'inform','stint','tropics','W'); INSERT INTO t2 VALUES (781,210102,37,'avenge','Sault','theorizers',''); INSERT INTO t2 VALUES (782,210103,37,'universals','faithful','renew','0'); INSERT INTO t2 VALUES (783,210104,37,'Kinsey','Ganymede','already',''); INSERT INTO t2 VALUES (784,210105,37,'ravines','tidiness','terminal',''); INSERT INTO t2 VALUES (785,210106,37,'bestseller','gainful','Hegelian',''); INSERT INTO t2 VALUES (786,210107,37,'equilibrium','contrary','hypothesizer',''); INSERT INTO t2 VALUES (787,210401,37,'extents','Tipperary','warningly','FAS'); INSERT INTO t2 VALUES (788,213201,37,'relatively','tropics','journalizing','FAS'); INSERT INTO t2 VALUES (789,213203,37,'pressure','theorizers','nested',''); INSERT INTO t2 VALUES (790,213204,37,'critiques','renew','Lars',''); INSERT INTO t2 VALUES (791,213205,37,'befouled','already','saplings',''); INSERT INTO t2 VALUES (792,213206,37,'rightfully','terminal','foothill',''); INSERT INTO t2 VALUES (793,213207,37,'mechanizing','Hegelian','labeled',''); INSERT INTO t2 VALUES (794,216101,37,'Latinizes','hypothesizer','imperiously','FAS'); INSERT INTO t2 VALUES (795,216103,37,'timesharing','warningly','reporters','FAS'); INSERT INTO t2 VALUES (796,218001,37,'Aden','journalizing','furnishings','FAS'); INSERT INTO t2 VALUES (797,218002,37,'embassies','nested','precipitable','FAS'); INSERT INTO t2 VALUES (798,218003,37,'males','Lars','discounts','FAS'); INSERT INTO t2 VALUES (799,218004,37,'shapelessly','saplings','excises','FAS'); INSERT INTO t2 VALUES (800,143503,50,'genres','foothill','Stalin',''); INSERT INTO t2 VALUES (801,218006,37,'mastering','labeled','despot','FAS'); INSERT INTO t2 VALUES (802,218007,37,'Newtonian','imperiously','ripeness','FAS'); INSERT INTO t2 VALUES (803,218008,37,'finishers','reporters','Arabia',''); INSERT INTO t2 VALUES (804,218009,37,'abates','furnishings','unruly',''); INSERT INTO t2 VALUES (805,218010,37,'teem','precipitable','mournfulness',''); INSERT INTO t2 VALUES (806,218011,37,'kiting','discounts','boom','FAS'); INSERT INTO t2 VALUES (807,218020,37,'stodgy','excises','slaughter','A'); INSERT INTO t2 VALUES (808,218021,50,'scalps','Stalin','Sabine',''); INSERT INTO t2 VALUES (809,218022,37,'feed','despot','handy','FAS'); INSERT INTO t2 VALUES (810,218023,37,'guitars','ripeness','rural',''); INSERT INTO t2 VALUES (811,218024,37,'airships','Arabia','organizer',''); INSERT INTO t2 VALUES (812,218101,37,'store','unruly','shipyard','FAS'); INSERT INTO t2 VALUES (813,218102,37,'denounces','mournfulness','civics','FAS'); INSERT INTO t2 VALUES (814,218103,37,'Pyle','boom','inaccuracy','FAS'); INSERT INTO t2 VALUES (815,218201,37,'Saxony','slaughter','rules','FAS'); INSERT INTO t2 VALUES (816,218202,37,'serializations','Sabine','juveniles','FAS'); INSERT INTO t2 VALUES (817,218203,37,'Peruvian','handy','comprised','W'); INSERT INTO t2 VALUES (818,218204,37,'taxonomically','rural','investigations',''); INSERT INTO t2 VALUES (819,218205,37,'kingdom','organizer','stabilizes','A'); INSERT INTO t2 VALUES (820,218301,37,'stint','shipyard','seminaries','FAS'); INSERT INTO t2 VALUES (821,218302,37,'Sault','civics','Hunter','A'); INSERT INTO t2 VALUES (822,218401,37,'faithful','inaccuracy','sporty','FAS'); INSERT INTO t2 VALUES (823,218402,37,'Ganymede','rules','test','FAS'); INSERT INTO t2 VALUES (824,218403,37,'tidiness','juveniles','weasels',''); INSERT INTO t2 VALUES (825,218404,37,'gainful','comprised','CERN',''); INSERT INTO t2 VALUES (826,218407,37,'contrary','investigations','tempering',''); INSERT INTO t2 VALUES (827,218408,37,'Tipperary','stabilizes','afore','FAS'); INSERT INTO t2 VALUES (828,218409,37,'tropics','seminaries','Galatean',''); INSERT INTO t2 VALUES (829,218410,37,'theorizers','Hunter','techniques','W'); INSERT INTO t2 VALUES (830,226001,37,'renew','sporty','error',''); INSERT INTO t2 VALUES (831,226002,37,'already','test','veranda',''); INSERT INTO t2 VALUES (832,226003,37,'terminal','weasels','severely',''); INSERT INTO t2 VALUES (833,226004,37,'Hegelian','CERN','Cassites','FAS'); INSERT INTO t2 VALUES (834,226005,37,'hypothesizer','tempering','forthcoming',''); INSERT INTO t2 VALUES (835,226006,37,'warningly','afore','guides',''); INSERT INTO t2 VALUES (836,226007,37,'journalizing','Galatean','vanish','FAS'); INSERT INTO t2 VALUES (837,226008,37,'nested','techniques','lied','A'); INSERT INTO t2 VALUES (838,226203,37,'Lars','error','sawtooth','FAS'); INSERT INTO t2 VALUES (839,226204,37,'saplings','veranda','fated','FAS'); INSERT INTO t2 VALUES (840,226205,37,'foothill','severely','gradually',''); INSERT INTO t2 VALUES (841,226206,37,'labeled','Cassites','widens',''); INSERT INTO t2 VALUES (842,226207,37,'imperiously','forthcoming','preclude',''); INSERT INTO t2 VALUES (843,226208,37,'reporters','guides','Jobrel',''); INSERT INTO t2 VALUES (844,226209,37,'furnishings','vanish','hooker',''); INSERT INTO t2 VALUES (845,226210,37,'precipitable','lied','rainstorm',''); INSERT INTO t2 VALUES (846,226211,37,'discounts','sawtooth','disconnects',''); INSERT INTO t2 VALUES (847,228001,37,'excises','fated','cruelty',''); INSERT INTO t2 VALUES (848,228004,37,'Stalin','gradually','exponentials','A'); INSERT INTO t2 VALUES (849,228005,37,'despot','widens','affective','A'); INSERT INTO t2 VALUES (850,228006,37,'ripeness','preclude','arteries',''); INSERT INTO t2 VALUES (851,228007,37,'Arabia','Jobrel','Crosby','FAS'); INSERT INTO t2 VALUES (852,228008,37,'unruly','hooker','acquaint',''); INSERT INTO t2 VALUES (853,228009,37,'mournfulness','rainstorm','evenhandedly',''); INSERT INTO t2 VALUES (854,228101,37,'boom','disconnects','percentage',''); INSERT INTO t2 VALUES (855,228108,37,'slaughter','cruelty','disobedience',''); INSERT INTO t2 VALUES (856,228109,37,'Sabine','exponentials','humility',''); INSERT INTO t2 VALUES (857,228110,37,'handy','affective','gleaning','A'); INSERT INTO t2 VALUES (858,228111,37,'rural','arteries','petted','A'); INSERT INTO t2 VALUES (859,228112,37,'organizer','Crosby','bloater','A'); INSERT INTO t2 VALUES (860,228113,37,'shipyard','acquaint','minion','A'); INSERT INTO t2 VALUES (861,228114,37,'civics','evenhandedly','marginal','A'); INSERT INTO t2 VALUES (862,228115,37,'inaccuracy','percentage','apiary','A'); INSERT INTO t2 VALUES (863,228116,37,'rules','disobedience','measures',''); INSERT INTO t2 VALUES (864,228117,37,'juveniles','humility','precaution',''); INSERT INTO t2 VALUES (865,228118,37,'comprised','gleaning','repelled',''); INSERT INTO t2 VALUES (866,228119,37,'investigations','petted','primary','FAS'); INSERT INTO t2 VALUES (867,228120,37,'stabilizes','bloater','coverings',''); INSERT INTO t2 VALUES (868,228121,37,'seminaries','minion','Artemia','A'); INSERT INTO t2 VALUES (869,228122,37,'Hunter','marginal','navigate',''); INSERT INTO t2 VALUES (870,228201,37,'sporty','apiary','spatial',''); INSERT INTO t2 VALUES (871,228206,37,'test','measures','Gurkha',''); INSERT INTO t2 VALUES (872,228207,37,'weasels','precaution','meanwhile','A'); INSERT INTO t2 VALUES (873,228208,37,'CERN','repelled','Melinda','A'); INSERT INTO t2 VALUES (874,228209,37,'tempering','primary','Butterfield',''); INSERT INTO t2 VALUES (875,228210,37,'afore','coverings','Aldrich','A'); INSERT INTO t2 VALUES (876,228211,37,'Galatean','Artemia','previewing','A'); INSERT INTO t2 VALUES (877,228212,37,'techniques','navigate','glut','A'); INSERT INTO t2 VALUES (878,228213,37,'error','spatial','unaffected',''); INSERT INTO t2 VALUES (879,228214,37,'veranda','Gurkha','inmate',''); INSERT INTO t2 VALUES (880,228301,37,'severely','meanwhile','mineral',''); INSERT INTO t2 VALUES (881,228305,37,'Cassites','Melinda','impending','A'); INSERT INTO t2 VALUES (882,228306,37,'forthcoming','Butterfield','meditation','A'); INSERT INTO t2 VALUES (883,228307,37,'guides','Aldrich','ideas',''); INSERT INTO t2 VALUES (884,228308,37,'vanish','previewing','miniaturizes','W'); INSERT INTO t2 VALUES (885,228309,37,'lied','glut','lewdly',''); INSERT INTO t2 VALUES (886,228310,37,'sawtooth','unaffected','title',''); INSERT INTO t2 VALUES (887,228311,37,'fated','inmate','youthfulness',''); INSERT INTO t2 VALUES (888,228312,37,'gradually','mineral','creak','FAS'); INSERT INTO t2 VALUES (889,228313,37,'widens','impending','Chippewa',''); INSERT INTO t2 VALUES (890,228314,37,'preclude','meditation','clamored',''); INSERT INTO t2 VALUES (891,228401,65,'Jobrel','ideas','freezes',''); INSERT INTO t2 VALUES (892,228402,65,'hooker','miniaturizes','forgivably','FAS'); INSERT INTO t2 VALUES (893,228403,65,'rainstorm','lewdly','reduce','FAS'); INSERT INTO t2 VALUES (894,228404,65,'disconnects','title','McGovern','W'); INSERT INTO t2 VALUES (895,228405,65,'cruelty','youthfulness','Nazis','W'); INSERT INTO t2 VALUES (896,228406,65,'exponentials','creak','epistle','W'); INSERT INTO t2 VALUES (897,228407,65,'affective','Chippewa','socializes','W'); INSERT INTO t2 VALUES (898,228408,65,'arteries','clamored','conceptions',''); INSERT INTO t2 VALUES (899,228409,65,'Crosby','freezes','Kevin',''); INSERT INTO t2 VALUES (900,228410,65,'acquaint','forgivably','uncovering',''); INSERT INTO t2 VALUES (901,230301,37,'evenhandedly','reduce','chews','FAS'); INSERT INTO t2 VALUES (902,230302,37,'percentage','McGovern','appendixes','FAS'); INSERT INTO t2 VALUES (903,230303,37,'disobedience','Nazis','raining',''); INSERT INTO t2 VALUES (904,018062,37,'humility','epistle','infest',''); INSERT INTO t2 VALUES (905,230501,37,'gleaning','socializes','compartment',''); INSERT INTO t2 VALUES (906,230502,37,'petted','conceptions','minting',''); INSERT INTO t2 VALUES (907,230503,37,'bloater','Kevin','ducks',''); INSERT INTO t2 VALUES (908,230504,37,'minion','uncovering','roped','A'); INSERT INTO t2 VALUES (909,230505,37,'marginal','chews','waltz',''); INSERT INTO t2 VALUES (910,230506,37,'apiary','appendixes','Lillian',''); INSERT INTO t2 VALUES (911,230507,37,'measures','raining','repressions','A'); INSERT INTO t2 VALUES (912,230508,37,'precaution','infest','chillingly',''); INSERT INTO t2 VALUES (913,230509,37,'repelled','compartment','noncritical',''); INSERT INTO t2 VALUES (914,230901,37,'primary','minting','lithograph',''); INSERT INTO t2 VALUES (915,230902,37,'coverings','ducks','spongers',''); INSERT INTO t2 VALUES (916,230903,37,'Artemia','roped','parenthood',''); INSERT INTO t2 VALUES (917,230904,37,'navigate','waltz','posed',''); INSERT INTO t2 VALUES (918,230905,37,'spatial','Lillian','instruments',''); INSERT INTO t2 VALUES (919,230906,37,'Gurkha','repressions','filial',''); INSERT INTO t2 VALUES (920,230907,37,'meanwhile','chillingly','fixedly',''); INSERT INTO t2 VALUES (921,230908,37,'Melinda','noncritical','relives',''); INSERT INTO t2 VALUES (922,230909,37,'Butterfield','lithograph','Pandora',''); INSERT INTO t2 VALUES (923,230910,37,'Aldrich','spongers','watering','A'); INSERT INTO t2 VALUES (924,230911,37,'previewing','parenthood','ungrateful',''); INSERT INTO t2 VALUES (925,230912,37,'glut','posed','secures',''); INSERT INTO t2 VALUES (926,230913,37,'unaffected','instruments','chastisers',''); INSERT INTO t2 VALUES (927,230914,37,'inmate','filial','icon',''); INSERT INTO t2 VALUES (928,231304,37,'mineral','fixedly','reuniting','A'); INSERT INTO t2 VALUES (929,231305,37,'impending','relives','imagining','A'); INSERT INTO t2 VALUES (930,231306,37,'meditation','Pandora','abiding','A'); INSERT INTO t2 VALUES (931,231307,37,'ideas','watering','omnisciently',''); INSERT INTO t2 VALUES (932,231308,37,'miniaturizes','ungrateful','Britannic',''); INSERT INTO t2 VALUES (933,231309,37,'lewdly','secures','scholastics','A'); INSERT INTO t2 VALUES (934,231310,37,'title','chastisers','mechanics','A'); INSERT INTO t2 VALUES (935,231311,37,'youthfulness','icon','humidly','A'); INSERT INTO t2 VALUES (936,231312,37,'creak','reuniting','masterpiece',''); INSERT INTO t2 VALUES (937,231313,37,'Chippewa','imagining','however',''); INSERT INTO t2 VALUES (938,231314,37,'clamored','abiding','Mendelian',''); INSERT INTO t2 VALUES (939,231315,37,'freezes','omnisciently','jarred',''); INSERT INTO t2 VALUES (940,232102,37,'forgivably','Britannic','scolds',''); INSERT INTO t2 VALUES (941,232103,37,'reduce','scholastics','infatuate',''); INSERT INTO t2 VALUES (942,232104,37,'McGovern','mechanics','willed','A'); INSERT INTO t2 VALUES (943,232105,37,'Nazis','humidly','joyfully',''); INSERT INTO t2 VALUES (944,232106,37,'epistle','masterpiece','Microsoft',''); INSERT INTO t2 VALUES (945,232107,37,'socializes','however','fibrosities',''); INSERT INTO t2 VALUES (946,232108,37,'conceptions','Mendelian','Baltimorean',''); INSERT INTO t2 VALUES (947,232601,37,'Kevin','jarred','equestrian',''); INSERT INTO t2 VALUES (948,232602,37,'uncovering','scolds','Goodrich',''); INSERT INTO t2 VALUES (949,232603,37,'chews','infatuate','apish','A'); INSERT INTO t2 VALUES (950,232605,37,'appendixes','willed','Adlerian',''); INSERT INTO t2 VALUES (5950,1232605,37,'appendixes','willed','Adlerian',''); INSERT INTO t2 VALUES (5951,1232606,37,'appendixes','willed','Adlerian',''); INSERT INTO t2 VALUES (5952,1232607,37,'appendixes','willed','Adlerian',''); INSERT INTO t2 VALUES (5953,1232608,37,'appendixes','willed','Adlerian',''); INSERT INTO t2 VALUES (5954,1232609,37,'appendixes','willed','Adlerian',''); INSERT INTO t2 VALUES (951,232606,37,'raining','joyfully','Tropez',''); INSERT INTO t2 VALUES (952,232607,37,'infest','Microsoft','nouns',''); INSERT INTO t2 VALUES (953,232608,37,'compartment','fibrosities','distracting',''); INSERT INTO t2 VALUES (954,232609,37,'minting','Baltimorean','mutton',''); INSERT INTO t2 VALUES (955,236104,37,'ducks','equestrian','bridgeable','A'); INSERT INTO t2 VALUES (956,236105,37,'roped','Goodrich','stickers','A'); INSERT INTO t2 VALUES (957,236106,37,'waltz','apish','transcontinental','A'); INSERT INTO t2 VALUES (958,236107,37,'Lillian','Adlerian','amateurish',''); INSERT INTO t2 VALUES (959,236108,37,'repressions','Tropez','Gandhian',''); INSERT INTO t2 VALUES (960,236109,37,'chillingly','nouns','stratified',''); INSERT INTO t2 VALUES (961,236110,37,'noncritical','distracting','chamberlains',''); INSERT INTO t2 VALUES (962,236111,37,'lithograph','mutton','creditably',''); INSERT INTO t2 VALUES (963,236112,37,'spongers','bridgeable','philosophic',''); INSERT INTO t2 VALUES (964,236113,37,'parenthood','stickers','ores',''); INSERT INTO t2 VALUES (965,238005,37,'posed','transcontinental','Carleton',''); INSERT INTO t2 VALUES (966,238006,37,'instruments','amateurish','tape','A'); INSERT INTO t2 VALUES (967,238007,37,'filial','Gandhian','afloat','A'); INSERT INTO t2 VALUES (968,238008,37,'fixedly','stratified','goodness','A'); INSERT INTO t2 VALUES (969,238009,37,'relives','chamberlains','welcoming',''); INSERT INTO t2 VALUES (970,238010,37,'Pandora','creditably','Pinsky','FAS'); INSERT INTO t2 VALUES (971,238011,37,'watering','philosophic','halting',''); INSERT INTO t2 VALUES (972,238012,37,'ungrateful','ores','bibliography',''); INSERT INTO t2 VALUES (973,238013,37,'secures','Carleton','decoding',''); INSERT INTO t2 VALUES (974,240401,41,'chastisers','tape','variance','A'); INSERT INTO t2 VALUES (975,240402,41,'icon','afloat','allowed','A'); INSERT INTO t2 VALUES (976,240901,41,'reuniting','goodness','dire','A'); INSERT INTO t2 VALUES (977,240902,41,'imagining','welcoming','dub','A'); INSERT INTO t2 VALUES (978,241801,41,'abiding','Pinsky','poisoning',''); INSERT INTO t2 VALUES (979,242101,41,'omnisciently','halting','Iraqis','A'); INSERT INTO t2 VALUES (980,242102,41,'Britannic','bibliography','heaving',''); INSERT INTO t2 VALUES (981,242201,41,'scholastics','decoding','population','A'); INSERT INTO t2 VALUES (982,242202,41,'mechanics','variance','bomb','A'); INSERT INTO t2 VALUES (983,242501,41,'humidly','allowed','Majorca','A'); INSERT INTO t2 VALUES (984,242502,41,'masterpiece','dire','Gershwins',''); INSERT INTO t2 VALUES (985,246201,41,'however','dub','explorers',''); INSERT INTO t2 VALUES (986,246202,41,'Mendelian','poisoning','libretto','A'); INSERT INTO t2 VALUES (987,246203,41,'jarred','Iraqis','occurred',''); INSERT INTO t2 VALUES (988,246204,41,'scolds','heaving','Lagos',''); INSERT INTO t2 VALUES (989,246205,41,'infatuate','population','rats',''); INSERT INTO t2 VALUES (990,246301,41,'willed','bomb','bankruptcies','A'); INSERT INTO t2 VALUES (991,246302,41,'joyfully','Majorca','crying',''); INSERT INTO t2 VALUES (992,248001,41,'Microsoft','Gershwins','unexpected',''); INSERT INTO t2 VALUES (993,248002,41,'fibrosities','explorers','accessed','A'); INSERT INTO t2 VALUES (994,248003,41,'Baltimorean','libretto','colorful','A'); INSERT INTO t2 VALUES (995,248004,41,'equestrian','occurred','versatility','A'); INSERT INTO t2 VALUES (996,248005,41,'Goodrich','Lagos','cosy',''); INSERT INTO t2 VALUES (997,248006,41,'apish','rats','Darius','A'); INSERT INTO t2 VALUES (998,248007,41,'Adlerian','bankruptcies','mastering','A'); INSERT INTO t2 VALUES (999,248008,41,'Tropez','crying','Asiaticizations','A'); INSERT INTO t2 VALUES (1000,248009,41,'nouns','unexpected','offerers','A'); INSERT INTO t2 VALUES (1001,248010,41,'distracting','accessed','uncles','A'); INSERT INTO t2 VALUES (1002,248011,41,'mutton','colorful','sleepwalk',''); INSERT INTO t2 VALUES (1003,248012,41,'bridgeable','versatility','Ernestine',''); INSERT INTO t2 VALUES (1004,248013,41,'stickers','cosy','checksumming',''); INSERT INTO t2 VALUES (1005,248014,41,'transcontinental','Darius','stopped',''); INSERT INTO t2 VALUES (1006,248015,41,'amateurish','mastering','sicker',''); INSERT INTO t2 VALUES (1007,248016,41,'Gandhian','Asiaticizations','Italianization',''); INSERT INTO t2 VALUES (1008,248017,41,'stratified','offerers','alphabetic',''); INSERT INTO t2 VALUES (1009,248018,41,'chamberlains','uncles','pharmaceutic',''); INSERT INTO t2 VALUES (1010,248019,41,'creditably','sleepwalk','creator',''); INSERT INTO t2 VALUES (1011,248020,41,'philosophic','Ernestine','chess',''); INSERT INTO t2 VALUES (1012,248021,41,'ores','checksumming','charcoal',''); INSERT INTO t2 VALUES (1013,248101,41,'Carleton','stopped','Epiphany','A'); INSERT INTO t2 VALUES (1014,248102,41,'tape','sicker','bulldozes','A'); INSERT INTO t2 VALUES (1015,248201,41,'afloat','Italianization','Pygmalion','A'); INSERT INTO t2 VALUES (1016,248202,41,'goodness','alphabetic','caressing','A'); INSERT INTO t2 VALUES (1017,248203,41,'welcoming','pharmaceutic','Palestine','A'); INSERT INTO t2 VALUES (1018,248204,41,'Pinsky','creator','regimented','A'); INSERT INTO t2 VALUES (1019,248205,41,'halting','chess','scars','A'); INSERT INTO t2 VALUES (1020,248206,41,'bibliography','charcoal','realest','A'); INSERT INTO t2 VALUES (1021,248207,41,'decoding','Epiphany','diffusing','A'); INSERT INTO t2 VALUES (1022,248208,41,'variance','bulldozes','clubroom','A'); INSERT INTO t2 VALUES (1023,248209,41,'allowed','Pygmalion','Blythe','A'); INSERT INTO t2 VALUES (1024,248210,41,'dire','caressing','ahead',''); INSERT INTO t2 VALUES (1025,248211,50,'dub','Palestine','reviver',''); INSERT INTO t2 VALUES (1026,250501,34,'poisoning','regimented','retransmitting','A'); INSERT INTO t2 VALUES (1027,250502,34,'Iraqis','scars','landslide',''); INSERT INTO t2 VALUES (1028,250503,34,'heaving','realest','Eiffel',''); INSERT INTO t2 VALUES (1029,250504,34,'population','diffusing','absentee',''); INSERT INTO t2 VALUES (1030,250505,34,'bomb','clubroom','aye',''); INSERT INTO t2 VALUES (1031,250601,34,'Majorca','Blythe','forked','A'); INSERT INTO t2 VALUES (1032,250602,34,'Gershwins','ahead','Peruvianizes',''); INSERT INTO t2 VALUES (1033,250603,34,'explorers','reviver','clerked',''); INSERT INTO t2 VALUES (1034,250604,34,'libretto','retransmitting','tutor',''); INSERT INTO t2 VALUES (1035,250605,34,'occurred','landslide','boulevard',''); INSERT INTO t2 VALUES (1036,251001,34,'Lagos','Eiffel','shuttered',''); INSERT INTO t2 VALUES (1037,251002,34,'rats','absentee','quotes','A'); INSERT INTO t2 VALUES (1038,251003,34,'bankruptcies','aye','Caltech',''); INSERT INTO t2 VALUES (1039,251004,34,'crying','forked','Mossberg',''); INSERT INTO t2 VALUES (1040,251005,34,'unexpected','Peruvianizes','kept',''); INSERT INTO t2 VALUES (1041,251301,34,'accessed','clerked','roundly',''); INSERT INTO t2 VALUES (1042,251302,34,'colorful','tutor','features','A'); INSERT INTO t2 VALUES (1043,251303,34,'versatility','boulevard','imaginable','A'); INSERT INTO t2 VALUES (1044,251304,34,'cosy','shuttered','controller',''); INSERT INTO t2 VALUES (1045,251305,34,'Darius','quotes','racial',''); INSERT INTO t2 VALUES (1046,251401,34,'mastering','Caltech','uprisings','A'); INSERT INTO t2 VALUES (1047,251402,34,'Asiaticizations','Mossberg','narrowed','A'); INSERT INTO t2 VALUES (1048,251403,34,'offerers','kept','cannot','A'); INSERT INTO t2 VALUES (1049,251404,34,'uncles','roundly','vest',''); INSERT INTO t2 VALUES (1050,251405,34,'sleepwalk','features','famine',''); INSERT INTO t2 VALUES (1051,251406,34,'Ernestine','imaginable','sugars',''); INSERT INTO t2 VALUES (1052,251801,34,'checksumming','controller','exterminated','A'); INSERT INTO t2 VALUES (1053,251802,34,'stopped','racial','belays',''); INSERT INTO t2 VALUES (1054,252101,34,'sicker','uprisings','Hodges','A'); INSERT INTO t2 VALUES (1055,252102,34,'Italianization','narrowed','translatable',''); INSERT INTO t2 VALUES (1056,252301,34,'alphabetic','cannot','duality','A'); INSERT INTO t2 VALUES (1057,252302,34,'pharmaceutic','vest','recording','A'); INSERT INTO t2 VALUES (1058,252303,34,'creator','famine','rouses','A'); INSERT INTO t2 VALUES (1059,252304,34,'chess','sugars','poison',''); INSERT INTO t2 VALUES (1060,252305,34,'charcoal','exterminated','attitude',''); INSERT INTO t2 VALUES (1061,252306,34,'Epiphany','belays','dusted',''); INSERT INTO t2 VALUES (1062,252307,34,'bulldozes','Hodges','encompasses',''); INSERT INTO t2 VALUES (1063,252308,34,'Pygmalion','translatable','presentation',''); INSERT INTO t2 VALUES (1064,252309,34,'caressing','duality','Kantian',''); INSERT INTO t2 VALUES (1065,256001,34,'Palestine','recording','imprecision','A'); INSERT INTO t2 VALUES (1066,256002,34,'regimented','rouses','saving',''); INSERT INTO t2 VALUES (1067,256003,34,'scars','poison','maternal',''); INSERT INTO t2 VALUES (1068,256004,34,'realest','attitude','hewed',''); INSERT INTO t2 VALUES (1069,256005,34,'diffusing','dusted','kerosene',''); INSERT INTO t2 VALUES (1070,258001,34,'clubroom','encompasses','Cubans',''); INSERT INTO t2 VALUES (1071,258002,34,'Blythe','presentation','photographers',''); INSERT INTO t2 VALUES (1072,258003,34,'ahead','Kantian','nymph','A'); INSERT INTO t2 VALUES (1073,258004,34,'reviver','imprecision','bedlam','A'); INSERT INTO t2 VALUES (1074,258005,34,'retransmitting','saving','north','A'); INSERT INTO t2 VALUES (1075,258006,34,'landslide','maternal','Schoenberg','A'); INSERT INTO t2 VALUES (1076,258007,34,'Eiffel','hewed','botany','A'); INSERT INTO t2 VALUES (1077,258008,34,'absentee','kerosene','curs',''); INSERT INTO t2 VALUES (1078,258009,34,'aye','Cubans','solidification',''); INSERT INTO t2 VALUES (1079,258010,34,'forked','photographers','inheritresses',''); INSERT INTO t2 VALUES (1080,258011,34,'Peruvianizes','nymph','stiller',''); INSERT INTO t2 VALUES (1081,258101,68,'clerked','bedlam','t1','A'); INSERT INTO t2 VALUES (1082,258102,68,'tutor','north','suite','A'); INSERT INTO t2 VALUES (1083,258103,34,'boulevard','Schoenberg','ransomer',''); INSERT INTO t2 VALUES (1084,258104,68,'shuttered','botany','Willy',''); INSERT INTO t2 VALUES (1085,258105,68,'quotes','curs','Rena','A'); INSERT INTO t2 VALUES (1086,258106,68,'Caltech','solidification','Seattle','A'); INSERT INTO t2 VALUES (1087,258107,68,'Mossberg','inheritresses','relaxes','A'); INSERT INTO t2 VALUES (1088,258108,68,'kept','stiller','exclaim',''); INSERT INTO t2 VALUES (1089,258109,68,'roundly','t1','implicated','A'); INSERT INTO t2 VALUES (1090,258110,68,'features','suite','distinguish',''); INSERT INTO t2 VALUES (1091,258111,68,'imaginable','ransomer','assayed',''); INSERT INTO t2 VALUES (1092,258112,68,'controller','Willy','homeowner',''); INSERT INTO t2 VALUES (1093,258113,68,'racial','Rena','and',''); INSERT INTO t2 VALUES (1094,258201,34,'uprisings','Seattle','stealth',''); INSERT INTO t2 VALUES (1095,258202,34,'narrowed','relaxes','coinciding','A'); INSERT INTO t2 VALUES (1096,258203,34,'cannot','exclaim','founder','A'); INSERT INTO t2 VALUES (1097,258204,34,'vest','implicated','environing',''); INSERT INTO t2 VALUES (1098,258205,34,'famine','distinguish','jewelry',''); INSERT INTO t2 VALUES (1099,258301,34,'sugars','assayed','lemons','A'); INSERT INTO t2 VALUES (1100,258401,34,'exterminated','homeowner','brokenness','A'); INSERT INTO t2 VALUES (1101,258402,34,'belays','and','bedpost','A'); INSERT INTO t2 VALUES (1102,258403,34,'Hodges','stealth','assurers','A'); INSERT INTO t2 VALUES (1103,258404,34,'translatable','coinciding','annoyers',''); INSERT INTO t2 VALUES (1104,258405,34,'duality','founder','affixed',''); INSERT INTO t2 VALUES (1105,258406,34,'recording','environing','warbling',''); INSERT INTO t2 VALUES (1106,258407,34,'rouses','jewelry','seriously',''); INSERT INTO t2 VALUES (1107,228123,37,'poison','lemons','boasted',''); INSERT INTO t2 VALUES (1108,250606,34,'attitude','brokenness','Chantilly',''); INSERT INTO t2 VALUES (1109,208405,37,'dusted','bedpost','Iranizes',''); INSERT INTO t2 VALUES (1110,212101,37,'encompasses','assurers','violinist',''); INSERT INTO t2 VALUES (1111,218206,37,'presentation','annoyers','extramarital',''); INSERT INTO t2 VALUES (1112,150401,37,'Kantian','affixed','spates',''); INSERT INTO t2 VALUES (1113,248212,41,'imprecision','warbling','cloakroom',''); INSERT INTO t2 VALUES (1114,128026,00,'saving','seriously','gazer',''); INSERT INTO t2 VALUES (1115,128024,00,'maternal','boasted','hand',''); INSERT INTO t2 VALUES (1116,128027,00,'hewed','Chantilly','tucked',''); INSERT INTO t2 VALUES (1117,128025,00,'kerosene','Iranizes','gems',''); INSERT INTO t2 VALUES (1118,128109,00,'Cubans','violinist','clinker',''); INSERT INTO t2 VALUES (1119,128705,00,'photographers','extramarital','refiner',''); INSERT INTO t2 VALUES (1120,126303,00,'nymph','spates','callus',''); INSERT INTO t2 VALUES (1121,128308,00,'bedlam','cloakroom','leopards',''); INSERT INTO t2 VALUES (1122,128204,00,'north','gazer','comfortingly',''); INSERT INTO t2 VALUES (1123,128205,00,'Schoenberg','hand','generically',''); INSERT INTO t2 VALUES (1124,128206,00,'botany','tucked','getters',''); INSERT INTO t2 VALUES (1125,128207,00,'curs','gems','sexually',''); INSERT INTO t2 VALUES (1126,118205,00,'solidification','clinker','spear',''); INSERT INTO t2 VALUES (1127,116801,00,'inheritresses','refiner','serums',''); INSERT INTO t2 VALUES (1128,116803,00,'stiller','callus','Italianization',''); INSERT INTO t2 VALUES (1129,116804,00,'t1','leopards','attendants',''); INSERT INTO t2 VALUES (1130,116802,00,'suite','comfortingly','spies',''); INSERT INTO t2 VALUES (1131,128605,00,'ransomer','generically','Anthony',''); INSERT INTO t2 VALUES (1132,118308,00,'Willy','getters','planar',''); INSERT INTO t2 VALUES (1133,113702,00,'Rena','sexually','cupped',''); INSERT INTO t2 VALUES (1134,113703,00,'Seattle','spear','cleanser',''); INSERT INTO t2 VALUES (1135,112103,00,'relaxes','serums','commuters',''); INSERT INTO t2 VALUES (1136,118009,00,'exclaim','Italianization','honeysuckle',''); INSERT INTO t2 VALUES (5136,1118009,00,'exclaim','Italianization','honeysuckle',''); INSERT INTO t2 VALUES (1137,138011,00,'implicated','attendants','orphanage',''); INSERT INTO t2 VALUES (1138,138010,00,'distinguish','spies','skies',''); INSERT INTO t2 VALUES (1139,138012,00,'assayed','Anthony','crushers',''); INSERT INTO t2 VALUES (1140,068304,00,'homeowner','planar','Puritan',''); INSERT INTO t2 VALUES (1141,078009,00,'and','cupped','squeezer',''); INSERT INTO t2 VALUES (1142,108013,00,'stealth','cleanser','bruises',''); INSERT INTO t2 VALUES (1143,084004,00,'coinciding','commuters','bonfire',''); INSERT INTO t2 VALUES (1144,083402,00,'founder','honeysuckle','Colombo',''); INSERT INTO t2 VALUES (1145,084003,00,'environing','orphanage','nondecreasing',''); INSERT INTO t2 VALUES (1146,088504,00,'jewelry','skies','innocents',''); INSERT INTO t2 VALUES (1147,088005,00,'lemons','crushers','masked',''); INSERT INTO t2 VALUES (1148,088007,00,'brokenness','Puritan','file',''); INSERT INTO t2 VALUES (1149,088006,00,'bedpost','squeezer','brush',''); INSERT INTO t2 VALUES (1150,148025,00,'assurers','bruises','mutilate',''); INSERT INTO t2 VALUES (1151,148024,00,'annoyers','bonfire','mommy',''); INSERT INTO t2 VALUES (1152,138305,00,'affixed','Colombo','bulkheads',''); INSERT INTO t2 VALUES (1153,138306,00,'warbling','nondecreasing','undeclared',''); INSERT INTO t2 VALUES (1154,152701,00,'seriously','innocents','displacements',''); INSERT INTO t2 VALUES (1155,148505,00,'boasted','masked','nieces',''); INSERT INTO t2 VALUES (1156,158003,00,'Chantilly','file','coeducation',''); INSERT INTO t2 VALUES (1157,156201,00,'Iranizes','brush','brassy',''); INSERT INTO t2 VALUES (1158,156202,00,'violinist','mutilate','authenticator',''); INSERT INTO t2 VALUES (1159,158307,00,'extramarital','mommy','Washoe',''); INSERT INTO t2 VALUES (1160,158402,00,'spates','bulkheads','penny',''); INSERT INTO t2 VALUES (1161,158401,00,'cloakroom','undeclared','Flagler',''); INSERT INTO t2 VALUES (1162,068013,00,'gazer','displacements','stoned',''); INSERT INTO t2 VALUES (1163,068012,00,'hand','nieces','cranes',''); INSERT INTO t2 VALUES (1164,068203,00,'tucked','coeducation','masterful',''); INSERT INTO t2 VALUES (1165,088205,00,'gems','brassy','biracial',''); INSERT INTO t2 VALUES (1166,068704,00,'clinker','authenticator','steamships',''); INSERT INTO t2 VALUES (1167,068604,00,'refiner','Washoe','windmills',''); INSERT INTO t2 VALUES (1168,158502,00,'callus','penny','exploit',''); INSERT INTO t2 VALUES (1169,123103,00,'leopards','Flagler','riverfront',''); INSERT INTO t2 VALUES (1170,148026,00,'comfortingly','stoned','sisterly',''); INSERT INTO t2 VALUES (1171,123302,00,'generically','cranes','sharpshoot',''); INSERT INTO t2 VALUES (1172,076503,00,'getters','masterful','mittens',''); INSERT INTO t2 VALUES (1173,126304,00,'sexually','biracial','interdependency',''); INSERT INTO t2 VALUES (1174,068306,00,'spear','steamships','policy',''); INSERT INTO t2 VALUES (1175,143504,00,'serums','windmills','unleashing',''); INSERT INTO t2 VALUES (1176,160201,00,'Italianization','exploit','pretenders',''); INSERT INTO t2 VALUES (1177,148028,00,'attendants','riverfront','overstatements',''); INSERT INTO t2 VALUES (1178,148027,00,'spies','sisterly','birthed',''); INSERT INTO t2 VALUES (1179,143505,00,'Anthony','sharpshoot','opportunism',''); INSERT INTO t2 VALUES (1180,108014,00,'planar','mittens','showroom',''); INSERT INTO t2 VALUES (1181,076104,00,'cupped','interdependency','compromisingly',''); INSERT INTO t2 VALUES (1182,078106,00,'cleanser','policy','Medicare',''); INSERT INTO t2 VALUES (1183,126102,00,'commuters','unleashing','corresponds',''); INSERT INTO t2 VALUES (1184,128029,00,'honeysuckle','pretenders','hardware',''); INSERT INTO t2 VALUES (1185,128028,00,'orphanage','overstatements','implant',''); INSERT INTO t2 VALUES (1186,018410,00,'skies','birthed','Alicia',''); INSERT INTO t2 VALUES (1187,128110,00,'crushers','opportunism','requesting',''); INSERT INTO t2 VALUES (1188,148506,00,'Puritan','showroom','produced',''); INSERT INTO t2 VALUES (1189,123303,00,'squeezer','compromisingly','criticizes',''); INSERT INTO t2 VALUES (1190,123304,00,'bruises','Medicare','backer',''); INSERT INTO t2 VALUES (1191,068504,00,'bonfire','corresponds','positively',''); INSERT INTO t2 VALUES (1192,068305,00,'Colombo','hardware','colicky',''); INSERT INTO t2 VALUES (1193,000000,00,'nondecreasing','implant','thrillingly',''); --enable_query_log # # Search with a key # select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%"; select fld3 from t2 where fld3 like "%cultivation" ; # # Search with a key using sorting and limit the same time # select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3; select fld3,companynr from t2 where companynr = 58 order by fld3; select fld3 from t2 order by fld3 desc limit 10; select fld3 from t2 order by fld3 desc limit 5; select fld3 from t2 order by fld3 desc limit 5,5; # # Update # UPDATE t2 SET fld3="foo" WHERE fld3="b%"; select fld3 from t2; # # Update randomly # UPDATE t2 SET fld3="bar" WHERE fld3="s%"; select fld3 from t2; # # Delete with constant # DELETE FROM t2 WHERE fld3="r%"; SELECT fld3 FROM t2; # # Delete with Random # DELETE FROM t2 WHERE fld3="d%" ORDER BY RAND(); SELECT fld3 FROM t2; # # Rename table # DROP TABLE t1; ALTER TABLE t2 RENAME t1; # # Drop and recreate # DROP TABLE t1; CREATE TABLE t1 ( Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL, Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL ) ENGINE = CSV; INSERT INTO t1 VALUES (9410,9412); select period from t1; drop table if exists t1,t2,t3,t4; # # Bug #13894 Server crashes on update of CSV table # --disable_warnings DROP TABLE IF EXISTS bug13894; --enable_warnings CREATE TABLE bug13894 ( val integer not null ) ENGINE = CSV; INSERT INTO bug13894 VALUES (5); INSERT INTO bug13894 VALUES (10); INSERT INTO bug13894 VALUES (11); INSERT INTO bug13894 VALUES (10); SELECT * FROM bug13894; UPDATE bug13894 SET val=6 WHERE val=10; SELECT * FROM bug13894; DROP TABLE bug13894; # # Bug #14672 Bug in deletion # --disable_warnings DROP TABLE IF EXISTS bug14672; --enable_warnings CREATE TABLE bug14672 (c1 integer not null) engine = CSV; INSERT INTO bug14672 VALUES (1), (2), (3); SELECT * FROM bug14672; DELETE FROM bug14672 WHERE c1 = 2; SELECT * FROM bug14672; INSERT INTO bug14672 VALUES (4); SELECT * FROM bug14672; INSERT INTO bug14672 VALUES (5); SELECT * FROM bug14672; DROP TABLE bug14672; # End of 4.1 tests # # Test CONCURRENT INSERT (5.1) # CREATE TABLE test_concurrent_insert ( val integer not null ) ENGINE = CSV; connect (con1,localhost,root,,); connect (con2,localhost,root,,); connection con1; # obtain TL_READ lock on the table LOCK TABLES test_concurrent_insert READ LOCAL; connection con2; # should pass despite of the lock INSERT INTO test_concurrent_insert VALUES (1); SELECT * FROM test_concurrent_insert; connection con1; # first connection should not notice the changes SELECT * FROM test_concurrent_insert; UNLOCK TABLES; # Now check that we see our own changes LOCK TABLES test_concurrent_insert WRITE; INSERT INTO test_concurrent_insert VALUES (2); SELECT * FROM test_concurrent_insert; UNLOCK TABLES; # cleanup DROP TABLE test_concurrent_insert; connection default; --disconnect con1 --disconnect con2 # # Test REPAIR/CHECK TABLE (5.1) # # Check that repair on the newly created table works fine CREATE TABLE test_repair_table ( val integer not null ) ENGINE = CSV; CHECK TABLE test_repair_table; REPAIR TABLE test_repair_table; DROP TABLE test_repair_table; # # Check autorepair. Here we also check that we can work w/o metafile # restore the meta-file # CREATE TABLE test_repair_table2 ( val integer not null ) ENGINE = CSV; let $MYSQLD_DATADIR= `select @@datadir`; --remove_file $MYSQLD_DATADIR/test/test_repair_table2.CSM # Should give a warning and perform autorepair. We also disable ps-protocol # here, as mysql-test eats up warnings in ps-protocol mode --disable_ps_protocol SELECT * from test_repair_table2; --enable_ps_protocol # this should work ok, as the table is already repaired SELECT * from test_repair_table2; # check that the metafile appeared again. --file_exists $MYSQLD_DATADIR/test/test_repair_table2.CSM CHECK TABLE test_repair_table2; DROP TABLE test_repair_table2; # Corrupt csv file and see if we can repair it CREATE TABLE test_repair_table3 ( val integer not null ) ENGINE = CSV; --remove_file $MYSQLD_DATADIR/test/test_repair_table3.CSV --write_file $MYSQLD_DATADIR/test/test_repair_table3.CSV "1" "4" "3 EOF CHECK TABLE test_repair_table3; REPAIR TABLE test_repair_table3; SELECT * FROM test_repair_table3; DROP TABLE test_repair_table3; # Test with more sophisticated table CREATE TABLE test_repair_table4 ( num int not null, magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL, company_name char(30) DEFAULT '' NOT NULL, founded char(4) DEFAULT '' NOT NULL ) ENGINE = CSV; --remove_file $MYSQLD_DATADIR/test/test_repair_table4.CSM --disable_ps_protocol SELECT * FROM test_repair_table4; --enable_ps_protocol SELECT * FROM test_repair_table4; CHECK TABLE test_repair_table4; INSERT INTO test_repair_table4 VALUES (2,101,'SAP','1972'); INSERT INTO test_repair_table4 VALUES (1,101,'Microsoft','1978'); INSERT INTO test_repair_table4 VALUES (2,101,'MySQL','1995'); # list table content SELECT * FROM test_repair_table4; CHECK TABLE test_repair_table4; REPAIR TABLE test_repair_table4; # check that nothing changed SELECT * FROM test_repair_table4; # verify that check/repair did non corrupt the table itself CHECK TABLE test_repair_table4; REPAIR TABLE test_repair_table4; SELECT * FROM test_repair_table4; DROP TABLE test_repair_table4; # Run CHECK/REPAIR on the CSV file with a single row, which misses a column. CREATE TABLE test_repair_table5 ( num int not null, magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL, company_name char(30) DEFAULT '' NOT NULL, founded char(4) DEFAULT '' NOT NULL ) ENGINE = CSV; # Corrupt a table -- put a file with wrong # of columns --remove_file $MYSQLD_DATADIR/test/test_repair_table5.CSV --write_file $MYSQLD_DATADIR/test/test_repair_table5.CSV "1","101","IBM" EOF CHECK TABLE test_repair_table5; REPAIR TABLE test_repair_table5; SELECT * FROM test_repair_table5; INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT", 1876); SELECT * FROM test_repair_table5; # Corrupt a table -- put a row with wrong # of columns at end of file --append_file $MYSQLD_DATADIR/test/test_repair_table5.CSV "1","101","IBM" EOF FLUSH TABLES; CHECK TABLE test_repair_table5; REPAIR TABLE test_repair_table5; # The correct record inserted should still be in the file SELECT * FROM test_repair_table5; INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT2", 1876); SELECT * FROM test_repair_table5; # Corrupt table again -- put a row with wrong # of columns at end of file --append_file $MYSQLD_DATADIR/test/test_repair_table5.CSV "1","101","IBM" EOF FLUSH TABLES; CHECK TABLE test_repair_table5; REPAIR TABLE test_repair_table5; # The two correct records inserted should still be in the file SELECT * FROM test_repair_table5; DROP TABLE test_repair_table5; # # BUG#13406 - incorrect amount of "records deleted" # create table t1 (a int not null) engine=csv; insert t1 values (1); --enable_info delete from t1; # delete_row delete from t1; # delete_all_rows --disable_info insert t1 values (1),(2); --enable_info ONCE delete from t1; # delete_all_rows insert t1 values (1),(2),(3); flush tables; --enable_info ONCE delete from t1; # delete_row insert t1 values (1),(2),(3),(4); flush tables; select count(*) from t1; --enable_info ONCE delete from t1; # delete_all_rows insert t1 values (1),(2),(3),(4),(5); --enable_info ONCE truncate table t1; # truncate drop table t1; # # Some additional tests for new, faster alter table. Note that most of the # whole alter table code is being tested all around the test suite already. # create table t1 (v varchar(32) not null) engine=csv; insert into t1 values ('def'),('abc'),('hij'),('3r4f'); select * from t1; # Fast alter, no copy performed alter table t1 change v v2 varchar(32) not null; select * from t1; # Fast alter, no copy performed alter table t1 change v2 v varchar(64) not null; select * from t1; update t1 set v = 'lmn' where v = 'hij'; select * from t1; # Regular alter table alter table t1 add i int not null first; select * from t1; update t1 set i=3 where v = 'abc'; select * from t1; alter table t1 change i i bigint not null; select * from t1; select * from t1 where i between 2 and 4 and v in ('def','3r4f','abc'); drop table t1; # # Bug #15205 Select from CSV table without the datafile causes crash # # NOTE: the bug is not deterministic # The crash happens because the necessary cleanup after an error wasn't # performed. Namely, the table share, inserted in the hash during table # open, was not deleted from hash. At the same time the share was freed # when an error was encountered. Thus, subsequent access to the hash # resulted in scanning through deleted memory and we were geting a crash. # that's why we need two tables in the bugtest create table bug15205 (val int(11) not null) engine=csv; create table bug15205_2 (val int(11) not null) engine=csv; --remove_file $MYSQLD_DATADIR/test/bug15205.CSV # system error (can't open the datafile) --replace_result $MYSQLTEST_VARDIR . mysqld.1/data/ '' --error 13 select * from bug15205; select * from bug15205_2; # Create empty file --write_file $MYSQLD_DATADIR/test/bug15205.CSV EOF select * from bug15205; drop table bug15205; drop table bug15205_2; # # Bug#28862 "Extended Latin1 characters get lost in CVS engine" # set names latin1; create table t1 ( c varchar(1) not null, name varchar(64) not null ) character set latin1 engine=csv; insert into t1 values (0xC0,'LATIN CAPITAL LETTER A WITH GRAVE'); insert into t1 values (0xE0,'LATIN SMALL LETTER A WITH GRAVE'); insert into t1 values (0xEE,'LATIN SMALL LETTER I WITH CIRCUMFLEX'); insert into t1 values (0xFE,'LATIN SMALL LETTER THORN'); insert into t1 values (0xF7,'DIVISION SIGN'); insert into t1 values (0xFF,'LATIN SMALL LETTER Y WITH DIAERESIS'); select hex(c), c, name from t1 order by 1; drop table t1; --echo End of 5.0 tests # # Bug#22080 "CHECK fails to identify some corruption" # create table bug22080_1 (id int not null,string varchar(64) not null) Engine=CSV; create table bug22080_2 (id int not null,string varchar(64) not null) Engine=CSV; create table bug22080_3 (id int not null,string varchar(64) not null) Engine=CSV; insert into bug22080_1 values(1,'string'); insert into bug22080_1 values(2,'string'); insert into bug22080_1 values(3,'string'); # Create first corrupt file as described in bug report --remove_file $MYSQLD_DATADIR/test/bug22080_2.CSV --write_file $MYSQLD_DATADIR/test/bug22080_2.CSV 1,"string" 2","string" 3,"string" EOF # Create second corrupt file as described in bug report --remove_file $MYSQLD_DATADIR/test/bug22080_3.CSV --write_file $MYSQLD_DATADIR/test/bug22080_3.CSV 1,"string" "2",string" 3,"string" EOF check table bug22080_2; check table bug22080_3; drop tables bug22080_1,bug22080_2,bug22080_3; # # Testing float type # create table float_test (id float not null,string varchar(64) not null) Engine=CSV; insert into float_test values(1.0,'string'); insert into float_test values(2.23,'serg.g'); insert into float_test values(0.03,'string'); insert into float_test values(0.19,'string'); insert into float_test values(.67,'string'); insert into float_test values(9.67,'string'); select * from float_test; drop table float_test; # # Bug #21328 mysqld issues warnings on ALTER CSV table to MyISAM # CREATE TABLE `bug21328` ( `col1` int(11) NOT NULL, `col2` int(11) NOT NULL, `col3` int(11) NOT NULL ) ENGINE=CSV; insert into bug21328 values (1,0,0); alter table bug21328 engine=myisam; drop table bug21328; # # BUG#28971 - ALTER TABLE followed by UPDATE for a CSV table make server # crash # create table t1(a blob not null, b int not null) engine=csv; insert into t1 values('a', 1); flush tables; update t1 set b=2; select * from t1; drop table t1; # # Bug #29353: negative values # create table t1(a int not null) engine=csv; insert into t1 values(-1), (-123.34), (2), (-23); select * from t1; check table t1; drop table t1; create table t1(a int not null, b int not null) engine=csv; --remove_file $MYSQLD_DATADIR/test/t1.CSV --write_file $MYSQLD_DATADIR/test/t1.CSV 1, 1E-2 -2E2, .9 -10E-1, -.9 -1, -100.1 1a, -2b EOF repair table t1; check table t1; select * from t1; check table t1; drop table t1; # # Bug #29411: deleting from a csv table leads to the table corruption # create table t1(a int not null) engine=csv; insert into t1 values (0), (1), (2); delete from t1 limit 2; check table t1; select * from t1; delete from t1; check table t1; select * from t1; drop table t1; # # Bug #31473: does not work with NULL value in datetime field # SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1(a datetime not null) engine=csv; insert into t1 values(); select * from t1; drop table t1; create table t1(a set('foo','bar') not null) engine=csv; insert into t1 values(); select * from t1; drop table t1; create table t1(a varchar(32) not null) engine=csv; insert into t1 values(); select * from t1; drop table t1; create table t1(a int not null) engine=csv; insert into t1 values(); select * from t1; drop table t1; create table t1(a blob not null) engine=csv; insert into t1 values(); select * from t1; drop table t1; create table t1(a bit(1) not null) engine=csv; insert into t1 values(); select BIN(a) from t1; drop table t1; # We prevent creation of table with nullable ENUM --error ER_CHECK_NOT_IMPLEMENTED create table t1(a enum('foo','bar') default null) engine=csv; --error ER_CHECK_NOT_IMPLEMENTED create table t1(a enum('foo','bar') default 'foo') engine=csv; # Enum columns must be specified as NOT NULL create table t1(a enum('foo','bar') default 'foo' not null) engine=csv; insert into t1 values(); select * from t1; drop table t1; SET sql_mode = default; # # BUG#32817 - though CSV is marked as supported create table is rejected # with error 1005. # --error ER_CHECK_NOT_IMPLEMENTED CREATE TABLE t1(a INT) ENGINE=CSV; SHOW WARNINGS; # # BUG#33067 - . # create table t1 (c1 tinyblob not null) engine=csv; insert into t1 values("This"); --enable_info ONCE update t1 set c1="That" where c1="This"; select * from t1; drop table t1; # # Bug#36638 mysqld crashes when open file limit is passed and general query log enabled # create table t1 (a int not null) engine=csv; lock tables t1 read; connect (con1,localhost,root,,); --connection con1 --remove_file $MYSQLD_DATADIR/test/t1.CSV # Error returned depends on platform --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR/ ./ MYSQLD_DATADIR/ "13 - Permission denied" "2 - No such file or directory" # EE_FILENOTFOUND 29 --error 29 select * from t1; --disconnect con1 --source include/wait_until_disconnected.inc connection default; unlock tables; drop table t1; # # Bug#33717 INSERT...(default) fails for enum. Crashes CSV tables, loads spaces for MyISAM # CREATE TABLE t1 (e enum('foo','bar') NOT NULL) ENGINE = CSV; INSERT INTO t1 VALUES(); INSERT INTO t1 VALUES(default); INSERT IGNORE INTO t1 VALUES(0); INSERT IGNORE INTO t1 VALUES(3); INSERT IGNORE INTO t1 VALUES(-1); SELECT * FROM t1; DROP TABLE t1; # # Bug #40814 CSV engine does not parse \X characters when they occur in unquoted fields # --echo # --echo # Test for the following cases --echo # 1) integers and strings enclosed in quotes --echo # 2) integers and strings not enclosed in quotes --echo # 3) \X characters with quotes --echo # 4) \X characters outside quotes --echo # CREATE TABLE t1(c1 INT NOT NULL, c2 VARCHAR(50) NOT NULL) ENGINE=csv; --echo # remove the already existing .CSV file if any --remove_file $MYSQLD_DATADIR/test/t1.CSV --echo # create the .CSV file that contains the hard-coded data used in --echo # testing --write_file $MYSQLD_DATADIR/test/t1.CSV 1,"integer sans quotes" 1,string sans quotes 1,quotes"in between" strings "1",Integer with quote and string with no quote 1,"escape sequence \n \" \\ \r \a within quotes" 1,escape sequence \n \" \\ \r \a without quotes EOF --cat_file $MYSQLD_DATADIR/test/t1.CSV --echo # select from the table in which the data has been filled in using --echo # the hard-coded .CSV file SELECT * FROM t1; DROP TABLE t1; --echo # Test for the case when a field begins with a quote, but does not end in a --echo # quote. --echo # Note: This results in an error. CREATE TABLE t1(c1 INT NOT NULL, c2 VARCHAR(50) NOT NULL) ENGINE=csv; --echo # remove the already existing .CSV file if any --remove_file $MYSQLD_DATADIR/test/t1.CSV --echo # create the .CSV file that contains the hard-coded data used in --echo # testing --write_file $MYSQLD_DATADIR/test/t1.CSV 1,"string only at the beginning quotes EOF --cat_file $MYSQLD_DATADIR/test/t1.CSV --echo # select from the table in which the data has been filled in using --echo # the hard-coded .CSV file --error ER_CRASHED_ON_USAGE SELECT * FROM t1; DROP TABLE t1; --echo # Test for the case when a field ends with a quote, but does not begin in a --echo # quote. --echo # Note: This results in an error. CREATE TABLE t1(c1 INT NOT NULL, c2 VARCHAR(50) NOT NULL) ENGINE=csv; --echo # remove the already existing .CSV file if any --remove_file $MYSQLD_DATADIR/test/t1.CSV --echo # create the .CSV file that contains the hard-coded data used in --echo # testing --write_file $MYSQLD_DATADIR/test/t1.CSV 1,string with only ending quotes" EOF --cat_file $MYSQLD_DATADIR/test/t1.CSV --echo # select from the table in which the data has been filled in using --echo # the hard-coded .CSV file --error ER_CRASHED_ON_USAGE SELECT * FROM t1; DROP TABLE t1; --echo End of 5.1 tests
Close