This is an automated email from the ASF dual-hosted git repository.
sunnianjun pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new b837a4717f1 Add DAL cases for MySQL system variable query (#25346)
b837a4717f1 is described below
commit b837a4717f1c285132324f0a358c52b992dc9471
Author: 吴伟杰 <[email protected]>
AuthorDate: Thu Apr 27 12:37:08 2023 +0800
Add DAL cases for MySQL system variable query (#25346)
* Add DAL case for MySQL system variable query
* Add DAL case for MySQL system variable query with aliases
---
.../test/e2e/engine/type/DALE2EIT.java | 2 +-
.../resources/cases/dal/dal-integration-show.xml | 6 +
.../select_aliased_system_variables_with_scope.xml | 464 +++++++++++++++++++++
.../cases/dal/dataset/select_system_variables.xml | 464 +++++++++++++++++++++
4 files changed, 935 insertions(+), 1 deletion(-)
diff --git
a/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/DALE2EIT.java
b/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/DALE2EIT.java
index 322ca224e41..c5440a6a13b 100644
---
a/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/DALE2EIT.java
+++
b/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/DALE2EIT.java
@@ -120,7 +120,7 @@ class DALE2EIT {
private void assertRow(final ResultSet actual, final ResultSetMetaData
actualMetaData, final DataSetRow expected) throws SQLException {
int columnIndex = 1;
- for (String each : expected.splitValues(",")) {
+ for (String each : expected.splitValues(", ")) {
String columnLabel = actualMetaData.getColumnLabel(columnIndex);
if (Types.DATE == actual.getMetaData().getColumnType(columnIndex))
{
assertDateValue(actual, columnIndex, columnLabel, each);
diff --git a/test/e2e/sql/src/test/resources/cases/dal/dal-integration-show.xml
b/test/e2e/sql/src/test/resources/cases/dal/dal-integration-show.xml
index f550610a5b6..3048ea3e7d1 100644
--- a/test/e2e/sql/src/test/resources/cases/dal/dal-integration-show.xml
+++ b/test/e2e/sql/src/test/resources/cases/dal/dal-integration-show.xml
@@ -20,4 +20,10 @@
<test-case sql="SHOW DATABASES" db-types="MySQL"
scenario-types="dbtbl_with_readwrite_splitting,readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting"
adapters="proxy">
<assertion expected-data-file="show_databases.xml" />
</test-case>
+ <test-case db-types="MySQL" scenario-types="passthrough" adapters="proxy"
sql="SELECT @@activate_all_roles_on_login, @@admin_address, @@admin_port,
@@admin_ssl_ca, @@admin_ssl_capath, @@admin_ssl_cert, @@admin_ssl_cipher,
@@admin_ssl_crl, @@admin_ssl_crlpath, @@admin_ssl_key,
@@admin_tls_ciphersuites, @@admin_tls_version, @@authentication_policy,
@@auto_generate_certs, @@auto_increment_increment, @@auto_increment_offset,
@@autocommit, @@automatic_sp_privileges, @@avoid_temporal_upgra [...]
+ <assertion expected-data-file="select_system_variables.xml" />
+ </test-case>
+ <test-case db-types="MySQL" scenario-types="passthrough" adapters="proxy"
sql="SELECT @@global.activate_all_roles_on_login AS
activate_all_roles_on_login, @@global.admin_address AS admin_address,
@@global.admin_port AS admin_port, @@global.admin_ssl_ca AS admin_ssl_ca,
@@global.admin_ssl_capath AS admin_ssl_capath, @@global.admin_ssl_cert AS
admin_ssl_cert, @@global.admin_ssl_cipher AS admin_ssl_cipher,
@@global.admin_ssl_crl AS admin_ssl_crl, @@global.admin_ssl_crlpath AS
admin_ssl_ [...]
+ <assertion
expected-data-file="select_aliased_system_variables_with_scope.xml" />
+ </test-case>
</integration-test-cases>
diff --git
a/test/e2e/sql/src/test/resources/cases/dal/dataset/select_aliased_system_variables_with_scope.xml
b/test/e2e/sql/src/test/resources/cases/dal/dataset/select_aliased_system_variables_with_scope.xml
new file mode 100644
index 00000000000..746ff65fc1b
--- /dev/null
+++
b/test/e2e/sql/src/test/resources/cases/dal/dataset/select_aliased_system_variables_with_scope.xml
@@ -0,0 +1,464 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="activate_all_roles_on_login" />
+ <column name="admin_address" />
+ <column name="admin_port" />
+ <column name="admin_ssl_ca" />
+ <column name="admin_ssl_capath" />
+ <column name="admin_ssl_cert" />
+ <column name="admin_ssl_cipher" />
+ <column name="admin_ssl_crl" />
+ <column name="admin_ssl_crlpath" />
+ <column name="admin_ssl_key" />
+ <column name="admin_tls_ciphersuites" />
+ <column name="admin_tls_version" />
+ <column name="authentication_policy" />
+ <column name="auto_generate_certs" />
+ <column name="auto_increment_increment" />
+ <column name="auto_increment_offset" />
+ <column name="autocommit" />
+ <column name="automatic_sp_privileges" />
+ <column name="avoid_temporal_upgrade" />
+ <column name="back_log" />
+ <column name="basedir" />
+ <column name="big_tables" />
+ <column name="bind_address" />
+ <column name="binlog_cache_size" />
+ <column name="binlog_direct_non_transactional_updates" />
+ <column name="binlog_encryption" />
+ <column name="binlog_expire_logs_auto_purge" />
+ <column name="binlog_expire_logs_seconds" />
+ <column name="binlog_group_commit_sync_delay" />
+ <column name="binlog_group_commit_sync_no_delay_count" />
+ <column name="binlog_gtid_simple_recovery" />
+ <column name="binlog_max_flush_queue_time" />
+ <column name="binlog_order_commits" />
+ <column name="binlog_rotate_encryption_master_key_at_startup" />
+ <column name="binlog_row_event_max_size" />
+ <column name="binlog_rows_query_log_events" />
+ <column name="binlog_stmt_cache_size" />
+ <column name="binlog_transaction_compression" />
+ <column name="binlog_transaction_compression_level_zstd" />
+ <column name="binlog_transaction_dependency_history_size" />
+ <column name="build_id" />
+ <column name="bulk_insert_buffer_size" />
+ <column name="character_set_client" />
+ <column name="character_set_connection" />
+ <column name="character_set_database" />
+ <column name="character_set_filesystem" />
+ <column name="character_set_results" />
+ <column name="character_set_server" />
+ <column name="character_set_system" />
+ <column name="character_sets_dir" />
+ <column name="check_proxy_users" />
+ <column name="collation_connection" />
+ <column name="collation_database" />
+ <column name="collation_server" />
+ <column name="connect_timeout" />
+ <column name="connection_memory_chunk_size" />
+ <column name="connection_memory_limit" />
+ <column name="core_file" />
+ <column name="create_admin_listener_thread" />
+ <column name="cte_max_recursion_depth" />
+ <column name="datadir" />
+ <column name="debug_sensitive_session_string" />
+ <column name="default_authentication_plugin" />
+ <column name="default_collation_for_utf8mb4" />
+ <column name="default_password_lifetime" />
+ <column name="default_storage_engine" />
+ <column name="default_table_encryption" />
+ <column name="default_tmp_storage_engine" />
+ <column name="default_week_format" />
+ <column name="delayed_insert_limit" />
+ <column name="delayed_insert_timeout" />
+ <column name="delayed_queue_size" />
+ <column name="disabled_storage_engines" />
+ <column name="disconnect_on_expired_password" />
+ <column name="div_precision_increment" />
+ <column name="end_markers_in_json" />
+ <column name="enforce_gtid_consistency" />
+ <column name="eq_range_index_dive_limit" />
+ <column name="error_count" />
+ <column name="expire_logs_days" />
+ <column name="explicit_defaults_for_timestamp" />
+ <column name="external_user" />
+ <column name="flush" />
+ <column name="flush_time" />
+ <column name="foreign_key_checks" />
+ <column name="ft_boolean_syntax" />
+ <column name="ft_max_word_len" />
+ <column name="ft_min_word_len" />
+ <column name="ft_query_expansion_limit" />
+ <column name="ft_stopword_file" />
+ <column name="general_log" />
+ <column name="general_log_file" />
+ <column name="generated_random_password_length" />
+ <column name="global_connection_memory_limit" />
+ <column name="global_connection_memory_tracking" />
+ <column name="group_concat_max_len" />
+ <column name="gtid_executed_compression_period" />
+ <column name="have_ssl" />
+ <column name="histogram_generation_max_mem_size" />
+ <column name="host_cache_size" />
+ <column name="hostname" />
+ <column name="identity" />
+ <column name="immediate_server_version" />
+ <column name="information_schema_stats_expiry" />
+ <column name="init_connect" />
+ <column name="init_file" />
+ <column name="init_replica" />
+ <column name="init_slave" />
+ <column name="insert_id" />
+ <column name="interactive_timeout" />
+ <column name="join_buffer_size" />
+ <column name="keep_files_on_create" />
+ <column name="keyring_operations" />
+ <column name="large_files_support" />
+ <column name="large_page_size" />
+ <column name="large_pages" />
+ <column name="last_insert_id" />
+ <column name="lc_messages" />
+ <column name="lc_messages_dir" />
+ <column name="lc_time_names" />
+ <column name="license" />
+ <column name="local_infile" />
+ <column name="lock_wait_timeout" />
+ <column name="locked_in_memory" />
+ <column name="log_bin" />
+ <column name="log_bin_basename" />
+ <column name="log_bin_index" />
+ <column name="log_bin_trust_function_creators" />
+ <column name="log_bin_use_v1_row_events" />
+ <column name="log_error" />
+ <column name="log_error_services" />
+ <column name="log_error_suppression_list" />
+ <column name="log_error_verbosity" />
+ <column name="log_queries_not_using_indexes" />
+ <column name="log_raw" />
+ <column name="log_replica_updates" />
+ <column name="log_slave_updates" />
+ <column name="log_slow_admin_statements" />
+ <column name="log_slow_extra" />
+ <column name="log_slow_replica_statements" />
+ <column name="log_slow_slave_statements" />
+ <column name="log_statements_unsafe_for_binlog" />
+ <column name="log_throttle_queries_not_using_indexes" />
+ <column name="long_query_time" />
+ <column name="low_priority_updates" />
+ <column name="lower_case_file_system" />
+ <column name="lower_case_table_names" />
+ <column name="mandatory_roles" />
+ <column name="master_verify_checksum" />
+ <column name="max_allowed_packet" />
+ <column name="max_binlog_cache_size" />
+ <column name="max_binlog_size" />
+ <column name="max_binlog_stmt_cache_size" />
+ <column name="max_connect_errors" />
+ <column name="max_connections" />
+ <column name="max_delayed_threads" />
+ <column name="max_digest_length" />
+ <column name="max_error_count" />
+ <column name="max_execution_time" />
+ <column name="max_heap_table_size" />
+ <column name="max_insert_delayed_threads" />
+ <column name="max_join_size" />
+ <column name="max_length_for_sort_data" />
+ <column name="max_points_in_geometry" />
+ <column name="max_prepared_stmt_count" />
+ <column name="max_relay_log_size" />
+ <column name="max_seeks_for_key" />
+ <column name="max_sort_length" />
+ <column name="max_sp_recursion_depth" />
+ <column name="max_user_connections" />
+ <column name="max_write_lock_count" />
+ <column name="min_examined_row_limit" />
+ <column name="mysql_native_password_proxy_users" />
+ <column name="net_buffer_length" />
+ <column name="net_read_timeout" />
+ <column name="net_retry_count" />
+ <column name="net_write_timeout" />
+ <column name="new" />
+ <column name="offline_mode" />
+ <column name="old" />
+ <column name="old_alter_table" />
+ <column name="open_files_limit" />
+ <column name="optimizer_max_subgraph_pairs" />
+ <column name="optimizer_prune_level" />
+ <column name="optimizer_search_depth" />
+ <column name="optimizer_trace_limit" />
+ <column name="optimizer_trace_max_mem_size" />
+ <column name="optimizer_trace_offset" />
+ <column name="original_commit_timestamp" />
+ <column name="original_server_version" />
+ <column name="parser_max_mem_size" />
+ <column name="partial_revokes" />
+ <column name="password_history" />
+ <column name="password_require_current" />
+ <column name="password_reuse_interval" />
+ <column name="performance_schema" />
+ <column name="performance_schema_accounts_size" />
+ <column name="performance_schema_digests_size" />
+ <column name="performance_schema_error_size" />
+ <column name="performance_schema_events_stages_history_long_size" />
+ <column name="performance_schema_events_stages_history_size" />
+ <column name="performance_schema_events_statements_history_long_size"
/>
+ <column name="performance_schema_events_statements_history_size" />
+ <column
name="performance_schema_events_transactions_history_long_size" />
+ <column name="performance_schema_events_transactions_history_size" />
+ <column name="performance_schema_events_waits_history_long_size" />
+ <column name="performance_schema_events_waits_history_size" />
+ <column name="performance_schema_hosts_size" />
+ <column name="performance_schema_max_cond_classes" />
+ <column name="performance_schema_max_cond_instances" />
+ <column name="performance_schema_max_digest_length" />
+ <column name="performance_schema_max_digest_sample_age" />
+ <column name="performance_schema_max_file_classes" />
+ <column name="performance_schema_max_file_handles" />
+ <column name="performance_schema_max_file_instances" />
+ <column name="performance_schema_max_index_stat" />
+ <column name="performance_schema_max_memory_classes" />
+ <column name="performance_schema_max_metadata_locks" />
+ <column name="performance_schema_max_mutex_classes" />
+ <column name="performance_schema_max_mutex_instances" />
+ <column name="performance_schema_max_prepared_statements_instances" />
+ <column name="performance_schema_max_program_instances" />
+ <column name="performance_schema_max_rwlock_classes" />
+ <column name="performance_schema_max_rwlock_instances" />
+ <column name="performance_schema_max_socket_classes" />
+ <column name="performance_schema_max_socket_instances" />
+ <column name="performance_schema_max_sql_text_length" />
+ <column name="performance_schema_max_stage_classes" />
+ <column name="performance_schema_max_statement_classes" />
+ <column name="performance_schema_max_statement_stack" />
+ <column name="performance_schema_max_table_handles" />
+ <column name="performance_schema_max_table_instances" />
+ <column name="performance_schema_max_table_lock_stat" />
+ <column name="performance_schema_max_thread_classes" />
+ <column name="performance_schema_max_thread_instances" />
+ <column name="performance_schema_session_connect_attrs_size" />
+ <column name="performance_schema_setup_actors_size" />
+ <column name="performance_schema_setup_objects_size" />
+ <column name="performance_schema_show_processlist" />
+ <column name="performance_schema_users_size" />
+ <column name="persist_only_admin_x509_subject" />
+ <column name="persist_sensitive_variables_in_plaintext" />
+ <column name="persisted_globals_load" />
+ <column name="pid_file" />
+ <column name="plugin_dir" />
+ <column name="port" />
+ <column name="preload_buffer_size" />
+ <column name="print_identified_with_as_hex" />
+ <column name="profiling" />
+ <column name="profiling_history_size" />
+ <column name="protocol_compression_algorithms" />
+ <column name="protocol_version" />
+ <column name="proxy_user" />
+ <column name="pseudo_replica_mode" />
+ <column name="pseudo_slave_mode" />
+ <column name="pseudo_thread_id" />
+ <column name="query_alloc_block_size" />
+ <column name="query_prealloc_size" />
+ <column name="rand_seed1" />
+ <column name="rand_seed2" />
+ <column name="range_alloc_block_size" />
+ <column name="range_optimizer_max_mem_size" />
+ <column name="read_buffer_size" />
+ <column name="read_only" />
+ <column name="read_rnd_buffer_size" />
+ <column name="regexp_stack_limit" />
+ <column name="regexp_time_limit" />
+ <column name="relay_log" />
+ <column name="relay_log_basename" />
+ <column name="relay_log_index" />
+ <column name="relay_log_info_file" />
+ <column name="relay_log_purge" />
+ <column name="relay_log_recovery" />
+ <column name="relay_log_space_limit" />
+ <column name="replica_allow_batching" />
+ <column name="replica_checkpoint_group" />
+ <column name="replica_checkpoint_period" />
+ <column name="replica_compressed_protocol" />
+ <column name="replica_load_tmpdir" />
+ <column name="replica_max_allowed_packet" />
+ <column name="replica_net_timeout" />
+ <column name="replica_parallel_workers" />
+ <column name="replica_pending_jobs_size_max" />
+ <column name="replica_preserve_commit_order" />
+ <column name="replica_skip_errors" />
+ <column name="replica_sql_verify_checksum" />
+ <column name="replica_transaction_retries" />
+ <column name="replication_optimize_for_static_plugin_config" />
+ <column name="replication_sender_observe_commit_only" />
+ <column name="report_host" />
+ <column name="report_password" />
+ <column name="report_port" />
+ <column name="report_user" />
+ <column name="require_row_format" />
+ <column name="require_secure_transport" />
+ <column name="rpl_read_size" />
+ <column name="rpl_stop_replica_timeout" />
+ <column name="rpl_stop_slave_timeout" />
+ <column name="schema_definition_cache" />
+ <column name="secondary_engine_cost_threshold" />
+ <column name="secure_file_priv" />
+ <column name="select_into_buffer_size" />
+ <column name="select_into_disk_sync" />
+ <column name="select_into_disk_sync_delay" />
+ <column name="server_id" />
+ <column name="server_id_bits" />
+ <column name="server_uuid" />
+ <column name="session_track_schema" />
+ <column name="session_track_state_change" />
+ <column name="session_track_system_variables" />
+ <column name="sha256_password_proxy_users" />
+ <column name="show_create_table_skip_secondary_engine" />
+ <column name="show_create_table_verbosity" />
+ <column name="show_gipk_in_create_table_and_information_schema" />
+ <column name="show_old_temporals" />
+ <column name="skip_external_locking" />
+ <column name="skip_name_resolve" />
+ <column name="skip_networking" />
+ <column name="skip_replica_start" />
+ <column name="skip_show_database" />
+ <column name="skip_slave_start" />
+ <column name="slave_allow_batching" />
+ <column name="slave_checkpoint_group" />
+ <column name="slave_checkpoint_period" />
+ <column name="slave_compressed_protocol" />
+ <column name="slave_exec_mode" />
+ <column name="slave_load_tmpdir" />
+ <column name="slave_max_allowed_packet" />
+ <column name="slave_net_timeout" />
+ <column name="slave_parallel_type" />
+ <column name="slave_parallel_workers" />
+ <column name="slave_pending_jobs_size_max" />
+ <column name="slave_preserve_commit_order" />
+ <column name="slave_rows_search_algorithms" />
+ <column name="slave_skip_errors" />
+ <column name="slave_sql_verify_checksum" />
+ <column name="slave_transaction_retries" />
+ <column name="slave_type_conversions" />
+ <column name="slow_launch_time" />
+ <column name="slow_query_log" />
+ <column name="slow_query_log_file" />
+ <column name="socket" />
+ <column name="sort_buffer_size" />
+ <column name="source_verify_checksum" />
+ <column name="sql_auto_is_null" />
+ <column name="sql_big_selects" />
+ <column name="sql_buffer_result" />
+ <column name="sql_generate_invisible_primary_key" />
+ <column name="sql_log_bin" />
+ <column name="sql_log_off" />
+ <column name="sql_mode" />
+ <column name="sql_notes" />
+ <column name="sql_quote_show_create" />
+ <column name="sql_replica_skip_counter" />
+ <column name="sql_require_primary_key" />
+ <column name="sql_safe_updates" />
+ <column name="sql_select_limit" />
+ <column name="sql_slave_skip_counter" />
+ <column name="sql_warnings" />
+ <column name="ssl_ca" />
+ <column name="ssl_capath" />
+ <column name="ssl_cert" />
+ <column name="ssl_cipher" />
+ <column name="ssl_crl" />
+ <column name="ssl_crlpath" />
+ <column name="ssl_fips_mode" />
+ <column name="ssl_key" />
+ <column name="ssl_session_cache_mode" />
+ <column name="ssl_session_cache_timeout" />
+ <column name="stored_program_cache" />
+ <column name="stored_program_definition_cache" />
+ <column name="super_read_only" />
+ <column name="sync_binlog" />
+ <column name="sync_master_info" />
+ <column name="sync_relay_log" />
+ <column name="sync_relay_log_info" />
+ <column name="sync_source_info" />
+ <column name="system_time_zone" />
+ <column name="table_definition_cache" />
+ <column name="table_encryption_privilege_check" />
+ <column name="table_open_cache" />
+ <column name="table_open_cache_instances" />
+ <column name="tablespace_definition_cache" />
+ <column name="temptable_max_mmap" />
+ <column name="temptable_max_ram" />
+ <column name="temptable_use_mmap" />
+ <column name="terminology_use_previous" />
+ <column name="thread_cache_size" />
+ <column name="thread_handling" />
+ <column name="thread_stack" />
+ <column name="time_zone" />
+ <column name="timestamp" />
+ <column name="tls_ciphersuites" />
+ <column name="tls_version" />
+ <column name="tmp_table_size" />
+ <column name="tmpdir" />
+ <column name="transaction_alloc_block_size" />
+ <column name="transaction_allow_batching" />
+ <column name="transaction_prealloc_size" />
+ <column name="transaction_write_set_extraction" />
+ <column name="unique_checks" />
+ <column name="updatable_views_with_limit" />
+ <column name="use_secondary_engine" />
+ <column name="version_comment" />
+ <column name="version_compile_machine" />
+ <column name="version_compile_os" />
+ <column name="version_compile_zlib" />
+ <column name="wait_timeout" />
+ <column name="warning_count" />
+ <column name="windowing_use_high_precision" />
+ <column name="xa_detach_on_prepare" />
+ <column name="date_format" />
+ <column name="datetime_format" />
+ <column name="have_crypt" />
+ <column name="ignore_builtin_innodb" />
+ <column name="ignore_db_dirs" />
+ <column name="internal_tmp_disk_storage_engine" />
+ <column name="log_builtin_as_identified_by_password" />
+ <column name="log_syslog" />
+ <column name="log_syslog_facility" />
+ <column name="log_syslog_include_pid" />
+ <column name="log_syslog_tag" />
+ <column name="log_warnings" />
+ <column name="max_tmp_tables" />
+ <column name="metadata_locks_cache_size" />
+ <column name="metadata_locks_hash_instances" />
+ <column name="multi_range_count" />
+ <column name="old_passwords" />
+ <column name="query_cache_limit" />
+ <column name="query_cache_min_res_unit" />
+ <column name="query_cache_size" />
+ <column name="query_cache_type" />
+ <column name="query_cache_wlock_invalidate" />
+ <column name="secure_auth" />
+ <column name="show_compatibility_56" />
+ <column name="sync_frm" />
+ <column name="time_format" />
+ <column name="binlogging_impossible_mode" />
+ <column name="simplified_binlog_gtid_recovery" />
+ <column name="storage_engine" />
+ <column name="thread_concurrency" />
+ <column name="timed_mutexes" />
+ </metadata>
+ <row values="0, , 33062, , , , , , , , , TLSv1.2,TLSv1.3, *,,, 1, 1, 1, 1,
1, 0, 0, , 0, *, 32768, 0, 0, 1, 2592000, 0, 0, 1, 0, 1, 0, 8192, 0, 32768, 0,
3, 25000, , 8388608, utf8mb4, utf8mb4, utf8mb4, binary, utf8mb4, utf8mb4,
utf8mb4, , 0, utf8mb4_unicode_ci, utf8mb4_unicode_ci, utf8mb4_unicode_ci, 10,
8912, 18446744073709551615, 0, 0, 1000, , , caching_sha2_password, �, 0, , 0, ,
0, 100, 300, 1000, , 1, 4, 0, FALSE, 200, 0, 0, 1, , 0, 0, 1, +
-><()~*:""&|, 84, [...]
+</dataset>
diff --git
a/test/e2e/sql/src/test/resources/cases/dal/dataset/select_system_variables.xml
b/test/e2e/sql/src/test/resources/cases/dal/dataset/select_system_variables.xml
new file mode 100644
index 00000000000..dec2cf7ac33
--- /dev/null
+++
b/test/e2e/sql/src/test/resources/cases/dal/dataset/select_system_variables.xml
@@ -0,0 +1,464 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="@@activate_all_roles_on_login" />
+ <column name="@@admin_address" />
+ <column name="@@admin_port" />
+ <column name="@@admin_ssl_ca" />
+ <column name="@@admin_ssl_capath" />
+ <column name="@@admin_ssl_cert" />
+ <column name="@@admin_ssl_cipher" />
+ <column name="@@admin_ssl_crl" />
+ <column name="@@admin_ssl_crlpath" />
+ <column name="@@admin_ssl_key" />
+ <column name="@@admin_tls_ciphersuites" />
+ <column name="@@admin_tls_version" />
+ <column name="@@authentication_policy" />
+ <column name="@@auto_generate_certs" />
+ <column name="@@auto_increment_increment" />
+ <column name="@@auto_increment_offset" />
+ <column name="@@autocommit" />
+ <column name="@@automatic_sp_privileges" />
+ <column name="@@avoid_temporal_upgrade" />
+ <column name="@@back_log" />
+ <column name="@@basedir" />
+ <column name="@@big_tables" />
+ <column name="@@bind_address" />
+ <column name="@@binlog_cache_size" />
+ <column name="@@binlog_direct_non_transactional_updates" />
+ <column name="@@binlog_encryption" />
+ <column name="@@binlog_expire_logs_auto_purge" />
+ <column name="@@binlog_expire_logs_seconds" />
+ <column name="@@binlog_group_commit_sync_delay" />
+ <column name="@@binlog_group_commit_sync_no_delay_count" />
+ <column name="@@binlog_gtid_simple_recovery" />
+ <column name="@@binlog_max_flush_queue_time" />
+ <column name="@@binlog_order_commits" />
+ <column name="@@binlog_rotate_encryption_master_key_at_startup" />
+ <column name="@@binlog_row_event_max_size" />
+ <column name="@@binlog_rows_query_log_events" />
+ <column name="@@binlog_stmt_cache_size" />
+ <column name="@@binlog_transaction_compression" />
+ <column name="@@binlog_transaction_compression_level_zstd" />
+ <column name="@@binlog_transaction_dependency_history_size" />
+ <column name="@@build_id" />
+ <column name="@@bulk_insert_buffer_size" />
+ <column name="@@character_set_client" />
+ <column name="@@character_set_connection" />
+ <column name="@@character_set_database" />
+ <column name="@@character_set_filesystem" />
+ <column name="@@character_set_results" />
+ <column name="@@character_set_server" />
+ <column name="@@character_set_system" />
+ <column name="@@character_sets_dir" />
+ <column name="@@check_proxy_users" />
+ <column name="@@collation_connection" />
+ <column name="@@collation_database" />
+ <column name="@@collation_server" />
+ <column name="@@connect_timeout" />
+ <column name="@@connection_memory_chunk_size" />
+ <column name="@@connection_memory_limit" />
+ <column name="@@core_file" />
+ <column name="@@create_admin_listener_thread" />
+ <column name="@@cte_max_recursion_depth" />
+ <column name="@@datadir" />
+ <column name="@@debug_sensitive_session_string" />
+ <column name="@@default_authentication_plugin" />
+ <column name="@@default_collation_for_utf8mb4" />
+ <column name="@@default_password_lifetime" />
+ <column name="@@default_storage_engine" />
+ <column name="@@default_table_encryption" />
+ <column name="@@default_tmp_storage_engine" />
+ <column name="@@default_week_format" />
+ <column name="@@delayed_insert_limit" />
+ <column name="@@delayed_insert_timeout" />
+ <column name="@@delayed_queue_size" />
+ <column name="@@disabled_storage_engines" />
+ <column name="@@disconnect_on_expired_password" />
+ <column name="@@div_precision_increment" />
+ <column name="@@end_markers_in_json" />
+ <column name="@@enforce_gtid_consistency" />
+ <column name="@@eq_range_index_dive_limit" />
+ <column name="@@error_count" />
+ <column name="@@expire_logs_days" />
+ <column name="@@explicit_defaults_for_timestamp" />
+ <column name="@@external_user" />
+ <column name="@@flush" />
+ <column name="@@flush_time" />
+ <column name="@@foreign_key_checks" />
+ <column name="@@ft_boolean_syntax" />
+ <column name="@@ft_max_word_len" />
+ <column name="@@ft_min_word_len" />
+ <column name="@@ft_query_expansion_limit" />
+ <column name="@@ft_stopword_file" />
+ <column name="@@general_log" />
+ <column name="@@general_log_file" />
+ <column name="@@generated_random_password_length" />
+ <column name="@@global_connection_memory_limit" />
+ <column name="@@global_connection_memory_tracking" />
+ <column name="@@group_concat_max_len" />
+ <column name="@@gtid_executed_compression_period" />
+ <column name="@@have_ssl" />
+ <column name="@@histogram_generation_max_mem_size" />
+ <column name="@@host_cache_size" />
+ <column name="@@hostname" />
+ <column name="@@identity" />
+ <column name="@@immediate_server_version" />
+ <column name="@@information_schema_stats_expiry" />
+ <column name="@@init_connect" />
+ <column name="@@init_file" />
+ <column name="@@init_replica" />
+ <column name="@@init_slave" />
+ <column name="@@insert_id" />
+ <column name="@@interactive_timeout" />
+ <column name="@@join_buffer_size" />
+ <column name="@@keep_files_on_create" />
+ <column name="@@keyring_operations" />
+ <column name="@@large_files_support" />
+ <column name="@@large_page_size" />
+ <column name="@@large_pages" />
+ <column name="@@last_insert_id" />
+ <column name="@@lc_messages" />
+ <column name="@@lc_messages_dir" />
+ <column name="@@lc_time_names" />
+ <column name="@@license" />
+ <column name="@@local_infile" />
+ <column name="@@lock_wait_timeout" />
+ <column name="@@locked_in_memory" />
+ <column name="@@log_bin" />
+ <column name="@@log_bin_basename" />
+ <column name="@@log_bin_index" />
+ <column name="@@log_bin_trust_function_creators" />
+ <column name="@@log_bin_use_v1_row_events" />
+ <column name="@@log_error" />
+ <column name="@@log_error_services" />
+ <column name="@@log_error_suppression_list" />
+ <column name="@@log_error_verbosity" />
+ <column name="@@log_queries_not_using_indexes" />
+ <column name="@@log_raw" />
+ <column name="@@log_replica_updates" />
+ <column name="@@log_slave_updates" />
+ <column name="@@log_slow_admin_statements" />
+ <column name="@@log_slow_extra" />
+ <column name="@@log_slow_replica_statements" />
+ <column name="@@log_slow_slave_statements" />
+ <column name="@@log_statements_unsafe_for_binlog" />
+ <column name="@@log_throttle_queries_not_using_indexes" />
+ <column name="@@long_query_time" />
+ <column name="@@low_priority_updates" />
+ <column name="@@lower_case_file_system" />
+ <column name="@@lower_case_table_names" />
+ <column name="@@mandatory_roles" />
+ <column name="@@master_verify_checksum" />
+ <column name="@@max_allowed_packet" />
+ <column name="@@max_binlog_cache_size" />
+ <column name="@@max_binlog_size" />
+ <column name="@@max_binlog_stmt_cache_size" />
+ <column name="@@max_connect_errors" />
+ <column name="@@max_connections" />
+ <column name="@@max_delayed_threads" />
+ <column name="@@max_digest_length" />
+ <column name="@@max_error_count" />
+ <column name="@@max_execution_time" />
+ <column name="@@max_heap_table_size" />
+ <column name="@@max_insert_delayed_threads" />
+ <column name="@@max_join_size" />
+ <column name="@@max_length_for_sort_data" />
+ <column name="@@max_points_in_geometry" />
+ <column name="@@max_prepared_stmt_count" />
+ <column name="@@max_relay_log_size" />
+ <column name="@@max_seeks_for_key" />
+ <column name="@@max_sort_length" />
+ <column name="@@max_sp_recursion_depth" />
+ <column name="@@max_user_connections" />
+ <column name="@@max_write_lock_count" />
+ <column name="@@min_examined_row_limit" />
+ <column name="@@mysql_native_password_proxy_users" />
+ <column name="@@net_buffer_length" />
+ <column name="@@net_read_timeout" />
+ <column name="@@net_retry_count" />
+ <column name="@@net_write_timeout" />
+ <column name="@@new" />
+ <column name="@@offline_mode" />
+ <column name="@@old" />
+ <column name="@@old_alter_table" />
+ <column name="@@open_files_limit" />
+ <column name="@@optimizer_max_subgraph_pairs" />
+ <column name="@@optimizer_prune_level" />
+ <column name="@@optimizer_search_depth" />
+ <column name="@@optimizer_trace_limit" />
+ <column name="@@optimizer_trace_max_mem_size" />
+ <column name="@@optimizer_trace_offset" />
+ <column name="@@original_commit_timestamp" />
+ <column name="@@original_server_version" />
+ <column name="@@parser_max_mem_size" />
+ <column name="@@partial_revokes" />
+ <column name="@@password_history" />
+ <column name="@@password_require_current" />
+ <column name="@@password_reuse_interval" />
+ <column name="@@performance_schema" />
+ <column name="@@performance_schema_accounts_size" />
+ <column name="@@performance_schema_digests_size" />
+ <column name="@@performance_schema_error_size" />
+ <column name="@@performance_schema_events_stages_history_long_size" />
+ <column name="@@performance_schema_events_stages_history_size" />
+ <column
name="@@performance_schema_events_statements_history_long_size" />
+ <column name="@@performance_schema_events_statements_history_size" />
+ <column
name="@@performance_schema_events_transactions_history_long_size" />
+ <column name="@@performance_schema_events_transactions_history_size" />
+ <column name="@@performance_schema_events_waits_history_long_size" />
+ <column name="@@performance_schema_events_waits_history_size" />
+ <column name="@@performance_schema_hosts_size" />
+ <column name="@@performance_schema_max_cond_classes" />
+ <column name="@@performance_schema_max_cond_instances" />
+ <column name="@@performance_schema_max_digest_length" />
+ <column name="@@performance_schema_max_digest_sample_age" />
+ <column name="@@performance_schema_max_file_classes" />
+ <column name="@@performance_schema_max_file_handles" />
+ <column name="@@performance_schema_max_file_instances" />
+ <column name="@@performance_schema_max_index_stat" />
+ <column name="@@performance_schema_max_memory_classes" />
+ <column name="@@performance_schema_max_metadata_locks" />
+ <column name="@@performance_schema_max_mutex_classes" />
+ <column name="@@performance_schema_max_mutex_instances" />
+ <column name="@@performance_schema_max_prepared_statements_instances"
/>
+ <column name="@@performance_schema_max_program_instances" />
+ <column name="@@performance_schema_max_rwlock_classes" />
+ <column name="@@performance_schema_max_rwlock_instances" />
+ <column name="@@performance_schema_max_socket_classes" />
+ <column name="@@performance_schema_max_socket_instances" />
+ <column name="@@performance_schema_max_sql_text_length" />
+ <column name="@@performance_schema_max_stage_classes" />
+ <column name="@@performance_schema_max_statement_classes" />
+ <column name="@@performance_schema_max_statement_stack" />
+ <column name="@@performance_schema_max_table_handles" />
+ <column name="@@performance_schema_max_table_instances" />
+ <column name="@@performance_schema_max_table_lock_stat" />
+ <column name="@@performance_schema_max_thread_classes" />
+ <column name="@@performance_schema_max_thread_instances" />
+ <column name="@@performance_schema_session_connect_attrs_size" />
+ <column name="@@performance_schema_setup_actors_size" />
+ <column name="@@performance_schema_setup_objects_size" />
+ <column name="@@performance_schema_show_processlist" />
+ <column name="@@performance_schema_users_size" />
+ <column name="@@persist_only_admin_x509_subject" />
+ <column name="@@persist_sensitive_variables_in_plaintext" />
+ <column name="@@persisted_globals_load" />
+ <column name="@@pid_file" />
+ <column name="@@plugin_dir" />
+ <column name="@@port" />
+ <column name="@@preload_buffer_size" />
+ <column name="@@print_identified_with_as_hex" />
+ <column name="@@profiling" />
+ <column name="@@profiling_history_size" />
+ <column name="@@protocol_compression_algorithms" />
+ <column name="@@protocol_version" />
+ <column name="@@proxy_user" />
+ <column name="@@pseudo_replica_mode" />
+ <column name="@@pseudo_slave_mode" />
+ <column name="@@pseudo_thread_id" />
+ <column name="@@query_alloc_block_size" />
+ <column name="@@query_prealloc_size" />
+ <column name="@@rand_seed1" />
+ <column name="@@rand_seed2" />
+ <column name="@@range_alloc_block_size" />
+ <column name="@@range_optimizer_max_mem_size" />
+ <column name="@@read_buffer_size" />
+ <column name="@@read_only" />
+ <column name="@@read_rnd_buffer_size" />
+ <column name="@@regexp_stack_limit" />
+ <column name="@@regexp_time_limit" />
+ <column name="@@relay_log" />
+ <column name="@@relay_log_basename" />
+ <column name="@@relay_log_index" />
+ <column name="@@relay_log_info_file" />
+ <column name="@@relay_log_purge" />
+ <column name="@@relay_log_recovery" />
+ <column name="@@relay_log_space_limit" />
+ <column name="@@replica_allow_batching" />
+ <column name="@@replica_checkpoint_group" />
+ <column name="@@replica_checkpoint_period" />
+ <column name="@@replica_compressed_protocol" />
+ <column name="@@replica_load_tmpdir" />
+ <column name="@@replica_max_allowed_packet" />
+ <column name="@@replica_net_timeout" />
+ <column name="@@replica_parallel_workers" />
+ <column name="@@replica_pending_jobs_size_max" />
+ <column name="@@replica_preserve_commit_order" />
+ <column name="@@replica_skip_errors" />
+ <column name="@@replica_sql_verify_checksum" />
+ <column name="@@replica_transaction_retries" />
+ <column name="@@replication_optimize_for_static_plugin_config" />
+ <column name="@@replication_sender_observe_commit_only" />
+ <column name="@@report_host" />
+ <column name="@@report_password" />
+ <column name="@@report_port" />
+ <column name="@@report_user" />
+ <column name="@@require_row_format" />
+ <column name="@@require_secure_transport" />
+ <column name="@@rpl_read_size" />
+ <column name="@@rpl_stop_replica_timeout" />
+ <column name="@@rpl_stop_slave_timeout" />
+ <column name="@@schema_definition_cache" />
+ <column name="@@secondary_engine_cost_threshold" />
+ <column name="@@secure_file_priv" />
+ <column name="@@select_into_buffer_size" />
+ <column name="@@select_into_disk_sync" />
+ <column name="@@select_into_disk_sync_delay" />
+ <column name="@@server_id" />
+ <column name="@@server_id_bits" />
+ <column name="@@server_uuid" />
+ <column name="@@session_track_schema" />
+ <column name="@@session_track_state_change" />
+ <column name="@@session_track_system_variables" />
+ <column name="@@sha256_password_proxy_users" />
+ <column name="@@show_create_table_skip_secondary_engine" />
+ <column name="@@show_create_table_verbosity" />
+ <column name="@@show_gipk_in_create_table_and_information_schema" />
+ <column name="@@show_old_temporals" />
+ <column name="@@skip_external_locking" />
+ <column name="@@skip_name_resolve" />
+ <column name="@@skip_networking" />
+ <column name="@@skip_replica_start" />
+ <column name="@@skip_show_database" />
+ <column name="@@skip_slave_start" />
+ <column name="@@slave_allow_batching" />
+ <column name="@@slave_checkpoint_group" />
+ <column name="@@slave_checkpoint_period" />
+ <column name="@@slave_compressed_protocol" />
+ <column name="@@slave_exec_mode" />
+ <column name="@@slave_load_tmpdir" />
+ <column name="@@slave_max_allowed_packet" />
+ <column name="@@slave_net_timeout" />
+ <column name="@@slave_parallel_type" />
+ <column name="@@slave_parallel_workers" />
+ <column name="@@slave_pending_jobs_size_max" />
+ <column name="@@slave_preserve_commit_order" />
+ <column name="@@slave_rows_search_algorithms" />
+ <column name="@@slave_skip_errors" />
+ <column name="@@slave_sql_verify_checksum" />
+ <column name="@@slave_transaction_retries" />
+ <column name="@@slave_type_conversions" />
+ <column name="@@slow_launch_time" />
+ <column name="@@slow_query_log" />
+ <column name="@@slow_query_log_file" />
+ <column name="@@socket" />
+ <column name="@@sort_buffer_size" />
+ <column name="@@source_verify_checksum" />
+ <column name="@@sql_auto_is_null" />
+ <column name="@@sql_big_selects" />
+ <column name="@@sql_buffer_result" />
+ <column name="@@sql_generate_invisible_primary_key" />
+ <column name="@@sql_log_bin" />
+ <column name="@@sql_log_off" />
+ <column name="@@sql_mode" />
+ <column name="@@sql_notes" />
+ <column name="@@sql_quote_show_create" />
+ <column name="@@sql_replica_skip_counter" />
+ <column name="@@sql_require_primary_key" />
+ <column name="@@sql_safe_updates" />
+ <column name="@@sql_select_limit" />
+ <column name="@@sql_slave_skip_counter" />
+ <column name="@@sql_warnings" />
+ <column name="@@ssl_ca" />
+ <column name="@@ssl_capath" />
+ <column name="@@ssl_cert" />
+ <column name="@@ssl_cipher" />
+ <column name="@@ssl_crl" />
+ <column name="@@ssl_crlpath" />
+ <column name="@@ssl_fips_mode" />
+ <column name="@@ssl_key" />
+ <column name="@@ssl_session_cache_mode" />
+ <column name="@@ssl_session_cache_timeout" />
+ <column name="@@stored_program_cache" />
+ <column name="@@stored_program_definition_cache" />
+ <column name="@@super_read_only" />
+ <column name="@@sync_binlog" />
+ <column name="@@sync_master_info" />
+ <column name="@@sync_relay_log" />
+ <column name="@@sync_relay_log_info" />
+ <column name="@@sync_source_info" />
+ <column name="@@system_time_zone" />
+ <column name="@@table_definition_cache" />
+ <column name="@@table_encryption_privilege_check" />
+ <column name="@@table_open_cache" />
+ <column name="@@table_open_cache_instances" />
+ <column name="@@tablespace_definition_cache" />
+ <column name="@@temptable_max_mmap" />
+ <column name="@@temptable_max_ram" />
+ <column name="@@temptable_use_mmap" />
+ <column name="@@terminology_use_previous" />
+ <column name="@@thread_cache_size" />
+ <column name="@@thread_handling" />
+ <column name="@@thread_stack" />
+ <column name="@@time_zone" />
+ <column name="@@timestamp" />
+ <column name="@@tls_ciphersuites" />
+ <column name="@@tls_version" />
+ <column name="@@tmp_table_size" />
+ <column name="@@tmpdir" />
+ <column name="@@transaction_alloc_block_size" />
+ <column name="@@transaction_allow_batching" />
+ <column name="@@transaction_prealloc_size" />
+ <column name="@@transaction_write_set_extraction" />
+ <column name="@@unique_checks" />
+ <column name="@@updatable_views_with_limit" />
+ <column name="@@use_secondary_engine" />
+ <column name="@@version_comment" />
+ <column name="@@version_compile_machine" />
+ <column name="@@version_compile_os" />
+ <column name="@@version_compile_zlib" />
+ <column name="@@wait_timeout" />
+ <column name="@@warning_count" />
+ <column name="@@windowing_use_high_precision" />
+ <column name="@@xa_detach_on_prepare" />
+ <column name="@@date_format" />
+ <column name="@@datetime_format" />
+ <column name="@@have_crypt" />
+ <column name="@@ignore_builtin_innodb" />
+ <column name="@@ignore_db_dirs" />
+ <column name="@@internal_tmp_disk_storage_engine" />
+ <column name="@@log_builtin_as_identified_by_password" />
+ <column name="@@log_syslog" />
+ <column name="@@log_syslog_facility" />
+ <column name="@@log_syslog_include_pid" />
+ <column name="@@log_syslog_tag" />
+ <column name="@@log_warnings" />
+ <column name="@@max_tmp_tables" />
+ <column name="@@metadata_locks_cache_size" />
+ <column name="@@metadata_locks_hash_instances" />
+ <column name="@@multi_range_count" />
+ <column name="@@old_passwords" />
+ <column name="@@query_cache_limit" />
+ <column name="@@query_cache_min_res_unit" />
+ <column name="@@query_cache_size" />
+ <column name="@@query_cache_type" />
+ <column name="@@query_cache_wlock_invalidate" />
+ <column name="@@secure_auth" />
+ <column name="@@show_compatibility_56" />
+ <column name="@@sync_frm" />
+ <column name="@@time_format" />
+ <column name="@@binlogging_impossible_mode" />
+ <column name="@@simplified_binlog_gtid_recovery" />
+ <column name="@@storage_engine" />
+ <column name="@@thread_concurrency" />
+ <column name="@@timed_mutexes" />
+ </metadata>
+ <row values="0, , 33062, , , , , , , , , TLSv1.2,TLSv1.3, *,,, 1, 1, 1, 1,
1, 0, 0, , 0, *, 32768, 0, 0, 1, 2592000, 0, 0, 1, 0, 1, 0, 8192, 0, 32768, 0,
3, 25000, , 8388608, utf8mb4, utf8mb4, utf8mb4, binary, utf8mb4, utf8mb4,
utf8mb4, , 0, utf8mb4_unicode_ci, utf8mb4_unicode_ci, utf8mb4_unicode_ci, 10,
8912, 18446744073709551615, 0, 0, 1000, , , caching_sha2_password, �, 0, , 0, ,
0, 100, 300, 1000, , 1, 4, 0, FALSE, 200, 0, 0, 1, , 0, 0, 1, +
-><()~*:""&|, 84, [...]
+</dataset>
