bzr commit into mysql-5.0-bugteam branch (timothy.smith:2777) Bug#32625

[Timothy Smith]

#At file:///home/tsmith/m/bzr/bugteam/50/ based on revid:timothy.smith@stripped

 2777 Timothy Smith	2009-03-11
      Bug #32625: Make test type_bit_innodb more robust
      
      Since there is more than one duplicate value in the table, when adding the
      unique index it is not deterministic which value will be reported as causing a
      problem.  Replace the reported value with '' so that it doesn't affect the
      results.

    modified:
      mysql-test/t/type_bit_innodb.test
=== modified file 'mysql-test/t/type_bit_innodb.test'
--- a/mysql-test/t/type_bit_innodb.test	2006-04-05 00:54:58 +0000
+++ b/mysql-test/t/type_bit_innodb.test	2009-03-11 20:54:57 +0000
@@ -40,7 +40,9 @@ drop table t1;
 create table t1 (a bit) engine=innodb;
 insert into t1 values (b'0'), (b'1'), (b'000'), (b'100'), (b'001');
 select hex(a) from t1;
---error 1062
+# It is not deterministic which duplicate will be seen first
+--replace_regex /(.*Duplicate entry )'.*'( for key.*)/\1''\2/
+--error ER_DUP_ENTRY
 alter table t1 add unique (a);
 drop table t1;
 


Attachment: [text/bzr-bundle] bzr/[e-mail]