like na unique mysql5 (was Re: spatne lcase(concat(..)) v mysql5 - bug?)

[Ondrej Koala Vacha]

On Tue, 14 Feb 2006, Michal Molhanec wrote:

> upgraduj manual, ten aktualni pise:

...
> 
> SELECT CONCAT(CAST(int_col AS CHAR), char_col);
> 

Diky moc, toto je zda se ciste reseni. Mam podobnou zahadu vyskytnuvsi se 
nasledne, a totiz ze like hleda na unique jaksi divne:

---------------------------------
create table a (
	id 	int(5) not null,    
	tt	char(255) not null,
	unique (tt)
);

insert into a values (1,'Aa');
insert into a values (2,'Aas');


select * from a where tt='Aa';             <------- najde
select * from a where tt like 'Aa%';       <------- najde jen Aas, tedy nenajde Aa
select * from a where tt like 'Aa';        <------- nenajde
------------------------------------


Muzu poprosit o komentar, resp. nakopnuti?

dik

--
Ondrej Koala Vacha