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.
----------------------------------------------------------------------
Brian Slesinsky
