mysql a order by na enum a varchar

[Ondrej Koala Vacha]

On Mon, 11 Feb 2002, David Tok wrote:

> :
> :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...
> 

U me ne a nebylo ani nekolik verzi pred a ani v 3.23.46. Tento problem 
jsem reportoval, ale bylo mi sdeleno, ze autorum to nedela, a ze mam asi 
problem s gcc. Predpokladam, ze tazatel ma mysql kompilovanou.
Protoze to bylo zrovna v ere boju 'Redhat a gcc' nechal jsem to tak, a ted 
cekam, kde se problem opravi sam. 


----
Date: Thu, 15 Feb 2001 21:17:51 +0200 (EET)
From: Michael Widenius <monty na mysql.com>
To: Ondrej Koala Vacha <koala na fi.muni.cz>
Cc: bugs na lists.mysql.com
Subject: wrong result of order by


Hi!

>>>>> "Ondrej" == Ondrej Koala Vacha <koala na fi.muni.cz> writes:

>> Description:
Ondrej>         when column in order by is enum, result of order is wrong

<cut>

I tested this with 3.23.33 on Linux compiled with gcc 2.95.2 and it
worked without any problems.

Could you try downloading our MySQL binary from www.mysql.com and
check if you get the same results from this?

(This could be a bug in our compiler...)

Regards,
Monty


-- 
Ondrej Koala Vacha