3750
# Bug#13805127: Stored program cache produces wrong result in same THD
3754
SELECT c1, t2.c2, count(c3)
3757
SELECT 3 as c2 FROM dual WHERE @x = 1
3759
SELECT 2 FROM dual WHERE @x = 1 OR @x = 2
3762
SELECT '2012-03-01 01:00:00' AS c1, 3 as c2, 1 as c3 FROM dual
3764
SELECT '2012-03-01 02:00:00', 3, 2 FROM dual
3766
SELECT '2012-03-01 01:00:00', 2, 1 FROM dual
3773
SELECT c1, t2.c2, count(c3)
3776
SELECT 3 as c2 FROM dual WHERE @x = 1
3778
SELECT 2 FROM dual WHERE @x = 1 OR @x = 2
3781
SELECT '2012-03-01 01:00:00' AS c1, 3 as c2, 1 as c3 FROM dual
3783
SELECT '2012-03-01 02:00:00', 3, 2 FROM dual
3785
SELECT '2012-03-01 01:00:00', 2, 1 FROM dual
3790
2012-03-01 01:00:00 2 1
3791
2012-03-01 01:00:00 3 1
3792
2012-03-01 02:00:00 3 1
3796
2012-03-01 01:00:00 2 1
3797
2012-03-01 01:00:00 3 1
3798
2012-03-01 02:00:00 3 1
3801
SELECT c1, t2.c2, count(c3)
3804
SELECT 3 as c2 FROM dual WHERE @x = 1
3806
SELECT 2 FROM dual WHERE @x = 1 OR @x = 2
3809
SELECT '2012-03-01 01:00:00' AS c1, 3 as c2, 1 as c3 FROM dual
3811
SELECT '2012-03-01 02:00:00', 3, 2 FROM dual
3813
SELECT '2012-03-01 01:00:00', 2, 1 FROM dual
3818
2012-03-01 01:00:00 2 1
3822
2012-03-01 01:00:00 2 1
3825
SELECT c1, t2.c2, count(c3)
3828
SELECT 3 as c2 FROM dual WHERE @x = 1
3830
SELECT 2 FROM dual WHERE @x = 1 OR @x = 2
3833
SELECT '2012-03-01 01:00:00' AS c1, 3 as c2, 1 as c3 FROM dual
3835
SELECT '2012-03-01 02:00:00', 3, 2 FROM dual
3837
SELECT '2012-03-01 01:00:00', 2, 1 FROM dual
3842
2012-03-01 01:00:00 2 1
3843
2012-03-01 01:00:00 3 1
3844
2012-03-01 02:00:00 3 1
3848
2012-03-01 01:00:00 2 1
3849
2012-03-01 01:00:00 3 1
3850
2012-03-01 02:00:00 3 1
3851
DEALLOCATE PREPARE s1;
3750
3853
# End of 5.5 tests.