Skip navigation links

MySQL Forums :: Cluster :: Incomplete primary index on table


Advanced Search

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 566 Jon Schøpzinsky 01/13/2013 10:37AM
Re: Incomplete primary index on table 269 Ted Wennmark 01/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.