From: Martin Hansson Date: January 26 2012 11:35am Subject: bzr push into mysql-trunk branch (martin.hansson:3793 to 3794) Bug#13536661 List-Archive: http://lists.mysql.com/commits/142574 X-Bug: 13536661 Message-Id: <201201261136.q0QBagBI007059@acsmt358.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3794 Martin Hansson 2012-01-26 Bug#13536661: Moved the test case to optimizer_debug_sync (currently decativated). modified: mysql-test/r/optimizer_debug_sync.result mysql-test/t/optimizer_debug_sync.test mysql-test/t/temp_table.test 3793 Guilhem Bichot 2012-01-26 [merge] merge from latest trunk modified: mysql-test/r/plugin.result mysql-test/t/plugin.test storage/example/ha_example.cc === modified file 'mysql-test/r/optimizer_debug_sync.result' --- a/mysql-test/r/optimizer_debug_sync.result 2011-03-01 14:57:53 +0000 +++ b/mysql-test/r/optimizer_debug_sync.result 2012-01-26 11:34:35 +0000 @@ -21,3 +21,20 @@ MAX(i) MAX(i) 2 DROP TABLE t; +# +# Bug #13536661: VALGRIND: DEFINITELY LOST: 552 BYTES IN 1 BLOCKS IN +# CREATE_TMP_TABLE AND HIGHER +# +CREATE TABLE t1 ( a INT, b INT ); +INSERT INTO t1 VALUES (4, 40), (1, 10), (2, 20), (2, 20), (3, 30); +SET debug_sync = "tmp_table_created SIGNAL parked WAIT_FOR go"; +# This should not leak memory. +SELECT b, COUNT(DISTINCT b) FROM t1 GROUP BY b ORDER BY -b; +SET debug_sync = "now WAIT_FOR parked"; +# Set locally to shadow the global variable. +SET debug = ''; +SET GLOBAL debug = '+d,simulate_out_of_memory'; +SET debug_sync = "now SIGNAL go"; +ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space +SET GLOBAL debug = ''; +DROP TABLE t1; === modified file 'mysql-test/t/optimizer_debug_sync.test' --- a/mysql-test/t/optimizer_debug_sync.test 2011-03-28 10:56:41 +0000 +++ b/mysql-test/t/optimizer_debug_sync.test 2012-01-26 11:34:35 +0000 @@ -59,3 +59,30 @@ DROP TABLE t; --exit --echo # End of BUG#56080 + +--echo # +--echo # Bug #13536661: VALGRIND: DEFINITELY LOST: 552 BYTES IN 1 BLOCKS IN +--echo # CREATE_TMP_TABLE AND HIGHER +--echo # +CREATE TABLE t1 ( a INT, b INT ); +INSERT INTO t1 VALUES (4, 40), (1, 10), (2, 20), (2, 20), (3, 30); + +connect(con1,localhost,root,,); +SET debug_sync = "tmp_table_created SIGNAL parked WAIT_FOR go"; +--echo # This should not leak memory. +send SELECT b, COUNT(DISTINCT b) FROM t1 GROUP BY b ORDER BY -b; + +connection default; +SET debug_sync = "now WAIT_FOR parked"; +--echo # Set locally to shadow the global variable. +SET debug = ''; +SET GLOBAL debug = '+d,simulate_out_of_memory'; + +SET debug_sync = "now SIGNAL go"; + +connection con1; +--error ER_OUT_OF_RESOURCES +reap; +SET GLOBAL debug = ''; + +DROP TABLE t1; === modified file 'mysql-test/t/temp_table.test' --- a/mysql-test/t/temp_table.test 2012-01-25 11:42:57 +0000 +++ b/mysql-test/t/temp_table.test 2012-01-26 11:34:35 +0000 @@ -294,32 +294,3 @@ INSERT INTO t3 VALUES (101), (102), (103 REPAIR TABLE t1, t2, t3; DROP TABLES t1, t2, t3; - -# Test case temporarily deactivated until we can find a place to move it -# --echo # -# --echo # Bug #13536661: VALGRIND: DEFINITELY LOST: 552 BYTES IN 1 BLOCKS IN -# --echo # CREATE_TMP_TABLE AND HIGHER -# --echo # -# CREATE TABLE t1 ( a INT, b INT ); -# INSERT INTO t1 VALUES (4, 40), (1, 10), (2, 20), (2, 20), (3, 30); -# -# connect(con1,localhost,root,,); -# SET debug_sync = "tmp_table_created SIGNAL parked WAIT_FOR go"; -# --echo # This should not leak memory. -# send SELECT b, COUNT(DISTINCT b) FROM t1 GROUP BY b ORDER BY -b; -# -# connection default; -# SET debug_sync = "now WAIT_FOR parked"; -# --echo # Set locally to shadow the global variable. -# SET debug = ''; -# SET GLOBAL debug = '+d,simulate_out_of_memory'; -# -# SET debug_sync = "now SIGNAL go"; -# -# connection con1; -# --error ER_OUT_OF_RESOURCES -# reap; -# SET GLOBAL debug = ''; -# -# DROP TABLE t1; -# \ No newline at end of file No bundle (reason: useless for push emails).