Brian Slesinsky wrote:
>
> Hi, it looks like queries return the wrong results when I create an index
> on a Berkeley DB table. Here's a test case:
>
> -- test case to see if index works
> drop table if exists foo;
>
> CREATE TABLE foo (
> id int(10) unsigned DEFAULT '0' NOT NULL,
> bar int(10) unsigned,
> PRIMARY KEY (id),
> KEY bar (bar)
> ) type=BDB;
>
> INSERT INTO foo VALUES (1,1);
>
> -- should return one row
> -- but if bug is present, returns empty set
> select * from foo where bar=1;
>
> The same query works fine with MyISM or without the index. I'm using MySQL
> 3.23.27 and Berkeley DB 3.2.3 on Linux.
Worked fine for me...
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
