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)
Subject
Views
Written By
Posted
10147
October 04, 2006 12:29PM
Re: MERGE table index fails to contain all records
5747
October 04, 2006 12:38PM
5609
October 04, 2006 12:48PM
5478
October 11, 2006 10:48AM
5522
November 20, 2006 11:56AM
5474
February 17, 2007 11:12AM
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.