1
explain extended select rand(999999),rand();
3
# Bug #7281: problem with rand()
6
--error ER_BAD_FIELD_ERROR
10
# Bug #6172 RAND(a) should only accept constant values as arguments
12
CREATE TABLE t1 (a INT);
14
INSERT INTO t1 VALUES (1),(1),(1),(2);
15
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1;
16
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1 WHERE a = 1;
17
INSERT INTO t1 VALUES (3);
18
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1;
19
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1 WHERE a = 1;