mysql a order by na enum a varchar

[David Tok]

On Mon, 11 Feb 2002, Ondrej Koala Vacha wrote:

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




MySQL, v. 3.23.46, kompilovana :

./configure --prefix=/usr/local/mysql-3.23.46 --datadir=/etc \
    --with-unix-socket-path=/var/run/mysql/mysql.sock \
    --with-tcp-port=3306 --without-debug \
    --with-charset=latin2

kompilator gcc v 2.96-98.

 
mysql> create table pokusorder (stav enum('A','N','P'), nazev 
varchar(40));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into pokusorder values ('A', "b");
Query OK, 1 row affected (0.00 sec)

mysql> insert into pokusorder values ('A', "a");
Query OK, 1 row affected (0.00 sec)

mysql> select stav, nazev from pokusorder order by stav, nazev;
+------+-------+
| stav | nazev |
+------+-------+
| A    | a     |
| A    | b     |
+------+-------+
2 rows in set (0.00 sec)

mysql> drop table pokusorder;
Query OK, 0 rows affected (0.00 sec)

mysql> create table pokusorder (stav enum('A','N','P'), nazev 
varchar(40));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into pokusorder values ('A', "a");
Query OK, 1 row affected (0.00 sec)

mysql> insert into pokusorder values ('A', "b");
Query OK, 1 row affected (0.00 sec)

mysql> select stav, nazev from pokusorder order by stav, nazev;
+------+-------+
| stav | nazev |
+------+-------+
| A    | a     |
| A    | b     |
+------+-------+
2 rows in set (0.00 sec)


-- zkouseno na 3 ruznych strojich 



On Mon, 11 Feb 2002, Karel Zak wrote:

: 3.23.36 je unstable?

proti 3.23.36 nemam namitek, jenom z meho momentalniho pohledu se toto
jevi jako bug, ktery je ve verzi 3.23.46 opraven. (je to ale subjektivni 
pohled).


-- david tok