List:Bugs« Previous MessageNext Message »
From:sasha Date:October 31 2000 3:53pm
Subject:Re: indexes not working in BDB tables
View as plain text  
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
       <___/
Thread
indexes not working in BDB tablesBrian Slesinsky31 Oct
  • Re: indexes not working in BDB tablessasha31 Oct
    • Re: indexes not working in BDB tablesBrian Slesinsky31 Oct
      • Re: indexes not working in BDB tablessasha1 Nov