List:Commits« Previous MessageNext Message »
From:Alexey Botchkov Date:June 25 2009 1:18pm
Subject:bzr commit into mysql-5.4 branch (holyfoot:3356)
View as plain text  
#At file:///home/hf/work/mysql_common/wl4991/ based on revid:holyfoot@strippedx2awucpm7628c9z

 3356 Alexey Botchkov	2009-06-25 [merge]
      merging

    modified:
      mysql-test/include/gis_generic.inc
      mysql-test/include/master-slave.inc
      mysql-test/r/archive_gis.result
      mysql-test/r/gis.result
      mysql-test/r/innodb_gis.result
      mysql-test/suite/backup/r/backup_no_engine.result
      mysql-test/suite/backup/t/backup_db_grants.test
      mysql-test/suite/backup/t/backup_no_engine.test
      mysql-test/suite/backup/t/backup_objects_dependency.test
      mysql-test/suite/backup/t/disabled.def
      mysql-test/suite/backup_engines/t/backup_partitioning.test
      mysql-test/suite/funcs_1/r/storedproc.result
      mysql-test/suite/funcs_1/t/storedproc.test
      mysql-test/suite/ndb/r/ndb_gis.result
      mysql-test/suite/ndb/t/disabled.def
      mysql-test/suite/ndb/t/ndb_basic.test
      mysql-test/suite/ndb/t/ndb_index.test
      mysql-test/suite/ndb/t/ndb_index_ordered.test
      mysql-test/suite/ndb_binlog/t/ndb_binlog_basic.test
      mysql-test/suite/ndb_team/t/ndb_autodiscover.test
      mysql-test/suite/parts/inc/part_supported_sql_funcs_main.inc
      mysql-test/suite/parts/inc/partition_decimal.inc
      mysql-test/suite/parts/inc/partition_double.inc
      mysql-test/suite/parts/inc/partition_float.inc
      mysql-test/suite/parts/t/disabled.def
      mysql-test/suite/rpl/t/disabled.def
      mysql-test/suite/rpl/t/rpl_backup_multi.test
      mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test
      mysql-test/suite/rpl/t/rpl_cross_version.test
      mysql-test/suite/rpl/t/rpl_extraCol_innodb.test
      mysql-test/suite/rpl/t/rpl_extraCol_myisam.test
      mysql-test/suite/rpl/t/rpl_killed_ddl.test
      mysql-test/suite/rpl/t/rpl_row_colSize.test
      mysql-test/suite/rpl/t/rpl_row_create_table.test
      mysql-test/suite/rpl/t/rpl_row_mysqlbinlog.test
      mysql-test/suite/rpl/t/rpl_stm_log.test
      mysql-test/suite/rpl/t/rpl_temporary.test
      mysql-test/suite/rpl/t/rpl_truncate_3innodb.test
      mysql-test/suite/sys_vars/inc/timestamp_basic.inc
      mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test
      mysql-test/suite/sys_vars/t/disabled.def
      mysql-test/suite/sys_vars/t/foreign_key_checks_func.test
      mysql-test/t/csv_not_null.test
      mysql-test/t/ctype_ldml.test
      mysql-test/t/ctype_utf8.test
      mysql-test/t/disabled.def
      mysql-test/t/gis.test
      mysql-test/t/index_merge_innodb.test
      mysql-test/t/information_schema_db.test
      mysql-test/t/innodb_ctype_ldml.test
      mysql-test/t/mysqlbinlog-cp932.test
      mysql-test/t/mysqldump.test
      mysql-test/t/partition_mgm_err2.test
      mysql-test/t/partition_not_windows.test
      mysql-test/t/ps.test
      mysql-test/t/query_cache.test
      mysql-test/t/show_check.test
      mysql-test/t/sp.test
      mysql-test/t/symlink.test
      mysql-test/t/trigger.test
      sql/opt_range.cc
=== modified file 'mysql-test/include/gis_generic.inc'
--- a/mysql-test/include/gis_generic.inc	2007-03-29 10:00:32 +0000
+++ b/mysql-test/include/gis_generic.inc	2009-06-24 19:39:33 +0000
@@ -108,7 +108,8 @@ explain extended select AsText(Centroid(
 
 SELECT fid, IsClosed(g) FROM gis_multi_line ORDER by fid;
 
-SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
+# -- [DISABLED Bug#38092]
+# SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
 SELECT fid, Area(g) FROM gis_multi_polygon ORDER by fid;
 
 SELECT fid, NumGeometries(g) from gis_multi_point ORDER by fid;

=== modified file 'mysql-test/include/master-slave.inc'
--- a/mysql-test/include/master-slave.inc	2008-09-09 05:23:11 +0000
+++ b/mysql-test/include/master-slave.inc	2009-06-25 12:33:12 +0000
@@ -1,5 +1,9 @@
 # Replication tests need binlog
 #
+
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
 # $skip_slave_start  If true, the slave will not be started
 source include/have_log_bin.inc;
 

=== modified file 'mysql-test/r/archive_gis.result'
--- a/mysql-test/r/archive_gis.result	2009-02-10 14:51:18 +0000
+++ b/mysql-test/r/archive_gis.result	2009-06-24 19:39:33 +0000
@@ -324,11 +324,6 @@ fid	IsClosed(g)
 114	0
 115	0
 116	0
-SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
-fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
-119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon ORDER by fid;
 fid	Area(g)
 117	1684.5

=== modified file 'mysql-test/r/gis.result'
--- a/mysql-test/r/gis.result	2009-04-29 03:50:14 +0000
+++ b/mysql-test/r/gis.result	2009-06-25 11:45:53 +0000
@@ -316,11 +316,6 @@ fid	IsClosed(g)
 114	0
 115	0
 116	0
-SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon;
-fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
-119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon;
 fid	Area(g)
 117	1684.5
@@ -652,10 +647,6 @@ select object_id, geometrytype(geo), ISS
 t1 where object_id=85998;
 object_id	geometrytype(geo)	ISSIMPLE(GEO)	ASTEXT(centroid(geo))
 85998	MULTIPOLYGON	0	POINT(115.31877315203187 -36.23747282102153)
-select object_id, geometrytype(geo), ISSIMPLE(GEO), ASTEXT(centroid(geo)) from
-t1 where object_id=85984;
-object_id	geometrytype(geo)	ISSIMPLE(GEO)	ASTEXT(centroid(geo))
-85984	MULTIPOLYGON	0	POINT(-114.87787186923313 36.33101763469049)
 drop table t1;
 create table t1 (fl geometry not null);
 insert into t1 values (1);

=== modified file 'mysql-test/r/innodb_gis.result'
--- a/mysql-test/r/innodb_gis.result	2009-02-10 14:51:18 +0000
+++ b/mysql-test/r/innodb_gis.result	2009-06-24 19:39:33 +0000
@@ -324,11 +324,6 @@ fid	IsClosed(g)
 114	0
 115	0
 116	0
-SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
-fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
-119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon ORDER by fid;
 fid	Area(g)
 117	1684.5

=== modified file 'mysql-test/suite/backup/r/backup_no_engine.result'
--- a/mysql-test/suite/backup/r/backup_no_engine.result	2008-10-07 17:15:44 +0000
+++ b/mysql-test/suite/backup/r/backup_no_engine.result	2009-06-18 11:28:01 +0000
@@ -1,12 +1,14 @@
 DROP DATABASE IF EXISTS db;
 CREATE DATABASE db;
-CREATE TABLE db.t1 (a int, b char(32))
-ENGINE=MYISAM;
+CREATE TABLE db.t1 (a int, b char(32));
+SHOW TABLES IN db;
+Tables_in_db
+t1
+t2
 BACKUP DATABASE db TO "db.backup";
 backup_id
 #
 DROP DATABASE db;
-CREATE DATABASE db;
 RESTORE FROM "db.backup";
 backup_id
 #

=== modified file 'mysql-test/suite/backup/t/backup_db_grants.test'
--- a/mysql-test/suite/backup/t/backup_db_grants.test	2009-03-04 10:20:21 +0000
+++ b/mysql-test/suite/backup/t/backup_db_grants.test	2009-06-24 19:39:33 +0000
@@ -110,7 +110,7 @@ SHOW GRANTS FOR 'bup_user3'@'%';
 --error ER_NONEXISTING_GRANT
 SHOW GRANTS FOR 'no_user'@'%';
 
-#
+# -- [DISABLED Bug#39016]
 # Section of test disabled due to errors in PB. See BUG#39016
 #
 #--echo Now demonstrate what happens when grants are altered in backup image.

=== modified file 'mysql-test/suite/backup/t/backup_no_engine.test'
--- a/mysql-test/suite/backup/t/backup_no_engine.test	2009-02-24 20:57:21 +0000
+++ b/mysql-test/suite/backup/t/backup_no_engine.test	2009-06-18 11:28:01 +0000
@@ -13,19 +13,19 @@ DROP DATABASE IF EXISTS db;
 --enable_warnings
 
 CREATE DATABASE db;
-CREATE TABLE db.t1 (a int, b char(32))
-;
+CREATE TABLE db.t1 (a int, b char(32));
 
 # copy description of a table using non-existent storage engine
 copy_file $table_def $MYSQLD_DATADIR/db/t2.frm;
 
+SHOW TABLES IN db;
+
 # backup test database, the table with no storage engine will be ignored
 --replace_column 1 #
 BACKUP DATABASE db TO "db.backup";
 
 # wipe-out backed-up database
 DROP DATABASE db;
-CREATE DATABASE db;
 
 --replace_column 1 #
 RESTORE FROM "db.backup";

=== modified file 'mysql-test/suite/backup/t/backup_objects_dependency.test'
--- a/mysql-test/suite/backup/t/backup_objects_dependency.test	2009-03-11 01:14:44 +0000
+++ b/mysql-test/suite/backup/t/backup_objects_dependency.test	2009-06-24 19:39:33 +0000
@@ -432,7 +432,7 @@ SHOW CREATE TABLE ob3.tp;
 SHOW CREATE TABLE ob2.t23;
 SHOW CREATE TABLE ob3.tp;
 
-#
+# -- [DISABLED Bug#43549]
 # BUG#43549 This portion disabled because the firing of the event is
 #           non-deterministic.
 #
@@ -528,7 +528,7 @@ SHOW CREATE TABLE ob3.tp;
 SHOW CREATE TABLE ob2.t23;
 SHOW CREATE TABLE ob3.tp;
 
-#
+# -- [DISABLED Bug#43549]
 # BUG#43549 This portion disabled because the firing of the event is
 #           non-deterministic.
 #
@@ -646,7 +646,7 @@ INSERT INTO ob3.t32 VALUES(97);
 SELECT * FROM ob3.t32;
 SELECT * FROM ob1.t14;
 
-#
+# -- [DISABLED Bug#43549]
 # BUG#43549 This portion disabled because the firing of the event is
 #           non-deterministic.
 #
@@ -739,7 +739,7 @@ Let $db=ob3;
 --error ER_NO_SUCH_TABLE
 CALL ob3.fire('user3 created');
 
-#
+# -- [DISABLED Bug#43549]
 # BUG#43549 This portion disabled because the firing of the event is
 #           non-deterministic.
 #

=== modified file 'mysql-test/suite/backup/t/disabled.def'
--- a/mysql-test/suite/backup/t/disabled.def	2009-04-03 17:58:04 +0000
+++ b/mysql-test/suite/backup/t/disabled.def	2009-06-25 09:29:53 +0000
@@ -1,4 +1,4 @@
-|##############################################################################
+##############################################################################
 #
 #  List the test cases that are to be disabled temporarily.
 #
@@ -9,5 +9,4 @@
 #  Do not use any TAB characters for whitespace.
 #
 ##############################################################################
-backup_no_engine              : Bug#36021 2008-04-13 rsomla server crashes when openning table with unknown storage engine
 backup_no_data                : Bug#42756 2009-02-11 jorgen Test db state not preserved 

=== modified file 'mysql-test/suite/backup_engines/t/backup_partitioning.test'
--- a/mysql-test/suite/backup_engines/t/backup_partitioning.test	2009-03-12 19:50:43 +0000
+++ b/mysql-test/suite/backup_engines/t/backup_partitioning.test	2009-06-24 19:39:33 +0000
@@ -193,6 +193,7 @@ ALTER TABLE `ê` PARTITION BY KEY(DOB) P
 #Bug#20129
 #We can include these operations in the test case once this bug is fixed.
 
+# -- [DISABLED Bug#45712]
 #Bug#38784 Mysql server crash if table is altered with partition changes.
 #This happens only in Windows OS. The # can be removed once the bug#38784
 #is fixed.

=== modified file 'mysql-test/suite/funcs_1/r/storedproc.result'
--- a/mysql-test/suite/funcs_1/r/storedproc.result	2009-06-12 09:37:59 +0000
+++ b/mysql-test/suite/funcs_1/r/storedproc.result	2009-06-24 19:39:33 +0000
@@ -16797,18 +16797,12 @@ BEGIN
 set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
 return f1;
 END//
-SELECT fn50(4.29e+09);
-fn50(4.29e+09)
-4290000000
 DROP FUNCTION IF EXISTS fn51;
 CREATE FUNCTION fn51( f1 int unsigned zerofill) returns int unsigned zerofill
 BEGIN
 set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
 return f1;
 END//
-SELECT fn51(4.29e+09);
-fn51(4.29e+09)
-4290000000
 DROP FUNCTION IF EXISTS fn52;
 CREATE FUNCTION fn52( f1 int zerofill) returns int zerofill
 BEGIN
@@ -17928,18 +17922,12 @@ BEGIN
 set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
 SELECT f1;
 END//
-CALL sp50(4.29e+09);
-f1
-4290000000
 DROP PROCEDURE IF EXISTS sp51;
 CREATE PROCEDURE sp51( f1 int unsigned zerofill)
 BEGIN
 set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
 SELECT f1;
 END//
-CALL sp51(4.29e+09);
-f1
-4290000000
 DROP PROCEDURE IF EXISTS sp52;
 CREATE PROCEDURE sp52( f1 int zerofill)
 BEGIN
@@ -21390,11 +21378,6 @@ set var7 = -9.22e+18;
 CALL sp81(4.29e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e+18, var7, var8);
 SELECT var1, var2, var3, var4, var5, var6, var7, var8;
 END//
-CALL spexecute81();
-f1	f2	f3	f4	f5	f6	f7	f8	f9	f10	f11	f12
-4290000000	4290000000	4290000010	-9220000000000000000	6744073709551616	6744073709551616	-9220000000000000000	6744073709551616	6744073709551616	-9220000000000000000	6744073709551616	6744073709551616
-var1	var2	var3	var4	var5	var6	var7	var8
-4290000000	4290000010	6744073709551616	6744073709551616	6744073709551616	6744073709551616	6744073709551616	6744073709551616
 DROP PROCEDURE spexecute81;
 DROP PROCEDURE sp81;
 DROP PROCEDURE IF EXISTS sp82;
@@ -21424,11 +21407,6 @@ set var7 = -9.22e+18;
 CALL sp82(4.29e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e+18, var7, var8);
 SELECT var1, var2, var3, var4, var5, var6, var7, var8;
 END//
-CALL spexecute82();
-f1	f2	f3	f4	f5	f6	f7	f8	f9	f10	f11	f12
-4290000000	4290000000	4290000010	-9220000000000000000	6744073709551616	6744073709551616	-9220000000000000000	6744073709551616	6744073709551616	-9220000000000000000	6744073709551616	6744073709551616
-var1	var2	var3	var4	var5	var6	var7	var8
-4290000000	4290000010	6744073709551616	6744073709551616	6744073709551616	6744073709551616	6744073709551616	6744073709551616
 DROP PROCEDURE spexecute82;
 DROP PROCEDURE sp82;
 DROP PROCEDURE IF EXISTS sp83;

=== modified file 'mysql-test/suite/funcs_1/t/storedproc.test'
--- a/mysql-test/suite/funcs_1/t/storedproc.test	2009-06-09 16:22:40 +0000
+++ b/mysql-test/suite/funcs_1/t/storedproc.test	2009-06-24 19:39:33 +0000
@@ -444,6 +444,7 @@ BEGIN
 END//
 delimiter ;//
 
+# -- [DISABLED Bug#33396]
 # warnings for this select disabled due to diffs with/without --ps-protocol:
 # without ps-protocol the following warning is shown:
 # +Note   1291    Column '' has duplicated value 'value1' in SET
@@ -468,6 +469,7 @@ BEGIN
 END//
 delimiter ;//
 
+# -- [DISABLED Bug#33396]
 # warnings for this select disabled due to diffs with/without --ps-protocol:
 # without ps-protocol the following warning is shown:
 # +Note   1291    Column '' has duplicated value 'value1' in SET
@@ -20541,7 +20543,8 @@ BEGIN
 END//
 delimiter ;//
 
-SELECT fn50(4.29e+09);
+# -- [DISABLED Bug#45293]
+# SELECT fn50(4.29e+09);
 
 
 --disable_warnings
@@ -20556,7 +20559,8 @@ BEGIN
 END//
 delimiter ;//
 
-SELECT fn51(4.29e+09);
+# -- [DISABLED Bug#45293]
+# SELECT fn51(4.29e+09);
 
 
 --disable_warnings
@@ -22139,7 +22143,8 @@ BEGIN
 END//
 delimiter ;//
 
-CALL sp50(4.29e+09);
+# -- [DISABLED Bug#45293]
+# CALL sp50(4.29e+09);
 
 --disable_warnings
 DROP PROCEDURE IF EXISTS sp51;
@@ -22153,7 +22158,8 @@ BEGIN
 END//
 delimiter ;//
 
-CALL sp51(4.29e+09);
+# -- [DISABLED Bug#45293]
+# CALL sp51(4.29e+09);
 
 --disable_warnings
 DROP PROCEDURE IF EXISTS sp52;
@@ -26122,7 +26128,8 @@ BEGIN
 END//
 delimiter ;//
 
-CALL spexecute81();
+# -- [DISABLED Bug#45293]
+# CALL spexecute81();
 DROP PROCEDURE spexecute81;
 DROP PROCEDURE sp81;
 
@@ -26160,7 +26167,8 @@ BEGIN
 END//
 delimiter ;//
 
-CALL spexecute82();
+# -- [DISABLED Bug#45293]
+# CALL spexecute82();
 DROP PROCEDURE spexecute82;
 DROP PROCEDURE sp82;
 

=== modified file 'mysql-test/suite/ndb/r/ndb_gis.result'
--- a/mysql-test/suite/ndb/r/ndb_gis.result	2009-02-14 16:10:30 +0000
+++ b/mysql-test/suite/ndb/r/ndb_gis.result	2009-06-25 12:11:17 +0000
@@ -324,11 +324,6 @@ fid	IsClosed(g)
 114	0
 115	0
 116	0
-SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
-fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
-119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon ORDER by fid;
 fid	Area(g)
 117	1684.5
@@ -876,11 +871,6 @@ fid	IsClosed(g)
 114	0
 115	0
 116	0
-SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
-fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
-119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon ORDER by fid;
 fid	Area(g)
 117	1684.5

=== modified file 'mysql-test/suite/ndb/t/disabled.def'
--- a/mysql-test/suite/ndb/t/disabled.def	2009-03-06 22:17:00 +0000
+++ b/mysql-test/suite/ndb/t/disabled.def	2009-06-24 19:39:33 +0000
@@ -14,5 +14,5 @@ ndb_partition_error2	  : Bug#40989 msven
 # the below testcase have been reworked to avoid the bug, test contains comment, keep bug open
 #ndb_binlog_ddl_multi     : BUG#18976 2006-04-10 kent    CRBR: multiple binlog, second binlog may miss schema log events
 ndb_cache_trans           : Bug#42565 ndb_cache_trans failure since SERVER_STATUS_IN_TRANS added to hash key
-ndb_alter_table_online    : WL#4284: Needs to be reworked, tries to alter table used by a pending transaction.
-ndb_alter_table3          : WL#4284: Needs to be reworked, tries to alter table used by a pending transaction.
+ndb_alter_table_online    : Bug#45621 2009-06-19 alik A few test files are disabled due to WL#4284
+ndb_alter_table3          : Bug#45621 2009-06-10 alik A few test files are disabled due to WL#4284

=== modified file 'mysql-test/suite/ndb/t/ndb_basic.test'
--- a/mysql-test/suite/ndb/t/ndb_basic.test	2008-10-15 12:14:27 +0000
+++ b/mysql-test/suite/ndb/t/ndb_basic.test	2009-06-24 19:39:33 +0000
@@ -6,6 +6,7 @@ DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t
 drop database if exists mysqltest;
 --enable_warnings
 
+# -- [DISABLED Bug#45709]
 # workaround for bug#16445
 # remove to reproduce bug and run tests from ndb start
 # and with ndb_autodiscover disabled. Fails on Linux 50 % of the times

=== modified file 'mysql-test/suite/ndb/t/ndb_index.test'
--- a/mysql-test/suite/ndb/t/ndb_index.test	2007-07-04 20:38:53 +0000
+++ b/mysql-test/suite/ndb/t/ndb_index.test	2009-06-24 19:39:33 +0000
@@ -43,6 +43,8 @@ select port, accessnode, pop, accesstype
 select port, accessnode, pop, accesstype  from t1 where pop='pop98';
 select port, accessnode, pop, accesstype  from t1 where pop='pop98';
 select port, accessnode, pop, accesstype  from t1 where pop='pop98' order by accesstype;
+
+# -- [DISABLED Bug#45720]
 # The following two querys will not return any rows since 
 # the index used for access is case sensitive
 # They are thus disabled for now

=== modified file 'mysql-test/suite/ndb/t/ndb_index_ordered.test'
--- a/mysql-test/suite/ndb/t/ndb_index_ordered.test	2009-03-06 22:17:00 +0000
+++ b/mysql-test/suite/ndb/t/ndb_index_ordered.test	2009-06-24 19:39:33 +0000
@@ -334,6 +334,7 @@ select count(*)- 4 from t1 use index (v)
 drop table t1;
 
 #
+# -- [DISABLED Bug#45721]
 # Disabled due to WL#4284
 #
 # Needs to be reworked. It's not possible anymore to do a non-fast alter table

=== modified file 'mysql-test/suite/ndb_binlog/t/ndb_binlog_basic.test'
--- a/mysql-test/suite/ndb_binlog/t/ndb_binlog_basic.test	2009-01-29 12:44:41 +0000
+++ b/mysql-test/suite/ndb_binlog/t/ndb_binlog_basic.test	2009-06-24 19:39:33 +0000
@@ -48,6 +48,7 @@ select inserts,updates,deletes from 
   mysql.ndb_binlog_index where epoch > @max_epoch and updates > 0;
 
 #
+# -- [DISABLED Bug#45722]
 # check that purge clears the ndb_binlog_index
 #
 # TODO: make this deterministic

=== modified file 'mysql-test/suite/ndb_team/t/ndb_autodiscover.test'
--- a/mysql-test/suite/ndb_team/t/ndb_autodiscover.test	2009-02-20 13:35:24 +0000
+++ b/mysql-test/suite/ndb_team/t/ndb_autodiscover.test	2009-06-24 19:39:33 +0000
@@ -1,6 +1,7 @@
 -- source include/have_ndb.inc
 -- source include/not_embedded.inc
 
+# -- [DISABLED Bug#41308]
 # Bug#41308: Test main.ndb_autodiscover.test doesn't work on Windows due
 #            to 'grep' calls
 # Test is currently disabled on Windows via the next line until this bug
@@ -510,6 +511,7 @@ drop database test_only_ndb_tables;
 # a table with tha same name as a table that can't be
 # discovered( for example a table created via NDBAPI)
 
+# -- [DISABLED Bug#45725]
 # Test disabled since it doesn't work on case insensitive systems
 #--error ER_TABLE_EXISTS_ERROR
 #CREATE TABLE sys.SYSTAB_0 (a int);

=== modified file 'mysql-test/suite/parts/inc/part_supported_sql_funcs_main.inc'
--- a/mysql-test/suite/parts/inc/part_supported_sql_funcs_main.inc	2007-11-20 15:04:07 +0000
+++ b/mysql-test/suite/parts/inc/part_supported_sql_funcs_main.inc	2009-06-24 19:39:33 +0000
@@ -48,6 +48,7 @@ let $val1 =  5.1230;
 let $val2 = 13.345;
 let $val3 = 17.987;
 let $val4 = 15.654 ;
+# -- [DISABLED Bug#45717]
 # DISABLED due to bug 30577
 #--source suite/parts/inc/partition_supported_sql_funcs.inc
 
@@ -59,6 +60,7 @@ let $val1 =  5.1230;
 let $val2 = 13.345;
 let $val3 = 17.987;
 let $val4 = 15.654 ;
+# -- [DISABLED Bug#45717]
 # DISABLED due to bug 30577
 #--source suite/parts/inc/partition_supported_sql_funcs.inc
 

=== modified file 'mysql-test/suite/parts/inc/partition_decimal.inc'
--- a/mysql-test/suite/parts/inc/partition_decimal.inc	2008-02-06 14:13:56 +0000
+++ b/mysql-test/suite/parts/inc/partition_decimal.inc	2009-06-24 19:39:33 +0000
@@ -35,6 +35,7 @@ dec $count;
 select count(*) from t2;
 drop table t2;
 
+# -- [DISABLED Bug#45717]
 # Bug 30577: FLOOR() and CEILING() not usable as partition functions
 # Partition functions are required to return INT_RESULT; FLOOR() and
 # CEILING() do not, unless they have an INT argument.  Disable this

=== modified file 'mysql-test/suite/parts/inc/partition_double.inc'
--- a/mysql-test/suite/parts/inc/partition_double.inc	2008-02-06 14:13:56 +0000
+++ b/mysql-test/suite/parts/inc/partition_double.inc	2009-06-24 19:39:33 +0000
@@ -36,6 +36,7 @@ select count(*) from t2;
 drop table t2;
 
 
+# -- [DISABLED Bug#45717]
 # Bug 30577: FLOOR() and CEILING() not usable as partition functions
 # Partition functions are required to return INT_RESULT; FLOOR() and
 # CEILING() do not, unless they have an INT argument.  Disable this

=== modified file 'mysql-test/suite/parts/inc/partition_float.inc'
--- a/mysql-test/suite/parts/inc/partition_float.inc	2008-02-06 14:13:56 +0000
+++ b/mysql-test/suite/parts/inc/partition_float.inc	2009-06-24 19:39:33 +0000
@@ -39,6 +39,7 @@ dec $count;
 select count(*) from t2;
 drop table t2;
 
+# -- [DISABLED Bug#45717]
 # Bug 30577: FLOOR() and CEILING() not usable as partition functions
 # Partition functions are required to return INT_RESULT; FLOOR() and
 # CEILING() do not, unless they have an INT argument.  Disable this

=== modified file 'mysql-test/suite/parts/t/disabled.def'
--- a/mysql-test/suite/parts/t/disabled.def	2009-06-11 03:59:25 +0000
+++ b/mysql-test/suite/parts/t/disabled.def	2009-06-24 19:39:33 +0000
@@ -1,4 +1,4 @@
-partition_basic_ndb            : Bug#19899 Crashing the server (cannot create t1)
+partition_basic_ndb            : Bug#45710
 # http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations-syntax.html
 partition_syntax_ndb           : Bug#36735 Not supported
 ndb_dd_backuprestore           : Bug#32659 2008-07-14 alik  Disabled to make 6.0 greaner (the test fails too often)

=== modified file 'mysql-test/suite/rpl/t/disabled.def'
--- a/mysql-test/suite/rpl/t/disabled.def	2009-06-11 14:24:28 +0000
+++ b/mysql-test/suite/rpl/t/disabled.def	2009-06-24 19:39:33 +0000
@@ -15,6 +15,6 @@ rpl_extraColmaster_myisam  : BUG#40796 2
 rpl_cross_version          : BUG#42311 2009-03-27 joro rpl_cross_version fails on macosx
 rpl_heartbeat_basic        : Bug#43828 Sporadic failures (Serge.Kozlov@sun.com)
 rpl_heartbeat_2slaves      : Bug#43828 Sporadic failures (Serge.Kozlov@stripped)
-rpl_failed_optimize        : WL#4284: Can't optimize table used by a pending transaction (there is metadata lock on the table).
-rpl_read_only              : WL#4284: Setting Read only won't succeed until all metadata locks are released.
-rpl_init_slave         : Bug#44920 2009-05-18 pcrews MTR2 is not processing master.opt input properly on Windows
+rpl_failed_optimize        : Bug#44938 Replication fails when optimizing a table used by pending transaction.
+rpl_read_only              : Bug#44958 Setting read_only won't succeed if tx is already started in different connection
+rpl_init_slave             : Bug#44920 2009-05-18 pcrews MTR2 is not processing master.opt input properly on Windows

=== modified file 'mysql-test/suite/rpl/t/rpl_backup_multi.test'
--- a/mysql-test/suite/rpl/t/rpl_backup_multi.test	2009-05-26 22:21:34 +0000
+++ b/mysql-test/suite/rpl/t/rpl_backup_multi.test	2009-06-24 19:39:33 +0000
@@ -9,6 +9,9 @@
 --source include/not_embedded.inc
 --source include/have_innodb.inc
 
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
 # Set up multi master-slave configuration
 --source suite/rpl/include/rpl_backup_multi.inc
 

=== modified file 'mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test'
--- a/mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test	2008-10-29 17:40:17 +0000
+++ b/mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.test	2009-06-24 19:39:33 +0000
@@ -6,6 +6,10 @@
 # AUTO_INCREMENT_OFFSET variables and failover
 #############################################################
 --source include/have_innodb.inc
+
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
 # Use wait_for_slave_to_(start|stop) for current connections
 let $keep_connection= 1;
 

=== modified file 'mysql-test/suite/rpl/t/rpl_cross_version.test'
--- a/mysql-test/suite/rpl/t/rpl_cross_version.test	2009-02-16 12:51:39 +0000
+++ b/mysql-test/suite/rpl/t/rpl_cross_version.test	2009-06-24 19:39:33 +0000
@@ -12,6 +12,7 @@
 
 --source include/have_log_bin.inc
 
+# -- [DISABLED Bug#42879]
 # The test is disabled for windows due to 
 # Bug #42879 CHANGE MASTER RELAY_LOG_FILE=path fails on windows
 # Todo: release it from not_windows

=== modified file 'mysql-test/suite/rpl/t/rpl_extraCol_innodb.test'
--- a/mysql-test/suite/rpl/t/rpl_extraCol_innodb.test	2007-06-27 12:28:02 +0000
+++ b/mysql-test/suite/rpl/t/rpl_extraCol_innodb.test	2009-06-25 12:33:12 +0000
@@ -9,5 +9,3 @@
 -- source include/master-slave.inc
 let $engine_type = 'InnoDB';
 -- source extra/rpl_tests/rpl_extraSlave_Col.test
-
-

=== modified file 'mysql-test/suite/rpl/t/rpl_extraCol_myisam.test'
--- a/mysql-test/suite/rpl/t/rpl_extraCol_myisam.test	2007-06-27 12:28:02 +0000
+++ b/mysql-test/suite/rpl/t/rpl_extraCol_myisam.test	2009-06-25 12:33:12 +0000
@@ -4,9 +4,8 @@
 # Purpose: Wapper for rpl_extraSlave_Col.test
 #          Using MyISAM
 ########################################### 
+
 -- source include/have_binlog_format_row.inc
 -- source include/master-slave.inc
 let $engine_type = 'MyISAM';
 -- source extra/rpl_tests/rpl_extraSlave_Col.test
-
-

=== modified file 'mysql-test/suite/rpl/t/rpl_killed_ddl.test'
--- a/mysql-test/suite/rpl/t/rpl_killed_ddl.test	2009-04-08 23:42:51 +0000
+++ b/mysql-test/suite/rpl/t/rpl_killed_ddl.test	2009-06-24 19:39:33 +0000
@@ -144,6 +144,7 @@ let $diff_statement= SHOW DATABASES LIKE
 send CREATE DATABASE d2;
 source include/kill_query_and_diff_master_slave.inc;
 
+# -- [DISABLED Bug#44041]
 # Temporarily disabled, see BUG#44041, the ALTER DATABASE can affect the
 # collation of other database on slave
 #send ALTER DATABASE d1
@@ -166,6 +167,7 @@ send CREATE EVENT e2
   DO INSERT INTO test.t1 VALUES (2);
 source include/kill_query_and_diff_master_slave.inc;
 
+# -- [DISABLED Bug#44171]
 # Temporarily disabled because of BUG#44171, killing ALTER EVENT can
 # crash the server
 #send ALTER EVENT e1
@@ -197,6 +199,7 @@ source include/kill_query_and_diff_maste
 # function f2 probably does not exist because the CREATE query was
 # killed
 #
+# -- [DISABLED Bug#43353]
 # Temporarily disabled. Because of BUG#43353, KILL the query may
 # result in function not found, and for 5.1, DROP statements will be
 # logged if the function is not found on master, so the following DROP
@@ -256,6 +259,7 @@ source include/kill_query_and_diff_maste
 
 ######## SERVER ########
 
+# -- [DISABLED Bug#25705]
 # Tempoarily disabled, see bug#25705
 
 # let $diff_statement= SELECT * FROM mysql.server WHERE name like 's%';

=== modified file 'mysql-test/suite/rpl/t/rpl_row_colSize.test'
--- a/mysql-test/suite/rpl/t/rpl_row_colSize.test	2007-08-10 16:48:01 +0000
+++ b/mysql-test/suite/rpl/t/rpl_row_colSize.test	2009-06-24 19:39:33 +0000
@@ -6,6 +6,9 @@
 # having columns that are smaller (shorter) than the slave.      #
 ##################################################################
 
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
 -- source include/master-slave.inc
 -- source include/have_binlog_format_row.inc
 

=== modified file 'mysql-test/suite/rpl/t/rpl_row_create_table.test'
--- a/mysql-test/suite/rpl/t/rpl_row_create_table.test	2009-02-02 15:58:48 +0000
+++ b/mysql-test/suite/rpl/t/rpl_row_create_table.test	2009-06-24 19:39:33 +0000
@@ -1,6 +1,9 @@
 # Testing table creations for row-based replication.
-
 --source include/have_binlog_format_row.inc
+
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
 --source include/master-slave.inc
 --source include/have_innodb.inc
 connection slave;

=== modified file 'mysql-test/suite/rpl/t/rpl_row_mysqlbinlog.test'
--- a/mysql-test/suite/rpl/t/rpl_row_mysqlbinlog.test	2009-04-28 22:19:38 +0000
+++ b/mysql-test/suite/rpl/t/rpl_row_mysqlbinlog.test	2009-06-24 19:39:33 +0000
@@ -181,8 +181,6 @@ select "--- Test 3 First Remote test --"
 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
 --exec $MYSQL_BINLOG --short-form --local-load=$MYSQLTEST_VARDIR/tmp/ --stop-position=569 --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001
 
-# This part is disabled due to bug #17654
-
 --disable_query_log
 select "--- Test 4 Second Remote test --" as "";
 --enable_query_log

=== modified file 'mysql-test/suite/rpl/t/rpl_stm_log.test'
--- a/mysql-test/suite/rpl/t/rpl_stm_log.test	2007-06-27 12:29:10 +0000
+++ b/mysql-test/suite/rpl/t/rpl_stm_log.test	2009-06-24 19:39:33 +0000
@@ -1,5 +1,10 @@
 # Requires statement logging
+
 -- source include/have_binlog_format_mixed_or_statement.inc
+
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
 -- source include/master-slave.inc
 let $engine_type=MyISAM;
 -- source extra/rpl_tests/rpl_log.test

=== modified file 'mysql-test/suite/rpl/t/rpl_temporary.test'
--- a/mysql-test/suite/rpl/t/rpl_temporary.test	2009-05-22 23:44:08 +0000
+++ b/mysql-test/suite/rpl/t/rpl_temporary.test	2009-06-24 19:39:33 +0000
@@ -1,6 +1,9 @@
 # Test need anonymous user when connection are made as "zedjzlcsjhd"
 source include/add_anonymous_users.inc;
 
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
 -- source include/master-slave.inc
 
 # Clean up old slave's binlogs.

=== modified file 'mysql-test/suite/rpl/t/rpl_truncate_3innodb.test'
--- a/mysql-test/suite/rpl/t/rpl_truncate_3innodb.test	2007-06-27 12:28:02 +0000
+++ b/mysql-test/suite/rpl/t/rpl_truncate_3innodb.test	2009-06-24 19:39:33 +0000
@@ -2,5 +2,9 @@
 --source include/have_innodb.inc
 --source include/not_ndb_default.inc
 
+# -- [DISABLED Bug#45238]
+--source include/not_windows.inc
+
+
 let $engine=InnoDB;
 --source extra/rpl_tests/rpl_truncate.test

=== modified file 'mysql-test/suite/sys_vars/inc/timestamp_basic.inc'
--- a/mysql-test/suite/sys_vars/inc/timestamp_basic.inc	2009-02-03 09:16:53 +0000
+++ b/mysql-test/suite/sys_vars/inc/timestamp_basic.inc	2009-06-24 19:39:33 +0000
@@ -102,6 +102,7 @@ SET @@timestamp = 9999999999999999999999
 #     Check if the value in SESSION Table matches value in variable     #
 #########################################################################
 
+# -- [DISABLED Bug#41584]
 # disabled due to bug#41584
 #SELECT @@timestamp = VARIABLE_VALUE 
 #FROM INFORMATION_SCHEMA.SESSION_VARIABLES 

=== modified file 'mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test'
--- a/mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test	2008-12-19 15:12:15 +0000
+++ b/mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test	2009-06-24 19:39:33 +0000
@@ -127,6 +127,7 @@ disconnect conUser1;
 
 SET GLOBAL automatic_sp_privileges = @global_automatic_sp_privileges;
 
+# -- [DISABLED Bug#35384]
 # Disabled due to differences in results: Bug#35384
 #SHOW GRANTS FOR 'userTest'@'localhost';
 

=== modified file 'mysql-test/suite/sys_vars/t/disabled.def'
--- a/mysql-test/suite/sys_vars/t/disabled.def	2009-04-03 09:30:07 +0000
+++ b/mysql-test/suite/sys_vars/t/disabled.def	2009-06-25 10:58:03 +0000
@@ -11,7 +11,6 @@
 ##############################################################################
 query_cache_size_basic_32           : Bug#36747: Allocating a large query cache is not deterministic
 query_cache_size_basic_64           : Bug#36747: Allocating a large query cache is not deterministic
-max_heap_table_size_basic_32        : Bug#36877: main.max_heap_table_size_basic_32 fails on some systems
 #thread_cache_size_func             : Bug#40575: 2008-11-07 joro main.thread_cache_size_func fails in pushbuild when run with pool of threads
 log_output_basic                    : Bug#40988: log_output_basic.test succeeded though syntactically false.
 

=== modified file 'mysql-test/suite/sys_vars/t/foreign_key_checks_func.test'
--- a/mysql-test/suite/sys_vars/t/foreign_key_checks_func.test	2008-12-19 15:12:15 +0000
+++ b/mysql-test/suite/sys_vars/t/foreign_key_checks_func.test	2009-06-24 19:39:33 +0000
@@ -112,6 +112,7 @@ ALTER TABLE t2 DROP FOREIGN KEY fk;
 
 SET @@session.foreign_key_checks = 1;
 
+# -- [DISABLED Bug#45726]
 # Test disabled as error description is different. The resulting description has
 # difference in code #sql-xxx_2 where xxx is different for each run.
 #--Error ER_NO_REFERENCED_ROW_2

=== modified file 'mysql-test/t/csv_not_null.test'
--- a/mysql-test/t/csv_not_null.test	2009-02-05 09:49:32 +0000
+++ b/mysql-test/t/csv_not_null.test	2009-06-24 19:39:33 +0000
@@ -55,6 +55,7 @@ INSERT INTO t1 VALUES();
 SELECT * FROM t1;
 
 -- disable_warnings
+# -- [DISABLED Bug#33717]
 # NOTE - Test disabled due to enum crash for this INSERT
 # See Bug#33717 - INSERT...(default) fails for enum. 
 # Crashes CSV tables, loads spaces for MyISAM

=== modified file 'mysql-test/t/ctype_ldml.test'
--- a/mysql-test/t/ctype_ldml.test	2009-06-08 14:58:33 +0000
+++ b/mysql-test/t/ctype_ldml.test	2009-06-24 19:39:33 +0000
@@ -1,12 +1,5 @@
 --source include/have_ucs2.inc
 
-#
-# Disabled due to WL#1213 removal
-#
-# --source include/have_utf16.inc
-# --source include/have_utf32.inc
-
-
 --disable_warnings
 drop table if exists t1;
 --enable_warnings

=== modified file 'mysql-test/t/ctype_utf8.test'
--- a/mysql-test/t/ctype_utf8.test	2009-06-11 09:13:52 +0000
+++ b/mysql-test/t/ctype_utf8.test	2009-06-24 19:39:33 +0000
@@ -1449,33 +1449,6 @@ DROP TABLE t1;
 --echo End of 5.0 tests
 
 #
-# Disabled due to removal of WL#1213.
-#
-# #
-# # Bug#32914 Character sets: illegal characters in utf8 and utf32 columns
-# #
-# create table t1 (utf8 char(1) character set utf8);
-# --echo Testing [F0][90..BF][80..BF][80..BF]
-# insert into t1 values (0xF0908080);
-# insert into t1 values (0xF0BFBFBF);
-# insert into t1 values (0xF08F8080);
-# select hex(utf8) from t1;
-# delete from t1;
-
-# --echo Testing [F2..F3][80..BF][80..BF][80..BF]
-# insert into t1 values (0xF2808080);
-# insert into t1 values (0xF2BFBFBF);
-# select hex(utf8) from t1;
-# delete from t1;
-
-# --echo Testing [F4][80..8F][80..BF][80..BF]
-# insert into t1 values (0xF4808080);
-# insert into t1 values (0xF48F8080);
-# insert into t1 values (0xF4908080);
-# select hex(utf8) from t1;
-# drop table t1;
-
-#
 # Bug#26474: Add Sinhala script (Sri Lanka) collation to MySQL
 #
 --disable_warnings
@@ -1541,19 +1514,4 @@ INSERT INTO t1 VALUES (19, x'E0B696'), (
 SELECT predicted_order, hex(utf8_encoding) FROM t1 ORDER BY utf8_encoding COLLATE utf8_sinhala_ci;
 DROP TABLE t1;
 
-#
-# Disabled due to removal of WL#1213.
-#
-# #
-# # Check that supplementary characters are not allowed in identifiers
-# #
-# --error 1300
-# CREATE DATABASE `𐀀`;
-# --error 1300
-# CREATE TABLE `𐀀` (a int);
-# --error 1166
-# CREATE TABLE test.t1 SELECT '𐀀';
-# --error 1300
-# CREATE USER `𐀀`;
-
 --echo End of tests

=== modified file 'mysql-test/t/disabled.def'
--- a/mysql-test/t/disabled.def	2009-06-11 14:24:28 +0000
+++ b/mysql-test/t/disabled.def	2009-06-25 11:50:39 +0000
@@ -15,3 +15,4 @@ innodb_bug39438      : Bug#42383 2009-01
 query_cache_28249    : Bug#43861 2009-03-25 main.query_cache_28249 fails sporadically
 information_schema   : Bug#42893 2009-03-26 alik main.information_schema times out sporadically
 init_connect         : Bug#44920 2009-05-18 pcrews MTR2 is not processing master.opt input properly on Windows
+skip_name_resolve    : Bug#43006 2009-06-25 alik main.skip_name_resolve fails on Windows in PB2

=== modified file 'mysql-test/t/gis.test'
--- a/mysql-test/t/gis.test	2009-04-29 03:50:14 +0000
+++ b/mysql-test/t/gis.test	2009-06-25 11:45:53 +0000
@@ -108,7 +108,8 @@ explain extended select AsText(Centroid(
 
 SELECT fid, IsClosed(g) FROM gis_multi_line;
 
-SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon;
+# -- [DISABLED Bug#38092]
+# SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon;
 SELECT fid, Area(g) FROM gis_multi_polygon;
 
 SELECT fid, NumGeometries(g) from gis_multi_point;
@@ -359,12 +360,13 @@ insert into t1 values ('85984',GeomFromT
 select object_id, geometrytype(geo), ISSIMPLE(GEO), ASTEXT(centroid(geo)) from
 t1 where object_id=85998;
 
+# -- [DISABLED Bug#38092]
 # Expected results are -114.87787186923313 and 36.33101763469049, but IA64 
 # returns -114.87787186923326 and 36.33101763469043 due to fused multiply-add
 # instructions.
---replace_result -114.87787186923326 -114.87787186923313 36.33101763469043 36.33101763469049
-select object_id, geometrytype(geo), ISSIMPLE(GEO), ASTEXT(centroid(geo)) from
-t1 where object_id=85984;
+# --replace_result -114.87787186923326 -114.87787186923313 36.33101763469043 36.33101763469049
+# select object_id, geometrytype(geo), ISSIMPLE(GEO), ASTEXT(centroid(geo)) from
+# t1 where object_id=85984;
 
 drop table t1;
 

=== modified file 'mysql-test/t/index_merge_innodb.test'
--- a/mysql-test/t/index_merge_innodb.test	2006-09-18 14:55:56 +0000
+++ b/mysql-test/t/index_merge_innodb.test	2009-06-24 19:39:33 +0000
@@ -15,6 +15,7 @@ let $engine_type= InnoDB;
 # InnoDB does not support Merge tables (affects include/index_merge1.inc)
 let $merge_table_support= 0;
 
+# -- [DISABLED Bug#45727]
 # The first two tests are disabled because of non deterministic explain output.
 # If include/index_merge1.inc can be enabled for InnoDB and all other
 # storage engines, please remove the subtest for Bug#21277 from

=== modified file 'mysql-test/t/information_schema_db.test'
--- a/mysql-test/t/information_schema_db.test	2009-05-15 15:59:57 +0000
+++ b/mysql-test/t/information_schema_db.test	2009-06-24 19:39:33 +0000
@@ -1,5 +1,5 @@
 # this test mostly test privilege control (what doesn't work
-# in the embedded server by default). So disabled in embedded-server mode
+# in the embedded server by default). So skip the test in embedded-server mode.
 -- source include/not_embedded.inc
 
 -- source include/testdb_only.inc

=== modified file 'mysql-test/t/innodb_ctype_ldml.test'
--- a/mysql-test/t/innodb_ctype_ldml.test	2009-06-02 18:04:09 +0000
+++ b/mysql-test/t/innodb_ctype_ldml.test	2009-06-24 19:39:33 +0000
@@ -1,13 +1,6 @@
 --source include/have_innodb.inc
 --source include/have_ucs2.inc
 
-#
-# Disabled due to WL#1213 removal.
-#
-# --source include/have_utf16.inc
-# --source include/have_utf32.inc
-
-
 --disable_warnings
 drop table if exists t1;
 --enable_warnings

=== modified file 'mysql-test/t/mysqlbinlog-cp932.test'
--- a/mysql-test/t/mysqlbinlog-cp932.test	2007-12-12 17:19:24 +0000
+++ b/mysql-test/t/mysqlbinlog-cp932.test	2009-06-24 19:39:33 +0000
@@ -1,3 +1,4 @@
+# -- [DISABLED Bug#45728]
 # disabled in embedded until tools running is fixed with embedded
 --source include/not_embedded.inc
 

=== modified file 'mysql-test/t/mysqldump.test'
--- a/mysql-test/t/mysqldump.test	2009-05-29 16:22:30 +0000
+++ b/mysql-test/t/mysqldump.test	2009-06-24 19:39:33 +0000
@@ -1698,6 +1698,7 @@ DROP TABLE t1;
 # Added for use-thread option
 #
 
+# -- [DISABLED Bug#32991]
 # THIS PART OF THE TEST IS DISABLED UNTIL Bug#32991 IS FIXED
 if ($bug32991_fixed) {
 

=== modified file 'mysql-test/t/partition_mgm_err2.test'
--- a/mysql-test/t/partition_mgm_err2.test	2008-10-02 14:14:27 +0000
+++ b/mysql-test/t/partition_mgm_err2.test	2009-06-24 19:39:33 +0000
@@ -4,9 +4,8 @@
 --source include/have_partition.inc
 --source include/have_symlink.inc
 
-#
-# This test is disabled on windows due to BUG#19107
-#
+# -- [DISABLED Bug#33687]
+# This test is disabled on windows due to BUG#33687
 --source include/not_windows.inc
 #
 # BUG: 14354 Partitions: data directory clause fails

=== modified file 'mysql-test/t/partition_not_windows.test'
--- a/mysql-test/t/partition_not_windows.test	2009-02-02 15:58:48 +0000
+++ b/mysql-test/t/partition_not_windows.test	2009-06-24 19:39:33 +0000
@@ -4,7 +4,8 @@
 # DATA DIRECTORY/INDEX DIRECTORY require symbolic link support
 --source include/have_symlink.inc
 
-# The test for Bug 20770 is disabled on Windows due to BUG#19107; it
+# -- [DISABLED Bug#33687]
+# The test for Bug 20770 is disabled on Windows due to BUG#33687; it
 # should be moved into partition.test once the bug has been resolved.
 
 #

=== modified file 'mysql-test/t/ps.test'
--- a/mysql-test/t/ps.test	2009-05-29 08:09:00 +0000
+++ b/mysql-test/t/ps.test	2009-06-24 19:39:33 +0000
@@ -2795,7 +2795,7 @@ execute abc;
 deallocate prepare abc;
 drop table t1, t2;
 
-#
+# -- [DISABLED Bug#45716]
 # Bug #21422: GRANT/REVOKE possible inside stored function, probably in a trigger
 # This is disabled for now till it is resolved in 5.0
 #

=== modified file 'mysql-test/t/query_cache.test'
--- a/mysql-test/t/query_cache.test	2009-02-13 16:30:54 +0000
+++ b/mysql-test/t/query_cache.test	2009-06-24 19:39:33 +0000
@@ -1185,6 +1185,8 @@ set global query_cache_type=0;
 show status like 'Qcache_free_blocks';
 
 --echo Restore default values.
+#
+# -- [DISABLED Bug#45729]
 # Bug#28211 RENAME DATABASE and query cache don't play nicely together
 #
 # TODO: enable these tests when RENAME DATABASE is implemented.

=== modified file 'mysql-test/t/show_check.test'
--- a/mysql-test/t/show_check.test	2009-03-06 20:33:52 +0000
+++ b/mysql-test/t/show_check.test	2009-06-24 19:39:33 +0000
@@ -1,4 +1,4 @@
-# Uses GRANT commands that usually disabled in embedded server
+# Uses GRANT commands that are not available in embedded server
 -- source include/not_embedded.inc
 
 # check that CSV engine was compiled in, as the result of the test
@@ -362,6 +362,7 @@ delete from mysql.db
 where user='mysqltest_1' || user='mysqltest_2' || user='mysqltest_3';
 flush privileges;
 
+# -- [DISABLED Bug#45730]
 # This test fails on MAC OSX, so it is temporary disabled.
 # This needs WL#1324 to be done.
 #set names latin1;

=== modified file 'mysql-test/t/sp.test'
--- a/mysql-test/t/sp.test	2009-06-17 07:30:19 +0000
+++ b/mysql-test/t/sp.test	2009-06-24 19:39:33 +0000
@@ -3352,6 +3352,7 @@ begin
   select plus;
 end|
 
+# -- [DISABLED Bug#45707]
 # QQ: This is currently disabled. Not only does it slow down a normal test
 #     run, it makes running with valgrind (or similar tools) extremely
 #     painful.
@@ -4069,6 +4070,7 @@ drop procedure if exists bug7088_1|
 drop procedure if exists bug7088_2|
 --enable_warnings
 
+# -- [DISABLED Bug#45708]
 --disable_parsing # temporarily disabled until Bar fixes BUG#11986
 create procedure bug6063()
   lâbel: begin end|

=== modified file 'mysql-test/t/symlink.test'
--- a/mysql-test/t/symlink.test	2009-05-15 13:45:06 +0000
+++ b/mysql-test/t/symlink.test	2009-06-24 19:39:33 +0000
@@ -73,6 +73,7 @@ create database mysqltest;
 --error 1,1
 create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="/this-dir-does-not-exist";
 
+# -- [DISABLED Bug#45731]
 # temporarily disabled as it returns different result in the embedded server
 # --error ER_WRONG_ARGUMENTS, ER_WRONG_ARGUMENTS
 # create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="not-hard-path";

=== modified file 'mysql-test/t/trigger.test'
--- a/mysql-test/t/trigger.test	2009-06-16 12:27:49 +0000
+++ b/mysql-test/t/trigger.test	2009-06-24 19:39:33 +0000
@@ -862,6 +862,7 @@ select * from t1;
 drop trigger t1_bi;
 drop tables t1, t2;
 
+# -- [DISABLED Bug#45732]
 # Tests for bug #12704 "Server crashes during trigger execution".
 # If we run DML statements and CREATE TRIGGER statements concurrently
 # it may happen that trigger will be created while DML statement is

=== modified file 'sql/opt_range.cc'
--- a/sql/opt_range.cc	2009-06-09 16:53:34 +0000
+++ b/sql/opt_range.cc	2009-06-24 10:55:41 +0000
@@ -4862,13 +4862,14 @@ static TRP_RANGE *get_key_scans_params(P
       found_records= check_quick_select(param, idx, read_index_only, *key,
                                         update_tbl_stats, &mrr_flags,
                                         &buf_size, &cost);
-      found_read_time= cost.total_cost();
+
       if ((found_records != HA_POS_ERROR) && param->is_ror_scan)
       {
         tree->n_ror_scans++;
         tree->ror_scans_map.set_bit(idx);
       }
-      if (found_records != HA_POS_ERROR && read_time > found_read_time)
+      if (found_records != HA_POS_ERROR &&
+          read_time > (found_read_time= cost.total_cost()))
       {
         read_time=    found_read_time;
         best_records= found_records;

Attachment: [text/bzr-bundle] bzr/holyfoot@mysql.com-20090625111804-zkgex4vbiysyikxs.bundle
Thread
bzr commit into mysql-5.4 branch (holyfoot:3356)Alexey Botchkov25 Jun 2009