Scott McCool writes:
> 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.
>
>
>
>
>
Hi!
As there have been some bug fixes meanwhile, can you please check if
the above works with 3.23.36 ??
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
