From: Thimble Smith
Date: March 1 2000 9:47pm
Subject: Problem with "HAVING" and quoted field aliases
List-Archive: http://lists.mysql.com/bugs/31
Message-Id: <20000301164716.O6645@threads.polyesthetic.msg>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Forwarded from mysql@stripped....

----- Forwarded message from spt@stripped -----

Date: Wed, 01 Mar 2000 16:55:02 -0500
From: spt@stripped
Subject: Problem with "HAVING" and quoted field aliases
To: mysql@stripped

>Description:
	When running a query with HAVING with the critia with a quoted field, I 
recieve incorrect results. 

>How-To-Repeat:
	
select 1 as Junk from sometable having Junk=1;
	This returns the number of records in sometable with each record containing 1.
but:

select 1 as "Junk" from sometable having "Junk"=1;
	This returns an empty set.

>Fix:
	

>Submitter-Id:	<submitter ID>
>Originator:	Sean P. Thomas
>Organization:	Dynamic Consulting, Inc.
>MySQL support: none
>Synopsis:	Problem with "HAVING" and quoted field aliases
>Severity:	serious
>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
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			1 hour 15 min 0 sec

Threads: 9  Questions: 5964  Slow queries: 0  Opens: 2135  Flush tables: 1  Open tables: 63
>Environment:
	
System: Linux john 2.0.35 #42 Mon Dec 6 17:58:27 EST 1999 i686 unknown
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnulibc1/egcs-2.90.29/specs
gcc version egcs-2.90.29 980515 (egcs-1.0.3 release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
Configure command: ./configure  --enable-assembler --without-debug
Perl: This is perl, version 5.004_04 built for i586-linux

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread29688@stripped

To unsubscribe, send a message to:
    <mysql-unsubscribe-tim=desert.net@stripped>


----- End forwarded message -----

-- 
Tim Smith   < tim@stripped >  :MySQL Development Team:  Boone, NC  USA.