summaryrefslogtreecommitdiffstats
path: root/mysql-test/collections/10.0-compatible.list
blob: cccf5b7c0e87057ac8ec16f89e678d56ec1a280a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
# All lines which have a hash sign *anywhere* will be ignored

main.1st
main.adddate_454
main.almost_full
main.alter_table_autoinc-5574
main.alter_table_errors
main.alter_table_mdev539_maria
main.alter_table_mdev539_myisam
main.alter_table_online
main.alter_table_trans
main.analyze
main.analyze_stmt
main.analyze_stmt_orderby
main.analyze_stmt_slow_query_log
main.ansi
main.assign_key_cache
main.auth_rpl
main.auto_increment
main.auto_increment_ranges_innodb
main.auto_increment_ranges_myisam
main.bad_frm_crash_5029
main.bench_count_distinct
main.bigint
main.binary
main.binary_to_hex
main.blackhole
main.blackhole_plugin
main.bool
main.bootstrap
main.bug12427262
main.bug13633383
main.bug46760
main.bug47671
main.bulk_replace
main.case
main.change_user
main.check_constraint_show
main.client_xml
main.comment_column
main.comment_column2
main.comment_index
main.comments
main.comment_table
main.commit_1innodb
main.compare
main.compound
main.contributors
main.count_distinct
main.count_distinct2
main.create_drop_db
main.create_drop_event
main.create_drop_function
main.create_drop_index
main.create_drop_procedure
main.create_drop_server
main.create_drop_trigger
main.create_drop_user
main.create_drop_view
main.create_not_windows
main.create_select_tmp
main.create-uca
main.create_user
main.create_w_max_indexes_64
main.ctype_ascii
main.ctype_big5
main.ctype_binary
main.ctype_collate
main.ctype_cp1250_ch
main.ctype_cp1251
main.ctype_cp850
main.ctype_cp932
main.ctype_cp932_binlog_row
main.ctype_cp932_binlog_stm
main.ctype_create
main.ctype_eucjpms
main.ctype_euckr
main.ctype_filename
main.ctype_filesystem
main.ctype_gb2312
main.ctype_gbk
main.ctype_gbk_binlog
main.ctype_gbk_export_import
main.ctype_hebrew
main.ctype_latin1
main.ctype_latin1_de
main.ctype_latin2
main.ctype_latin2_ch
main.ctype_ldml
main.ctype_many
main.ctype_mb
main.ctype_nopad_8bit
main.ctype_partitions
main.ctype_recoding
main.ctype_sjis
main.ctype_swe7
main.ctype_tis620
main.ctype_uca
main.ctype_uca_innodb
main.ctype_uca_partitions
main.ctype_ucs
main.ctype_ucs2_def
main.ctype_ucs2_query_cache
main.ctype_ucs2_uca
main.ctype_ujis
main.ctype_ujis_ucs2
main.ctype_upgrade
main.ctype_utf16
main.ctype_utf16_def
main.ctype_utf16le
main.ctype_utf16_uca
main.ctype_utf32
main.ctype_utf32_uca
main.ctype_utf8
main.ctype_utf8mb4
main.ctype_utf8mb4_heap
main.ctype_utf8mb4_innodb
main.ctype_utf8mb4_myisam
main.ctype_utf8mb4_uca
main.ctype_utf8_uca
main.date_formats
main.datetime_456
main.default_storage_engine
main.delete
main.delete_returning
main.deprecated_features
main.derived_cond_pushdown
main.derived_opt
main.derived_view
main.distinct
main.drop-no_root
main.dyncol
main.empty_server_name-8224
main.empty_table
main.endspace
main.enforce_storage_engine_opt
main.errors
main.events_2
main.events_logs_tests
main.events_microsec
main.events_restart
main.events_scheduling
main.events_slowlog
main.events_trans
main.execution_constants
main.explain
main.explain_json
main.explain_json_format_partitions
main.explain_json_innodb
main.explain_non_select
main.ext_key_noPK_6794
main.fast_prefix_index_fetch_innodb
main.features
main.filesort_bad_i_s-7585
main.flush2
main.foreign_key
main.frm_bad_row_type-7333
main.fulltext
main.fulltext2
main.fulltext3
main.fulltext_cache
main.fulltext_charsets
main.fulltext_derived_4257
main.fulltext_derived_4316
main.fulltext_distinct
main.fulltext_left_join
main.fulltext_multi
main.fulltext_order_by
main.fulltext_update
main.fulltext_var
main.func_analyse
main.func_concat
main.func_crypt
main.func_date_add
main.func_default
main.func_des_encrypt
main.func_digest
main.func_encrypt
main.func_encrypt_ucs2
main.func_equal
main.func_gconcat
main.func_group_innodb
main.func_hybrid_type
main.func_if
main.func_in
main.func_isnull
main.func_like
main.func_math
main.func_op
main.func_regexp
main.func_regexp_pcre
main.func_rollback
main.func_sapdb
main.func_set
main.func_system
main.func_test
main.func_time
main.func_time_hires
main.func_timestamp
main.function_defaults
main.function_defaults_innodb
main.gcc296
main.get_diagnostics
main.gis
main.gis-alter_table_online
main.gis-precise
main.gis-rt-precise
main.gis-rtree
main.grant_4332
main.greedy_optimizer
main.group_by
main.group_by_innodb
main.group_by_null
main.group_min_max
main.group_min_max_innodb
main.handler_read_last
main.handlersocket
main.having
main.help
main.host_cache_size_functionality
main.huge_frm-6224
main.implicit_char_to_num_conversion
main.implicit_commit
main.in_datetime_241
main.index_intersect
main.index_intersect_innodb
main.index_merge_innodb
main.index_merge_myisam
main.information_schema2
main.information_schema_all_engines
main.information_schema_chmod
main.information_schema_inno
main.information_schema_parameters
main.information_schema_part
main.information_schema_routines
main.information_schema_stats
main.init_file
main.init_file_longline_3816
main.init_file_set_password-7656
main.innodb_bug878769
main.innodb_ext_key
main.innodb_group
main.innodb_icp
main.innodb_ignore_builtin
main.innodb_mrr_cpk
main.innodb_utf8
main.insert
main.insert_innodb
main.insert_select
main.insert_update
main.insert_update_autoinc-7150
main.join
main.join_cache
main.join_crash
main.join_nested
main.join_nested_jcl6
main.join_optimizer
main.join_outer
main.join_outer_innodb
main.join_outer_jcl6
main.key
main.key_cache
main.key_diff
main.key_primary
main.keyread
main.keywords
main.last_value
main.limit
main.limit_rows_examined
main.loaddata_autocom_innodb
main.locale
main.log_errchk
main.log_slow
main.log_state_bug33693
main.log_tables_upgrade
main.long_tmpdir
main.lowercase_mixed_tmpdir
main.lowercase_table
main.lowercase_table5
main.lowercase_table_grant
main.lowercase_table_qcache
main.lowercase_utf8
main.lowercase_view
main.mdev13607
main.mdev_14586
main.mdev316
main.mdl
main.merge_innodb
main.merge_mmap
main.metadata
main.mix2_myisam_ucs2
main.mrr_derived_crash_4610
main.mrr_icp_extra
main.multi_statement
main.multi_update2
main.multi_update_innodb
main.multi_update_tiny_hash
main.myisam-blob
main.myisam_enable_keys-10506
main.myisam_explain_non_select_all
main.myisam_icp
main.myisam_mrr
main.myisampack
main.myisam-system
main.mysql
main.mysql5613mysql
main.mysql57_virtual
main.mysqladmin
main.mysql_binary_mode
main.mysqlcheck
main.mysql_comments
main.mysql_cp932
main.mysqld--defaults-file
main.mysqld--help
main.mysqld_help_crash-9183
main.mysqld_option_err
main.mysqldump-compat
main.mysqldump-nl
main.mysqldump-no-binlog
main.mysqldump_restore
main.mysql_not_windows
main.mysql_protocols
main.mysqlshow
main.mysqlslap
main.mysqltest_256
main.mysqltest_cont_on_error
main.mysql_tzinfo_to_sql_symlink
main.mysql_upgrade_noengine
main.mysql_upgrade_no_innodb
main.mysql_upgrade_ssl
main.mysql_upgrade_view
main.negation_elimination
main.no_binlog
main.no_password_column-mdev-11170
main.null
main.null_key
main.odbc
main.olap
main.old-mode
main.order_by
main.order_by_innodb
main.order_by-mdev-10122
main.order_by_optimizer
main.order_by_optimizer_innodb
main.order_by_sortkey
main.order_by_zerolength-4285
main.order_fill_sortbuf
main.outfile_loaddata
main.parser
main.parser_bug21114_innodb
main.parser_precedence
main.parser_stack
main.partition
main.partition_binlog
main.partition_binlog_stmt
main.partition_blackhole
main.partition_bug18198
main.partition_cache_innodb
main.partition_cache_myisam
main.partition_charset
main.partition_column
main.partition_column_prune
main.partition_datatype
main.partition_disabled
main.partition_error
main.partition_example
main.partition_exchange
main.partition_explicit_prune
main.partition_hash
main.partition_key_cache
main.partition_list
main.partition_mgm
main.partition_mgm_err
main.partition_mgm_err2
main.partition_myisam
main.partition_not_blackhole
main.partition_not_windows
main.partition_order
main.partition_pruning
main.partition_range
main.partition_rename_longfilename
main.partition_truncate
main.partition_utf8
main.perror
main.plugin
main.plugin_auth_qa
main.plugin_auth_qa_2
main.plugin_auth_qa_3
main.plugin_innodb
main.plugin_load
main.plugin_loaderr
main.plugin_load_option
main.plugin_maturity
main.preload
main.profiling
main.progress_976225
main.ps_10nestset
main.ps_11bugs
main.ps_1general
main.ps_2myisam
main.ps_3innodb
main.ps_4heap
main.ps_5merge
main.ps_change_master
main.ps_ddl1
main.ps_max_subselect-5113
main.ps_not_windows
main.query_cache
main.query_cache_innodb
main.query_cache_merge
main.query_cache_with_views
main.range
main.range_innodb
main.range_mrr_icp
main.range_vs_index_merge
main.range_vs_index_merge_innodb
main.renamedb
main.reopen_temp_table
main.repair
main.repair_symlink-5543
main.replace
main.rollback
main.round
main.row
main.row-checksum
main.row-checksum-old
main.rowid_order_innodb
main.rpl_mysqldump_slave
main.second_frac-9175
main.select
main.select_found
main.selectivity
main.selectivity_innodb
main.selectivity_no_engine
main.select_jcl6
main.select_pkeycache
main.select_safe
main.servers
main.set_password
main.set_statement_notembedded
main.set_statement_notembedded_binlog
main.show
main.show_bad_definer-5553
main.show_create_user
main.show_function_with_pad_char_to_full_length
main.show_profile
main.show_row_order-9226
main.sighup-6580
main.signal
main.signal_demo1
main.signal_demo2
main.signal_demo3
main.signal_sqlmode
main.single_delete_update
main.single_delete_update_innodb
main.skip_grants
main.skip_log_bin
main.sp-big
main.sp-bugs
main.sp-bugs2
main.sp-destruct
main.sp-dynamic
main.sp-error
main.sp-fib
main.sp_gis
main.sp-group
main.sp_missing_4665
main.sp-no-code
main.sp-prelocking
main.sp_stress_case
main.sp_trans
main.sp_trans_log
main.sp-ucs2
main.sp-vars
main.ssl_7937
main.ssl_8k_key
main.ssl_and_innodb
main.ssl_ca
main.ssl_cert_verify
main.ssl_connect
main.ssl_crl_clients
main.stack-crash
main.statistics
main.statistics_index_crash-7362
main.stat_tables
main.stat_tables_disabled
main.stat_tables_innodb
main.stat_tables_partition
main.stat_tables_repl
main.strict
main.strict_autoinc_1myisam
main.strict_autoinc_2innodb
main.strict_autoinc_3heap
main.str_to_datetime_457
main.subselect2
main.subselect3
main.subselect3_jcl6
main.subselect4
main.subselect_cache
main.subselect-crash_15755
main.subselect_exists2in
main.subselect_exists2in_costmat
main.subselect_extra
# Disabled due to connect log output
# main.subselect_extra_no_semijoin
main.subselect_gis
main.subselect_innodb
main.subselect_mat
main.subselect_mat_cost
main.subselect_mat_cost_bugs
main.subselect_notembedded
main.subselect_nulls
main.subselect_partial_match
main.subselect_sj2
main.subselect_sj2_jcl6
main.subselect_sj2_mat
main.subselect_sj_aria
main.subselect_sj_mat
main.subselect_sj_nonmerged
main.sum_distinct
main.sysdate_is_now
main.system_mysql_db
main.system_mysql_db_refs
main.table_elim
main.table_elim_debug
main.table_keyinfo-6838
main.tablelock
main.table_options
main.table_options-5867
main.temporal_literal
main.temporal_scale_4283
main.temp_table_frm
main.timezone
main.timezone2
main.timezone3
main.timezone4
main.tmp_table_count-7586
main.trigger_no_defaults-11698
main.trigger_null-8605
main.truncate
main.truncate_badse
main.truncate-stale-6500
main.type_binary
main.type_bit
main.type_bit_innodb
main.type_blob
main.type_datetime_hires
main.type_decimal
main.type_enum
main.type_float
main.type_int
main.type_nchar
main.type_newdecimal
main.type_num
main.type_num_innodb
main.type_ranges
main.type_set
main.type_temporal_innodb
main.type_temporal_mysql56
main.type_time
main.type_time_6065
main.type_time_hires
main.type_timestamp_hires
main.type_uint
main.type_varchar
main.type_year
main.update_ignore_216
main.update_innodb
main.upgrade
main.user_var
main.varbinary
main.variables_community
main.view_alias
main.warnings_engine_disabled
main.win_avg
main.win_big
main.win_big-mdev-10092
main.win_big-mdev-11697
main.win_bit
main.win_empty_over
main.win_first_last_value
main.win_insert_select
main.win_i_s
# Disabled due to unknown SQL error name
# main.win_lead_lag
main.win_min_max
main.win_nth_value
main.win_orderby
main.win_percent_cume
main.win_rank
main.win_sum
main.xa_binlog
main.xml
main.xtradb_mrr