181
# Bug #32124: crash if prepared statements refer to variables in the where
185
CREATE TABLE t1 (a INT);
186
PREPARE stmt FROM 'select 1 from `t1` where `a` = any (select (@@tmpdir))';
188
DEALLOCATE PREPARE stmt;
191
CREATE TABLE t2 (a INT PRIMARY KEY);
192
INSERT INTO t2 VALUES (400000), (400001);
194
SET @@sort_buffer_size=400000;
198
CREATE FUNCTION p1(i INT) RETURNS INT
200
SET @@sort_buffer_size= i;
206
SELECT * FROM t2 WHERE a = @@sort_buffer_size AND p1(@@sort_buffer_size + 1) > a - 1;
212
SELECT CONCAT(@@sort_buffer_size);
213
SELECT LEFT("12345", @@ft_boolean_syntax);
215
SET @@sort_buffer_size=DEFAULT;
180
217
--echo End of 5.0 tests.