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.