|
The following test cases executed with --ps-protocol fail with assert on server built in debug mode with -DWITH_PROTECT_STATEMENT_MEMROOT
CREATE TABLE t1 (s1 CHAR(1));
|
INSERT INTO t1 VALUES ('a');
|
SELECT * FROM t1 WHERE _utf8'a' > ANY (SELECT s1 FROM t1);
|
DROP TABLE t1;
|
CREATE TABLE t1 (f1 CHAR(3) CHARACTER SET utf8 NULL, f2 CHAR(3) CHARACTER SET latin1 NULL);
|
INSERT INTO t1 VALUES ('foo','bar');
|
SELECT * FROM t1 WHERE f2 >= SOME ( SELECT f1 FROM t1 );
|
DROP TABLE t1;
|
In case the condition of the query is changed to '=' the above mentioned tests cases be completed without assert failures.
|