2 messages in com.mysql.lists.bugsSelecting ordered data from BDB table...| From | Sent On | Attachments |
|---|---|---|
| Manuel Lemos | 07 Sep 2000 22:44 | |
| Michael Widenius | 08 Sep 2000 02:31 |
| Subject: | Selecting ordered data from BDB tables fails. |
|---|---|
| From: | Manuel Lemos (mle...@acm.org) |
| Date: | 09/07/2000 10:44:26 PM |
| List: | com.mysql.lists.bugs |
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