3 messages in com.mysql.lists.bugsRe: do not use '0' in your selects...
FromSent OnAttachments
Milos Wikarski17 May 2001 02:15 
Sinisa Milivojevic17 May 2001 06:19 
Jani Tolonen17 May 2001 06:23 
Subject:Re: do not use '0' in your selects...
From:Sinisa Milivojevic (sin@mysql.com)
Date:05/17/2001 06:19:51 AM
List:com.mysql.lists.bugs

Milos Wikarski writes:

Description: select aa, '0' from foo makes wrong results if aa is type int How-To-Repeat:

create table foo ( aa int, bb int ); insert into foo values ( 33, 44 ); insert into foo values ( 55, 66 ); select aa, bb, 0 from foo; select 0, aa, bb from foo; select 0, aa, bb, '0' from foo;

See the results and wonder

<cut>

Hi!

I have run your test case and I have got results as expected.

Try using our 3.23.38 binary for Linux and see if the problem resolves.

Regards,

Sinisa

____ __ _____ _____ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@mysql.com /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ /*/ \*\ Developers Team