9027
9027
DROP PROCEDURE p2;
9031
--echo # Bug#13805127: Stored program cache produces wrong result in same THD
9036
CREATE PROCEDURE p1(x INT UNSIGNED)
9038
SELECT c1, t2.c2, count(c3)
9041
SELECT 3 as c2 FROM dual WHERE x = 1
9043
SELECT 2 FROM dual WHERE x = 1 OR x = 2
9046
SELECT '2012-03-01 01:00:00' AS c1, 3 as c2, 1 as c3 FROM dual
9048
SELECT '2012-03-01 02:00:00', 3, 2 FROM dual
9050
SELECT '2012-03-01 01:00:00', 2, 1 FROM dual
9030
9066
--echo # End of 5.5 test