MySQL Forums
Forum List  »  Merge Storage Engine

Re: MERGE table index fails to contain all records
Posted by: ahigerd
Date: October 04, 2006 12:38PM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MERGE table index fails to contain all records
5747
October 04, 2006 12:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.