From: Bjorn Munch Date: January 19 2011 10:16am Subject: bzr commit into mysql-5.1-mtr branch (bjorn.munch:2974) List-Archive: http://lists.mysql.com/commits/129152 Message-Id: <201101191016.p0JAGqtD024877@khepri15.norway.sun.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit #At file:///home/bm136801/my/merge-51/ based on revid:bjorn.munch@stripped 2974 Bjorn Munch 2011-01-19 [merge] merge from 5.1-mtr added: mysql-test/include/restart_slave_sql.inc mysql-test/include/rpl_connection_master.inc mysql-test/include/rpl_connection_slave.inc mysql-test/include/rpl_connection_slave1.inc modified: mysql-test/r/ctype_many.result mysql-test/r/func_like.result mysql-test/r/xml.result mysql-test/suite/rpl/r/rpl_stop_slave.result mysql-test/suite/rpl/t/rpl_packet.test mysql-test/suite/rpl/t/rpl_stop_slave.test mysql-test/suite/sys_vars/r/innodb_max_dirty_pages_pct_func.result mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_func.test mysql-test/t/ctype_many.test mysql-test/t/func_like.test mysql-test/t/xml.test sql/item_strfunc.cc sql/item_strfunc.h sql/item_sum.h sql/slave.cc sql/sql_repl.cc strings/xml.c === added file 'mysql-test/include/restart_slave_sql.inc' --- a/mysql-test/include/restart_slave_sql.inc 1970-01-01 00:00:00 +0000 +++ b/mysql-test/include/restart_slave_sql.inc 2011-01-18 17:23:49 +0000 @@ -0,0 +1,43 @@ +# ==== Purpose ==== +# +# Provide a earier way to restart SQL thread when you want to stop sql thread +# and then start it immediately. +# +# Sources stop_slave_sql.inc to stop SQL thread on the current connection. +# Then issues START SLAVE SQL_THREAD and then waits until +# the SQL threads have started, or until a timeout is reached. +# +# Please use this instead of 'STOP|START SLAVE SQL_THREAD', to reduce the risk of +# test case bugs. +# +# +# ==== Usage ==== +# +# [--let $slave_timeout= NUMBER] +# [--let $rpl_debug= 1] +# --source include/restart_slave_sql.inc +# +# Parameters: +# $slave_timeout +# See include/wait_for_slave_param.inc +# +# $rpl_debug +# See include/rpl_init.inc + + +--let $include_filename= restart_slave.inc +--source include/begin_include_file.inc + + +if (!$rpl_debug) +{ + --disable_query_log +} + +source include/stop_slave_sql.inc; +START SLAVE SQL_THREAD; +source include/wait_for_slave_sql_to_start.inc; + + +--let $include_filename= restart_slave.inc +--source include/end_include_file.inc \ No newline at end of file === added file 'mysql-test/include/rpl_connection_master.inc' --- a/mysql-test/include/rpl_connection_master.inc 1970-01-01 00:00:00 +0000 +++ b/mysql-test/include/rpl_connection_master.inc 2011-01-18 17:23:49 +0000 @@ -0,0 +1,2 @@ +let $rpl_connection_name= master; +source include/rpl_connection.inc; \ No newline at end of file === added file 'mysql-test/include/rpl_connection_slave.inc' --- a/mysql-test/include/rpl_connection_slave.inc 1970-01-01 00:00:00 +0000 +++ b/mysql-test/include/rpl_connection_slave.inc 2011-01-18 17:23:49 +0000 @@ -0,0 +1,2 @@ +let $rpl_connection_name= slave; +source include/rpl_connection.inc; \ No newline at end of file === added file 'mysql-test/include/rpl_connection_slave1.inc' --- a/mysql-test/include/rpl_connection_slave1.inc 1970-01-01 00:00:00 +0000 +++ b/mysql-test/include/rpl_connection_slave1.inc 2011-01-18 17:23:49 +0000 @@ -0,0 +1,2 @@ +let $rpl_connection_name= slave1; +source include/rpl_connection.inc; \ No newline at end of file === modified file 'mysql-test/r/ctype_many.result' --- a/mysql-test/r/ctype_many.result 2006-02-22 09:09:59 +0000 +++ b/mysql-test/r/ctype_many.result 2011-01-17 12:11:33 +0000 @@ -1683,3 +1683,18 @@ ARMENIAN CAPIT DA 2 ARMENIAN CAPIT ECH 2 ARMENIAN CAPIT ZA 2 DROP TABLE t1; +# +# Start of 5.1 tests +# +# +# Bug#58371 Assertion failed: !s.uses_buffer_owned_by(this) with format string function +# +SET NAMES latin1; +DO CONVERT(CAST(SUBSTRING_INDEX(FORMAT(1,'1111'), FORMAT('','Zpq'),1) +AS BINARY(0)) USING utf8); +Warnings: +Warning 1292 Truncated incorrect INTEGER value: 'Zpq' +Warning 1292 Truncated incorrect BINARY(0) value: '1.' +# +# End of 5.1 tests +# === modified file 'mysql-test/r/func_like.result' --- a/mysql-test/r/func_like.result 2010-11-08 10:55:43 +0000 +++ b/mysql-test/r/func_like.result 2011-01-17 09:30:22 +0000 @@ -182,4 +182,9 @@ INSERT INTO t2 VALUES (1), (2), (3); SELECT 1 FROM t2 JOIN t1 ON 1 LIKE a GROUP BY a; 1 DROP TABLE t1, t2; +# +# Bug#59149 valgrind warnings with "like .. escape .." function +# +SELECT '' LIKE '1' ESCAPE COUNT(1); +ERROR HY000: Incorrect arguments to ESCAPE End of 5.1 tests === modified file 'mysql-test/r/xml.result' --- a/mysql-test/r/xml.result 2010-11-22 09:21:10 +0000 +++ b/mysql-test/r/xml.result 2011-01-18 06:38:41 +0000 @@ -1113,4 +1113,15 @@ SELECT UPDATEXML(NULL, (LPAD(0.1111E-15, ERROR 22007: Illegal double '111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111' value found during parsing SELECT EXTRACTVALUE('', LPAD(0.1111E-15, '2011', 1)); ERROR 22007: Illegal double '111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111' value found during parsing +# +# Bug #44332 my_xml_scan reads behind the end of buffer +# +SELECT UPDATEXML(CONVERT(_latin1'<' USING utf8),'1','1'); +UPDATEXML(CONVERT(_latin1'<' USING utf8),'1','1') +NULL +Warnings: +Warning 1525 Incorrect XML value: 'parse error at line 1 pos 2: END-OF-INPUT unexpected (ident or '/' wanted)' +SELECT UPDATEXML(CONVERT(_latin1'", 3); p->cur++) - {} - if (!memcmp(p->cur, "-->", 3)) - p->cur+=3; + for (; p->cur < p->end; p->cur++) + { + if (!my_xml_parser_prefix_cmp(p, C_STRING_WITH_LEN("-->"))) + { + p->cur+= 3; + break; + } + } a->end=p->cur; lex=MY_XML_COMMENT; } - else if (!memcmp(p->cur, "cur+= 9; for (; p->cur < p->end - 2 ; p->cur++) No bundle (reason: revision is a merge).