>Description:
Sorting (ORDER BY in INNOBASE tables) with LIMIT doesn't work
>How-To-Repeat:
CREATE TABLE AUTHOR (ID int(7) NOT NULL auto_increment,
First_Name_ru varchar(250) NOT NULL default '',
Last_Name_ru varchar(250) NOT NULL default '',
First_Name_en varchar(250) default NULL, Last_Name_en varchar(250) default NULL,
Image varchar(250) default NULL, Description text,
PRIMARY KEY (ID), KEY First_Name_ru (First_Name_ru), KEY Last_Name_ru (Last_Name_ru)
) TYPE=Innobase;
mysql> insert into AUTHOR (ID,First_Name_ru,Last_Name_ru) values ('','ddd','ddd');
mysql> insert into AUTHOR (ID,First_Name_ru,Last_Name_ru) values ('','sss','sss');
mysql> insert into AUTHOR (ID,First_Name_ru,Last_Name_ru) values ('','lll','lll');
mysql> insert into AUTHOR (ID,First_Name_ru,Last_Name_ru) values ('','ccc','ccc');
mysql> insert into AUTHOR (ID,First_Name_ru,Last_Name_ru) values ('','bbb','bbb');
mysql> insert into AUTHOR (ID,First_Name_ru,Last_Name_ru) values ('','aaa','aaa');
select ID,First_Name_ru,Last_Name_ru from AUTHOR order by Last_Name_ru Limit 0, 2;
>Fix:
<Don't know :(>
>Submitter-Id: <[EMAIL PROTECTED]>
>Originator:
>Organization:
<News paper LENTA.CO.IL>
>MySQL support: none
>Synopsis: <Wrong result of ORDER BY xxx LIMIT x,x>
>Severity:
>Priority:
>Category: <mysql>
>Class:
>Release: mysql-3.23.35 (Source distribution)
>Environment:
<IBM Netfinity 5100, Linux Slackware 7.1 + kernel 2.4.2>
System: Linux www 2.4.2 #1 Mon Mar 5 10:37:36 IST 2001 i686 unknown
Architecture: i686
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-slackware-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 Feb 28 12:07 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 1013224 Mar 22 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so
Configure command: ./configure --with-charset=cp1251
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --prefix=/usr/local/mysql
--with-libwrap --with-raid --with-mysqld-user=mysql --with-innobase
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
