>Description:
If you a table type BDB and select all data using ORDER BY clause it fails.
Without this it is not possible to select ordered data in tables that are needed to work
with transactions.
>How-To-Repeat:
# NOTICE: This script was generated with mysqldump but the parameter TYPE=BDB was inserted
manually because mysqldump does not output it. At the ended it was appended a SELECT
statement that fails with this table.
# MySQL dump 8.8
#
# Host: localhost Database: driver_test
#--------------------------------------------------------
# Server version 3.23.23-beta
#
# Table structure for table 'users'
#
CREATE TABLE users (
user_name varchar(12),
password text,
subscribed char(1),
user_id int(11) DEFAULT '0' NOT NULL,
quota bigint(20),
weight double,
access_date date,
access_time time,
approved datetime,
dummy_primary_key int(11) NOT NULL auto_increment,
PRIMARY KEY (dummy_primary_key)
) TYPE=BDB;
#
# Dumping data for table 'users'
#
INSERT INTO users VALUES
('user_0','somepassword','N',0,0,0,'2000-09-07','23:06:59','2000-09-07 23:06:59',1);
INSERT INTO users VALUES
('user_1','somepassword','Y',1,1,1,'2000-09-07','23:06:59','2000-09-07 23:06:59',2);
INSERT INTO users VALUES
('user_2','somepassword','N',2,2,1.4142135623731,'2000-09-07','23:06:59','2000-09-07
23:06:59',3);
INSERT INTO users VALUES
('user_3','somepassword','Y',3,3,1.7320508075689,'2000-09-07','23:06:59','2000-09-07
23:06:59',4);
INSERT INTO users VALUES
('user_4','somepassword','N',4,4,2,'2000-09-07','23:06:59','2000-09-07 23:06:59',5);
>Fix:
N/A
>Submitter-Id:
>Originator:
>Organization:
Metabase PHP database abstraction package development
>MySQL support: none
>Synopsis: Selecting ordered data from BDB tables fails.
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.23-beta (Source distribution)
>Environment:
System: Linux cohones.serio.org 2.2.12-5cl #1 ter set 14 16:36:28 EST 1999 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-conectiva-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Nov 25 1999 /lib/libc.so.6 -> libc-2.1.1.so
-rwxr-xr-x 1 root root 4016875 Jul 1 1999 /lib/libc-2.1.1.so
-rw-r--r-- 1 root root 19561856 Jul 1 1999 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jul 1 1999 /usr/lib/libc.so
Configure command: ./configure --prefix=/extra/install/mysql
--with-berkeley-db=/extra/install/db
Perl: This is perl, version 5.005_03 built for i386-linux
