Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.23.92.44
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 /
suite /
sys_vars /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
all_vars.result
1.31
KB
-rw-r--r--
auto_generate_certs_basic.resu...
25
B
-rw-r--r--
auto_increment_increment_basic...
6.68
KB
-rw-r--r--
auto_increment_increment_func....
5.53
KB
-rw-r--r--
auto_increment_offset_basic.re...
7.09
KB
-rw-r--r--
auto_increment_offset_func.res...
6.08
KB
-rw-r--r--
autocommit_basic.result
3.66
KB
-rw-r--r--
autocommit_func.result
2.66
KB
-rw-r--r--
autocommit_func2.result
822
B
-rw-r--r--
autocommit_func3.result
778
B
-rw-r--r--
autocommit_func4.result
822
B
-rw-r--r--
autocommit_func5.result
778
B
-rw-r--r--
automatic_sp_privileges_basic....
4.9
KB
-rw-r--r--
automatic_sp_privileges_func.r...
1.84
KB
-rw-r--r--
avoid_temporal_upgrade_basic.r...
3.15
KB
-rw-r--r--
back_log_basic.result
679
B
-rw-r--r--
basedir_basic.result
1.5
KB
-rw-r--r--
big_tables_basic.result
3.55
KB
-rw-r--r--
bind_address_basic.result
1.77
KB
-rw-r--r--
binlog_cache_size_basic_32.res...
4.26
KB
-rw-r--r--
binlog_cache_size_basic_64.res...
4.26
KB
-rw-r--r--
binlog_checksum_basic.result
1.8
KB
-rw-r--r--
binlog_direct_non_transactiona...
2.81
KB
-rw-r--r--
binlog_error_action_basic.resu...
1.28
KB
-rw-r--r--
binlog_format_basic.result
1.89
KB
-rw-r--r--
binlog_group_commit_sync_delay...
685
B
-rw-r--r--
binlog_group_commit_sync_no_de...
742
B
-rw-r--r--
binlog_gtid_simple_recovery_ba...
982
B
-rw-r--r--
binlog_max_flush_queue_time_ba...
2.24
KB
-rw-r--r--
binlog_order_commits_basic.res...
4.47
KB
-rw-r--r--
binlog_row_image_basic.result
2.55
KB
-rw-r--r--
binlog_rows_query_log_events_b...
2.44
KB
-rw-r--r--
binlog_stmt_cache_size_basic_3...
4.61
KB
-rw-r--r--
binlog_stmt_cache_size_basic_6...
4.61
KB
-rw-r--r--
binlog_transaction_dependency_...
2.64
KB
-rw-r--r--
binlog_transaction_dependency_...
5.28
KB
-rw-r--r--
block_encryption_mode_basic.re...
7.79
KB
-rw-r--r--
bulk_insert_buffer_size_basic_...
6.26
KB
-rw-r--r--
bulk_insert_buffer_size_basic_...
6.09
KB
-rw-r--r--
character_set_client_basic.res...
15.25
KB
-rw-r--r--
character_set_client_func.resu...
1.25
KB
-rw-r--r--
character_set_connection_basic...
17.22
KB
-rw-r--r--
character_set_connection_func....
2.23
KB
-rw-r--r--
character_set_database_basic.r...
28.52
KB
-rw-r--r--
character_set_database_func.re...
3.54
KB
-rw-r--r--
character_set_filesystem_basic...
16.49
KB
-rw-r--r--
character_set_results_basic.re...
16.34
KB
-rw-r--r--
character_set_results_func.res...
1.99
KB
-rw-r--r--
character_set_server_basic.res...
15.75
KB
-rw-r--r--
character_set_server_func.resu...
2.07
KB
-rw-r--r--
character_set_system_basic.res...
1.84
KB
-rw-r--r--
character_sets_dir_basic.resul...
922
B
-rw-r--r--
check_proxy_users_basic.result
4.25
KB
-rw-r--r--
check_proxy_users_cmdl.result
1.35
KB
-rw-r--r--
check_proxy_users_func.result
736
B
-rw-r--r--
collation_connection_basic.res...
42.67
KB
-rw-r--r--
collation_connection_func.resu...
2.29
KB
-rw-r--r--
collation_database_basic.resul...
73.39
KB
-rw-r--r--
collation_database_func.result
4.72
KB
-rw-r--r--
collation_server_basic.result
39.15
KB
-rw-r--r--
collation_server_func.result
2.62
KB
-rw-r--r--
completion_type_basic.result
5.02
KB
-rw-r--r--
completion_type_func.result
4.15
KB
-rw-r--r--
concurrent_insert_basic.result
4.7
KB
-rw-r--r--
concurrent_insert_func.result
2.69
KB
-rw-r--r--
connect_timeout_basic.result
3.69
KB
-rw-r--r--
core_file_basic.result
197
B
-rw-r--r--
datadir_basic.result
1.5
KB
-rw-r--r--
date_format_basic.result
859
B
-rw-r--r--
datetime_format_basic.result
972
B
-rw-r--r--
debug_basic.result
716
B
-rw-r--r--
debug_sync_basic.result
832
B
-rw-r--r--
default_authentication_plugin_...
1.87
KB
-rw-r--r--
default_password_lifetime_basi...
1.06
KB
-rw-r--r--
default_storage_engine_basic.r...
4.65
KB
-rw-r--r--
default_tmp_storage_engine_bas...
6.57
KB
-rw-r--r--
default_week_format_basic.resu...
6.05
KB
-rw-r--r--
default_week_format_func.resul...
1.57
KB
-rw-r--r--
delay_key_write_basic.result
3.37
KB
-rw-r--r--
delay_key_write_func.result
1.67
KB
-rw-r--r--
delayed_insert_limit_basic_32....
7.53
KB
-rw-r--r--
delayed_insert_limit_basic_64....
7.46
KB
-rw-r--r--
delayed_insert_timeout_basic.r...
9.05
KB
-rw-r--r--
delayed_queue_size_basic_32.re...
7.32
KB
-rw-r--r--
delayed_queue_size_basic_64.re...
7.25
KB
-rw-r--r--
disconnect_on_expired_password...
992
B
-rw-r--r--
div_precision_increment_basic....
7.62
KB
-rw-r--r--
div_precision_increment_func.r...
2.54
KB
-rw-r--r--
end_markers_in_json_basic.resu...
1.88
KB
-rw-r--r--
enforce_gtid_consistency_basic...
5.88
KB
-rw-r--r--
eq_range_index_dive_limit_basi...
3.27
KB
-rw-r--r--
error_count_basic.result
1.56
KB
-rw-r--r--
event_scheduler_basic.result
4.26
KB
-rw-r--r--
expire_logs_days_basic.result
4.48
KB
-rw-r--r--
explicit_defaults_for_timestam...
1.44
KB
-rw-r--r--
external_user_basic.result
71
B
-rw-r--r--
flush_basic.result
3.23
KB
-rw-r--r--
flush_time_basic.result
1.64
KB
-rw-r--r--
foreign_key_checks_basic.resul...
3.75
KB
-rw-r--r--
foreign_key_checks_func.result
1.96
KB
-rw-r--r--
ft_boolean_syntax_basic.result
4.4
KB
-rw-r--r--
ft_boolean_syntax_func.result
4.69
KB
-rw-r--r--
ft_max_word_len_basic.result
791
B
-rw-r--r--
ft_min_word_len_basic.result
786
B
-rw-r--r--
ft_query_expansion_limit_basic...
935
B
-rw-r--r--
ft_stopword_file_basic.result
847
B
-rw-r--r--
general_log_basic.result
3.83
KB
-rw-r--r--
general_log_file_basic.result
961
B
-rw-r--r--
general_log_file_func.result
499
B
-rw-r--r--
general_log_func.result
1.24
KB
-rw-r--r--
group_concat_max_len_basic.res...
5.82
KB
-rw-r--r--
group_concat_max_len_func.resu...
3.21
KB
-rw-r--r--
gtid_executed_basic.result
7.07
KB
-rw-r--r--
gtid_executed_compression_peri...
2.83
KB
-rw-r--r--
gtid_mode_basic.result
6.14
KB
-rw-r--r--
gtid_next_basic.result
1.47
KB
-rw-r--r--
gtid_owned_basic.result
1.04
KB
-rw-r--r--
gtid_purged_basic.result
1.63
KB
-rw-r--r--
have_compress_basic.result
1.65
KB
-rw-r--r--
have_crypt_basic.result
1.58
KB
-rw-r--r--
have_dynamic_loading_basic.res...
1.84
KB
-rw-r--r--
have_geometry_basic.result
1.65
KB
-rw-r--r--
have_openssl_basic.result
1.63
KB
-rw-r--r--
have_profiling_basic.result
875
B
-rw-r--r--
have_query_cache_basic.result
2.4
KB
-rw-r--r--
have_rtree_keys_basic.result
1.71
KB
-rw-r--r--
have_ssl_basic.result
1.52
KB
-rw-r--r--
have_statement_timeout_basic.r...
1.84
KB
-rw-r--r--
have_symlink_basic.result
1.63
KB
-rw-r--r--
host_cache_size_basic.result
2.01
KB
-rw-r--r--
hostname_basic.result
1.52
KB
-rw-r--r--
identity_basic.result
4.28
KB
-rw-r--r--
identity_func.result
2.33
KB
-rw-r--r--
ignore_builtin_innodb_basic.re...
890
B
-rw-r--r--
ignore_db_dirs_basic.result
566
B
-rw-r--r--
init_connect_basic.result
3.78
KB
-rw-r--r--
init_file_basic.result
689
B
-rw-r--r--
init_slave_basic.result
3.34
KB
-rw-r--r--
innodb_adaptive_flushing_basic...
4.01
KB
-rw-r--r--
innodb_adaptive_flushing_lwm_b...
4.46
KB
-rw-r--r--
innodb_adaptive_hash_index_bas...
4.14
KB
-rw-r--r--
innodb_adaptive_hash_index_par...
1.84
KB
-rw-r--r--
innodb_adaptive_max_sleep_dela...
2.68
KB
-rw-r--r--
innodb_api_bk_commit_interval_...
3.94
KB
-rw-r--r--
innodb_api_disable_rowlock_bas...
2.02
KB
-rw-r--r--
innodb_api_enable_binlog_basic...
1.98
KB
-rw-r--r--
innodb_api_enable_mdl_basic.re...
1.9
KB
-rw-r--r--
innodb_api_trx_level_basic.res...
2.3
KB
-rw-r--r--
innodb_autoextend_increment_ba...
3.87
KB
-rw-r--r--
innodb_autoinc_lock_mode_basic...
1.24
KB
-rw-r--r--
innodb_autoinc_lock_mode_func....
649
B
-rw-r--r--
innodb_background_drop_list_em...
225
B
-rw-r--r--
innodb_buf_flush_list_now_basi...
800
B
-rw-r--r--
innodb_buffer_pool_chunk_size_...
1.76
KB
-rw-r--r--
innodb_buffer_pool_dump_at_shu...
709
B
-rw-r--r--
innodb_buffer_pool_dump_now_ba...
201
B
-rw-r--r--
innodb_buffer_pool_dump_pct_ba...
1.26
KB
-rw-r--r--
innodb_buffer_pool_evict_basic...
208
B
-rw-r--r--
innodb_buffer_pool_filename_ba...
414
B
-rw-r--r--
innodb_buffer_pool_instances_b...
2.05
KB
-rw-r--r--
innodb_buffer_pool_load_abort_...
209
B
-rw-r--r--
innodb_buffer_pool_load_at_sta...
350
B
-rw-r--r--
innodb_buffer_pool_load_now_ba...
392
B
-rw-r--r--
innodb_buffer_pool_size_basic....
1.96
KB
-rw-r--r--
innodb_change_buffer_max_size_...
3.29
KB
-rw-r--r--
innodb_change_buffering_basic....
2.92
KB
-rw-r--r--
innodb_change_buffering_debug_...
2.83
KB
-rw-r--r--
innodb_checksum_algorithm_basi...
1.66
KB
-rw-r--r--
innodb_checksums_basic.result
1.77
KB
-rw-r--r--
innodb_cmp_per_index_enabled_b...
1.92
KB
-rw-r--r--
innodb_commit_concurrency_basi...
3.35
KB
-rw-r--r--
innodb_compress_debug_basic.re...
3.13
KB
-rw-r--r--
innodb_compression_failure_thr...
5.16
KB
-rw-r--r--
innodb_compression_level_basic...
2.85
KB
-rw-r--r--
innodb_compression_pad_pct_max...
4.05
KB
-rw-r--r--
innodb_concurrency_tickets_bas...
5.09
KB
-rw-r--r--
innodb_data_file_path_basic.re...
1.87
KB
-rw-r--r--
innodb_data_home_dir_basic.res...
1.84
KB
-rw-r--r--
innodb_deadlock_detect_basic.r...
2.08
KB
-rw-r--r--
innodb_default_row_format_basi...
1.77
KB
-rw-r--r--
innodb_dict_stats_disabled_deb...
1.43
KB
-rw-r--r--
innodb_disable_background_merg...
76
B
-rw-r--r--
innodb_disable_resize_buffer_p...
2.55
KB
-rw-r--r--
innodb_disable_sort_file_cache...
4.4
KB
-rw-r--r--
innodb_doublewrite_basic.resul...
1.82
KB
-rw-r--r--
innodb_doublewrite_batch_size_...
1.12
KB
-rw-r--r--
innodb_fast_shutdown_basic.res...
5.3
KB
-rw-r--r--
innodb_fil_make_page_dirty_deb...
1.01
KB
-rw-r--r--
innodb_file_format_basic.resul...
3
KB
-rw-r--r--
innodb_file_format_check_basic...
3.12
KB
-rw-r--r--
innodb_file_format_max_basic.r...
3.18
KB
-rw-r--r--
innodb_file_io_threads_basic.r...
3.5
KB
-rw-r--r--
innodb_file_per_table_basic.re...
2.3
KB
-rw-r--r--
innodb_fill_factor_basic.resul...
1.23
KB
-rw-r--r--
innodb_flush_log_at_timeout_ba...
4.26
KB
-rw-r--r--
innodb_flush_log_at_trx_commit...
4.68
KB
-rw-r--r--
innodb_flush_method_basic.resu...
1.82
KB
-rw-r--r--
innodb_flush_neighbors_basic.r...
4.13
KB
-rw-r--r--
innodb_flush_sync_basic.result
3.56
KB
-rw-r--r--
innodb_flushing_avg_loops_basi...
4
KB
-rw-r--r--
innodb_force_load_corrupted_ba...
2.06
KB
-rw-r--r--
innodb_force_recovery_basic.re...
1.87
KB
-rw-r--r--
innodb_force_recovery_crash_ba...
1.5
KB
-rw-r--r--
innodb_ft_aux_table_basic.resu...
1.4
KB
-rw-r--r--
innodb_ft_cache_size_basic.res...
896
B
-rw-r--r--
innodb_ft_enable_diag_print_ba...
4.21
KB
-rw-r--r--
innodb_ft_enable_stopword_basi...
5.03
KB
-rw-r--r--
innodb_ft_max_token_size_basic...
935
B
-rw-r--r--
innodb_ft_min_token_size_basic...
930
B
-rw-r--r--
innodb_ft_num_word_optimize_ba...
2.45
KB
-rw-r--r--
innodb_ft_result_cache_limit_b...
1.52
KB
-rw-r--r--
innodb_ft_server_stopword_tabl...
1.77
KB
-rw-r--r--
innodb_ft_sort_pll_degree_basi...
946
B
-rw-r--r--
innodb_ft_total_cache_size_bas...
1002
B
-rw-r--r--
innodb_ft_user_stopword_table_...
1.5
KB
-rw-r--r--
innodb_io_capacity_basic.resul...
3.27
KB
-rw-r--r--
innodb_io_capacity_max_basic.r...
3.53
KB
-rw-r--r--
innodb_large_prefix_basic.resu...
4.58
KB
-rw-r--r--
innodb_limit_optimistic_insert...
3.01
KB
-rw-r--r--
innodb_lock_wait_timeout_basic...
5.55
KB
-rw-r--r--
innodb_locks_unsafe_for_binlog...
2.14
KB
-rw-r--r--
innodb_log_buffer_size_basic.r...
1.89
KB
-rw-r--r--
innodb_log_checkpoint_now_basi...
3.54
KB
-rw-r--r--
innodb_log_checksums_basic.res...
1.35
KB
-rw-r--r--
innodb_log_compressed_pages_ba...
2.53
KB
-rw-r--r--
innodb_log_file_size_basic.res...
1.84
KB
-rw-r--r--
innodb_log_files_in_group_basi...
1.97
KB
-rw-r--r--
innodb_log_group_home_dir_basi...
1.97
KB
-rw-r--r--
innodb_log_write_ahead_size_ba...
3.53
KB
-rw-r--r--
innodb_lru_scan_depth_basic.re...
2.64
KB
-rw-r--r--
innodb_master_thread_disabled_...
1.5
KB
-rw-r--r--
innodb_max_dirty_pages_pct_bas...
6.68
KB
-rw-r--r--
innodb_max_dirty_pages_pct_fun...
2.62
KB
-rw-r--r--
innodb_max_dirty_pages_pct_lwm...
5.41
KB
-rw-r--r--
innodb_max_purge_lag_basic.res...
4.35
KB
-rw-r--r--
innodb_max_purge_lag_delay_bas...
1.63
KB
-rw-r--r--
innodb_max_undo_log_size_basic...
1.91
KB
-rw-r--r--
innodb_merge_threshold_set_all...
1.1
KB
-rw-r--r--
innodb_monitor_disable_basic.r...
21.78
KB
-rw-r--r--
innodb_monitor_enable_basic.re...
21.78
KB
-rw-r--r--
innodb_monitor_reset_all_basic...
21.78
KB
-rw-r--r--
innodb_monitor_reset_basic.res...
21.78
KB
-rw-r--r--
innodb_numa_interleave_basic.r...
369
B
-rw-r--r--
innodb_old_blocks_pct_basic.re...
3.41
KB
-rw-r--r--
innodb_old_blocks_time_basic.r...
2.24
KB
-rw-r--r--
innodb_online_alter_log_max_si...
3.19
KB
-rw-r--r--
innodb_open_files_basic.result
1.76
KB
-rw-r--r--
innodb_optimize_fulltext_only_...
4.34
KB
-rw-r--r--
innodb_page_cleaner_disabled_d...
1.47
KB
-rw-r--r--
innodb_page_cleaners_basic.res...
1.42
KB
-rw-r--r--
innodb_page_hash_locks_basic.r...
1022
B
-rw-r--r--
innodb_page_size_basic.result
275
B
-rw-r--r--
innodb_print_all_deadlocks_bas...
4.16
KB
-rw-r--r--
innodb_purge_batch_size_basic....
4.16
KB
-rw-r--r--
innodb_purge_rseg_truncate_fre...
4.96
KB
-rw-r--r--
innodb_purge_run_now_basic.res...
731
B
-rw-r--r--
innodb_purge_stop_now_basic.re...
731
B
-rw-r--r--
innodb_purge_threads_basic.res...
1.42
KB
-rw-r--r--
innodb_random_read_ahead_basic...
4.02
KB
-rw-r--r--
innodb_read_ahead_threshold_ba...
3.59
KB
-rw-r--r--
innodb_read_io_threads_basic.r...
898
B
-rw-r--r--
innodb_read_only_basic.result
842
B
-rw-r--r--
innodb_replication_delay_basic...
3.95
KB
-rw-r--r--
innodb_rollback_on_timeout_bas...
2.03
KB
-rw-r--r--
innodb_rollback_segments_basic...
2.41
KB
-rw-r--r--
innodb_saved_page_number_debug...
1.01
KB
-rw-r--r--
innodb_semaphore_wait_timeout_...
1.48
KB
-rw-r--r--
innodb_sort_buffer_size_basic....
944
B
-rw-r--r--
innodb_spin_wait_delay_basic.r...
3.81
KB
-rw-r--r--
innodb_stats_auto_recalc_basic...
776
B
-rw-r--r--
innodb_stats_include_delete_ma...
1.06
KB
-rw-r--r--
innodb_stats_method_basic.resu...
3.27
KB
-rw-r--r--
innodb_stats_on_metadata_basic...
4.02
KB
-rw-r--r--
innodb_stats_persistent_basic....
757
B
-rw-r--r--
innodb_stats_persistent_sample...
3.78
KB
-rw-r--r--
innodb_stats_sample_pages_basi...
3.53
KB
-rw-r--r--
innodb_stats_transient_sample_...
3
KB
-rw-r--r--
innodb_status_output_basic.res...
4.16
KB
-rw-r--r--
innodb_status_output_locks_bas...
4.58
KB
-rw-r--r--
innodb_strict_mode_basic.resul...
4.43
KB
-rw-r--r--
innodb_support_xa_basic.result
9.24
KB
-rw-r--r--
innodb_support_xa_func.result
2.99
KB
-rw-r--r--
innodb_sync_array_size_basic.r...
1.1
KB
-rw-r--r--
innodb_sync_debug_basic.result
267
B
-rw-r--r--
innodb_sync_spin_loops_basic.r...
4.53
KB
-rw-r--r--
innodb_table_locks_basic.resul...
5.8
KB
-rw-r--r--
innodb_table_locks_func.result
1.01
KB
-rw-r--r--
innodb_temp_data_file_path_bas...
2
KB
-rw-r--r--
innodb_thread_concurrency_basi...
4.12
KB
-rw-r--r--
innodb_thread_sleep_delay_basi...
3.54
KB
-rw-r--r--
innodb_tmpdir_basic.result
1.6
KB
-rw-r--r--
innodb_trx_purge_view_update_o...
3.43
KB
-rw-r--r--
innodb_trx_rseg_n_slots_debug_...
3.03
KB
-rw-r--r--
innodb_undo_directory_basic.re...
1.56
KB
-rw-r--r--
innodb_undo_log_truncate_basic...
2.42
KB
-rw-r--r--
innodb_undo_logs_basic.result
3.09
KB
-rw-r--r--
innodb_undo_tablespaces_basic....
1.17
KB
-rw-r--r--
innodb_use_native_aio_basic.re...
1.9
KB
-rw-r--r--
innodb_version_basic.result
854
B
-rw-r--r--
innodb_write_io_threads_basic....
914
B
-rw-r--r--
insert_id_basic.result
4.08
KB
-rw-r--r--
insert_id_func.result
1.75
KB
-rw-r--r--
interactive_timeout_basic.resu...
6.33
KB
-rw-r--r--
interactive_timeout_func.resul...
929
B
-rw-r--r--
internal_tmp_disk_storage_engi...
2.48
KB
-rw-r--r--
join_buffer_size_basic_32.resu...
5.87
KB
-rw-r--r--
join_buffer_size_basic_64.resu...
5.87
KB
-rw-r--r--
keep_files_on_create_basic.res...
6.38
KB
-rw-r--r--
key_buffer_size_basic.result
3.62
KB
-rw-r--r--
key_buffer_size_func.result
2.19
KB
-rw-r--r--
key_cache_age_threshold_basic_...
5.36
KB
-rw-r--r--
key_cache_age_threshold_basic_...
5.36
KB
-rw-r--r--
key_cache_block_size_basic.res...
5.68
KB
-rw-r--r--
key_cache_division_limit_basic...
5.65
KB
-rw-r--r--
large_files_support_basic.resu...
854
B
-rw-r--r--
large_page_size_basic.result
794
B
-rw-r--r--
large_pages_basic.result
730
B
-rw-r--r--
last_insert_id_basic.result
1.52
KB
-rw-r--r--
last_insert_id_func.result
2.52
KB
-rw-r--r--
lc_messages_basic.result
1.5
KB
-rw-r--r--
lc_messages_dir_basic.result
856
B
-rw-r--r--
lc_time_names_basic.result
27.38
KB
-rw-r--r--
lc_time_names_func.result
2.8
KB
-rw-r--r--
license_basic.result
1.5
KB
-rw-r--r--
local_infile_basic.result
3.84
KB
-rw-r--r--
local_infile_func.result
1.03
KB
-rw-r--r--
lock_wait_timeout_basic.result
7.55
KB
-rw-r--r--
locked_in_memory_basic.result
810
B
-rw-r--r--
log_bin_basename_basic.result
837
B
-rw-r--r--
log_bin_basic.result
666
B
-rw-r--r--
log_bin_index_basic.result
789
B
-rw-r--r--
log_bin_trust_function_creator...
4.8
KB
-rw-r--r--
log_bin_trust_function_creator...
2.45
KB
-rw-r--r--
log_bin_use_v1_row_events_basi...
2.42
KB
-rw-r--r--
log_builtin_as_identified_by_p...
1.22
KB
-rw-r--r--
log_error_basic.result
715
B
-rw-r--r--
log_error_func.result
249
B
-rw-r--r--
log_error_func2.result
203
B
-rw-r--r--
log_error_func3.result
118
B
-rw-r--r--
log_error_verbosity_basic.resu...
719
B
-rw-r--r--
log_output_basic.result
4.5
KB
-rw-r--r--
log_output_func.result
1.6
KB
-rw-r--r--
log_queries_not_using_indexes_...
3.81
KB
-rw-r--r--
log_slave_updates_basic.result
826
B
-rw-r--r--
log_slow_admin_statements_basi...
3.56
KB
-rw-r--r--
log_slow_admin_statements_func...
2.68
KB
-rw-r--r--
log_slow_slave_statements_basi...
3.56
KB
-rw-r--r--
log_statements_unsafe_for_binl...
3.99
KB
-rw-r--r--
log_syslog_basic.result
946
B
-rw-r--r--
log_syslog_facility_basic.resu...
1.62
KB
-rw-r--r--
log_syslog_include_pid_basic.r...
1.24
KB
-rw-r--r--
log_syslog_tag_basic.result
963
B
-rw-r--r--
log_throttle_qni_basic.result
1.84
KB
-rw-r--r--
log_timestamps_basic.result
742
B
-rw-r--r--
log_warnings_basic_32.result
6.83
KB
-rw-r--r--
log_warnings_basic_64.result
6.83
KB
-rw-r--r--
long_query_time_basic.result
5.61
KB
-rw-r--r--
low_priority_updates_basic.res...
6.33
KB
-rw-r--r--
lower_case_file_system_basic.r...
957
B
-rw-r--r--
lower_case_table_names_basic.r...
890
B
-rw-r--r--
master_info_repository_basic.r...
1.61
KB
-rw-r--r--
master_verify_checksum_basic.r...
588
B
-rw-r--r--
max_allowed_packet_basic.resul...
8.83
KB
-rw-r--r--
max_allowed_packet_func.result
2.93
KB
-rw-r--r--
max_binlog_cache_size_basic.re...
6.66
KB
-rw-r--r--
max_binlog_cache_size_func.res...
2.14
MB
-rw-r--r--
max_binlog_size_basic.result
5.37
KB
-rw-r--r--
max_binlog_stmt_cache_size_bas...
7.06
KB
-rw-r--r--
max_connect_errors_basic_32.re...
4.99
KB
-rw-r--r--
max_connect_errors_basic_64.re...
4.83
KB
-rw-r--r--
max_connections_basic.result
4.83
KB
-rw-r--r--
max_delayed_threads_basic.resu...
14.3
KB
-rw-r--r--
max_digest_length_basic.result
828
B
-rw-r--r--
max_error_count_basic.result
5.94
KB
-rw-r--r--
max_execution_time_basic.resul...
7.88
KB
-rw-r--r--
max_heap_table_size_basic.resu...
8.05
KB
-rw-r--r--
max_insert_delayed_threads_bas...
14.79
KB
-rw-r--r--
max_join_size_basic.result
4.04
KB
-rw-r--r--
max_join_size_func.result
2.24
KB
-rw-r--r--
max_length_for_sort_data_basic...
8.2
KB
-rw-r--r--
max_points_in_geometry_basic.r...
4.24
KB
-rw-r--r--
max_prepared_stmt_count_basic....
5.56
KB
-rw-r--r--
max_prepared_stmt_count_func.r...
3.5
KB
-rw-r--r--
max_relay_log_size_basic.resul...
5.57
KB
-rw-r--r--
max_seeks_for_key_basic_32.res...
5.92
KB
-rw-r--r--
max_seeks_for_key_basic_64.res...
5.82
KB
-rw-r--r--
max_seeks_for_key_func.result
4.61
KB
-rw-r--r--
max_sort_length_basic.result
6.85
KB
-rw-r--r--
max_sort_length_func.result
9.32
KB
-rw-r--r--
max_sp_recursion_depth_basic.r...
7.6
KB
-rw-r--r--
max_sp_recursion_depth_func.re...
2.79
KB
-rw-r--r--
max_tmp_tables_basic_32.result
12.86
KB
-rw-r--r--
max_tmp_tables_basic_64.result
12.54
KB
-rw-r--r--
max_user_connections_basic.res...
4.36
KB
-rw-r--r--
max_user_connections_func.resu...
845
B
-rw-r--r--
max_write_lock_count_basic_32....
3.82
KB
-rw-r--r--
max_write_lock_count_basic_64....
3.69
KB
-rw-r--r--
maximum_basic.result
552
B
-rw-r--r--
metadata_locks_cache_size_basi...
934
B
-rw-r--r--
metadata_locks_hash_instances_...
3.3
KB
-rw-r--r--
min_examined_row_limit_basic_3...
6.59
KB
-rw-r--r--
min_examined_row_limit_basic_6...
6.34
KB
-rw-r--r--
multi_range_count_basic_32.res...
13.28
KB
-rw-r--r--
multi_range_count_basic_64.res...
13.01
KB
-rw-r--r--
myisam_data_pointer_size_basic...
5.19
KB
-rw-r--r--
myisam_data_pointer_size_func....
1.28
KB
-rw-r--r--
myisam_max_sort_file_size_basi...
5.39
KB
-rw-r--r--
myisam_max_sort_file_size_basi...
5.42
KB
-rw-r--r--
myisam_mmap_size_basic.result
897
B
-rw-r--r--
myisam_recover_options_basic.r...
908
B
-rw-r--r--
myisam_sort_buffer_size_basic_...
7.59
KB
-rw-r--r--
myisam_sort_buffer_size_basic_...
7.51
KB
-rw-r--r--
myisam_stats_method_basic.resu...
5.4
KB
-rw-r--r--
myisam_stats_method_func.resul...
3.16
KB
-rw-r--r--
myisam_use_mmap_basic.result
1.72
KB
-rw-r--r--
mysql_native_password_proxy_us...
5.57
KB
-rw-r--r--
mysql_native_password_proxy_us...
1.68
KB
-rw-r--r--
mysql_native_password_proxy_us...
12.94
KB
-rw-r--r--
mysql_native_password_proxy_us...
2.56
KB
-rw-r--r--
named_pipe_basic.result
714
B
-rw-r--r--
named_pipe_full_access_group_b...
1.14
KB
-rw-r--r--
net_buffer_length_basic.result
5.06
KB
-rw-r--r--
net_read_timeout_basic.result
5.61
KB
-rw-r--r--
net_retry_count_basic_32.resul...
5.98
KB
-rw-r--r--
net_retry_count_basic_64.resul...
5.67
KB
-rw-r--r--
net_write_timeout_basic.result
5.73
KB
-rw-r--r--
new_basic.result
4.33
KB
-rw-r--r--
ngram_token_size_basic.result
1.57
KB
-rw-r--r--
offline_mode_basic.result
1.5
KB
-rw-r--r--
old_alter_table_basic.result
1.88
KB
-rw-r--r--
old_basic.result
602
B
-rw-r--r--
old_passwords_basic.result
5.88
KB
-rw-r--r--
old_passwords_func.result
1.26
KB
-rw-r--r--
open_files_limit_basic.result
802
B
-rw-r--r--
optimizer_prune_level_basic.re...
6.77
KB
-rw-r--r--
optimizer_search_depth_basic.r...
6.7
KB
-rw-r--r--
optimizer_switch_basic.result
9.59
KB
-rw-r--r--
optimizer_trace_basic.result
1.81
KB
-rw-r--r--
optimizer_trace_features_basic...
2.79
KB
-rw-r--r--
optimizer_trace_limit_basic.re...
1.97
KB
-rw-r--r--
optimizer_trace_max_mem_size_b...
2.55
KB
-rw-r--r--
optimizer_trace_offset_basic.r...
2.42
KB
-rw-r--r--
optimizer_trace_offset_max.res...
1.01
KB
-rw-r--r--
parser_max_mem_size_32.result
3.13
KB
-rw-r--r--
parser_max_mem_size_64.result
3.14
KB
-rw-r--r--
parser_max_mem_size_basic_32.r...
3.03
KB
-rw-r--r--
parser_max_mem_size_basic_64.r...
3.03
KB
-rw-r--r--
performance_schema_basic.resul...
838
B
-rw-r--r--
pfs_accounts_size_basic.result
1.04
KB
-rw-r--r--
pfs_digests_size_basic.result
1.03
KB
-rw-r--r--
pfs_events_stages_h_size_basic...
1.24
KB
-rw-r--r--
pfs_events_stages_hl_size_basi...
1.33
KB
-rw-r--r--
pfs_events_statements_h_size_b...
1.3
KB
-rw-r--r--
pfs_events_statements_hl_size_...
1.4
KB
-rw-r--r--
pfs_events_transactions_h_size...
1.33
KB
-rw-r--r--
pfs_events_transactions_hl_siz...
1.43
KB
-rw-r--r--
pfs_events_waits_h_size_basic....
1.23
KB
-rw-r--r--
pfs_events_waits_hl_size_basic...
1.32
KB
-rw-r--r--
pfs_hosts_size_basic.result
1020
B
-rw-r--r--
pfs_max_cond_classes_basic.res...
1.09
KB
-rw-r--r--
pfs_max_cond_instances_basic.r...
1.12
KB
-rw-r--r--
pfs_max_digest_length_basic.re...
1.07
KB
-rw-r--r--
pfs_max_file_classes_basic.res...
1.09
KB
-rw-r--r--
pfs_max_file_handles_basic.res...
1.09
KB
-rw-r--r--
pfs_max_file_instances_basic.r...
1.12
KB
-rw-r--r--
pfs_max_index_stat_basic.resul...
1.06
KB
-rw-r--r--
pfs_max_memory_classes_basic.r...
1.12
KB
-rw-r--r--
pfs_max_metadata_locks_basic.r...
1.12
KB
-rw-r--r--
pfs_max_mutex_classes_basic.re...
1.11
KB
-rw-r--r--
pfs_max_mutex_instances_basic....
1.14
KB
-rw-r--r--
pfs_max_prepared_statements_in...
2.36
KB
-rw-r--r--
pfs_max_program_instances_basi...
2
KB
-rw-r--r--
pfs_max_rwlock_classes_basic.r...
1.12
KB
-rw-r--r--
pfs_max_rwlock_instances_basic...
1.15
KB
-rw-r--r--
pfs_max_socket_classes_basic.r...
1.12
KB
-rw-r--r--
pfs_max_socket_instances_basic...
1.15
KB
-rw-r--r--
pfs_max_sql_text_length_basic....
1.14
KB
-rw-r--r--
pfs_max_stage_classes_basic.re...
1.11
KB
-rw-r--r--
pfs_max_statement_classes_basi...
1.17
KB
-rw-r--r--
pfs_max_statement_stack_basic....
1.94
KB
-rw-r--r--
pfs_max_table_handles_basic.re...
1.11
KB
-rw-r--r--
pfs_max_table_instances_basic....
1.14
KB
-rw-r--r--
pfs_max_table_lock_stat_basic....
1.14
KB
-rw-r--r--
pfs_max_thread_classes_basic.r...
1.12
KB
-rw-r--r--
pfs_max_thread_instances_basic...
1.15
KB
-rw-r--r--
pfs_session_connect_attrs_size...
1.25
KB
-rw-r--r--
pfs_setup_actors_size_basic.re...
1.11
KB
-rw-r--r--
pfs_setup_objects_size_basic.r...
1.12
KB
-rw-r--r--
pfs_show_processlist_basic.res...
2.14
KB
-rw-r--r--
pfs_users_size_basic.result
1020
B
-rw-r--r--
pid_file_basic.result
834
B
-rw-r--r--
plugin_dir_basic.result
771
B
-rw-r--r--
port_basic.result
670
B
-rw-r--r--
preload_buffer_size_basic.resu...
6.61
KB
-rw-r--r--
profiling_basic.result
3.18
KB
-rw-r--r--
profiling_h_size_basic.result
3.52
KB
-rw-r--r--
protocol_version_basic.result
807
B
-rw-r--r--
proxy_user_basic.result
65
B
-rw-r--r--
pseudo_slave_mode_basic.result
5.96
KB
-rw-r--r--
pseudo_thread_id_basic.result
1.43
KB
-rw-r--r--
query_alloc_block_size_basic.r...
7.38
KB
-rw-r--r--
query_cache_limit_basic_32.res...
8.34
KB
-rw-r--r--
query_cache_limit_basic_64.res...
8.14
KB
-rw-r--r--
query_cache_limit_func.result
5
KB
-rw-r--r--
query_cache_min_res_unit_basic...
9.77
KB
-rw-r--r--
query_cache_min_res_unit_basic...
9.63
KB
-rw-r--r--
query_cache_size_basic_32.resu...
5.02
KB
-rw-r--r--
query_cache_size_basic_64.resu...
5.02
KB
-rw-r--r--
query_cache_type_basic.result
8.5
KB
-rw-r--r--
query_cache_type_func.result
8.88
KB
-rw-r--r--
query_cache_wlock_invalidate_b...
12.35
KB
-rw-r--r--
query_cache_wlock_invalidate_f...
6.55
KB
-rw-r--r--
query_prealloc_size_basic.resu...
6.19
KB
-rw-r--r--
query_prealloc_size_func.resul...
1.06
KB
-rw-r--r--
rand_seed1_basic.result
1.19
KB
-rw-r--r--
rand_seed2_basic.result
1.19
KB
-rw-r--r--
range_alloc_block_size_basic.r...
6.99
KB
-rw-r--r--
range_optimizer_max_mem_size_b...
2.05
KB
-rw-r--r--
rbr_exec_mode_basic.result
1.69
KB
-rw-r--r--
read_buffer_size_basic.result
6.49
KB
-rw-r--r--
read_only_basic.result
3.78
KB
-rw-r--r--
read_only_func.result
1.59
KB
-rw-r--r--
read_rnd_buffer_size_basic.res...
6.12
KB
-rw-r--r--
relay_log_basename_basic.resul...
1.28
KB
-rw-r--r--
relay_log_basic.result
689
B
-rw-r--r--
relay_log_index_basic.result
1.23
KB
-rw-r--r--
relay_log_info_file_basic.resu...
915
B
-rw-r--r--
relay_log_info_repository_basi...
1.67
KB
-rw-r--r--
relay_log_purge_basic.result
3.89
KB
-rw-r--r--
relay_log_recovery_basic.resul...
1.07
KB
-rw-r--r--
relay_log_space_limit_basic.re...
882
B
-rw-r--r--
replication_optimize_for_stati...
1.96
KB
-rw-r--r--
replication_sender_observe_com...
1.29
KB
-rw-r--r--
report_host_basic.result
721
B
-rw-r--r--
report_password_basic.result
785
B
-rw-r--r--
report_port_basic.result
812
B
-rw-r--r--
report_user_basic.result
721
B
-rw-r--r--
require_secure_transport_basic...
5.02
KB
-rw-r--r--
require_secure_transport_windo...
348
B
-rw-r--r--
rpl_init_slave_func.result
1.7
KB
-rw-r--r--
rpl_max_binlog_size_func.resul...
329
B
-rw-r--r--
rpl_recovery_rank_basic_32.res...
5.78
KB
-rw-r--r--
rpl_recovery_rank_basic_64.res...
5.57
KB
-rw-r--r--
rpl_semi_sync_master_enabled_b...
3.41
KB
-rw-r--r--
rpl_semi_sync_master_timeout_b...
2.55
KB
-rw-r--r--
rpl_semi_sync_master_trace_lev...
3.53
KB
-rw-r--r--
rpl_semi_sync_master_wait_for_...
4.05
KB
-rw-r--r--
rpl_semi_sync_master_wait_no_s...
3.72
KB
-rw-r--r--
rpl_semi_sync_master_wait_poin...
2.86
KB
-rw-r--r--
rpl_semi_sync_slave_enabled_ba...
3.35
KB
-rw-r--r--
rpl_semi_sync_slave_trace_leve...
3.48
KB
-rw-r--r--
rpl_stop_slave_timeout_basic.r...
3.85
KB
-rw-r--r--
secure_auth_basic.result
4.41
KB
-rw-r--r--
secure_file_priv.result
295
B
-rw-r--r--
secure_file_priv2.result
346
B
-rw-r--r--
secure_file_priv_basic.result
882
B
-rw-r--r--
server_id_basic.result
3.63
KB
-rw-r--r--
server_id_bits_basic.result
3.78
KB
-rw-r--r--
server_uuid_basic.result
1.46
KB
-rw-r--r--
session_track_gtids_basic.resu...
1.86
KB
-rw-r--r--
session_track_schema_basic.res...
2.94
KB
-rw-r--r--
session_track_state_change_bas...
3.34
KB
-rw-r--r--
session_track_system_variables...
5.37
KB
-rw-r--r--
session_track_transaction_info...
2.58
KB
-rw-r--r--
sha256_password_auto_generate_...
25
B
-rw-r--r--
sha256_password_private_key_pa...
25
B
-rw-r--r--
sha256_password_proxy_users_ba...
5.07
KB
-rw-r--r--
sha256_password_proxy_users_cm...
1.56
KB
-rw-r--r--
sha256_password_proxy_users_fu...
12.91
KB
-rw-r--r--
sha256_password_proxy_users_lo...
2.52
KB
-rw-r--r--
sha256_password_public_key_pat...
25
B
-rw-r--r--
shared_memory_base_name_basic....
1.02
KB
-rw-r--r--
shared_memory_basic.result
762
B
-rw-r--r--
show_compatibility_56_basic.re...
1.66
KB
-rw-r--r--
show_create_table_verbosity_ba...
2.76
KB
-rw-r--r--
show_old_temporals_basic.resul...
4.79
KB
-rw-r--r--
skip_external_locking_basic.re...
886
B
-rw-r--r--
skip_name_resolve_basic.result
764
B
-rw-r--r--
skip_networking_basic.result
794
B
-rw-r--r--
skip_show_database_basic.resul...
842
B
-rw-r--r--
slave_allow_batching_basic.res...
5.54
KB
-rw-r--r--
slave_checkpoint_group_basic.r...
1.87
KB
-rw-r--r--
slave_checkpoint_period_basic....
1.9
KB
-rw-r--r--
slave_compressed_protocol_basi...
4.53
KB
-rw-r--r--
slave_exec_mode_basic.result
124
B
-rw-r--r--
slave_load_tmpdir_basic.result
923
B
-rw-r--r--
slave_max_allowed_packet_basic...
6.2
KB
-rw-r--r--
slave_net_timeout_basic.result
4.51
KB
-rw-r--r--
slave_parallel_type_basic.resu...
1.4
KB
-rw-r--r--
slave_parallel_workers_basic.r...
1.07
KB
-rw-r--r--
slave_pending_jobs_size_max_ba...
1.57
KB
-rw-r--r--
slave_preserve_commit_order_ba...
2.63
KB
-rw-r--r--
slave_rows_search_algorithms_b...
2.57
KB
-rw-r--r--
slave_skip_errors_basic.result
828
B
-rw-r--r--
slave_sql_verify_checksum_basi...
618
B
-rw-r--r--
slave_transaction_retries_basi...
4.87
KB
-rw-r--r--
slave_transaction_retries_basi...
4.69
KB
-rw-r--r--
slave_type_conversions_basic.r...
1010
B
-rw-r--r--
slow_launch_time_basic.result
4.66
KB
-rw-r--r--
slow_launch_time_func.result
679
B
-rw-r--r--
slow_query_log_basic.result
4.04
KB
-rw-r--r--
slow_query_log_file_basic.resu...
959
B
-rw-r--r--
slow_query_log_file_func.resul...
202
B
-rw-r--r--
slow_query_log_func.result
2.91
KB
-rw-r--r--
socket_basic.result
772
B
-rw-r--r--
sort_buffer_size_basic_32.resu...
4.78
KB
-rw-r--r--
sort_buffer_size_basic_64.resu...
4.78
KB
-rw-r--r--
sql_auto_is_null_basic.result
990
B
-rw-r--r--
sql_big_selects_basic.result
3.61
KB
-rw-r--r--
sql_big_selects_func.result
2.29
KB
-rw-r--r--
sql_buffer_result_basic.result
3.95
KB
-rw-r--r--
sql_buffer_result_func.result
1.92
KB
-rw-r--r--
sql_log_bin_basic.result
3.97
KB
-rw-r--r--
sql_log_off_basic.result
3.52
KB
-rw-r--r--
sql_log_off_func.result
1.61
KB
-rw-r--r--
sql_low_priority_updates_func....
2.91
KB
-rw-r--r--
sql_mode_basic.result
24.63
KB
-rw-r--r--
sql_mode_func.result
4.59
KB
-rw-r--r--
sql_notes_basic.result
3.38
KB
-rw-r--r--
sql_notes_func.result
1.57
KB
-rw-r--r--
sql_quote_show_create_basic.re...
4.23
KB
-rw-r--r--
sql_quote_show_create_func.res...
2.04
KB
-rw-r--r--
sql_safe_updates_basic.result
3.88
KB
-rw-r--r--
sql_safe_updates_func.result
3.89
KB
-rw-r--r--
sql_select_limit_basic.result
1.85
KB
-rw-r--r--
sql_select_limit_func.result
4.09
KB
-rw-r--r--
sql_slave_skip_counter_basic.r...
3.35
KB
-rw-r--r--
sql_warnings_basic.result
3.48
KB
-rw-r--r--
sql_warnings_func.result
1.38
KB
-rw-r--r--
ssl_ca_basic.result
1.47
KB
-rw-r--r--
ssl_capath_basic.result
1.58
KB
-rw-r--r--
ssl_cert_basic.result
1.52
KB
-rw-r--r--
ssl_cipher_basic.result
1.58
KB
-rw-r--r--
ssl_crl_basic.result
106
B
-rw-r--r--
ssl_crlpath_basic.result
114
B
-rw-r--r--
ssl_key_basic.result
1.5
KB
-rw-r--r--
stored_program_cache_basic.res...
2.25
KB
-rw-r--r--
super_read_only_basic.result
4.48
KB
-rw-r--r--
super_read_only_func.result
2.24
KB
-rw-r--r--
sync_binlog_basic.result
3.7
KB
-rw-r--r--
sync_frm_basic.result
5.54
KB
-rw-r--r--
sync_master_info_basic.result
1.65
KB
-rw-r--r--
sync_relay_log_basic.result
1.58
KB
-rw-r--r--
sync_relay_log_info_basic.resu...
1.75
KB
-rw-r--r--
system_time_zone_basic.result
1.73
KB
-rw-r--r--
table_definition_cache_basic.r...
4.76
KB
-rw-r--r--
table_open_cache_basic.result
4.26
KB
-rw-r--r--
table_open_cache_instances_bas...
2.35
KB
-rw-r--r--
thread_cache_size_basic.result
3.06
KB
-rw-r--r--
thread_cache_size_func.result
937
B
-rw-r--r--
thread_handling_basic.result
1.93
KB
-rw-r--r--
thread_stack_basic.result
763
B
-rw-r--r--
time_format_basic.result
851
B
-rw-r--r--
time_zone_basic.result
6.69
KB
-rw-r--r--
time_zone_func.result
4.9
KB
-rw-r--r--
timestamp_basic.result
2.42
KB
-rw-r--r--
timestamp_func.result
672
B
-rw-r--r--
timestamp_sysdate_is_now_func....
672
B
-rw-r--r--
tmp_table_size_basic.result
5.73
KB
-rw-r--r--
tmpdir_basic.result
1.47
KB
-rw-r--r--
transaction_alloc_block_size_b...
7.46
KB
-rw-r--r--
transaction_allow_batching_bas...
1.57
KB
-rw-r--r--
transaction_isolation_basic.re...
8.3
KB
-rw-r--r--
transaction_isolation_func.res...
6.93
KB
-rw-r--r--
transaction_prealloc_size_basi...
6.77
KB
-rw-r--r--
transaction_read_only_basic.re...
8.01
KB
-rw-r--r--
transaction_write_set_extracti...
6.37
KB
-rw-r--r--
tx_isolation_basic.result
11.55
KB
-rw-r--r--
tx_isolation_func.result
9.69
KB
-rw-r--r--
tx_read_only_basic.result
13.83
KB
-rw-r--r--
unique_checks_basic.result
3.06
KB
-rw-r--r--
updatable_views_with_limit_bas...
7.64
KB
-rw-r--r--
updatable_views_with_limit_fun...
2.17
KB
-rw-r--r--
version_basic.result
1.5
KB
-rw-r--r--
version_comment_basic.result
1.71
KB
-rw-r--r--
version_compile_machine_basic....
1.92
KB
-rw-r--r--
version_compile_os_basic.resul...
1.79
KB
-rw-r--r--
wait_timeout_basic.result
5.7
KB
-rw-r--r--
wait_timeout_func.result
1.13
KB
-rw-r--r--
warning_count_basic.result
1.62
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : sql_mode_basic.result
SET @global_start_value = @@global.sql_mode; SELECT @global_start_value; @global_start_value ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @session_start_value = @@session.sql_mode; SELECT @session_start_value; @session_start_value ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION '#--------------------FN_DYNVARS_152_01------------------------#' SET @@global.sql_mode = ANSI; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SET @@global.sql_mode = DEFAULT; SELECT @@global.sql_mode; @@global.sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @@session.sql_mode = ANSI; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SET @@session.sql_mode = DEFAULT; SELECT @@session.sql_mode; @@session.sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION '#---------------------FN_DYNVARS_152_02-------------------------#' SET @@global.sql_mode = NULL; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NULL' SET @@global.sql_mode = ''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode SET @@global.sql_mode = ' '; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode SET @@session.sql_mode = NULL; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NULL' SET @@session.sql_mode = ''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode SET @@session.sql_mode = ' '; SELECT @@session.sql_mode; @@session.sql_mode '#--------------------FN_DYNVARS_152_03------------------------#' SET @@global.sql_mode = ANSI; SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI SET @@global.sql_mode = STRICT_TRANS_TABLES; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@global.sql_mode; @@global.sql_mode STRICT_TRANS_TABLES SET @@global.sql_mode = TRADITIONAL; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @@global.sql_mode = ALLOW_INVALID_DATES; SELECT @@global.sql_mode; @@global.sql_mode ALLOW_INVALID_DATES SET @@global.sql_mode = ANSI_QUOTES; SELECT @@global.sql_mode; @@global.sql_mode ANSI_QUOTES SET @@global.sql_mode = ERROR_FOR_DIVISION_BY_ZERO; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@global.sql_mode; @@global.sql_mode ERROR_FOR_DIVISION_BY_ZERO SET @@global.sql_mode = HIGH_NOT_PRECEDENCE; SELECT @@global.sql_mode; @@global.sql_mode HIGH_NOT_PRECEDENCE SET @@global.sql_mode = IGNORE_SPACE; SELECT @@global.sql_mode; @@global.sql_mode IGNORE_SPACE SET @@global.sql_mode = NO_AUTO_CREATE_USER; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode NO_AUTO_CREATE_USER SET @@global.sql_mode = NO_AUTO_VALUE_ON_ZERO; SELECT @@global.sql_mode; @@global.sql_mode NO_AUTO_VALUE_ON_ZERO SET @@global.sql_mode = NO_BACKSLASH_ESCAPES; SELECT @@global.sql_mode; @@global.sql_mode NO_BACKSLASH_ESCAPES SET @@global.sql_mode = NO_DIR_IN_CREATE; SELECT @@global.sql_mode; @@global.sql_mode NO_DIR_IN_CREATE SET @@global.sql_mode = NO_ENGINE_SUBSTITUTION; SELECT @@global.sql_mode; @@global.sql_mode NO_ENGINE_SUBSTITUTION SET @@global.sql_mode = NO_FIELD_OPTIONS; Warnings: Warning 3090 Changing sql mode 'NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode NO_FIELD_OPTIONS SET @@global.sql_mode = NO_KEY_OPTIONS; Warnings: Warning 3090 Changing sql mode 'NO_KEY_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode NO_KEY_OPTIONS SET @@global.sql_mode = NO_TABLE_OPTIONS; Warnings: Warning 3090 Changing sql mode 'NO_TABLE_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode NO_TABLE_OPTIONS SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION; SELECT @@global.sql_mode; @@global.sql_mode NO_UNSIGNED_SUBTRACTION SET @@global.sql_mode = NO_ZERO_DATE; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@global.sql_mode; @@global.sql_mode NO_ZERO_DATE SET @@global.sql_mode = NO_ZERO_IN_DATE; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@global.sql_mode; @@global.sql_mode NO_ZERO_IN_DATE SET @@global.sql_mode = ONLY_FULL_GROUP_BY; SELECT @@global.sql_mode; @@global.sql_mode ONLY_FULL_GROUP_BY SET @@global.sql_mode = PIPES_AS_CONCAT; SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT SET @@global.sql_mode = REAL_AS_FLOAT; SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT SET @@global.sql_mode = STRICT_ALL_TABLES; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@global.sql_mode; @@global.sql_mode STRICT_ALL_TABLES SET @@global.sql_mode = STRICT_TRANS_TABLES; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@global.sql_mode; @@global.sql_mode STRICT_TRANS_TABLES SET @@global.sql_mode = DB2; Warnings: Warning 3090 Changing sql mode 'DB2,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,DB2,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS SET @@global.sql_mode = MAXDB; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning 3090 Changing sql mode 'MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER SET @@global.sql_mode = MSSQL; Warnings: Warning 3090 Changing sql mode 'MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS SET @@global.sql_mode = MYSQL323; Warnings: Warning 3090 Changing sql mode 'MYSQL323' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode MYSQL323,HIGH_NOT_PRECEDENCE SET @@global.sql_mode = MYSQL40; Warnings: Warning 3090 Changing sql mode 'MYSQL40' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode MYSQL40,HIGH_NOT_PRECEDENCE SET @@global.sql_mode = ORACLE; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning 3090 Changing sql mode 'ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER SET @@global.sql_mode = POSTGRESQL; Warnings: Warning 3090 Changing sql mode 'POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS SET @@global.sql_mode = TRADITIONAL; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @@global.sql_mode = OFF; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OFF' SET @@session.sql_mode = ANSI; SELECT @@session.sql_mode; @@session.sql_mode REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI SET @@session.sql_mode = STRICT_TRANS_TABLES; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@session.sql_mode; @@session.sql_mode STRICT_TRANS_TABLES SET @@session.sql_mode = TRADITIONAL; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @@session.sql_mode = ALLOW_INVALID_DATES; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode ALLOW_INVALID_DATES SET @@session.sql_mode = ANSI_QUOTES; SELECT @@session.sql_mode; @@session.sql_mode ANSI_QUOTES SET @@session.sql_mode = ERROR_FOR_DIVISION_BY_ZERO; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@session.sql_mode; @@session.sql_mode ERROR_FOR_DIVISION_BY_ZERO SET @@session.sql_mode = HIGH_NOT_PRECEDENCE; SELECT @@session.sql_mode; @@session.sql_mode HIGH_NOT_PRECEDENCE SET @@session.sql_mode = IGNORE_SPACE; SELECT @@session.sql_mode; @@session.sql_mode IGNORE_SPACE SET @@session.sql_mode = NO_AUTO_CREATE_USER; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode NO_AUTO_CREATE_USER SET @@session.sql_mode = NO_AUTO_VALUE_ON_ZERO; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode NO_AUTO_VALUE_ON_ZERO SET @@session.sql_mode = NO_BACKSLASH_ESCAPES; SELECT @@session.sql_mode; @@session.sql_mode NO_BACKSLASH_ESCAPES SET @@session.sql_mode = NO_DIR_IN_CREATE; SELECT @@session.sql_mode; @@session.sql_mode NO_DIR_IN_CREATE SET @@session.sql_mode = NO_ENGINE_SUBSTITUTION; SELECT @@session.sql_mode; @@session.sql_mode NO_ENGINE_SUBSTITUTION SET @@session.sql_mode = NO_FIELD_OPTIONS; Warnings: Warning 3090 Changing sql mode 'NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode NO_FIELD_OPTIONS SET @@session.sql_mode = NO_KEY_OPTIONS; Warnings: Warning 3090 Changing sql mode 'NO_KEY_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode NO_KEY_OPTIONS SET @@session.sql_mode = NO_TABLE_OPTIONS; Warnings: Warning 3090 Changing sql mode 'NO_TABLE_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode NO_TABLE_OPTIONS SET @@session.sql_mode = NO_UNSIGNED_SUBTRACTION; SELECT @@session.sql_mode; @@session.sql_mode NO_UNSIGNED_SUBTRACTION SET @@session.sql_mode = NO_ZERO_DATE; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@session.sql_mode; @@session.sql_mode NO_ZERO_DATE SET @@session.sql_mode = NO_ZERO_IN_DATE; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@session.sql_mode; @@session.sql_mode NO_ZERO_IN_DATE SET @@session.sql_mode = ONLY_FULL_GROUP_BY; SELECT @@session.sql_mode; @@session.sql_mode ONLY_FULL_GROUP_BY SET @@session.sql_mode = PIPES_AS_CONCAT; SELECT @@session.sql_mode; @@session.sql_mode PIPES_AS_CONCAT SET @@session.sql_mode = REAL_AS_FLOAT; SELECT @@session.sql_mode; @@session.sql_mode REAL_AS_FLOAT SET @@session.sql_mode = STRICT_ALL_TABLES; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@session.sql_mode; @@session.sql_mode STRICT_ALL_TABLES SET @@session.sql_mode = STRICT_TRANS_TABLES; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. SELECT @@session.sql_mode; @@session.sql_mode STRICT_TRANS_TABLES SET @@session.sql_mode = DB2; Warnings: Warning 3090 Changing sql mode 'DB2,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,DB2,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS SET @@session.sql_mode = MAXDB; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning 3090 Changing sql mode 'MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER SET @@session.sql_mode = MSSQL; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning 3090 Changing sql mode 'MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS SET @@session.sql_mode = MYSQL323; Warnings: Warning 3090 Changing sql mode 'MYSQL323' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode MYSQL323,HIGH_NOT_PRECEDENCE SET @@session.sql_mode = MYSQL40; Warnings: Warning 3090 Changing sql mode 'MYSQL40' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode MYSQL40,HIGH_NOT_PRECEDENCE SET @@session.sql_mode = ORACLE; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning 3090 Changing sql mode 'ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER SET @@session.sql_mode = POSTGRESQL; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning 3090 Changing sql mode 'POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS SET @@session.sql_mode = TRADITIONAL; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @@session.sql_mode = OFF; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OFF' SET @@global.sql_mode = '?'; ERROR 42000: Variable 'sql_mode' can't be set to the value of '?' SELECT @@global.sql_mode; @@global.sql_mode STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION '#--------------------FN_DYNVARS_152_04-------------------------#' SET @@global.sql_mode = -1; ERROR 42000: Variable 'sql_mode' can't be set to the value of '-1' SET @@global.sql_mode = ASCII; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ASCII' SET @@global.sql_mode = NON_TRADITIONAL; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NON_TRADITIONAL' SET @@global.sql_mode = 'OF'; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OF' SET @@global.sql_mode = NONE; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NONE' SET @@session.sql_mode = -1; ERROR 42000: Variable 'sql_mode' can't be set to the value of '-1' SET @@session.sql_mode = ANSI_SINGLE_QUOTES; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ANSI_SINGLE_QUOTES' SET @@session.sql_mode = 'ON'; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ON' SET @@session.sql_mode = 'OF'; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OF' SET @@session.sql_mode = DISABLE; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'DISABLE' '#-------------------FN_DYNVARS_152_05----------------------------#' SELECT @@session.sql_mode = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='sql_mode'; @@session.sql_mode = VARIABLE_VALUE 1 '#----------------------FN_DYNVARS_152_06------------------------#' SELECT @@global.sql_mode = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sql_mode'; @@global.sql_mode = VARIABLE_VALUE 1 '#---------------------FN_DYNVARS_152_07-------------------------#' SET @@global.sql_mode = 0; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode SET @@global.sql_mode = 1; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT SET @@global.sql_mode = 2; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT SET @@global.sql_mode = 3; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT,PIPES_AS_CONCAT SET @@global.sql_mode = 50000; Warnings: Warning 3090 Changing sql mode 'POSTGRESQL,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,,,NO_UNSIGNED_SUBTRACTION,POSTGRESQL,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER SET @@global.sql_mode = 500000; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning 3090 Changing sql mode 'POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,HIGH_NOT_PRECEDENCE SET @@global.sql_mode = 4294967295; Warnings: Warning 3090 Changing sql mode 'POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,,,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH SET @@global.sql_mode = 4294967296; ERROR 42000: Variable 'sql_mode' can't be set to the value of '4294967296' SET @@global.sql_mode = 0.4; ERROR 42000: Incorrect argument type to variable 'sql_mode' '#---------------------FN_DYNVARS_152_08----------------------#' SET @@global.sql_mode = TRUE; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT SET @@global.sql_mode = FALSE; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode '#---------------------FN_DYNVARS_152_09----------------------#' SET sql_mode = 'ANSI'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SET session.sql_mode = 'ANSI'; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.sql_mode = 'ANSI'' at line 1 SET global.sql_mode = 'ANSI'; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.sql_mode = 'ANSI'' at line 1 SET session sql_mode = 1; SELECT @@sql_mode; @@sql_mode REAL_AS_FLOAT SET global sql_mode = 0; SELECT @@global.sql_mode; @@global.sql_mode '#---------------------FN_DYNVARS_152_10----------------------#' SET @@session.sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES,ANSI_QUOTES'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode ANSI_QUOTES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @@global.sql_mode = 'ONLY_FULL_GROUP_BY,PIPES_AS_CONCAT,REAL_AS_FLOAT,ORACLE,POSTGRESQL'; Warnings: Warning 3090 Changing sql mode 'POSTGRESQL,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,POSTGRESQL,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER SET @@session.sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,FOOBAR,IGNORE_SPACE'; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'FOOBAR' SET @@sql_mode=','; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@sql_mode; @@sql_mode SET @@sql_mode=',,,,ANSI_QUOTES,,,'; SELECT @@sql_mode; @@sql_mode ANSI_QUOTES SET @@sql_mode=',,,,FOOBAR,,,,,'; ERROR 42000: Variable 'sql_mode' can't be set to the value of 'FOOBAR' SELECT @@sql_mode; @@sql_mode ANSI_QUOTES SET @@global.sql_mode = @global_start_value; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@global.sql_mode; @@global.sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET @@session.sql_mode = @session_start_value; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT @@session.sql_mode; @@session.sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Close