MySQL Forums
Forum List  »  NDB clusters

Incomplete primary index on table
Posted by: Jon Schøpzinsky
Date: January 13, 2013 10:37AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Incomplete primary index on table
1209
January 13, 2013 10:37AM


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.