diff options
Diffstat (limited to 'mysql-test/t/multi_update2.test')
-rw-r--r-- | mysql-test/t/multi_update2.test | 78 |
1 files changed, 0 insertions, 78 deletions
diff --git a/mysql-test/t/multi_update2.test b/mysql-test/t/multi_update2.test deleted file mode 100644 index a0f17fabec4..00000000000 --- a/mysql-test/t/multi_update2.test +++ /dev/null @@ -1,78 +0,0 @@ ---source include/long_test.inc - -# -# Test of update statement that uses many tables. -# - -# -# If we are running with -# - Valgrind -> $VALGRIND_TEST <> 0 -# - debug tracing -> @@session.debug LIKE '%trace%' -# the resource consumption (storage space needed, runtime) will be extreme. -# Therefore we require that the option "--big-test" is also set. -# - -let $need_big= 0; ---disable_query_log ---error 0,ER_UNKNOWN_SYSTEM_VARIABLE -SET @aux = @@session.debug; -if (!$mysql_errno) -{ - # We have returncode 0 = the server system variable @@session.debug exists. - # But we only need "--big-test" in case of tracing. - if (`SELECT @@session.debug LIKE '%trace%'`) - { - let $need_big= 1; - } -} ---enable_query_log -if ($VALGRIND_TEST) -{ - # We are running with Valgrind - inc $need_big; -} -if (`SELECT '$BIG_TEST' = '' AND $need_big = 1`) -{ - --skip Need "--big-test" when running with the option "--debug" or "--valgrind" -} - -# -# Bug#1820 Rows not deleted from second table on multi-table delete -# - ---disable_warnings -DROP TABLE IF EXISTS t1,t2; ---enable_warnings - -CREATE TABLE t1 ( a INT NOT NULL, b INT NOT NULL) ; ---echo # The protocolling of many inserts into t1 is suppressed. ---disable_query_log -INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4); -let $1=19; -set @d=4; -begin; -while ($1) -{ - eval INSERT INTO t1 SELECT a+@d,b+@d FROM t1; - eval SET @d=@d*2; - dec $1; -} -commit; ---enable_query_log -ALTER TABLE t1 ADD INDEX i1(a); -DELETE FROM t1 WHERE a > 2000000; -CREATE TABLE t2 LIKE t1; -INSERT INTO t2 SELECT * FROM t1; - -SELECT 't2 rows before small delete', COUNT(*) FROM t1; -DELETE t1,t2 FROM t1,t2 WHERE t1.b=t2.a AND t1.a < 2; -SELECT 't2 rows after small delete', COUNT(*) FROM t2; -SELECT 't1 rows after small delete', COUNT(*) FROM t1; - -## Try deleting many rows - -DELETE t1,t2 FROM t1,t2 WHERE t1.b=t2.a AND t1.a < 100*1000; -SELECT 't2 rows after big delete', COUNT(*) FROM t2; -SELECT 't1 rows after big delete', COUNT(*) FROM t1; - -DROP TABLE t1,t2; |