bzr commit into mysql-5.1 branch (kgeorge:2689) Bug#37627

[Georgi Kodinov]

#At file:///home/kgeorge/mysql/bzr/errs-5.1-bugteam/

 2689 Georgi Kodinov	2008-07-07
      Bug#37627: addendum :
       - moved the test into a separate file to check for presence of the test variable
added:
  mysql-test/r/subselect_debug.result
  mysql-test/t/subselect_debug.test
modified:
  mysql-test/r/subselect.result
  mysql-test/t/subselect.test

per-file messages:
  mysql-test/r/subselect.result
    Bug#37627: moved the test to a separate file
  mysql-test/r/subselect_debug.result
    Bug#37627: moved the test to a separate file
  mysql-test/t/subselect.test
    Bug#37627: moved the test to a separate file
  mysql-test/t/subselect_debug.test
    Bug#37627: moved the test to a separate file
=== modified file 'mysql-test/r/subselect.result'
--- a/mysql-test/r/subselect.result	2008-07-04 14:02:17 +0000
+++ b/mysql-test/r/subselect.result	2008-07-07 08:43:56 +0000
@@ -4398,16 +4398,4 @@ INSERT INTO t1 VALUES (1), (3);
 SELECT * FROM t2 WHERE b NOT IN (SELECT max(t.c) FROM t1, t1 t WHERE t.c>10);
 a	b
 DROP TABLE t1,t2;
-CREATE TABLE t1(id INT);
-INSERT INTO t1 VALUES (1),(2),(3),(4);
-INSERT INTO t1 SELECT a.id FROM t1 a,t1 b,t1 c,t1 d;
-INSERT INTO t1 SELECT a.id FROM t1 a,t1 b,t1 c;
-SET SESSION debug="d,subselect_exec_fail";
-SELECT SUM(EXISTS(SELECT RAND() FROM t1)) FROM t1;
-SUM(EXISTS(SELECT RAND() FROM t1))
-0
-SELECT REVERSE(EXISTS(SELECT RAND() FROM t1));
-REVERSE(EXISTS(SELECT RAND() FROM t1))
-0
-SET SESSION debug=DEFAULT;
-DROP TABLE t1;
+End of 5.0 tests.

=== added file 'mysql-test/r/subselect_debug.result'
--- a/mysql-test/r/subselect_debug.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/r/subselect_debug.result	2008-07-07 08:43:56 +0000
@@ -0,0 +1,12 @@
+CREATE TABLE t1(id INT);
+INSERT INTO t1 VALUES (1),(2),(3),(4);
+INSERT INTO t1 SELECT a.id FROM t1 a,t1 b,t1 c,t1 d;
+SET SESSION debug="d,subselect_exec_fail";
+SELECT SUM(EXISTS(SELECT RAND() FROM t1)) FROM t1;
+SUM(EXISTS(SELECT RAND() FROM t1))
+0
+SELECT REVERSE(EXISTS(SELECT RAND() FROM t1));
+REVERSE(EXISTS(SELECT RAND() FROM t1))
+0
+SET SESSION debug=DEFAULT;
+DROP TABLE t1;

=== modified file 'mysql-test/t/subselect.test'
--- a/mysql-test/t/subselect.test	2008-07-04 14:02:17 +0000
+++ b/mysql-test/t/subselect.test	2008-07-07 08:43:56 +0000
@@ -3299,18 +3299,4 @@ SELECT * FROM t2 WHERE b NOT IN (SELECT 
 
 DROP TABLE t1,t2;
 
-#
-# Bug #37627: Killing query with sum(exists()) or avg(exists()) reproducibly
-# crashes server
-#
-
-CREATE TABLE t1(id INT);
-INSERT INTO t1 VALUES (1),(2),(3),(4);
-INSERT INTO t1 SELECT a.id FROM t1 a,t1 b,t1 c,t1 d;
-INSERT INTO t1 SELECT a.id FROM t1 a,t1 b,t1 c;
-# Setup the mysqld to crash at certain point
-SET SESSION debug="d,subselect_exec_fail";
-SELECT SUM(EXISTS(SELECT RAND() FROM t1)) FROM t1;
-SELECT REVERSE(EXISTS(SELECT RAND() FROM t1));
-SET SESSION debug=DEFAULT;
-DROP TABLE t1;
+--echo End of 5.0 tests.

=== added file 'mysql-test/t/subselect_debug.test'
--- a/mysql-test/t/subselect_debug.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/subselect_debug.test	2008-07-07 08:43:56 +0000
@@ -0,0 +1,16 @@
+--source include/have_debug.inc
+
+#
+# Bug #37627: Killing query with sum(exists()) or avg(exists()) reproducibly
+# crashes server
+#
+
+CREATE TABLE t1(id INT);
+INSERT INTO t1 VALUES (1),(2),(3),(4);
+INSERT INTO t1 SELECT a.id FROM t1 a,t1 b,t1 c,t1 d;
+# Setup the mysqld to crash at certain point
+SET SESSION debug="d,subselect_exec_fail";
+SELECT SUM(EXISTS(SELECT RAND() FROM t1)) FROM t1;
+SELECT REVERSE(EXISTS(SELECT RAND() FROM t1));
+SET SESSION debug=DEFAULT;
+DROP TABLE t1;