← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/t/ps.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/ps.test
3079
3079
DEALLOCATE PREPARE stmt;
3080
3080
DROP TABLE t1;
3081
3081
 
 
3082
--echo #
 
3083
--echo # Bug#54494 crash with explain extended and prepared statements
 
3084
--echo #
 
3085
CREATE TABLE t1(a INT);
 
3086
INSERT INTO t1 VALUES (1),(2);
 
3087
PREPARE stmt FROM 'EXPLAIN EXTENDED SELECT 1 FROM t1 RIGHT JOIN t1 t2 ON 1';
 
3088
EXECUTE stmt;
 
3089
EXECUTE stmt;
 
3090
DEALLOCATE PREPARE stmt;
 
3091
DROP TABLE t1;
 
3092
 
 
3093
--echo #
 
3094
--echo # Bug#54488 crash when using explain and prepared statements with subqueries
 
3095
--echo #
 
3096
CREATE TABLE t1(f1 INT);
 
3097
INSERT INTO t1 VALUES (1),(1);
 
3098
PREPARE stmt FROM 'EXPLAIN SELECT 1 FROM t1 WHERE (SELECT (SELECT 1 FROM t1 GROUP BY f1))';
 
3099
EXECUTE stmt;
 
3100
EXECUTE stmt;
 
3101
DEALLOCATE PREPARE stmt;
 
3102
DROP TABLE t1;
 
3103
 
3082
3104
--echo End of 5.1 tests.