apache / apache/shardingsphere

`set dist variable sql_show = 1` showed succeed but ineffective

Open
#25,389 1 comment 0 reactions 0 assignees View on GitHub
feature: DistSQL status: volunteer wanted type: enhancement
Dominant language
Java
Stars
20.8k
Forks
6.9k
Avg merge
11h 35m
Merged PRs (30d)
326

Description

## Bug Report

### Which version of ShardingSphere did you use?

master - 2da012130897dd302482e79c9c58424d0cab2c22

### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

### Expected behavior

Enable `sql-show` or reject input.

### Actual behavior

```
bmsql_sharding=> set dist variable sql_show = 1;
SUCCESS

bmsql_sharding=> show dist variables;
variable_name | variable_value
---------------------------------------+-----------------
agent_plugins_enabled | true
cached_connections | 0
cdc_server_port | 33071
check_table_metadata_enabled | false
kernel_executor_size | 0
max_connections_size_per_query | 1
proxy_backend_query_fetch_size | 50
proxy_default_port | 3307
proxy_frontend_database_protocol_type |
proxy_frontend_executor_size | 4
proxy_frontend_flush_threshold | 128
proxy_frontend_max_connections | 0
proxy_frontend_ssl_cert_file |
proxy_frontend_ssl_cipher |
proxy_frontend_ssl_enabled | true
proxy_frontend_ssl_key_file |
proxy_frontend_ssl_version | TLSv1.2,TLSv1.3
proxy_hint_enabled | false
proxy_instance_type | Proxy
proxy_meta_data_collector_enabled | true
proxy_netty_backlog | 1024
sql_federation_type | NONE
sql_show | false
sql_simple | false
system_log_level | INFO
transaction_type | LOCAL
(26 rows)

```

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the reported SET DIST VARIABLE sql_show = 1 and SHOW DIST VARIABLES sequence in ShardingSphere-Proxy. Trace how the sql_show variable is handled; done means the setting enables sql-show or the input is rejected instead of returning SUCCESS.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.