Re: MERGE table index fails to contain all records

[ahigerd]

For reference, on a server running 4.1.20, we find a slightly different error.

mysql> select * from testm;
+------+
| id |
+------+
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
+------+
6 rows in set (0.00 sec)

mysql> select * from testm where id is null;
Empty set (0.00 sec)

mysql> select * from testm where id is not null;
+------+
| id |
+------+
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
+------+
5 rows in set (0.01 sec)

mysql> select * from testm where id<5;
+------+
| id |
+------+
| 2 |
| 3 |
| 4 |
+------+
3 rows in set (0.00 sec)