| Bug #93953 | use "sorted_result" of mysql-test , cause error result ( for type of binary ) | ||
|---|---|---|---|
| Submitted: | 17 Jan 2019 3:25 | Modified: | 30 May 2019 13:07 |
| Reporter: | Calvin leo | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tools: MTR / mysql-test-run | Severity: | S7 (Test Cases) |
| Version: | mysql-test 2.0 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | mysql-test | ||
[17 Jan 2019 6:38]
MySQL Verification Team
Hello Calvin leo, Thank you for the report and feedback! regards, Umesh
[30 May 2019 13:07]
Paul DuBois
Posted by developer: Fixed in 8.0.18. Work was done for test suite. No changelog entry required.
Description: My program runs the commands: CREATE TABLE t1 (a BINARY(32), b VARBINARY(32)) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; INSERT INTO t1 VALUES ('1a','1a'),('2a','2a'),('1234a','1234a'),('a','a'),('ab','ab'); --sorted_result SELECT * FROM t1; And the results above(wrong results): SELECT * FROM t1; a b 1234a How to repeat: NOTHING Suggested fix: I hope you can give me some helpful advice.