diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-08-05 11:47:58 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-08-05 11:47:58 +0200 |
| commit | cf4814b39700fc0fe062519ad9090099540f79c0 (patch) | |
| tree | 574b3446945a889c530e310150d81d404324e88d /mysql-test/r/type_bit_innodb.result | |
| parent | 321f589c81105ef9fc23689b7ec8eec3ff98ed39 (diff) | |
| download | mariadb-git-cf4814b39700fc0fe062519ad9090099540f79c0.tar.gz | |
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.
Diffstat (limited to 'mysql-test/r/type_bit_innodb.result')
| -rw-r--r-- | mysql-test/r/type_bit_innodb.result | 9 |
1 files changed, 9 insertions, 0 deletions
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; |