apache / apache/shardingsphere

Having trouble setting user session variables when connecting to a MySQL server through ShardingSphere Proxy

Open
#32,165 0 comments 0 reactions 0 assignees View on GitHub
db: MySQL in: proxy type: bug
Dominant language
Java
Stars
20.8k
Forks
6.9k
Avg merge
11h 38m
Merged PRs (30d)
326

Description

```
Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MySQL connection id is 2
Server version: 5.7.22-ShardingSphere-Proxy 5.5.0 Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]>
MySQL [(none)]>
MySQL [(none)]>
MySQL [(none)]> set @test_var = 1;
ERROR 1193 (HY000): Unknown system variable '@test_var'
MySQL [(none)]> set @test_var := 1;
ERROR 1193 (HY000): Unknown system variable '@test_var'
```

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the reported `set @test_var = 1;` and `set @test_var := 1;` commands through ShardingSphere Proxy against MySQL. Trace how the proxy handles user session variables and establish whether assignment should succeed; done means the behavior is fixed or clearly documented with a regression test or reproducible resolution.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.