apache / apache/shardingsphere
ShardingSphere-Proxy MySQL replied incorrect binary flags in column definition
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 11h 38m
- Merged PRs (30d)
- 326
Description
## Bug Report
### Which version of ShardingSphere did you use?
947c8c484b6eb6227891bc0500a52ce39f211584
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy MySQL
### Expected behavior
MySQL:
### Actual behavior
ShardingSphere-Proxy MySQL:
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
```sql
select _binary'abc', X'20', X'41'
```
Contributor guide
Research direction
Reproduce `select _binary'abc', X'20', X'41'` against ShardingSphere-Proxy MySQL and compare its column-definition binary flags with MySQL, using the expected and actual results in the report. Trace the Proxy's MySQL response handling for these expressions; done means the returned flags match MySQL.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100