I'm getting strange results that I think can be
explained by having an index that isn't set up right.
CREATE TABLE URL_POLICY (
url_id INTEGER NOT NULL,
policy_id INTEGER NOT NULL,
policy_order INTEGER NULL,
PRIMARY KEY (url_id, policy_id)
) TYPE=BDB;
INSERT INTO testtbl values(100,100,null);
INSERT INTO testtbl values(100,101,null);
INSERT INTO testtbl values(100,102,null);
INSERT INTO testtbl values(100,103,null);
INSERT INTO testtbl values(100,104,null);
INSERT INTO testtbl values(100,105,null);
Here is the problem:
SELECT * from URL_POLICY;
url_id policy_id policy_order
100 100 NULL
100 101 NULL
100 102 NULL
100 103 NULL
100 104 NULL
100 105 NULL
All seems in order, but as soon as I add a where
clause (SELECT * from URL_POLICY where url_id=100) I
only get a subset of those rows back.
Explain isn't all that useful since there are no
joins, but the "key_len" of 4 seems like it might be a
problem.
Another odd thing is that I can't reproduce this using
a different database, but I see it on the existing
table (even adding new rows to test with). The
CREATE/INSERTs above are exactly what we used.
Machine is SPARC/Solaris 7, running MySQL 3.23.34a.
Any guidance? It seemed like it might be a FAQ, but I
didn't see anything in the manual or a quick search of
the archives.
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php