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.226.181.89
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 : gis.test
# This tests GIS functionality with Myisam engine # These tests are also exists in Innodb # All tests are required to run with Myisam. # Hence MTR starts mysqld with MyISAM as default --source include/force_myisam_default.inc --source include/have_myisam.inc -- source include/have_geometry.inc SET sql_mode = 'ONLY_FULL_GROUP_BY,NO_ENGINE_SUBSTITUTION'; # # Spatial objects # --disable_warnings DROP TABLE IF EXISTS t1, gis_point, gis_line, gis_polygon, gis_multi_point, gis_multi_line, gis_multi_polygon, gis_geometrycollection, gis_geometry; --enable_warnings CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT); CREATE TABLE gis_line (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING); CREATE TABLE gis_polygon (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON); CREATE TABLE gis_multi_point (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT); CREATE TABLE gis_multi_line (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING); CREATE TABLE gis_multi_polygon (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON); CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION); CREATE TABLE gis_geometry (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY); SHOW FIELDS FROM gis_point; SHOW FIELDS FROM gis_line; SHOW FIELDS FROM gis_polygon; SHOW FIELDS FROM gis_multi_point; SHOW FIELDS FROM gis_multi_line; SHOW FIELDS FROM gis_multi_polygon; SHOW FIELDS FROM gis_geometrycollection; SHOW FIELDS FROM gis_geometry; INSERT INTO gis_point VALUES (101, ST_PointFromText('POINT(10 10)')), (102, ST_PointFromText('POINT(20 10)')), (103, ST_PointFromText('POINT(20 20)')), (104, ST_PointFromWKB(ST_AsWKB(ST_PointFromText('POINT(10 20)')))); INSERT INTO gis_line VALUES (105, ST_LineFromText('LINESTRING(0 0,0 10,10 0)')), (106, ST_LineStringFromText('LINESTRING(10 10,20 10,20 20,10 20,10 10)')), (107, ST_LineStringFromWKB(ST_AsWKB(LineString(Point(10, 10), Point(40, 10))))); INSERT INTO gis_polygon VALUES (108, ST_PolygonFromText('POLYGON((10 10,20 10,20 20,10 20,10 10))')), (109, ST_PolyFromText('POLYGON((0 0,50 0,50 50,0 50,0 0), (10 10,20 10,20 20,10 20,10 10))')), (110, ST_PolyFromWKB(ST_AsWKB(Polygon(LineString(Point(0, 0), Point(30, 0), Point(30, 30), Point(0, 0)))))); INSERT INTO gis_multi_point VALUES (111, ST_MultiPointFromText('MULTIPOINT(0 0,10 10,10 20,20 20)')), (112, ST_MPointFromText('MULTIPOINT(1 1,11 11,11 21,21 21)')), (113, ST_MPointFromWKB(ST_AsWKB(MultiPoint(Point(3, 6), Point(4, 10))))); INSERT INTO gis_multi_line VALUES (114, ST_MultiLineStringFromText('MULTILINESTRING((10 48,10 21,10 0),(16 0,16 23,16 48))')), (115, ST_MLineFromText('MULTILINESTRING((10 48,10 21,10 0))')), (116, ST_MLineFromWKB(ST_AsWKB(MultiLineString(LineString(Point(1, 2), Point(3, 5)), LineString(Point(2, 5), Point(5, 8), Point(21, 7)))))); INSERT INTO gis_multi_polygon VALUES (117, ST_MultiPolygonFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))')), (118, ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))')), (119, ST_MPolyFromWKB(ST_AsWKB(MultiPolygon(Polygon(LineString(Point(0, 3), Point(3, 3), Point(3, 0), Point(0, 3))))))); INSERT INTO gis_geometrycollection VALUES (120, ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')), (121, ST_GeometryFromWKB(ST_AsWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))))); INSERT into gis_geometry SELECT * FROM gis_point; INSERT into gis_geometry SELECT * FROM gis_line; INSERT into gis_geometry SELECT * FROM gis_polygon; INSERT into gis_geometry SELECT * FROM gis_multi_point; INSERT into gis_geometry SELECT * FROM gis_multi_line; INSERT into gis_geometry SELECT * FROM gis_multi_polygon; INSERT into gis_geometry SELECT * FROM gis_geometrycollection; SELECT fid, ST_AsText(g) FROM gis_point; SELECT fid, ST_AsText(g) FROM gis_line; SELECT fid, ST_AsText(g) FROM gis_polygon; SELECT fid, ST_AsText(g) FROM gis_multi_point; SELECT fid, ST_AsText(g) FROM gis_multi_line; SELECT fid, ST_AsText(g) FROM gis_multi_polygon; SELECT fid, ST_AsText(g) FROM gis_geometrycollection; SELECT fid, ST_AsText(g) FROM gis_geometry; SELECT fid, ST_Dimension(g) FROM gis_geometry; SELECT fid, ST_GeometryType(g) FROM gis_geometry; SELECT fid, ST_IsEmpty(g) FROM gis_geometry; SELECT fid, ST_AsText(ST_Envelope(g)) FROM gis_geometry; explain extended select ST_Dimension(g), ST_GeometryType(g), ST_IsEmpty(g), ST_AsText(ST_Envelope(g)) from gis_geometry; SELECT fid, ST_X(g) FROM gis_point; SELECT fid, ST_Y(g) FROM gis_point; explain extended select ST_X(g),ST_Y(g) FROM gis_point; SELECT fid, ST_AsText(ST_StartPoint(g)) FROM gis_line; SELECT fid, ST_AsText(ST_EndPoint(g)) FROM gis_line; SELECT fid, ST_Length(g) FROM gis_line; SELECT fid, ST_NumPoints(g) FROM gis_line; SELECT fid, ST_AsText(ST_PointN(g, 2)) FROM gis_line; SELECT fid, ST_IsClosed(g) FROM gis_line; explain extended select ST_AsText(ST_StartPoint(g)),ST_AsText(ST_EndPoint(g)),ST_Length(g),ST_NumPoints(g),ST_AsText(ST_PointN(g, 2)),ST_IsClosed(g) FROM gis_line; SELECT fid, ST_AsText(ST_Centroid(g)) FROM gis_polygon; SELECT fid, ST_Area(g) FROM gis_polygon; SELECT fid, ST_AsText(ST_ExteriorRing(g)) FROM gis_polygon; SELECT fid, ST_NumInteriorRings(g) FROM gis_polygon; SELECT fid, ST_AsText(ST_InteriorRingN(g, 1)) FROM gis_polygon; explain extended select ST_AsText(ST_Centroid(g)),ST_Area(g),ST_AsText(ST_ExteriorRing(g)),ST_NumInteriorRings(g),ST_AsText(ST_InteriorRingN(g, 1)) FROM gis_polygon; SELECT fid, ST_IsClosed(g) FROM gis_multi_line; SELECT fid, ST_AsText(ST_Centroid(g)) FROM gis_multi_polygon; SELECT fid, ST_Area(g) FROM gis_multi_polygon; SELECT fid, ST_NumGeometries(g) from gis_multi_point; SELECT fid, ST_NumGeometries(g) from gis_multi_line; SELECT fid, ST_NumGeometries(g) from gis_multi_polygon; SELECT fid, ST_NumGeometries(g) from gis_geometrycollection; explain extended SELECT fid, ST_NumGeometries(g) from gis_multi_point; SELECT fid, ST_AsText(ST_GeometryN(g, 2)) from gis_multi_point; SELECT fid, ST_AsText(ST_GeometryN(g, 2)) from gis_multi_line; SELECT fid, ST_AsText(ST_GeometryN(g, 2)) from gis_multi_polygon; SELECT fid, ST_AsText(ST_GeometryN(g, 2)) from gis_geometrycollection; SELECT fid, ST_AsText(ST_GeometryN(g, 1)) from gis_geometrycollection; explain extended SELECT fid, ST_AsText(ST_GeometryN(g, 2)) from gis_multi_point; SELECT g1.fid as first, g2.fid as second, MBRWithin(g1.g, g2.g) as w, MBRContains(g1.g, g2.g) as c, MBROverlaps(g1.g, g2.g) as o, MBREquals(g1.g, g2.g) as e, MBRDisjoint(g1.g, g2.g) as d, ST_Touches(g1.g, g2.g) as t, MBRIntersects(g1.g, g2.g) as i, ST_Crosses(g1.g, g2.g) as r FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second; explain extended SELECT g1.fid as first, g2.fid as second, MBRWithin(g1.g, g2.g) as w, MBRContains(g1.g, g2.g) as c, MBROverlaps(g1.g, g2.g) as o, MBREquals(g1.g, g2.g) as e, MBRDisjoint(g1.g, g2.g) as d, ST_Touches(g1.g, g2.g) as t, MBRIntersects(g1.g, g2.g) as i, ST_Crosses(g1.g, g2.g) as r FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second; DROP TABLE gis_point, gis_line, gis_polygon, gis_multi_point, gis_multi_line, gis_multi_polygon, gis_geometrycollection, gis_geometry; # # Check that ALTER TABLE doesn't loose geometry type # CREATE TABLE t1 ( gp point, ln linestring, pg polygon, mp multipoint, mln multilinestring, mpg multipolygon, gc geometrycollection, gm geometry ); SHOW FIELDS FROM t1; ALTER TABLE t1 ADD fid INT NOT NULL; SHOW FIELDS FROM t1; DROP TABLE t1; SELECT ST_AsText(ST_GeometryFromWKB(ST_AsWKB(ST_GeometryFromText('POINT(1 4)')))); explain extended SELECT ST_AsText(ST_GeometryFromWKB(ST_AsWKB(ST_GeometryFromText('POINT(1 4)')))); explain extended SELECT ST_AsText(ST_GeometryFromWKB(ST_AsWKB(ST_PointFromText('POINT(1 4)')))); SELECT ST_SRID(ST_GeomFromText('LineString(1 1,2 2)',101)); explain extended SELECT ST_SRID(ST_GeomFromText('LineString(1 1,2 2)',101)); #select ST_issimple(MultiPoint(Point(3, 6), Point(4, 10))), ST_issimple(Point(3, 6)),ST_issimple(ST_PolygonFromText('POLYGON((10 10,20 10,20 20,10 20,10 10))')),ST_issimple(ST_GeometryFromText('POINT(1 4)')), ST_issimple(ST_AsWKB(ST_GeometryFromText('POINT(1 4)'))); explain extended select ST_issimple(MultiPoint(Point(3, 6), Point(4, 10))), ST_issimple(Point(3, 6)); create table t1 (a geometry not null); insert into t1 values (ST_GeomFromText('Point(1 2)')); -- error 1416 insert into t1 values ('Garbage'); -- error 1416 insert IGNORE into t1 values ('Garbage'); alter table t1 add spatial index(a); drop table t1; # # Bug #5219: problem with range optimizer # create table t1(a geometry not null, spatial index(a)); insert into t1 values (ST_GeomFromText('POINT(1 1)')), (ST_GeomFromText('POINT(3 3)')), (ST_GeomFromText('POINT(4 4)')), (ST_GeomFromText('POINT(6 6)')); select ST_AsText(a) from t1 where MBRContains(ST_GeomFromText('Polygon((0 0, 0 2, 2 2, 2 0, 0 0))'), a) or MBRContains(ST_GeomFromText('Polygon((2 2, 2 5, 5 5, 5 2, 2 2))'), a); select ST_AsText(a) from t1 where MBRContains(ST_GeomFromText('Polygon((0 0, 0 2, 2 2, 2 0, 0 0))'), a) and MBRContains(ST_GeomFromText('Polygon((0 0, 0 7, 7 7, 7 0, 0 0))'), a); drop table t1; CREATE TABLE t1 (Coordinates POINT NOT NULL, SPATIAL INDEX(Coordinates)); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(383293632 1754448)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(564952612 157516260)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(903994614 180726515)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(98128178 141127631)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(862547902 799334546)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(341989013 850270906)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(803302376 93039099)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(857439153 817431356)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(319757546 343162742)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(826341972 717484432)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(305066789 201736238)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(626068992 616241497)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(55789424 755830108)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(802874458 312435220)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(153795660 551723671)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(242207428 537089292)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(553478119 807160039)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(694605552 457472733)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(987886554 792733729)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(598600363 850434457)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(592068275 940589376)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(700705362 395370650)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(33628474 558144514)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(212802006 353386020)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(901307256 39143977)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(70870451 206374045)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(240880214 696939443)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(822615542 296669638)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(452769551 625489999)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(609104858 606565210)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(177213669 851312285)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(143654501 730691787)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(658472325 838260052)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(188164520 646358878)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(630993781 786764883)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(496793334 223062055)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(727354258 197498696)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(618432704 760982731)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(755643210 831234710)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(114368751 656950466)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(870378686 185239202)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(863324511 111258900)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(882178645 685940052)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(407928538 334948195)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(311430051 17033395)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(941513405 488643719)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(868345680 85167906)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(219335507 526818004)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(923427958 407500026)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(173176882 554421738)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(194264908 669970217)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(777483793 921619165)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(867468912 395916497)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(682601897 623112122)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(227151206 796970647)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(280062588 97529892)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(982209849 143387099)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(208788792 864388493)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(829327151 616717329)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(199336688 140757201)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(633750724 140850093)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(629400920 502096404)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(226017998 848736426)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(28914408 149445955)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(256236452 202091290)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(703867693 450501360)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(872061506 481351486)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(372120524 739530418)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(877267982 54722420)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(362642540 104419188)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(851693067 642705127)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(201949080 833902916)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(786092225 410737872)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(698291409 615419376)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(27455201 897628096)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(756176576 661205925)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(38478189 385577496)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(163302328 264496186)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(234313922 192216735)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(413942141 490550373)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(394308025 117809834)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(941051732 266369530)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(599161319 313172256)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(5899948 476429301)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(367894677 368542487)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(580848489 219587743)')); INSERT INTO t1 VALUES(ST_GeomFromText('POINT(11247614 782797569)')); drop table t1; create table t1 select ST_GeomFromWKB(POINT(1,3)); show create table t1; drop table t1; CREATE TABLE `t1` (`object_id` bigint(20) unsigned NOT NULL default '0', `geo` geometry NOT NULL default '') ENGINE=MyISAM ; insert into t1 values ('85984',ST_GeomFromText('MULTIPOLYGON(((-115.006363 36.305435,-114.992394 36.305202,-114.991219 36.305975,-114.991163 36.306845,-114.989432 36.309452,-114.978275 36.312642,-114.977363 36.311978,-114.975327 36.312344,-114.96502 36.31597,-114.963364 36.313629,-114.961723 36.313721,-114.956398 36.316057,-114.951882 36.320979,-114.947073 36.323475,-114.945207 36.326451,-114.945207 36.326451,-114.944132 36.326061,-114.94003 36.326588,-114.924017 36.334484,-114.923281 36.334146,-114.92564 36.331504,-114.94072 36.319282,-114.945348 36.314812,-114.948091 36.314762,-114.951755 36.316211,-114.952446 36.313883,-114.952644 36.309488,-114.944725 36.313083,-114.93706 36.32043,-114.932478 36.323497,-114.924556 36.327708,-114.922608 36.329715,-114.92009 36.328695,-114.912105 36.323566,-114.901647 36.317952,-114.897436 36.313968,-114.895344 36.309573,-114.891699 36.304398,-114.890569 36.303551,-114.886356 36.302702,-114.885141 36.301351,-114.885709 36.297391,-114.892499 36.290893,-114.902142 36.288974,-114.904941 36.288838,-114.905308 36.289845,-114.906325 36.290395,-114.909916 36.289549,-114.914527 36.287535,-114.918797 36.284423,-114.922982 36.279731,-114.924113 36.277282,-114.924057 36.275817,-114.927733 36.27053,-114.929354 36.269029,-114.929354 36.269029,-114.950856 36.268715,-114.950768 36.264324,-114.960206 36.264293,-114.960301 36.268943,-115.006662 36.268929,-115.008583 36.265619,-115.00665 36.264247,-115.006659 36.246873,-115.006659 36.246873,-115.006838 36.247697,-115.010764 36.247774,-115.015609 36.25113,-115.015765 36.254505,-115.029517 36.254619,-115.038573 36.249317,-115.038573 36.249317,-115.023403 36.25841,-115.023873 36.258994,-115.031845 36.259829,-115.03183 36.261053,-115.025561 36.261095,-115.036417 36.274632,-115.033729 36.276041,-115.032217 36.274851,-115.029845 36.273959,-115.029934 36.274966,-115.025763 36.274896,-115.025406 36.281044,-115.028731 36.284471,-115.036497 36.290377,-115.042071 36.291039,-115.026759 36.298478,-115.008995 36.301966,-115.006363 36.305435),(-115.079835 36.244369,-115.079735 36.260186,-115.076435 36.262369,-115.069758 36.265,-115.070235 36.268757,-115.064542 36.268655,-115.061843 36.269857,-115.062676 36.270693,-115.06305 36.272344,-115.059051 36.281023,-115.05918 36.283008,-115.060591 36.285246,-115.061913 36.290022,-115.062499 36.306353,-115.062499 36.306353,-115.060918 36.30642,-115.06112 36.289779,-115.05713 36.2825,-115.057314 36.279446,-115.060779 36.274659,-115.061366 36.27209,-115.057858 36.26557,-115.055805 36.262883,-115.054688 36.262874,-115.047335 36.25037,-115.044234 36.24637,-115.052434 36.24047,-115.061734 36.23507,-115.061934 36.22677,-115.061934 36.22677,-115.061491 36.225267,-115.062024 36.218194,-115.060134 36.218278,-115.060133 36.210771,-115.057833 36.210771,-115.057433 36.196271,-115.062233 36.196271,-115.062233 36.190371,-115.062233 36.190371,-115.065533 36.190371,-115.071333 36.188571,-115.098331 36.188275,-115.098331 36.188275,-115.098435 36.237569,-115.097535 36.240369,-115.097535 36.240369,-115.093235 36.240369,-115.089135 36.240469,-115.083135 36.240569,-115.083135 36.240569,-115.079835 36.244369)))')),('85998',ST_GeomFromText('MULTIPOLYGON(((-115.333107 36.264587,-115.333168 36.280638,-115.333168 36.280638,-115.32226 36.280643,-115.322538 36.274311,-115.327222 36.274258,-115.32733 36.263026,-115.330675 36.262984,-115.332132 36.264673,-115.333107 36.264587),(-115.247239 36.247066,-115.247438 36.218267,-115.247438 36.218267,-115.278525 36.219263,-115.278525 36.219263,-115.301545 36.219559,-115.332748 36.219197,-115.332757 36.220041,-115.332757 36.220041,-115.332895 36.233514,-115.349023 36.233479,-115.351489 36.234475,-115.353681 36.237021,-115.357106 36.239789,-115.36519 36.243331,-115.368156 36.243487,-115.367389 36.244902,-115.364553 36.246014,-115.359219 36.24616,-115.356186 36.248025,-115.353347 36.248004,-115.350813 36.249507,-115.339673 36.25387,-115.333069 36.255018,-115.333069 36.255018,-115.333042 36.247767,-115.279039 36.248666,-115.263639 36.247466,-115.263839 36.252766,-115.261439 36.252666,-115.261439 36.247366,-115.247239 36.247066)))')); select object_id, ST_geometrytype(geo), ST_ISSIMPLE(GEO), ST_ASTEXT(ST_centroid(geo)) from t1 where object_id=85998; select object_id, ST_geometrytype(geo), ST_ISSIMPLE(GEO), ST_ASTEXT(ST_centroid(geo)) from t1 where object_id=85984; drop table t1; create table t1 (fl geometry not null); --error 1416 insert into t1 values (1); --error 1416 insert into t1 values (1.11); --error 1416 insert into t1 values ("qwerty"); --error 1048 --error ER_GIS_INVALID_DATA insert into t1 values (ST_pointfromtext('point(1,1)')); drop table t1; select (ST_asWKT(ST_geomfromwkb((0x000000000140240000000000004024000000000000)))); select (ST_asWKT(ST_geomfromwkb((0x010100000000000000000024400000000000002440)))); --enable_metadata create table t1 (g GEOMETRY); select * from t1; select ST_asbinary(g) from t1; --disable_metadata drop table t1; create table t1 (a TEXT, b GEOMETRY NOT NULL, SPATIAL KEY(b)); alter table t1 disable keys; --error 1263 load data infile '../../std_data/bad_gis_data.dat' into table t1; alter table t1 enable keys; drop table t1; # # Bug #26038: is null and bad data # create table t1 (a int, b blob); insert into t1 values (1, ''), (2, NULL), (3, '1'); select * from t1; --error ER_ILLEGAL_VALUE_FOR_TYPE select ST_geometryfromtext(b) IS NULL, ST_geometryfromwkb(b) IS NULL, ST_astext(b) IS NULL, ST_aswkb(b) IS NULL, ST_geometrytype(b) IS NULL, ST_centroid(b) IS NULL, ST_envelope(b) IS NULL, ST_startpoint(b) IS NULL, ST_endpoint(b) IS NULL, ST_exteriorring(b) IS NULL, ST_pointn(b, 1) IS NULL, ST_geometryn(b, 1) IS NULL, ST_interiorringn(b, 1) IS NULL, multipoint(b) IS NULL, ST_isempty(b) IS NULL, ST_issimple(b) IS NULL, ST_isclosed(b) IS NULL, ST_dimension(b) IS NULL, ST_numgeometries(b) IS NULL, ST_numinteriorrings(b) IS NULL, ST_numpoints(b) IS NULL, ST_area(b) IS NULL, ST_length(b) IS NULL, ST_srid(b) IS NULL, ST_x(b) IS NULL, ST_y(b) IS NULL from t1; --error ER_GIS_INVALID_DATA select MBRwithin(b, b) IS NULL, MBRcontains(b, b) IS NULL, MBRoverlaps(b, b) IS NULL, MBRequals(b, b) IS NULL, MBRdisjoint(b, b) IS NULL, ST_touches(b, b) IS NULL, MBRintersects(b, b) IS NULL, ST_crosses(b, b) IS NULL from t1; --error ER_ILLEGAL_VALUE_FOR_TYPE select point(b, b) IS NULL, linestring(b) IS NULL, polygon(b) IS NULL, multipoint(b) IS NULL, multilinestring(b) IS NULL, multipolygon(b) IS NULL, geometrycollection(b) IS NULL from t1; drop table t1; # # Bug #27164: Crash when mixing InnoDB and MyISAM Geospatial tables # CREATE TABLE t1(a POINT) ENGINE=MyISAM; INSERT INTO t1 VALUES (NULL); SELECT * FROM t1; DROP TABLE t1; # # Bug #30955 ST_geomfromtext() crasher # CREATE TABLE `t1` ( `col9` set('a'), `col89` date); INSERT INTO `t1` VALUES ('','0000-00-00'); --error ER_GIS_INVALID_DATA select ST_geomfromtext(col9,col89) as a from t1; DROP TABLE t1; # # Bug #31158 Spatial, Union, LONGBLOB vs BLOB bug (crops data) # CREATE TABLE t1 ( geomdata polygon NOT NULL, SPATIAL KEY index_geom (geomdata) ) ENGINE=MyISAM DEFAULT CHARSET=latin2 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED; CREATE TABLE t2 ( geomdata polygon NOT NULL, SPATIAL KEY index_geom (geomdata) ) ENGINE=MyISAM DEFAULT CHARSET=latin2 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED; CREATE TABLE t3 select ST_aswkb(ws.geomdata) AS geomdatawkb from t1 ws union select ST_aswkb(ws.geomdata) AS geomdatawkb from t2 ws; describe t3; drop table t1; drop table t2; drop table t3; # # Bug #30284 spatial key corruption # create table t1(col1 geometry default null,col15 geometrycollection not null,spatial index(col15),index(col1(15)))engine=myisam; --error ER_CANT_CREATE_GEOMETRY_OBJECT insert into t1 set col15 = ST_GeomFromText('POINT(6 5)'); --error ER_CANT_CREATE_GEOMETRY_OBJECT insert into t1 set col15 = ST_GeomFromText('POINT(6 5)'); check table t1 extended; drop table t1; --echo End of 4.1 tests # # Bug #12281 (Geometry: crash in trigger) # create table t1 (s1 geometry not null,s2 char(100)); create trigger t1_bu before update on t1 for each row set new.s1 = null; --error 1048 insert into t1 values (null,null); drop table t1; # # Bug #10499 (function creation with GEOMETRY datatype) # --disable_warnings drop procedure if exists fn3; --enable_warnings create function fn3 () returns point deterministic return ST_GeomFromText("point(1 1)"); show create function fn3; select ST_astext(fn3()); drop function fn3; # # Bug #12267 (primary key over GIS) # create table t1(pt POINT); alter table t1 add primary key pti(pt); drop table t1; create table t1(pt GEOMETRY); --error 1170 alter table t1 add primary key pti(pt); alter table t1 add primary key pti(pt(20)); drop table t1; create table t1 select ST_GeomFromText('point(1 1)'); desc t1; drop table t1; # # Bug #20691 (DEFAULT over NOT NULL field) # create table t1 (g geometry not null); --error ER_CANT_CREATE_GEOMETRY_OBJECT insert into t1 values(default); drop table t1; # # Bug #27300: create view with geometry functions lost columns types # CREATE TABLE t1 (a GEOMETRY); CREATE VIEW v1 AS SELECT ST_GeomFromwkb(ST_ASBINARY(a)) FROM t1; CREATE VIEW v2 AS SELECT a FROM t1; DESCRIBE v1; DESCRIBE v2; DROP VIEW v1,v2; DROP TABLE t1; # # Bug#24563: MBROverlaps does not seem to function propertly # Bug#54888: MBROverlaps missing in 5.1? # # Test all MBR* functions and their non-MBR-prefixed aliases, # using shifted squares to verify the spatial relations. create table t1 (name VARCHAR(100), square GEOMETRY); INSERT INTO t1 VALUES("center", ST_GeomFromText('POLYGON (( 0 0, 0 2, 2 2, 2 0, 0 0))')); INSERT INTO t1 VALUES("small", ST_GeomFromText('POLYGON (( 0 0, 0 1, 1 1, 1 0, 0 0))')); INSERT INTO t1 VALUES("big", ST_GeomFromText('POLYGON (( 0 0, 0 3, 3 3, 3 0, 0 0))')); INSERT INTO t1 VALUES("up", ST_GeomFromText('POLYGON (( 0 1, 0 3, 2 3, 2 1, 0 1))')); INSERT INTO t1 VALUES("up2", ST_GeomFromText('POLYGON (( 0 2, 0 4, 2 4, 2 2, 0 2))')); INSERT INTO t1 VALUES("up3", ST_GeomFromText('POLYGON (( 0 3, 0 5, 2 5, 2 3, 0 3))')); INSERT INTO t1 VALUES("down", ST_GeomFromText('POLYGON (( 0 -1, 0 1, 2 1, 2 -1, 0 -1))')); INSERT INTO t1 VALUES("down2", ST_GeomFromText('POLYGON (( 0 -2, 0 0, 2 0, 2 -2, 0 -2))')); INSERT INTO t1 VALUES("down3", ST_GeomFromText('POLYGON (( 0 -3, 0 -1, 2 -1, 2 -3, 0 -3))')); INSERT INTO t1 VALUES("right", ST_GeomFromText('POLYGON (( 1 0, 1 2, 3 2, 3 0, 1 0))')); INSERT INTO t1 VALUES("right2", ST_GeomFromText('POLYGON (( 2 0, 2 2, 4 2, 4 0, 2 0))')); INSERT INTO t1 VALUES("right3", ST_GeomFromText('POLYGON (( 3 0, 3 2, 5 2, 5 0, 3 0))')); INSERT INTO t1 VALUES("left", ST_GeomFromText('POLYGON (( -1 0, -1 2, 1 2, 1 0, -1 0))')); INSERT INTO t1 VALUES("left2", ST_GeomFromText('POLYGON (( -2 0, -2 2, 0 2, 0 0, -2 0))')); INSERT INTO t1 VALUES("left3", ST_GeomFromText('POLYGON (( -3 0, -3 2, -1 2, -1 0, -3 0))')); SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS mbrcontains FROM t1 a1 JOIN t1 a2 ON MBRContains( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS mbrdisjoint FROM t1 a1 JOIN t1 a2 ON MBRDisjoint( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS mbrequals FROM t1 a1 JOIN t1 a2 ON MBREquals( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS mbrintersect FROM t1 a1 JOIN t1 a2 ON MBRIntersects( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS mbroverlaps FROM t1 a1 JOIN t1 a2 ON MBROverlaps( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS mbrtouches FROM t1 a1 JOIN t1 a2 ON MBRTouches( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS mbrwithin FROM t1 a1 JOIN t1 a2 ON MBRWithin( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS MBRcontains FROM t1 a1 JOIN t1 a2 ON MBRContains( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS MBRdisjoint FROM t1 a1 JOIN t1 a2 ON MBRDisjoint( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS MBRequals FROM t1 a1 JOIN t1 a2 ON MBREquals( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS intersect FROM t1 a1 JOIN t1 a2 ON MBRIntersects( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS MBRoverlaps FROM t1 a1 JOIN t1 a2 ON MBROverlaps( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS ST_touches FROM t1 a1 JOIN t1 a2 ON ST_Touches( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS MBRwithin FROM t1 a1 JOIN t1 a2 ON MBRWithin( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; # MBROverlaps needs a few more tests, with point and line dimensions --error ER_GIS_INVALID_DATA SET @vert1 = ST_GeomFromText('POLYGON ((0 -2, 0 2, 0 -2))'); --error ER_GIS_INVALID_DATA SET @horiz1 = ST_GeomFromText('POLYGON ((-2 0, 2 0, -2 0))'); --error ER_GIS_INVALID_DATA SET @horiz2 = ST_GeomFromText('POLYGON ((-1 0, 3 0, -1 0))'); --error ER_GIS_INVALID_DATA SET @horiz3 = ST_GeomFromText('POLYGON ((2 0, 3 0, 2 0))'); --error ER_GIS_INVALID_DATA SET @point1 = ST_GeomFromText('POLYGON ((0 0))'); --error ER_GIS_INVALID_DATA SET @point2 = ST_GeomFromText('POLYGON ((-2 0))'); SELECT GROUP_CONCAT(a1.name ORDER BY a1.name) AS MBRoverlaps FROM t1 a1 WHERE MBROverlaps(a1.square, @vert1) GROUP BY a1.name; SELECT GROUP_CONCAT(a1.name ORDER BY a1.name) AS MBRoverlaps FROM t1 a1 WHERE MBROverlaps(a1.square, @horiz1) GROUP BY a1.name; SELECT MBROverlaps(@horiz1, @vert1) FROM DUAL; SELECT MBROverlaps(@horiz1, @horiz2) FROM DUAL; SELECT MBROverlaps(@horiz1, @horiz3) FROM DUAL; SELECT MBROverlaps(@horiz1, @point1) FROM DUAL; SELECT MBROverlaps(@horiz1, @point2) FROM DUAL; DROP TABLE t1; # # Bug#28763: Selecting geometry fields in UNION caused server crash. # create table t1(f1 geometry, f2 point, f3 linestring); select f1 from t1 union select f1 from t1; insert into t1 (f2,f3) values (ST_GeomFromText('POINT(1 1)'), ST_GeomFromText('LINESTRING(0 0,1 1,2 2)')); select ST_AsText(f2),ST_AsText(f3) from t1; select ST_AsText(a) from (select f2 as a from t1 union select f3 from t1) t; create table t2 as select f2 as a from t1 union select f3 from t1; desc t2; select ST_AsText(a) from t2; drop table t1, t2; # # Bug #29166: MYsql crash when query is run # # The test query itself is not logged : too large output. # The real test is the second query : see if the first hasn't crashed the # server --disable_query_log --disable_result_log SELECT ST_AsText(ST_GeometryFromText(CONCAT( 'MULTIPOLYGON(((', REPEAT ('-0.00000000001234567890123456789012 -0.123456789012345678,', 1000), '-0.00000000001234567890123456789012 -0.123456789012345678', ')))' ))) AS a; --enable_result_log --enable_query_log SELECT 1; -- source include/gis_keys.inc # # Bug #31155 gis types in union'd select cause crash # create table `t1` (`col002` point)engine=myisam; insert into t1 values (),(),(); --error ER_WRONG_ARGUMENTS select min(`col002`) from t1 union select `col002` from t1; drop table t1; --echo # --echo # Bug #47780: crash when comparing GIS items from subquery --echo # CREATE TABLE t1(a INT, b MULTIPOLYGON); INSERT INTO t1 VALUES (0, ST_GEOMFROMTEXT( 'multipolygon(((1 2,3 4,5 6,7 8,9 8, 1 2),(7 6,5 4,3 2,1 2,3 4, 7 6)))')); --echo # must not crash SELECT 1 FROM t1 WHERE a <> (SELECT ST_GEOMETRYCOLLECTIONFROMWKB(b) FROM t1); DROP TABLE t1; --echo # --echo # Bug #49250 : spatial btree index corruption and crash --echo # Part one : spatial syntax check --echo # --error ER_PARSE_ERROR CREATE TABLE t1(col1 MULTIPOLYGON NOT NULL, SPATIAL INDEX USING BTREE (col1)); CREATE TABLE t2(col1 MULTIPOLYGON NOT NULL); --error ER_PARSE_ERROR CREATE SPATIAL INDEX USING BTREE ON t2(col); --error ER_PARSE_ERROR ALTER TABLE t2 ADD SPATIAL INDEX USING BTREE (col1); DROP TABLE t2; --echo End of 5.0 tests # # Bug #11335 View redefines column types # create table t1 (f1 tinyint(1), f2 char(1), f3 varchar(1), f4 geometry, f5 datetime); create view v1 as select * from t1; desc v1; drop view v1; drop table t1; # # Bug#44684: valgrind reports invalid reads in # Item_func_spatial_collection::val_str # --error ER_ILLEGAL_VALUE_FOR_TYPE SELECT MultiPoint(12345,''); #SELECT MultiPoint(123451,''); #SELECT MultiPoint(1234512,''); #SELECT MultiPoint(12345123,''); --error ER_ILLEGAL_VALUE_FOR_TYPE #SELECT MultiLineString(12345,''); #SELECT MultiLineString(123451,''); #SELECT MultiLineString(1234512,''); #SELECT MultiLineString(12345123,''); --error ER_ILLEGAL_VALUE_FOR_TYPE #SELECT LineString(12345,''); #SELECT LineString(123451,''); #SELECT LineString(1234512,''); #SELECT LineString(12345123,''); --error ER_ILLEGAL_VALUE_FOR_TYPE #SELECT Polygon(12345,''); #SELECT Polygon(123451,''); #SELECT Polygon(1234512,''); #SELECT Polygon(12345123,''); # # Bug55531 crash with conversions of geometry types / strings # --error ER_ILLEGAL_VALUE_FOR_TYPE SELECT 1 FROM (SELECT GREATEST(1,GEOMETRYCOLLECTION('00000','00000')) b FROM DUAL) AS d WHERE (LINESTRING(d.b)); --echo # --echo # BUG#51875: crash when loading data into geometry function ST_polyfromwkb --echo # SET @a=0x00000000030000000100000000000000000000000000144000000000000014400000000000001840000000000000184000000000000014400000000000001440; --error ER_GIS_INVALID_DATA SET @a=ST_POLYFROMWKB(@a); SET @a=0x00000000030000000000000000000000000000000000144000000000000014400000000000001840000000000000184000000000000014400000000000001440; --error ER_GIS_INVALID_DATA SET @a=ST_POLYFROMWKB(@a); # # Bug #57321 crashes and valgrind errors from spatial types # create table t1(a polygon NOT NULL)engine=myisam; --error ER_CANT_CREATE_GEOMETRY_OBJECT insert into t1 values (ST_geomfromtext("point(0 1)")); --error ER_CANT_CREATE_GEOMETRY_OBJECT insert into t1 values (ST_geomfromtext("point(1 0)")); select * from (select polygon(t1.a) as p from t1 order by t1.a) d; drop table t1; --echo # --echo # Test for bug #59888 "debug assertion when attempt to create spatial index --echo # on char > 31 bytes". --echo # create table t1(a char(32) not null) engine=myisam; --error ER_SPATIAL_MUST_HAVE_GEOM_COL create spatial index i on t1 (a); drop table t1; --echo End of 5.1 tests # # Bug #50574 5.5.ST_x allows spatial indexes on non-spatial # columns, causing crashes! # Bug#11767480 SPATIAL INDEXES ON NON-SPATIAL COLUMNS # CAUSE CRASHES. # CREATE TABLE t0 (a BINARY(32) NOT NULL); --error ER_SPATIAL_MUST_HAVE_GEOM_COL CREATE SPATIAL INDEX i on t0 (a); INSERT INTO t0 VALUES (1); --error ER_SPATIAL_MUST_HAVE_GEOM_COL CREATE TABLE t1( col0 BINARY NOT NULL, col2 TIMESTAMP, SPATIAL INDEX i1 (col0) ) ENGINE=MyISAM; # Test other ways to add indices CREATE TABLE t1 ( col0 BINARY NOT NULL, col2 TIMESTAMP ) ENGINE=MyISAM; --error ER_SPATIAL_MUST_HAVE_GEOM_COL CREATE SPATIAL INDEX idx0 ON t1(col0); --error ER_SPATIAL_MUST_HAVE_GEOM_COL ALTER TABLE t1 ADD SPATIAL INDEX i1 (col0); CREATE TABLE t2 ( col0 INTEGER NOT NULL, col1 POINT, col2 POINT ); --error ER_TOO_MANY_KEY_PARTS CREATE SPATIAL INDEX idx0 ON t2 (col1, col2); --error ER_TOO_MANY_KEY_PARTS CREATE TABLE t3 ( col0 INTEGER NOT NULL, col1 POINT, col2 LINESTRING, SPATIAL INDEX i1 (col1, col2) ); # cleanup DROP TABLE t0, t1, t2; --echo # --echo # BUG#12414917 - ST_ISCLOSED() CRASHES ON 64-BIT BUILDS --echo # --error ER_GIS_DATA_WRONG_ENDIANESS SELECT ST_ISCLOSED(CONVERT(CONCAT(' ', 0x2), BINARY(20))); --echo # --echo # BUG#12537203 - CRASH WHEN SUBSELECTING GLOBAL VARIABLES IN --echo # GEOMETRY FUNCTION ARGUMENTS --echo # --replace_regex /non geometric .* value/non geometric '' value/ --error ER_ILLEGAL_VALUE_FOR_TYPE SELECT GEOMETRYCOLLECTION((SELECT @@OLD)); --echo End of 5.1 tests --echo # --echo # Bug#11908153: CRASH AND/OR VALGRIND ERRORS IN FIELD_BLOB::GET_KEY_IMAGE --echo # CREATE TABLE g1 (a geometry NOT NULL, UNIQUE KEY i (a(151))) engine=myisam; INSERT INTO g1 VALUES (ST_geomfromtext('point(1 1)')); INSERT INTO g1 VALUES (ST_geomfromtext('point(1 2)')); FLUSH TABLES; SELECT 1 FROM g1 FORCE INDEX(i) WHERE a = date_sub(now(), interval 2808.4 year_month) ; DROP TABLE g1; --echo # --echo # Bug#13013970 MORE CRASHES IN FIELD_BLOB::GET_KEY_IMAGE --echo # CREATE TABLE g1(a TEXT NOT NULL, KEY(a(255))); INSERT INTO g1 VALUES ('a'),('a'); --error ER_GIS_INVALID_DATA SELECT 1 FROM g1 WHERE a >= ANY (SELECT 1 FROM g1 WHERE a = ST_geomfromtext('') OR a) ; DROP TABLE g1; --echo # --echo # Bug#16451878 GEOMETRY QUERY CRASHES SERVER --echo # --echo # should not crash --error ER_GIS_DATA_WRONG_ENDIANESS SELECT ST_ASTEXT(0x0100000000030000000100000000000010); --echo #should not crash --error ER_GIS_DATA_WRONG_ENDIANESS SELECT ST_ENVELOPE(0x0100000000030000000100000000000010); --echo #should not crash --error ER_GIS_DATA_WRONG_ENDIANESS SELECT ST_GEOMETRYN(0x0100000000070000000100000001030000000200000000000000ffff0000, 1); --echo #should not crash --error ER_GIS_DATA_WRONG_ENDIANESS SELECT ST_GEOMETRYN(0x0100000000070000000100000001030000000200000000000000ffffff0f, 1); --echo End of 5.5 tests # Conformance tests # # C.3.3 Geometry types and functions # --disable_warnings DROP DATABASE IF EXISTS gis_ogs; --enable_warnings CREATE DATABASE gis_ogs; USE gis_ogs; --echo # --echo # C.3.3.1 Geometry types and functions schema construction --echo # # TODO: WL#2377 #CREATE TABLE spatial_ref_sys ( #ST_srid INTEGER NOT NULL PRIMARY KEY, #auth_name CHARACTER VARYING, #auth_srid INTEGER, #srtext CHARACTER VARYING(2048)); CREATE TABLE lakes ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), shore POLYGON); CREATE TABLE road_segments ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), aliases CHARACTER VARYING(64), num_lanes INTEGER, centerline LINESTRING); CREATE TABLE divided_routes ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), num_lanes INTEGER, centerlines MULTILINESTRING); CREATE TABLE forests ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), boundary MULTIPOLYGON); CREATE TABLE bridges ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), position POINT); CREATE TABLE streams ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), centerline LINESTRING); CREATE TABLE buildings ( fid INTEGER NOT NULL PRIMARY KEY, address CHARACTER VARYING(64), position POINT, footprint POLYGON); CREATE TABLE ponds ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), type CHARACTER VARYING(64), shores MULTIPOLYGON); CREATE TABLE named_places ( fid INTEGER NOT NULL PRIMARY KEY, name CHARACTER VARYING(64), boundary POLYGON); CREATE TABLE map_neatlines ( fid INTEGER NOT NULL PRIMARY KEY, neatline POLYGON); --echo # --echo # C.3.3.2 Geometry types and functions schema data loading --echo # # TODO: WL#2377 #-- Spatial Reference System #INSERT INTO spatial_ref_sys VALUES #(101, 'POSC', 32214, 'PROJCS["UTM_ZONE_14N", #GEOGCS["World Geodetic System 72", #DATUM["WGS_72", #ELLIPSOID["NWL_10D", 6378135, 298.26]], #PRIMEM["Greenwich", 0], #UNIT["Meter", 1.0]], #PROJECTION["Transverse_Mercator"], #PARAMETER["False_Easting", 500000.0], #PARAMETER["False_Northing", 0.0], #PARAMETER["Central_Meridian", -99.0], #PARAMETER["Scale_Factor", 0.9996], #PARAMETER["Latitude_of_origin", 0.0], #UNIT["Meter", 1.0]]'); --echo # Lakes INSERT INTO lakes VALUES ( 101, 'BLUE LAKE', ST_PolyFromText( 'POLYGON( (52 18,66 23,73 9,48 6,52 18), (59 18,67 18,67 13,59 13,59 18) )', 101)); --echo # Road Segments INSERT INTO road_segments VALUES(102, 'Route 5', NULL, 2, ST_LineFromText( 'LINESTRING( 0 18, 10 21, 16 23, 28 26, 44 31 )' ,101)); INSERT INTO road_segments VALUES(103, 'Route 5', 'Main Street', 4, ST_LineFromText( 'LINESTRING( 44 31, 56 34, 70 38 )' ,101)); INSERT INTO road_segments VALUES(104, 'Route 5', NULL, 2, ST_LineFromText( 'LINESTRING( 70 38, 72 48 )' ,101)); INSERT INTO road_segments VALUES(105, 'Main Street', NULL, 4, ST_LineFromText( 'LINESTRING( 70 38, 84 42 )' ,101)); INSERT INTO road_segments VALUES(106, 'Dirt Road by Green Forest', NULL, 1, ST_LineFromText( 'LINESTRING( 28 26, 28 0 )',101)); --echo # DividedRoutes INSERT INTO divided_routes VALUES(119, 'Route 75', 4, ST_MLineFromText( 'MULTILINESTRING((10 48,10 21,10 0), (16 0,16 23,16 48))', 101)); --echo # Forests INSERT INTO forests VALUES(109, 'Green Forest', ST_MPolyFromText( 'MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26), (52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))', 101)); --echo # Bridges INSERT INTO bridges VALUES(110, 'Cam Bridge', ST_PointFromText( 'POINT( 44 31 )', 101)); --echo # Streams INSERT INTO streams VALUES(111, 'Cam Stream', ST_LineFromText( 'LINESTRING( 38 48, 44 41, 41 36, 44 31, 52 18 )', 101)); INSERT INTO streams VALUES(112, NULL, ST_LineFromText( 'LINESTRING( 76 0, 78 4, 73 9 )', 101)); --echo # Buildings INSERT INTO buildings VALUES(113, '123 Main Street', ST_PointFromText( 'POINT( 52 30 )', 101), ST_PolyFromText( 'POLYGON( ( 50 31, 54 31, 54 29, 50 29, 50 31) )', 101)); INSERT INTO buildings VALUES(114, '215 Main Street', ST_PointFromText( 'POINT( 64 33 )', 101), ST_PolyFromText( 'POLYGON( ( 66 34, 62 34, 62 32, 66 32, 66 34) )', 101)); --echo # Ponds INSERT INTO ponds VALUES(120, NULL, 'Stock Pond', ST_MPolyFromText( 'MULTIPOLYGON( ( ( 24 44, 22 42, 24 40, 24 44) ), ( ( 26 44, 26 40, 28 42, 26 44) ) )', 101)); --echo # Named Places INSERT INTO named_places VALUES(117, 'Ashton', ST_PolyFromText( 'POLYGON( ( 62 48, 84 48, 84 30, 56 30, 56 34, 62 48) )', 101)); INSERT INTO named_places VALUES(118, 'Goose Island', ST_PolyFromText( 'POLYGON( ( 67 13, 67 18, 59 18, 59 13, 67 13) )', 101)); --echo # Map Neatlines INSERT INTO map_neatlines VALUES(115, ST_PolyFromText( 'POLYGON( ( 0 0, 0 48, 84 48, 84 0, 0 0 ) )', 101)); --echo # --echo # C.3.3.3 Geometry types and functions schema test queries --echo # TODO: WL#2377 #--echo # Conformance Item T1 #SELECT f_table_name #FROM geometry_columns; # #--echo # Conformance Item T2 #SELECT f_geometry_column #FROM geometry_columns #WHERE f_table_name = 'streams'; # #--echo # Conformance Item T3 #SELECT coord_dimension #FROM geometry_columns #WHERE f_table_name = 'streams'; # #--echo # Conformance Item T4 # #SELECT ST_srid #FROM geometry_columns #WHERE f_table_name = 'streams'; # #--echo # Conformance Item T5 # #SELECT srtext #FROM SPATIAL_REF_SYS #WHERE ST_SRID = 101; # --echo # Conformance Item T6 # TODO: ST_Dimension() alias SELECT ST_Dimension(shore) FROM lakes WHERE name = 'Blue Lake'; --echo # Conformance Item T7 # TODO: ST_GeometryType() alias SELECT ST_GeometryType(centerlines) FROM divided_routes WHERE name = 'Route 75'; --echo # Conformance Item T8 # TODO: ST_AsText() alias SELECT ST_AsText(boundary) FROM named_places WHERE name = 'Goose Island'; --echo # Conformance Item T9 # TODO: ST_AsBinary(), ST_PolyFromWKB() aliases SELECT ST_AsText(ST_PolyFromWKB(ST_AsBinary(boundary),101)) FROM named_places WHERE name = 'Goose Island'; --echo # Conformance Item T10 # TODO: ST_SRID() alias SELECT ST_SRID(boundary) FROM named_places WHERE name = 'Goose Island'; --echo # Conformance Item T11 # TODO: ST_IsEmpty() alias SELECT ST_IsEmpty(centerline) FROM road_segments WHERE name = 'Route 5' AND aliases = 'Main Street'; # FIXME: get wrong result:0, expected 1. #--echo # Conformance Item T12 # TODO: ST_IsSimple() alias #SELECT ST_IsSimple(shore) #FROM lakes #WHERE name = 'Blue Lake'; # TODO: WL#2377 #--echo # Conformance Item T13 #SELECT ST_AsText(Boundary((boundary),101) #FROM named_places #WHERE name = 'Goose Island'; --echo # Conformance Item T14 # TODO: ST_Envelope( ) alias # FIXME: we get anticlockwise, GIS suggests clockwise SELECT ST_AsText(ST_Envelope(boundary)) FROM named_places WHERE name = 'Goose Island'; --echo # Conformance Item T15 # TODO: ST_X() alias SELECT ST_X(position) FROM bridges WHERE name = 'Cam Bridge'; --echo # Conformance Item T16 # TODO: ST_Y() alias SELECT ST_Y(position) FROM bridges WHERE name = 'Cam Bridge'; --echo # Conformance Item T17 # TODO: ST_StartPoint() alias SELECT ST_AsText(ST_StartPoint(centerline)) FROM road_segments WHERE fid = 102; --echo # Conformance Item T18 # TODO: ST_EndPoint SELECT ST_AsText(ST_EndPoint(centerline)) FROM road_segments WHERE fid = 102; # TODO: WL#2377 #--echo # Conformance Item T19 # TODO: ST_LineFromWKB() alias #SELECT ST_IsClosed(LineFromWKB(ST_AsBinary(Boundary(boundary)),ST_SRID(boundary))) #FROM named_places #WHERE name = 'Goose Island'; # TODO: WL#2377 #--echo # Conformance Item T20 #SELECT IsRing(LineFromWKB(ST_AsBinary(Boundary(boundary)),ST_SRID(boundary))) #FROM named_places #WHERE name = 'Goose Island'; --echo # Conformance Item T21 # TODO: ST_Length() alias SELECT ST_Length(centerline) FROM road_segments WHERE fid = 106; --echo # Conformance Item T22 # TODO: ST_NumPoints() alias SELECT ST_NumPoints(centerline) FROM road_segments WHERE fid = 102; --echo # Conformance Item T23 # TODO: ST_PointN() alias SELECT ST_AsText(ST_PointN(centerline, 1)) FROM road_segments WHERE fid = 102; --echo # Conformance Item T24 # TODO: ST_Centroid() alias SELECT ST_AsText(ST_Centroid(boundary)) FROM named_places WHERE name = 'Goose Island'; # TODO: WL#2377 #--echo # Conformance Item T25 #SELECT MBRContains(boundary, PointOnSurface(boundary)) #FROM named_places #WHERE name = 'Goose Island'; --echo # Conformance Item T26 # TODO: ST_Area() alias SELECT ST_Area(boundary) FROM named_places WHERE name = 'Goose Island'; --echo # Conformance Item T27 # TODO: ST_ExteriorRing() alias SELECT ST_AsText(ST_ExteriorRing(shore)) FROM lakes WHERE name = 'Blue Lake'; --echo # Conformance Item T28 # TODO: ST_NumInteriorRings() alias SELECT ST_NumInteriorRings(shore) FROM lakes WHERE name = 'Blue Lake'; --echo # Conformance Item T29 # TODO: ST_InteriorRingN() alias SELECT ST_AsText(ST_InteriorRingN(shore, 1)) FROM lakes WHERE name = 'Blue Lake'; --echo # Conformance Item T30 # TODO: ST_NumGeometries() alias SELECT ST_NumGeometries(centerlines) FROM divided_routes WHERE name = 'Route 75'; --echo # Conformance Item T31 # TODO: ST_GeometryN() alias SELECT ST_AsText(ST_GeometryN(centerlines, 2)) FROM divided_routes WHERE name = 'Route 75'; --echo # Conformance Item T32 # TODO: ST_IsClosed() alias SELECT ST_IsClosed(centerlines) FROM divided_routes WHERE name = 'Route 75'; --echo # Conformance Item T33 # TODO: ST_Length() alias SELECT ST_Length(centerlines) FROM divided_routes WHERE name = 'Route 75'; --echo # Conformance Item T34 # TODO: ST_Centroid() alias SELECT ST_AsText(ST_Centroid(shores)) FROM ponds WHERE fid = 120; # TODO: WL#2377 #--echo # Conformance Item T35 #SELECT MBRContains(shores, PointOnSurface(shores)) #FROM ponds #WHERE fid = 120; --echo # Conformance Item T36 # TODO: ST_Area() alias SELECT ST_Area(shores) FROM ponds WHERE fid = 120; --echo # Conformance Item T37 # TODO: ST_PolyFromText() alias SELECT ST_Equals(boundary, ST_PolyFromText('POLYGON( ( 67 13, 67 18, 59 18, 59 13, 67 13) )',101)) FROM named_places WHERE name = 'Goose Island'; --error ER_GIS_DIFFERENT_SRIDS SELECT ST_Equals(boundary, ST_PolyFromText('POLYGON( ( 67 13, 67 18, 59 18, 59 13, 67 13) )',1)) FROM named_places WHERE name = 'Goose Island'; --echo # Conformance Item T38 SELECT ST_Disjoint(centerlines, boundary) FROM divided_routes, named_places WHERE divided_routes.name = 'Route 75' AND named_places.name = 'Ashton'; --echo # Conformance Item T39 SELECT ST_Touches(centerline, shore) FROM streams, lakes WHERE streams.name = 'Cam Stream' AND lakes.name = 'Blue Lake'; # FIXME: wrong result: get 0, expected 1 #--echo # Conformance Item T40 #SELECT ST_Within(boundary, footprint) #FROM named_places, buildings #WHERE named_places.name = 'Ashton' #AND buildings.address = '215 Main Street'; # FIXME: wrong result: get 0, expected 1 #--echo # Conformance Item T41 #SELECT ST_Overlaps(forests.boundary, named_places.boundary) #FROM forests, named_places #WHERE forests.name = 'Green Forest' #AND named_places.name = 'Ashton'; --echo # Conformance Item T42 # FIXME: TODO: ST_Crosses() alias SELECT ST_Crosses(road_segments.centerline, divided_routes.centerlines) FROM road_segments, divided_routes WHERE road_segments.fid = 102 AND divided_routes.name = 'Route 75'; --echo # Conformance Item T43 SELECT ST_Intersects(road_segments.centerline, divided_routes.centerlines) FROM road_segments, divided_routes WHERE road_segments.fid = 102 AND divided_routes.name = 'Route 75'; --echo # Conformance Item T44 SELECT ST_Contains(forests.boundary, named_places.boundary) FROM forests, named_places WHERE forests.name = 'Green Forest' AND named_places.name = 'Ashton'; # TODO: WL#2377 #--echo # Conformance Item T45 #SELECT Relate(forests.boundary, named_places.boundary, 'TTTTTTTTT') #FROM forests, named_places #WHERE forests.name = 'Green Forest' #AND named_places.name = 'Ashton'; --echo # Conformance Item T46 SELECT ST_Distance(position, boundary) FROM bridges, named_places WHERE bridges.name = 'Cam Bridge' AND named_places.name = 'Ashton'; # FIXME: wrong result: NULL, expected 12 #--echo # Conformance Item T47 #SELECT ST_AsText(ST_Intersection(centerline, shore)) #FROM streams, lakes #WHERE streams.name = 'Cam Stream' #AND lakes.name = 'Blue Lake'; --echo # Conformance Item T48 SELECT ST_AsText(ST_Difference(named_places.boundary, forests.boundary)) FROM named_places, forests WHERE named_places.name = 'Ashton' AND forests.name = 'Green Forest'; #--echo # Conformance Item T49 SELECT ST_AsText(ST_Union(shore, boundary)) FROM lakes, named_places WHERE lakes.name = 'Blue Lake' AND named_places.name = 'Goose Island'; --echo # Conformance Item T50 SELECT ST_AsText(ST_SymDifference(shore, boundary)) FROM lakes, named_places WHERE lakes.name = 'Blue Lake' AND named_places.name = 'Ashton'; --echo # Conformance Item T51 SELECT count(*) FROM buildings, bridges WHERE ST_Contains(ST_Buffer(bridges.position, 15.0), buildings.footprint) = 1; # TODO: WL#2377 #--echo # Conformance Item T52 #SELECT ST_AsText(ConvexHull(shore)) #FROM lakes #WHERE lakes.name = 'Blue Lake'; DROP DATABASE gis_ogs; --echo # --echo # Bug#13362660 ASSERTION `FIELD_POS < FIELD_COUNT' FAILED. IN PROTOCOL_TEXT::STORE --echo # --error ER_GIS_INVALID_DATA SELECT ST_Union('', ''), md5(1); --echo # --echo # Bug#18413646: SINCE 5.7 ERROR 1416 IS CONSIDERED FATAL, --echo # BUT IT SHOULDN'T BE. --echo # USE test; CREATE TABLE t1(a POINT NOT NULL, SPATIAL KEY(a)) engine=myisam; --echo # Check that normal INSERT gives error --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (""); --echo # INSERT IGNORE also gives error => not ignorable error --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT IGNORE INTO t1 VALUES (""); delimiter $; CREATE PROCEDURE p1() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN SELECT 'Handler activated'; END; INSERT INTO t1 VALUES(""); END $ delimiter ;$ --echo # But HANDLER should work => not fatal error CALL p1(); DROP PROCEDURE p1; DROP TABLE t1; SET sql_mode = default; --echo # --echo # Bug #19504183 GIS: -0 WOULD BE TRANSLATED TO 0 AUTOMATICALLY --echo # SELECT HEX(Point(-1*0e0, -1*0e0)); CREATE TABLE t1 (pk INTEGER AUTO_INCREMENT PRIMARY KEY, g GEOMETRY); INSERT INTO t1(g) VALUES (Point(0.0, 0.0)); INSERT INTO t1(g) VALUES (Point(-1*0e0, -1*0e0)); INSERT INTO t1(g) VALUES (ST_GeomFromText('POINT(-0 -0.0)')); INSERT INTO t1(g) VALUES (UNHEX('00000000010100000000000000000000800000000000000080')); SELECT pk, ST_AsText(g) AS wkt, HEX(g) AS hex FROM t1 ORDER BY pk; INSERT INTO t1(g) SELECT ST_GeomFromText(ST_AsText(g)) FROM t1 ORDER BY pk; SELECT pk, ST_AsText(g) AS wkt, HEX(g) AS hex FROM t1 ORDER BY pk; INSERT INTO t1(g) SELECT ST_GeomFromWKB(ST_AsBinary(g)) FROM t1 ORDER BY pk; SELECT pk, ST_AsText(g) AS wkt, HEX(g) AS hex FROM t1 ORDER BY pk; DROP TABLE t1; CREATE TABLE t1(g GEOMETRY); INSERT INTO t1 VALUES (Point(-1*0e0, -1*0e0)), (Point(0, 0)); SELECT ST_AsGeoJSON(g) AS GeoJSON, HEX(ST_AsBinary(g)) AS WKB FROM t1; SELECT ST_AsGeoJSON(g, 30) AS GeoJSON, HEX(ST_AsBinary(g)) AS WKB FROM t1; DROP TABLE t1; SELECT HEX(ST_GeomFromGeoJSON('{"type":"Point","coordinates":[-0,-0.0]}')) AS g; SELECT HEX( ST_GeomFromGeoJSON('{"type":"Point","coordinates":[-0.0,-0.0]}')) AS g; --echo # --echo # Bug #19593342 CREATE SPATIAL INDEX FAILS TO FLAG AN ERROR FOR INVALID --echo # GEOMETRY DATA --echo # CREATE TABLE t1(g GEOMETRY); # Big-endian geometry --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000000000000100000000000000000000000000000000')); # ST_GeomFromWKB should convert it to little-endian, so this should succeed INSERT INTO t1 VALUES (ST_GeomFromWKB( UNHEX('000000000100000000000000000000000000000000'))); SELECT ST_AsText(g) FROM t1; # Big-endian point in little-endian geometrycollection --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX( '00000000010700000001000000000000000100000000000000000000000000000000')); # Invalid and unsupported geometry types # Geometry -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000000000000000000000000000000000000000000000')); # CircularString -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010800000000000000000000000000000000000000')); # CompoundCurve -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010900000000000000000000000000000000000000')); # CurvePolygon -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010A00000000000000000000000000000000000000')); # MultiCurve -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010B00000000000000000000000000000000000000')); # MultiSurface -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010C00000000000000000000000000000000000000')); # Curve -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010D00000000000000000000000000000000000000')); # Surface -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010E00000000000000000000000000000000000000')); # PolyhedralSurface --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010F0000000100000001030000000100000004000000000000000000000000' '00000000000000000000000000F03F0000000000000000000000000000F03F00000000' '0000F03F00000000000000000000000000000000')); # TIN --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001100000000100000001030000000100000004000000000000000000000000' '00000000000000000000000000F03F0000000000000000000000000000F03F00000000' '0000F03F00000000000000000000000000000000')); # Triangle --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001110000000100000004000000000000000000000000000000000000000000' '00000000F03F0000000000000000000000000000F03F000000000000F03F0000000000' '0000000000000000000000')); # GeometryZ -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001E803000000000000000000000000000000000000')); # PointZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001E9030000000000000000000000000000000000000000000000000000')); # LineStringZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001EA0300000200000000000000000000000000000000000000000000000000' '0000000000000000F03F000000000000F03F0000000000000000')); # PolygonZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001EB0300000100000004000000000000000000000000000000000000000000' '000000000000000000000000F03F000000000000000000000000000000000000000000' '00F03F000000000000F03F000000000000000000000000000000000000000000000000' '0000000000000000')); # MultiPointZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001EC0300000100000001E90300000000000000000000000000000000000000' '00000000000000')); # MultiLineStringZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001ED030000010000000000000001EA03000002000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000F03F00000000' '00000000')); # MultiPolygonZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001EE0300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # GeometryCollectionZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001EF0300000100000001E90300000000000000000000000000000000000000' '00000000000000')); # CircularStringZ -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F003000000000000000000000000000000000000')); # CompoundCurveZ -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F103000000000000000000000000000000000000')); # CurvePolygonZ -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F203000000000000000000000000000000000000')); # MultiCurveZ -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F303000000000000000000000000000000000000')); # MultiSurfaceZ -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F403000000000000000000000000000000000000')); # CurveZ -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F503000000000000000000000000000000000000')); # SurfaceZ -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F603000000000000000000000000000000000000')); # PolyhedralSurfaceZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F70300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # TINZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F80300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # TriangleZ --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001F90300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # GeometryM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D007000000000000000000000000000000000000')); # PointM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D1070000000000000000000000000000000000000000000000000000')); # LineStringM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D20700000200000000000000000000000000000000000000000000000000' '0000000000000000F03F000000000000F03F0000000000000000')); # PolygonM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D30700000100000004000000000000000000000000000000000000000000' '000000000000000000000000F03F000000000000000000000000000000000000000000' '00F03F000000000000F03F000000000000000000000000000000000000000000000000' '0000000000000000')); # MultiPointM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D40700000100000001E90300000000000000000000000000000000000000' '00000000000000')); # MultiLineStringM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D5070000010000000000000001EA03000002000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000F03F00000000' '00000000')); # MultiPolygonM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D60700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # GeometryCollectionM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D70700000100000001E90300000000000000000000000000000000000000' '00000000000000')); # CircularStringM -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D807000000000000000000000000000000000000')); # CompoundCurveM -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001D907000000000000000000000000000000000000')); # CurvePolygonM -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001DA07000000000000000000000000000000000000')); # MultiCurveM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001DB07000000000000000000000000000000000000')); # MultiSurfaceM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001DC07000000000000000000000000000000000000')); # CurveM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001DD07000000000000000000000000000000000000')); # SurfaceM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001DE07000000000000000000000000000000000000')); # PolyhedralSurfaceM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001DF0700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # TINM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001E00700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # TriangleM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001E10700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # GeometryZM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001B80B000000000000000000000000000000000000')); # PointZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001B90B00000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000')); # LineStringZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001BA0B00000200000000000000000000000000000000000000000000000000' '00000000000000000000000000000000F03F000000000000F03F000000000000000000' '00000000000000')); # PolygonZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001BB0B00000100000004000000000000000000000000000000000000000000' '0000000000000000000000000000000000000000F03F00000000000000000000000000' '0000000000000000000000000000000000F03F000000000000F03F0000000000000000' '0000000000000000000000000000000000000000000000000000000000000000000000' '0000000000')); # MultiPointZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001BC0B00000100000001B90B00000000000000000000000000000000000000' '0000000000000000000000000000000000000000000000')); # MultiLineStringZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001BD0B00000100000001BA0B00000200000000000000000000000000000000' '00000000000000000000000000000000000000000000000000F03F000000000000F03F' '00000000000000000000000000000000')); # MultiPolygonZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001BE0B00000100000001BB0B00000100000004000000000000000000000000' '0000000000000000000000000000000000000000000000000000000000F03F00000000' '0000000000000000000000000000000000000000000000000000F03F000000000000F0' '3F00000000000000000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000')); # GeometryCollectionZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001BF0B00000100000001B90B00000000000000000000000000000000000000' '0000000000000000000000000000000000000000000000')); # CircularStringZM -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C00B000000000000000000000000000000000000')); # CompoundCurveZM -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C10B000000000000000000000000000000000000')); # CurvePolygonZM -- fictitious WKB (reserved for future use) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C20B000000000000000000000000000000000000')); # MultiCurveZM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C30B000000000000000000000000000000000000')); # MultiSurfaceZM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C40B000000000000000000000000000000000000')); # CurveZM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C50B000000000000000000000000000000000000')); # SurfaceZM -- fictitious WKB (abstract type) --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C60B000000000000000000000000000000000000')); # PolyhedralSurfaceZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C70B00000100000001BB0B00000100000004000000000000000000000000' '0000000000000000000000000000000000000000000000000000000000F03F00000000' '0000000000000000000000000000000000000000000000000000F03F000000000000F0' '3F00000000000000000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000')); # TINZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C80B00000100000001BB0B00000100000004000000000000000000000000' '0000000000000000000000000000000000000000000000000000000000F03F00000000' '0000000000000000000000000000000000000000000000000000F03F000000000000F0' '3F00000000000000000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000')); # TriangleZM --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001C90B00000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000')); # Used internally for inner rings of polygons -- invalid WKB --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000011F00000000000000000000000000000000000000')); # Linestring with no points --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('00000000010200000000000000')); # Linestring with one point --error ER_GIS_INVALID_DATA INSERT INTO t1 VALUES (LINESTRING(POINT(0,0))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001020000000100000000000000000000000000000000000000')); # Polygon with no rings --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('00000000010300000000000000')); # Polygon with one ring with no points --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('0000000001030000000100000000000000')); # Polygon ring with two points --error ER_GIS_INVALID_DATA INSERT INTO t1 VALUES (POLYGON(LINESTRING(POINT(0,0),POINT(1,0)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001030000000100000002000000000000000000000000000000000000000000' '00000000F03F0000000000000000')); # Polygon ring with three points --error ER_GIS_INVALID_DATA INSERT INTO t1 VALUES (POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(0,0)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001030000000100000003000000000000000000000000000000000000000000' '00000000F03F000000000000000000000000000000000000000000000000')); # Polygon ring with three points, where the fourth is added automatically # This should succeed INSERT INTO t1 VALUES (POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1), POINT(0,0)))); # Empty multipoint --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('00000000010400000000000000')); # Empty multilinestring --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('00000000010500000000000000')); # Empty multipolygon --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('00000000010600000000000000')); # Empty geometrycollection # This should succeed INSERT INTO t1 VALUES (UNHEX('00000000010700000000000000')); SELECT ST_AsText(g) FROM t1; # Strings that are shorter than the encoded object --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('00000000')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('0000000001')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('000000000101')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('000000000101000000')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('0000000001010000000000000000000000')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001010000000000000000000000000000000000000')); # Strings that are longer than the encoded object --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('000000000107000000000000000')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX('0000000001070000000000000000')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('000000000101000000000000000000000000000000000000000')); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001010000000000000000000000000000000000000000')); # Multipoint with a linestring in it --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001040000000100000001020000000200000000000000000000000000000000' '000000000000000000F03F000000000000F03F')); # Geometrycollection with a multipoint with a linestring in it --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001070000000100000001040000000100000001020000000200000000000000' '000000000000000000000000000000000000F03F000000000000F03F')); # Multilinestring with a point in it --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX( '00000000010500000001000000010100000000000000000000000000000000000000')); # Geometrycollection with a multilinestring with a point in it --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001070000000100000001050000000100000001010000000000000000000000' '0000000000000000')); # Multipolygon with a point in it --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (UNHEX( '00000000010600000001000000010100000000000000000000000000000000000000')); # Geometrycollection with a multipolygon with a point in it --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( UNHEX('0000000001070000000100000001060000000100000001010000000000000000000000' '0000000000000000')); DROP TABLE t1; # Invalid geometry types in point column CREATE TABLE t1 (p POINT); # This should succeed INSERT INTO t1 VALUES (POINT(0,0)); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (LINESTRING(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOINT(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTILINESTRING(LINESTRING(POINT(0,0),POINT(1,1)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0), POINT(1,1), POINT(0,1),POINT(0,0))))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (GEOMETRYCOLLECTION(POINT(0,0))); DROP TABLE t1; # Invalid geometry types in linestring column CREATE TABLE t1 (l LINESTRING); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (POINT(0,0)); # This should succeed INSERT INTO t1 VALUES (LINESTRING(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOINT(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTILINESTRING(LINESTRING(POINT(0,0),POINT(1,1)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0), POINT(1,1),POINT(0,1),POINT(0,0))))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (GEOMETRYCOLLECTION(POINT(0,0))); DROP TABLE t1; # Invalid geometry types in polygon column CREATE TABLE t1 (p POLYGON); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (POINT(0,0)); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (LINESTRING(POINT(0,0),POINT(1,1))); # This should succeed INSERT INTO t1 VALUES ( POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOINT(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTILINESTRING(LINESTRING(POINT(0,0),POINT(1,1)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0), POINT(1,1),POINT(0,1),POINT(0,0))))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (GEOMETRYCOLLECTION(POINT(0,0))); DROP TABLE t1; # Invalid geometry types in multipoint column CREATE TABLE t1 (m MULTIPOINT); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (POINT(0,0)); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (LINESTRING(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0)))); # This should succeed INSERT INTO t1 VALUES (MULTIPOINT(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTILINESTRING(LINESTRING(POINT(0,0),POINT(1,1)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0), POINT(1,1),POINT(0,1),POINT(0,0))))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (GEOMETRYCOLLECTION(POINT(0,0))); DROP TABLE t1; # Invalid geometry types in multilinestring column CREATE TABLE t1 (m MULTILINESTRING); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (POINT(0,0)); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (LINESTRING(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOINT(POINT(0,0),POINT(1,1))); # This should succeed INSERT INTO t1 VALUES (MULTILINESTRING(LINESTRING(POINT(0,0),POINT(1,1)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0), POINT(1,1),POINT(0,1),POINT(0,0))))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (GEOMETRYCOLLECTION(POINT(0,0))); DROP TABLE t1; # Invalid geometry types in multipolygon column CREATE TABLE t1 (m MULTIPOLYGON); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (POINT(0,0)); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (LINESTRING(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0)))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTIPOINT(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (MULTILINESTRING(LINESTRING(POINT(0,0),POINT(1,1)))); # This should succeed INSERT INTO t1 VALUES (MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0), POINT(1,1),POINT(0,1), POINT(0,0))))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (GEOMETRYCOLLECTION(POINT(0,0))); DROP TABLE t1; # Invalid geometry types in geometrycollection column CREATE TABLE t1 (g GEOMETRYCOLLECTION); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (POINT(0,0)); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES (LINESTRING(POINT(0,0),POINT(1,1))); --error ER_CANT_CREATE_GEOMETRY_OBJECT INSERT INTO t1 VALUES ( POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0)))); # This should succeed since it's a subtype of geometrycollection INSERT INTO t1 VALUES (MULTIPOINT(POINT(0,0),POINT(1,1))); # This should succeed since it's a subtype of geometrycollection INSERT INTO t1 VALUES (MULTILINESTRING(LINESTRING(POINT(0,0),POINT(1,1)))); # This should succeed since it's a subtype of geometrycollection INSERT INTO t1 VALUES (MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0), POINT(1,1),POINT(0,1),POINT(0,0))))); # This should succeed INSERT INTO t1 VALUES (GEOMETRYCOLLECTION(POINT(0,0))); DROP TABLE t1; --echo # --echo # Bug #20778939 ST_BUFFER CANNOT BUILD GEOMETRY OBJECT FOR NO APPARENT --echo # REASON --echo # CREATE TABLE t1 (g GEOMETRY); INSERT INTO t1 VALUES(ST_GeomFromText('GEOMETRYCOLLECTION()')); DROP TABLE t1; --echo # --echo # Bug #18320371 GIS: MISLEADING ERROR MESSAGE,WHEN TRY TO CREATE A --echo # SPATIAL INDEX ON MULTICOLUMN --echo # --error ER_TOO_MANY_KEY_PARTS CREATE TABLE t1 ( a GEOMETRY NOT NULL, b GEOMETRY NOT NULL, c GEOMETRY NOT NULL, d GEOMETRY NOT NULL, e GEOMETRY NOT NULL, f GEOMETRY NOT NULL, g GEOMETRY NOT NULL, h GEOMETRY NOT NULL, i GEOMETRY NOT NULL, j GEOMETRY NOT NULL, k GEOMETRY NOT NULL, l GEOMETRY NOT NULL, m GEOMETRY NOT NULL, n GEOMETRY NOT NULL, o GEOMETRY NOT NULL, p GEOMETRY NOT NULL, q GEOMETRY NOT NULL, r GEOMETRY NOT NULL, SPATIAL INDEX (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r) ); --echo # --echo # Bug #18422162 THE FIND_FLAG PASSED TO MYISAM AND INNODB ARE DIFFERENT --echo # SET @poly1 = ST_GeomFromText('POLYGON((25 25, 25 35, 35 35, 35 25, 25 25))'); CREATE TABLE t1 ( a INT NOT NULL, p POINT NOT NULL, l LINESTRING NOT NULL, g GEOMETRY NOT NULL, PRIMARY KEY(p), SPATIAL KEY idx2 (p), SPATIAL KEY idx3 (l), SPATIAL KEY idx4 (g) ) ENGINE=InnoDB; INSERT INTO t1 VALUES( 1, ST_GeomFromText('POINT(10 10)'), ST_GeomFromText('LINESTRING(1 1, 5 5, 10 10)'), ST_GeomFromText('POLYGON((30 30, 40 40, 50 50, 30 50, 30 40, 30 30))')); INSERT INTO t1 VALUES( 2, ST_GeomFromText('POINT(30 30)'), ST_GeomFromText('LINESTRING(2 3, 7 8, 9 10, 15 16)'), ST_GeomFromText('POLYGON((10 30, 30 40, 40 50, 40 30, 30 20, 10 30))')); EXPLAIN SELECT ST_AsText(p) FROM t1 WHERE ST_Within(p, @poly1); SELECT ST_AsText(p) FROM t1 WHERE ST_Within(p, @poly1); EXPLAIN SELECT ST_AsText(p) FROM t1 WHERE ST_Equals(p, ST_PointFromText('POINT(20 20)')); SELECT ST_AsText(p) FROM t1 WHERE ST_Equals(p, ST_PointFromText('POINT(20 20)')); DROP TABLE t1; CREATE TABLE t1 ( a INT NOT NULL, p POINT NOT NULL, l LINESTRING NOT NULL, g GEOMETRY NOT NULL, PRIMARY KEY(p), SPATIAL KEY idx2 (p), SPATIAL KEY idx3 (l), SPATIAL KEY idx4 (g) ) ENGINE=MyISAM; INSERT INTO t1 VALUES( 1, ST_GeomFromText('POINT(10 10)'), ST_GeomFromText('LINESTRING(1 1, 5 5, 10 10)'), ST_GeomFromText('POLYGON((30 30, 40 40, 50 50, 30 50, 30 40, 30 30))')); INSERT INTO t1 VALUES( 2, ST_GeomFromText('POINT(30 30)'), ST_GeomFromText('LINESTRING(2 3, 7 8, 9 10, 15 16)'), ST_GeomFromText('POLYGON((10 30, 30 40, 40 50, 40 30, 30 20, 10 30))')); EXPLAIN SELECT ST_AsText(p) FROM t1 WHERE ST_Within(p, @poly1); SELECT ST_AsText(p) FROM t1 WHERE ST_Within(p, @poly1); EXPLAIN SELECT ST_AsText(p) FROM t1 WHERE ST_Equals(p, ST_PointFromText('POINT(20 20)')); SELECT ST_AsText(p) FROM t1 WHERE ST_Equals(p, ST_PointFromText('POINT(20 20)')); DROP TABLE t1; --echo # --echo # Bug #21067378 GEOMETRIC OPERATION RETURNS ERROR INSTEAD OF RESULT --echo # CREATE TABLE t1 (p POINT NOT NULL UNIQUE) ENGINE=InnoDB; INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)')); SELECT ST_ASTEXT(p) FROM t1 WHERE MBRCOVEREDBY ( p, ST_GEOMFROMTEXT('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))') ); DROP TABLE t1; CREATE TABLE t1 (p POINT NOT NULL UNIQUE) ENGINE=MyISAM; INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)')); SELECT ST_ASTEXT(p) FROM t1 WHERE MBRCOVEREDBY ( p, ST_GEOMFROMTEXT('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))') ); DROP TABLE t1; --echo # --echo # Bug #21362781 ADD ST_NUMINTERIORRING ALIAS FOR ST_NUMINTERIORRINGS --echo # SELECT ST_NUMINTERIORRING(ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 0))')); SELECT ST_NUMINTERIORRING( ST_GEOMFROMTEXT( 'POLYGON((0 0, 1 0, 1 1, 0 0),(0.1 0.1, 0.9 0.8, 0.9 0.1, 0.1 0.1))' ) ); --echo # --echo # Bug#21651588 VIEW RETURNS ERROR WITH ST_CONVEXHULL() FUNCTION --echo # SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(0 0, 5 5)'))) as result; CREATE VIEW v1 AS SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(0 0, 5 5)'))); CREATE VIEW v2 AS SELECT ST_SRID(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(0 0, 5 5)'))); SELECT * FROM v1; SELECT * FROM v2; DROP VIEW v1; DROP VIEW v2; --echo # --echo # Bug#21652012 GIS FUNCTIONS RETURN ERROR WITH VALID INPUT WHEN USED IN SUBQUERY WITH NOT IN --echo # CREATE TABLE t1 (g GEOMETRY); INSERT INTO t1 (g) VALUES (ST_GeomFromText("MULTIPOLYGON(((0 7,-3 -14,9 -11,0 7)))")); --replace_numeric_round 12 SELECT ST_AsText(ST_Buffer(g, 2)), ST_AsText(ST_Buffer(g, 2)) FROM t1; --replace_numeric_round 12 SELECT ST_AsText(ST_Buffer(g, 2)), ST_AsText(ST_Difference(g, g)) FROM t1; DROP TABLE t1; CREATE TABLE t1(id INT PRIMARY KEY AUTO_INCREMENT, g GEOMETRY NOT NULL, SPATIAL INDEX(g)); INSERT INTO t1(g) VALUES (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 7,-3 -14,9 -11,0 7)))')); CREATE TABLE t2 SELECT ST_ASTEXT(ST_BUFFER(g, 54706, ST_BUFFER_STRATEGY('join_miter', 183))) AS result FROM t1 WHERE id = 1; UPDATE t2 SET result = (SELECT ST_ASTEXT(ST_BUFFER(g, 54706, ST_BUFFER_STRATEGY('join_miter', 183))) AS result FROM t1 WHERE id = 1) + 9999 WHERE result NOT IN (SELECT ST_ASTEXT(ST_BUFFER(g, 54706, ST_BUFFER_STRATEGY('join_miter', 183))) AS result FROM t1 WHERE id = 1); DROP TABLE t1; DROP TABLE t2; CREATE TABLE t1(id INT PRIMARY KEY AUTO_INCREMENT, g GEOMETRY); INSERT INTO t1(g) VALUES (ST_GEOMFROMTEXT('MULTIPOLYGON(((4 1,0 -18,6 -18,17 -18,19 8,4 1)))')); INSERT INTO t1(g) VALUES (ST_GEOMFROMTEXT('LINESTRING(-10 20,0 -1)')); CREATE TABLE t2 SELECT ST_ASTEXT(ST_DIFFERENCE(a.g, b.g)) AS result FROM t1 AS a, t1 AS b WHERE a.id = 1 AND b.id = 2; SELECT * FROM t2 WHERE result NOT IN (SELECT ST_ASTEXT(ST_DIFFERENCE(a.g, b.g)) AS result FROM t1 AS a, t1 AS b WHERE a.id = 1 AND b.id = 2); DROP TABLE t1; DROP TABLE t2; --echo # --echo # Bug#21658405 ST_UNION() RETURNS AN INVALID POLYGON --echo # SELECT ST_ISVALID(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 6,-11 -6,6 0,0 6),(3 1,5 0,-2 0,3 1))'), ST_GEOMFROMTEXT('POLYGON((5 4,6 0,9 12,-7 -12,5 -19,5 4))'))); SELECT ST_ISVALID(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,20 0,0 0))'), ST_GEOMFROMTEXT('POLYGON((10 5,20 7,10 10,30 10,20 0,20 5,10 5))'))); SELECT ST_ISVALID(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 0,0 40,40 40,40 0,0 0),(10 10,30 10,30 30,10 30,10 10))'), ST_GEOMFROMTEXT('POLYGON((5 15,5 30,30 15,5 15))'))); SELECT ST_ISVALID(ST_UNION(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 40,40 40,40 0,0 0),(10 10,30 10,30 30,10 30,10 10)))'), ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 20,20 10,10 10)),((20 10,30 20,30 10,20 10)),((10 20,10 30,20 20,10 20)),((20 20,30 30,30 20,20 20)))'))); SELECT ST_ISVALID(ST_UNION(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 40,40 40,40 0,0 0),(10 10,30 10,30 30,10 30,10 10)))'), ST_GEOMFROMTEXT('MULTIPOLYGON(((15 10,10 15,10 17,15 10)),((15 10,10 20,10 22,15 10)),((15 10,10 25,10 27,15 10)),((25 10,30 17,30 15,25 10)),((25 10,30 22,30 20,25 10)),((25 10,30 27,30 25,25 10)),((18 10,20 30,19 10,18 10)),((21 10,20 30,22 10,21 10)))'))); --echo # --echo # Bug#21614368 CRASH IN GEOMETRY::CONSTRUCT WITH BLOB INPUT --echo # FLUSH TABLES; CREATE TABLE t(a BLOB NOT NULL, b DATE NOT NULL) ENGINE=Innodb; SELECT NOT EXISTS ( SELECT 1 FROM t WHERE (SELECT a FROM t) IN (SELECT b FROM t) ) AS rescol FROM t; SELECT NOT EXISTS ( SELECT 1 FROM t WHERE (SELECT ST_GeomFromWKB(a) FROM t) IN (SELECT b FROM t) ) AS rescol FROM t; SELECT NOT EXISTS ( SELECT 1 FROM t WHERE (SELECT st_AsWKB(a) FROM t) IN (SELECT b FROM t) )AS rescol FROM t; SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t) AS result; SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t) AS result; INSERT INTO t VALUES(ST_GeomFromText('POINT(0 0)'), CURDATE()); SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t) AS result; SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t) AS result; --error ER_WRONG_ARGUMENTS SELECT ST_GeomFromText('POINT(0 0)') > (SELECT b FROM t) AS result; SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) > (SELECT b FROM t) AS result; DROP TABLE t; CREATE TABLE t1(a BLOB NOT NULL, b INT NOT NULL) ENGINE=Innodb; SELECT NOT EXISTS ( SELECT 1 FROM t1 WHERE (SELECT a FROM t1) IN (SELECT b FROM t1) ) AS rescol FROM t1; SELECT NOT EXISTS ( SELECT 1 FROM t1 WHERE (SELECT ST_GeomFromWKB(a) FROM t1) IN (SELECT b FROM t1) ) AS rescol FROM t1; SELECT NOT EXISTS ( SELECT 1 FROM t1 WHERE (SELECT st_AsWKB(a) FROM t1) IN (SELECT b FROM t1) )AS rescol FROM t1; SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t1) AS result; SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t1) AS result; INSERT INTO t1 VALUES(ST_GeomFromText('POINT(0 0)'), 1); SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t1) AS result; SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t1) AS result; --error ER_WRONG_ARGUMENTS SELECT ST_GeomFromText('POINT(0 0)') > (SELECT b FROM t1) AS result; SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) > (SELECT b FROM t1) AS result; DROP TABLE t1; --echo # --echo # Bug #19880316 ALTER TABLE INSERTS INVALID VALUES IN GEOMETRY COLUMNS --echo # --echo # Add a GEOMETRY NOT NULL column to a table without rows CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; ALTER TABLE t1 ADD COLUMN g GEOMETRY NOT NULL, ALGORITHM=INPLACE; ALTER TABLE t1 ADD COLUMN g2 GEOMETRY NOT NULL, ALGORITHM=COPY; ALTER TABLE t1 ADD COLUMN g3 GEOMETRY; ALTER TABLE t1 MODIFY COLUMN g3 GEOMETRY NOT NULL; ALTER TABLE t1 ADD COLUMN g4 GEOMETRY NOT NULL, ALGORITHM=DEFAULT; ALTER TABLE t1 ADD COLUMN g5 GEOMETRY NOT NULL; SHOW CREATE TABLE t1; DROP TABLE t1; --echo # Add a GEOMETRY NOT NULL column to a table with rows CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES (0); --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 ADD COLUMN g GEOMETRY NOT NULL, ALGORITHM=INPLACE; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 ADD COLUMN g GEOMETRY NOT NULL, ALGORITHM=COPY; ALTER TABLE t1 ADD COLUMN g GEOMETRY; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SHOW CREATE TABLE t1; SELECT i, g FROM t1; UPDATE t1 SET g=POINT(0,0) WHERE g IS NULL; ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SHOW CREATE TABLE t1; SELECT i, ST_ASTEXT(g) FROM t1; DROP TABLE t1; --echo # Convert an INT column without rows to GEOMETRY, and then to --echo # GEOMETRY NOT NULL CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; ALTER TABLE t1 ADD COLUMN g INT; ALTER TABLE t1 MODIFY COLUMN g GEOMETRY; ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SHOW CREATE TABLE t1; DROP TABLE t1; --echo # Convert an INT column without rows to GEOMETRY NOT NULL CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; ALTER TABLE t1 ADD COLUMN g INT; ALTER TABLE t1 ADD COLUMN g2 INT; ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; ALTER TABLE t1 CHANGE COLUMN g h GEOMETRY NOT NULL; SET @save_innodb_strict_mode=@@session.innodb_strict_mode; SET SESSION innodb_strict_mode=OFF; SET @save_sql_mode=@@session.sql_mode; SET SESSION sql_mode=""; ALTER TABLE t1 MODIFY COLUMN g2 GEOMETRY NOT NULL; ALTER TABLE t1 CHANGE COLUMN g2 h2 GEOMETRY NOT NULL; SET SESSION sql_mode=@save_sql_mode; SET SESSION innodb_strict_mode=@save_innodb_strict_mode; SHOW CREATE TABLE t1; DROP TABLE t1; --echo # Convert an INT column with NULL values to GEOMETRY, and then --echo # to GEOMETRY NOT NULL CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES (0); ALTER TABLE t1 ADD COLUMN g INT; SHOW CREATE TABLE t1; SELECT i, g FROM t1; ALTER TABLE t1 MODIFY COLUMN g GEOMETRY; SELECT i, g FROM t1; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SHOW CREATE TABLE t1; SELECT i, g FROM t1; DROP TABLE t1; --echo # Convert an INT column with NULL values to GEOMETRY NOT NULL CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES (0); ALTER TABLE t1 ADD COLUMN g INT; SHOW CREATE TABLE t1; SELECT i, g FROM t1; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 CHANGE COLUMN g h GEOMETRY NOT NULL; SET @save_innodb_strict_mode=@@session.innodb_strict_mode; SET SESSION innodb_strict_mode=OFF; SET @save_sql_mode=@@session.sql_mode; SET SESSION sql_mode=""; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 CHANGE COLUMN g h GEOMETRY NOT NULL; SET SESSION sql_mode=@save_sql_mode; SET SESSION innodb_strict_mode=@save_innodb_strict_mode; SHOW CREATE TABLE t1; SELECT i, g FROM t1; DROP TABLE t1; --echo # Convert an INT column without NULL values to GEOMETRY CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES (0); ALTER TABLE t1 ADD COLUMN g INT DEFAULT 1; SHOW CREATE TABLE t1; SELECT i, g FROM t1; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 MODIFY COLUMN g GEOMETRY; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 CHANGE COLUMN g h GEOMETRY; SHOW CREATE TABLE t1; SELECT i, g FROM t1; DROP TABLE t1; --echo # Convert an INT column without NULL values to GEOMETRY NOT --echo # NULL CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES (0); ALTER TABLE t1 ADD COLUMN g INT DEFAULT 1; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 CHANGE COLUMN g h GEOMETRY NOT NULL; SHOW CREATE TABLE t1; SELECT * FROM t1; DROP TABLE t1; --echo # Convert a VARCHAR column with an empty string to GEOMETRY CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES (0); ALTER TABLE t1 ADD COLUMN g VARCHAR(20) NOT NULL; SHOW CREATE TABLE t1; SELECT i, g FROM t1; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 MODIFY COLUMN g GEOMETRY; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 CHANGE COLUMN g h GEOMETRY; SHOW CREATE TABLE t1; SELECT i, g FROM t1; DROP TABLE t1; --echo # Convert a VARCHAR column with an empty string to GEOMETRY NOT --echo # NULL CREATE TABLE t1 ( i INT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES (0); ALTER TABLE t1 ADD COLUMN g VARCHAR(20) NOT NULL; SHOW CREATE TABLE t1; SELECT i, g FROM t1; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 CHANGE COLUMN g h GEOMETRY NOT NULL; SHOW CREATE TABLE t1; SELECT i, g FROM t1; DROP TABLE t1; --echo # Convert a BLOB column with a valid geometry in it to GEOMETRY --echo # NOT NULL CREATE TABLE t1 (b BLOB); INSERT INTO t1 VALUES(POINT(0,0)); ALTER TABLE t1 MODIFY COLUMN b BLOB; ALTER TABLE t1 ALGORITHM=COPY, MODIFY COLUMN b GEOMETRY NOT NULL; ALTER TABLE t1 MODIFY COLUMN b BLOB; INSERT INTO t1 VALUES(NULL); --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 ALGORITHM=COPY, MODIFY COLUMN b GEOMETRY NOT NULL; SET @save_innodb_strict_mode=@@session.innodb_strict_mode; SET SESSION innodb_strict_mode=OFF; SET @save_sql_mode=@@session.sql_mode; SET SESSION sql_mode=""; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN b GEOMETRY NOT NULL; SET SESSION sql_mode=@save_sql_mode; SET SESSION innodb_strict_mode=@save_innodb_strict_mode; SHOW CREATE TABLE t1; SELECT * FROM t1; DROP TABLE t1; --echo # Convert a POINT column without rows to POLYGON CREATE TABLE t1 ( p1 POINT, p2 POINT, p3 POINT, p4 POINT ) ENGINE=InnoDB; ALTER TABLE t1 MODIFY COLUMN p1 POLYGON; ALTER TABLE t1 CHANGE COLUMN p2 q2 POLYGON; ALTER TABLE t1 MODIFY COLUMN p3 POLYGON NOT NULL; ALTER TABLE t1 CHANGE COLUMN p4 q4 POLYGON NOT NULL; SHOW CREATE TABLE t1; SELECT * FROM t1; DROP TABLE t1; --echo # Convert a POINT column without NULL values to POLYGON CREATE TABLE t1 ( p POINT ) ENGINE=InnoDB; INSERT INTO t1 VALUES(POINT(0,0)); SHOW CREATE TABLE t1; SELECT ST_AsText(p) FROM t1; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 MODIFY COLUMN p POLYGON; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 CHANGE COLUMN p q POLYGON; SELECT ST_AsText(p) FROM t1; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 MODIFY COLUMN p POLYGON NOT NULL; --error ER_CANT_CREATE_GEOMETRY_OBJECT ALTER TABLE t1 CHANGE COLUMN p q POLYGON NOT NULL; SHOW CREATE TABLE t1; SELECT ST_AsText(p) FROM t1; DROP TABLE t1; --echo # Convert a MULTIPOINT NOT NULL column with rows via --echo # GEOMETRYCOLLECTION NOT NULL, to GEOMETRY NOT NULL and back CREATE TABLE t1 ( mp MULTIPOINT NOT NULL ) ENGINE=InnoDB; INSERT INTO t1 VALUES(MULTIPOINT(POINT(1,1))); SHOW CREATE TABLE t1; SELECT ST_AsText(mp) FROM t1; ALTER TABLE t1 MODIFY COLUMN mp GEOMETRYCOLLECTION NOT NULL; ALTER TABLE t1 MODIFY COLUMN mp GEOMETRY NOT NULL; ALTER TABLE t1 MODIFY COLUMN mp GEOMETRYCOLLECTION NOT NULL; ALTER TABLE t1 MODIFY COLUMN mp MULTIPOINT NOT NULL; SHOW CREATE TABLE t1; SELECT ST_AsText(mp) FROM t1; DROP TABLE t1; --echo # Convert a GEOMETRY column without rows to GEOMETRY NOT NULL CREATE TABLE t1 (g GEOMETRY) ENGINE=InnoDB; ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SHOW CREATE TABLE t1; DROP TABLE t1; CREATE TABLE t1 (g GEOMETRY) ENGINE=MyISAM; ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SHOW CREATE TABLE t1; DROP TABLE t1; --echo # Convert a GEOMETRY column with geometry data to GEOMETRY NOT --echo # NULL CREATE TABLE t1 (g GEOMETRY) ENGINE=InnoDB; INSERT INTO t1 VALUES (POINT(0,0)); ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SELECT ST_ASTEXT(g) FROM t1; DROP TABLE t1; CREATE TABLE t1 (g GEOMETRY) ENGINE=MyISAM; INSERT INTO t1 VALUES (POINT(0,0)); ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SELECT ST_ASTEXT(g) FROM t1; DROP TABLE t1; --echo # Convert a GEOMETRY column with a NULL value to GEOMETRY NOT NULL CREATE TABLE t1 (g GEOMETRY) ENGINE=InnoDB; INSERT INTO t1 VALUES (NULL); --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; DROP TABLE t1; CREATE TABLE t1 (g GEOMETRY) ENGINE=MyISAM; INSERT INTO t1 VALUES (NULL); --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SHOW CREATE TABLE t1; SELECT g FROM t1; SET @save_innodb_strict_mode=@@session.innodb_strict_mode; SET SESSION innodb_strict_mode=OFF; SET @save_sql_mode=@@session.sql_mode; SET SESSION sql_mode=""; --error ER_INVALID_USE_OF_NULL ALTER TABLE t1 MODIFY COLUMN g GEOMETRY NOT NULL; SET SESSION sql_mode=@save_sql_mode; SET SESSION innodb_strict_mode=@save_innodb_strict_mode; SHOW CREATE TABLE t1; SELECT g FROM t1; DROP TABLE t1; --echo # --echo # Bug#21689998 ST_UNION() RETURNS AN INVALID GEOMETRYCOLLECTION --echo # SELECT ST_ISVALID(ST_UNION(ST_GEOMFROMTEXT('LINESTRING(12 6,9 4,-9 1,-4 -6,12 -9,-9 -17,17 -11,-16 17,19 -19,0 -16,6 -5,15 3,14 -5,18 13,-9 10,-11 8)'), ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((-18 2,1 7),(-19 -3,-16 -12),(10 0,3 8,12 19,8 -15)),MULTILINESTRING((8 16,-8 -3),(18 3,8 12),(-19 4,20 14)),POLYGON((2 3,-9 -7,12 -13,2 3)),MULTILINESTRING((16 -7,-2 2,11 -10,-1 8),(6 0,-15 0,16 0,-6 -14)))'))); SELECT ST_ISVALID( ST_UNION( ST_GEOMFROMTEXT(' LINESTRING(-9 -17,17 -11) '), ST_GEOMFROMTEXT(' GEOMETRYCOLLECTION( LINESTRING(8 16,-8 -3), POLYGON((2 3,-9 -7,12 -13,2 3)), MULTILINESTRING((-2 2,11 -10),(6 0,-15 0,16 0)) ) ') ) ) AS valid; SELECT ST_ISVALID( ST_DIFFERENCE( ST_GEOMFROMTEXT('MULTILINESTRING((8 16,-8 -3),(-2 2,-0.561069 0.671756),(8.93182 -8.09091,11 -10),(6 0,3.875 0),(-1.3 0,-15 0,-1.3 0),(3.875 0,16 0))'), ST_GEOMFROMTEXT('POLYGON((2 3,-9 -7,12 -13,2 3))'))) as valid0; --echo # --echo # Bug#21658453 ST_INTERSECTION() PRODUCES INVALID POLYGON --echo # SELECT ST_ISVALID(ST_INTERSECTION(ST_GEOMFROMTEXT('POLYGON((0 5,-6 -17,12 17,0 5),(4 6,5 5,0 1,4 6))'), ST_GEOMFROMTEXT('POLYGON((3 9,-15 -5,13 -11,3 9))'))); SELECT ST_ISVALID(ST_INTERSECTION(ST_GEOMFROMTEXT('POLYGON((5 6,-15 -13,1 -8,5 6))'), ST_GEOMFROMTEXT('POLYGON((0 8,-19 6,18 -17,20 8,11 17,0 8),(3 2,3 -1,1 0,3 2),(1 3,4 4,0 -1,1 3))'))); --echo # --echo # Bug#21823135 INVALID READ OF MEMORY FREED BY GIS_WKB_RAW_FREE --echo # SELECT point(1,1) IN ('1',1,'1') AS res; SELECT st_centroid(point(1,1)) IN ('1',1,'1') AS res; DO st_centroid(point(1,1)) IN ('1',1,'1'); --echo # --echo # Bug #21841051 PREPARE STATEMENT RETURNS DIFFERENT NUMBER OF ROWS WHEN --echo # EXECUTED SECOND TIME --echo # SELECT ST_AsText(ST_GeomFromText('POINT(0 0)', NULL)); SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', NULL)); --echo # --echo # Bug#21871856 ST_BUFFER() RETURNS AN INVALID POLYGON --echo # SELECT ST_ISVALID(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((-5 15,7 15,19 -10,-11 -2),(2 13,2 -9))'), 1)); --echo # --echo # Bug #21889842 PROCEDURE RETURNS DIFFERENT RESULT WITH ST_AREA() WHEN --echo # EXECUTED SECOND TIME --echo # CREATE TABLE t1 (g GEOMETRY); INSERT INTO t1 VALUES (ST_GeomFromText('LINESTRING(-3 11,-10 15,-16 -13)')); CREATE TABLE t2 (g GEOMETRY); INSERT INTO t2 VALUES (ST_GeomFromText('POINT(-10 15)')), (ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(-13 9,0 -13))')); CREATE PROCEDURE proc () LANGUAGE SQL SELECT 1 AS result FROM (t1 RIGHT OUTER JOIN t2 ON ST_CONTAINS(t2.g, t1.g)) WHERE t1.g NOT IN (SELECT g FROM t2); CALL proc; CALL proc; CALL proc; DROP PROCEDURE proc; DROP TABLE t1, t2; --echo # --echo # Bug#21927558 ST_INTERSECTION(POLYGON, POLYGON) RETURNS SELF --echo # INTERSECTING POLYGON --echo # SELECT ST_ISVALID(ST_INTERSECTION(ST_GEOMFROMTEXT('POLYGON((6 7,18 14,-8 1,0 0,18 -8,6 7),(6 0,-4 3,5 3,6 0))'), ST_GEOMFROMTEXT('MULTIPOLYGON(((2 3,-3 5,-10 -1,2 3)))'))); --echo # --echo # Bug#21927639 ST_SYMDIFFERENCE(POLYGON, POLYGON) RETURNS INVALID --echo # MULTIPOLYGOM GEOMETRY --echo # SELECT ST_ISVALID(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((6 7,18 14,-8 1,0 0,18 -8,6 7),(6 0,-4 3,5 3,6 0))'), ST_GEOMFROMTEXT('POLYGON((0 7,-5 6,11 -13,0 7))'))); --echo # --echo # Bug#21927733 ST_UNION() PRODUCES AN INVALID POLYGON GEOMETRY --echo # SELECT ST_ISVALID(ST_UNION(ST_GEOMFROMTEXT('POLYGON((4 5,12 11,-12 -3,4 5))'), ST_GEOMFROMTEXT('MULTIPOLYGON(((5 4,-14 0,1 0,5 4)),((1 6,13 0,10 12,1 6)))'))); --echo # --echo # Bug#21977775 ST_DIFFERENCE(POLYGON, POLYGON) RETURNS INVALID GEOMETRY --echo # SELECT ST_ISVALID(ST_DIFFERENCE(ST_GEOMFROMTEXT('POLYGON((8 6,5 7,-1 4,-8 -7,0 -17,8 6),(3 6,5 5,0 -2,3 6))'), ST_GEOMFROMTEXT('POLYGON((3 5,-17 11,-8 -3,3 5))'))) AS result; --echo # --echo # Bug #22131961 CANNOT GET GEOMETRY OBJECT FROM DATA YOU SEND TO THE --echo # GEOMETRY FIELD --echo # CREATE TABLE d (id INT, r_id INT, i INT); INSERT INTO d VALUES (1, 1, 1); CREATE TABLE dp (id INT, d_id INT); INSERT INTO dp VALUES (1, 1); CREATE TABLE r (id INT, p POINT); INSERT INTO r VALUES (1, ST_GEOMFROMTEXT('POINT(1 1)')); DO (SELECT ST_ASBINARY(r.p) FROM d INNER JOIN dp ON d.id = dp.d_id INNER JOIN r ON d.r_id = r.id ORDER BY d.i); DROP TABLE d, dp, r; --echo # --echo # Bug #22340858 CRASH AT GET_INTERVAL_VALUEITEMINTERVAL_TYPE --echo # SET collation_connection='utf32_bin'; SELECT '2010-10-10 10:10:10' + INTERVAL ST_GeometryType(ST_GeomFromText('POINT(1 1)')) HOUR_SECOND; --echo # --echo # Bug #32975221 5.7.29+ REGRESSION, SPATIAL INDEX NOT USED ANYMORE FOR MBRCONTAINS --echo # CREATE TABLE t ( c1 VARCHAR(8) NOT NULL, c2 VARCHAR(16) NOT NULL, geom POINT NOT NULL, PRIMARY KEY (c2,c1), SPATIAL KEY coord (geom) ) ENGINE=INNODB DEFAULT CHARSET=UTF8; INSERT INTO t VALUES (1, 2, POINT(1, 2)); --replace_column 10 ## 11 ## EXPLAIN SELECT COUNT(*) FROM t WHERE MBRCONTAINS(ST_GEOMFROMTEXT('POLYGON((1 2, 2 2, 2 3, 1 2))'), geom) AND c1 <> '10'; DROP TABLE t;
Close