From: sasha
Date: October 31 2000 3:53pm
Subject: Re: indexes not working in BDB tables
List-Archive: http://lists.mysql.com/bugs/487
Message-Id: <39FEEB16.4DDBE4D0@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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
       <___/