|
Here' s what we have for MyISAM (the correct result):
MariaDB [test]> CREATE TABLE t1(f1 bit(2)) ENGINE=MYISAM;
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [test]> INSERT INTO t1 VALUES (b'');
|
Query OK, 1 row affected (0.00 sec)
|
|
MariaDB [test]> SELECT HEX(f1) from t1;
|
+---------+
|
| HEX(f1) |
|
+---------+
|
| 0 |
|
+---------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> SELECT bin(f1) from t1;
|
+---------+
|
| bin(f1) |
|
+---------+
|
| 0 |
|
+---------+
|
1 row in set (0.00 sec)
|
And here's what we have for INNODB (an incorrect result):
MariaDB [test]> CREATE TABLE t2(f1 bit(2)) ENGINE=INNODB;
|
Query OK, 0 rows affected (0.06 sec)
|
|
MariaDB [test]> INSERT INTO t2 VALUES (b'');
|
Query OK, 1 row affected (0.01 sec)
|
|
MariaDB [test]> SELECT HEX(f1) from t2;
|
+---------+
|
| HEX(f1) |
|
+---------+
|
| 8F |
|
+---------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> SELECT bin(f1) from t2;
|
+----------+
|
| bin(f1) |
|
+----------+
|
| 10001111 |
|
+----------+
|
1 row in set (0.00 sec)
|
mysql-5.6 returns the correct result in both cases.
|
unknown_bug.patch