Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.8.1, 11.4, 10.5(EOL)
-
None
Description
I run the following two cases, in which the same query result should be returned.
-- case 1
|
CREATE TABLE t1 (c1 LONGBLOB); |
INSERT INTO t1 (c1) VALUES ('55'); |
INSERT INTO t1 (c1) VALUES ('95'); |
SELECT c1 AS r1 FROM t1 WHERE (AES_ENCRYPT(c1, 48) <= ALL (SELECT c1 AS ca7 FROM t1)) IS FALSE; -- {} |
-- case 2
|
CREATE TABLE t1 (c1 TINYBLOB); |
INSERT INTO t1 (c1) VALUES ('55'); |
INSERT INTO t1 (c1) VALUES ('95'); |
SELECT c1 AS r2 FROM t1 WHERE (AES_ENCRYPT(c1, 48) <= ALL (SELECT c1 AS ca7 FROM t1)) IS FALSE; -- {95} |