MariaDB

  1. Bug #606013
  2. Comment #2

Comment 2 for bug 606013

Revision history for this message
Oleksandr "Sanja" Byelkin (sanja-byelkin) wrote :

Problem is in bit type conversion. Test suite is here:

CREATE TABLE t1 ( a bit(20), b bit(20));
INSERT INTO t1 VALUES(1,1),(2,2),(3,3);
SELECT a+0 FROM t1 WHERE NOT a IN (SELECT a FROM t1 WHERE b = 2);
DROP TABLE t1;

But number of bits should not be full bytes (8, 16, 24, 32 ...).