>Description:
Query with INNER JOIN return 0 rows, but the same query + yet another
WHERE condition return 1 row
>How-To-Repeat:
Query:
SELECT orders_common.vendor_id
FROM orders_common
INNER JOIN orders_common_count
ON (orders_common.id=orders_common_count.orders_id)
WHERE orders_common_count.clients_names_id in (3639)
AND orders_common.vendor_id=95
Result - 0 rows
but,
SELECT orders_common.vendor_id
FROM orders_common
INNER JOIN orders_common_count
ON (orders_common.id=orders_common_count.orders_id)
WHERE orders_common_count.clients_names_id in (3639)
AND orders_common.vendor_id=95
AND and orders_common.id=1060340
Result - 1 row
>Fix:
switch back to mysql-3.23.27 and all works fine
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: none
>Synopsis: INNER JOIN doesn't work as expected
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.45 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.45, for pc-linux-gnu on
i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.45
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 14 days 5 hours 51 min 38 sec
Threads: 5 Questions: 61278587 Slow queries: 2893 Opens: 3730 Flush
tables: 1 Open tables: 495 Queries per second avg: 49.792
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux mb.lamport.msk.ru 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 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-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc' CFLAGS='-O4 -march=i686' CXX='gcc'
CXXFLAGS='-O4 -march=i686 -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 сав 19 2001 /lib/libc.so.6 ->
libc-2.2.2.so
-rwxr-xr-x 1 root root 1236396 сав 7 2001 /lib/libc-2.2.2.so
-rw-r--r-- 1 root root 26350254 сав 6 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 сав 6 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --libexecdir=/usr/sbin
--localstatedir=/var/lib/mysql --mandir=/usr/share/man
--infodir=/usr/share/info --enable-assembler
--with-mysqld-ldflags=-all-static --with-mysql-user=mysql --with-innodb
'--with-extra-charsets=latin1 koi8_ru cp1251'
---------------------------------------------------------------------
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
