mysql a order by na enum a varchar

[David Tok]

On Mon, 11 Feb 2002, Martin Caslavsky wrote:

:Dobry den,
:
:nasledujici sekvence prikazu
:
:create table pokusorder (stav enum('A','N','P'), nazev varchar(40));
:insert into pokusorder values ('A', "b");
:insert into pokusorder values ('A', "a");
:select stav, nazev from pokusorder order by stav, nazev;
:
:mi v mem mysql 3.23.36  vrati:
:+------+-------+
:| stav | nazev |
:+------+-------+
:| A    | b     |
:| A    | a     |
:+------+-------+
:
:Proc neni "a" pred "b"? (Mimochodem to vraci stejny vysledek, i kdyz ty
:inserty prohodim.)

v mysql verze 3.23.46 je to v poradku...

-- david tok