>Description:
The UNION clause displays results 2 times even when not using the
ALL keyword with it. example: (SELECT
allusa.id,line,name,city,country,listcity,state,liststate,url,line,bookable,cost_range_low,cost_range_high,showlink,desc1,child,pets,wc,spec.id,spec.historic,spec.skiing,spec.romance,spec.antiques,spec.family_fun,spec.spas,spec.luxury_,spec.historic
FROM bb.allusa LEFT JOIN bb.spec on allusa.id=spec.id WHERE city = 'san francisco' AND
line=1 order by state,city,name) UNION (SELECT
allusa.id,line,name,city,country,listcity,state,liststate,url,line,bookable,cost_range_low,cost_range_high,showlink,desc1,child,pets,wc,spec.id,spec.historic,spec.skiing,spec.romance,spec.antiques,spec.family_fun,spec.spas,spec.luxury_,spec.historic
FROM bb.allusa LEFT JOIN bb.spec on allusa.id=spec.id WHERE (line=1) AND (city LIKE
'%san%' OR listcity LIKE '%san%' OR state='san' OR statename LIKE '%san%' OR country
LIKE '%san%' OR name LIKE '%san%') AND (city LIKE '%francisco%' OR listcity LIKE
'%francisco%' OR state='francisco' OR statename LIKE '%francisco%' OR country LIKE
'%francisco%' OR name LIKE '%francisco%')ORDER BY state,city,name ) LIMIT 15,15
produces the city "San Francisco" twice in the listing.
>How-To-Repeat:
<http://www.lanierbb.com/search/search.php?pt=bb&q=san+francisco&start=15&numr=29>
>Fix:
<Could not find a fix>
>Submitter-Id: <submitter ID>
>Originator: Cliff
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-4.0.2-alpha (Official MySQL binary)
>Server: /usr/local/bin/mysqladmin Ver 8.35 Distrib 4.0.2-alpha, for
>unknown-freebsdelf4.6 on i386
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 4.0.2-alpha
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 4 hours 38 min 52 sec
Threads: 34 Questions: 478382 Slow queries: 2 Opens: 1924 Flush tables: 1 Open
tables: 64 Queries per second avg: 28.591
>Environment:
System: FreeBSD lists.travelguides.com 4.6-STABLE FreeBSD 4.6-STABLE #0: Sat Jul 13
13:04:51 CDT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/TRAVELGUIDES
i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1222232 Jun 21 07:31 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Jun 21 07:31 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 579412 Jun 21 07:31 /usr/lib/libc.so.4
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-local-infile --enable-assembler
--with-named-z-libs=not-used --disable-shared 'CFLAGS=-O3 -fno-omit-frame-pointer'
CXX=gcc CC=gcc 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti'
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
