Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.1(EOL)
-
None
Description
Testcase:
CREATE TABLE t1 (a INT) ENGINE=MyISAM; |
CREATE TABLE t2 (b INT) ENGINE=MyISAM; |
INSERT INTO t2 VALUES (1); |
|
|
prepare stmt1 from "SELECT MAX(a), a in ( SELECT b FROM t2 ) AS bb FROM t1"; |
|
|
execute stmt1; |
execute stmt1; |
|
|
prepare stmt2 from "SELECT MAX(a), a >= ALL ( SELECT b FROM t2 ) AS bb FROM t1"; |
execute stmt2; |
execute stmt2; |
|
|
deallocate prepare stmt1; |
deallocate prepare stmt2; |
drop table t1, t2; |
Actual result:
prepare stmt1 from "SELECT MAX(a), a in ( SELECT b FROM t2 ) AS bb FROM t1"; |
execute stmt1; |
MAX(a) bb |
NULL NULL |
execute stmt1; |
MAX(a) bb |
NULL 0 |
prepare stmt2 from "SELECT MAX(a), a >= ALL ( SELECT b FROM t2 ) AS bb FROM t1"; |
execute stmt2; |
MAX(a) bb |
NULL NULL |
execute stmt2; |
MAX(a) bb |
NULL 1 |
Expected result:
prepare stmt1 from "SELECT MAX(a), a in ( SELECT b FROM t2 ) AS bb FROM t1"; |
execute stmt1; |
MAX(a) bb |
NULL NULL |
execute stmt1; |
MAX(a) bb |
NULL NULL |
prepare stmt2 from "SELECT MAX(a), a >= ALL ( SELECT b FROM t2 ) AS bb FROM t1"; |
execute stmt2; |
MAX(a) bb |
NULL NULL |
execute stmt2; |
MAX(a) bb |
NULL NULL |
Attachments
Issue Links
- relates to
-
MDEV-31003
Second execution for ps-protocol
-
- Closed
-