Incomplete primary index on table
Hello,
I am experiencing a weird problem with MySQL Cluster.
I have a table where I have loaded 6.5 million records. Its a quite basic table with a phone number as a integer primary index, and then 3 more data fields.
+------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| number | int(11) | NO | PRI | NULL | |
| numbertype | int(11) | YES | | NULL | |
| networkop | varchar(5) | YES | | NULL | |
| serviceop | varchar(5) | YES | | NULL | |
+------------+------------+------+-----+---------+-------+
the numbers are in the range 20000000-99999999.
When i query a number, etc SELECT * FROM num_table WHERE number=88389000, I get a result. But when i query SELECT * FROM num_table WHERE number=22304050, I get no result. But if a do a range query, etc SELECT * FROM num_table WHERE number BETWEEN 22300000 AND 22309999, I can see that the number 22304050 is actually there.
Does anybody have an idea as to why I cant query the number directly?
Subject
Views
Written By
Posted
Incomplete primary index on table
1569
January 13, 2013 10:37AM
611
January 14, 2013 06:14AM
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.