>Description:
        The following query results in a different # of rows if the sql_big_tables is 
set to 1:

  select count(incidents.ref_no) from incidents, labels where incidents.ref_no like 
'020531%' group by labels.label, incidents.ref_no;


The query seems unusual because it was a lot more complicated but I broke it down for 
better readability.

incidents.refno is [varchar(15) binary] eg '020531-000031'
labels.label is [blob] eg 'Pricing' 

Note: The results are only different if there is a large # of results from the query 

>How-To-Repeat:

  create two tables with the above attributes and of large size. Then run the query 
with sql_big_tables set to 1 and when it's not set.

>Fix:

Code fix?

>Submitter-Id:  <submitter ID>
>Originator: RightNow Techmologies      
>Organization:
 
 RightNow Technologies
>MySQL support: [ extended email support ]
>Synopsis:      sql_big_tables option changes results when set for some queries        
> 
>Severity:      
>Priority:      
>Category:      mysql
>Class:         
>Release:       mysql-3.23.47 (Source distribution)

>Environment:
        
System: Linux dbsc01.rightnowtech.com 2.4.17 #2 SMP Fri Jan 4 17:47:51 EST 2002 i686 
unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make

Compilation info: CC='gcc'  CFLAGS='-O3 -mpentiumpro'  CXX='gcc'  CXXFLAGS='-O3 
-mpentiumpro -felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
LIBC: 
lrwxrwxrwx    1 root     root           13 Oct 15  2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x    1 root     root      4103980 Jul 31  2000 /lib/libc-2.1.3.so
Configure command: ./configure  --prefix=/usr/local/pkg/mysql/mysql-3.23.47 
--enable-assembler --with-mysql-ldflags=-all-static --disable-shared 
--with-extra-charsets=complex


---------------------------------------------------------------------
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

Reply via email to