[EMAIL PROTECTED] writes:
> >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
>
>
Hi!
What is the output of the above select ??
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
