Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.6.1, 11.8.1, 11.8
-
None
Description
I run the following test cases, in which the query results are expected to be the same.
CREATE TABLE t1 (c1 LONGTEXT); |
INSERT INTO t1 (c1) VALUES ('B'); |
INSERT INTO t1 (c1) VALUES ('A'); |
SELECT c1 FROM t1 WHERE AES_ENCRYPT(c1, 1) > SOME (SELECT c1 FROM t1) IS TRUE; -- {} |
CREATE TABLE t1 (c1 TINYTEXT); |
INSERT INTO t1 (c1) VALUES ('B'); |
INSERT INTO t1 (c1) VALUES ('A'); |
SELECT c1 FROM t1 WHERE AES_ENCRYPT(c1, 1) > SOME (SELECT c1 FROM t1) IS TRUE; -- {A} |
Attachments
Issue Links
- is caused by
-
MDEV-19123 Change default charset from latin1 to utf8mb4
-
- Closed
-