>Description:
table one has only 1 record (table one: ID, some_description; table two IDone),
table two has records but none matching one.ID=two.IDone (table two: ID,
IDone, some_text, some_int).
doing a query like "SELECT one.ID,isnull(two.some_int) AS
dont_work,two.some_text
FROM one LEFT JOIN two ON one.ID=two.IDone ORDER BY
dont_work,two.some_text"
should produce a 1 record set with dont_work set to 1. Instead it
gives an empty set.
if there are 2 records in table one it all works fine, as if you take
away
the dont_work field from the ORDER BY clause
>How-To-Repeat:
see above
>Fix:
In the script I make a query to know how many records there are in the table
one
and accordingly add the generated field in the order by clause
>Submitter-Id: Christian Deligant
>Originator:
>Organization:
Zadig srl
>MySQL support: none
>Synopsis: single record record disappears when order by a generated field
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.32 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.32-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 55 days 15 hours 3 min 35 sec
Threads: 1 Questions: 19253 Slow queries: 1 Opens: 150 Flush tables: 1 Open
tables: 41
>Environment:
System: Linux Linux 2.2.16 #5 SMP Fri Sep 1 15:09:17 CEST 2000 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/usr/local/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 20000220 (Debian GNU/Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
Configure command: ./configure --enable-shared --without-readline --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info
--includedir=/usr/include --mandir=/usr/share/man
---------------------------------------------------------------------
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
