spatne lcase(concat(..)) v mysql5 - bug?

[Ondrej Koala Vacha]

On Tue, 14 Feb 2006, Ondrej Koala Vacha wrote:

> drop table if exists a;
> create table a (
> 	id 	int(5) not null,
> 	tt	char(255) not null
> );
> 
> insert into a values (1,'Aa');
> insert into a values (2,'Bb');
> insert into a values (3,'Cc');
> 
> 
> select lcase(concat(id,' ',tt)) from a;


Funguje 'perlove' reseni:

select lcase(concat(id+0,' ',tt)) from a;

tak nevim, co si o tom mam myslet...

--
Ondrej Koala Vacha