From cf4814b39700fc0fe062519ad9090099540f79c0 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Tue, 5 Aug 2014 11:47:58 +0200 Subject: MDEV-6052 Inconsistent results with bit type Remove the "don't update the row for b'' and store uninitialized bytes on disk" change. Update test cases to allow DEFAULT b'', because b'' is a valid expression elsewhere. --- mysql-test/r/type_bit_innodb.result | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mysql-test/r/type_bit_innodb.result') diff --git a/mysql-test/r/type_bit_innodb.result b/mysql-test/r/type_bit_innodb.result index 9bdd8658690..80fc942e77c 100644 --- a/mysql-test/r/type_bit_innodb.result +++ b/mysql-test/r/type_bit_innodb.result @@ -413,3 +413,12 @@ a ` drop table t1; End of 5.0 tests +create table t1(f1 bit(2) not null default b'10',f2 bit(14) not null default b'11110000111100'); +insert into t1 (f1) values (default); +insert into t1 values (b'',b''),('',''); +select hex(f1), hex(f2) from t1; +hex(f1) hex(f2) +2 3C3C +0 0 +0 0 +drop table t1; -- cgit v1.2.1