mysql a order by na enum a varchar
David Tok
ddt na coolnet.cz
Pondělí Únor 11 13:18:13 CET 2002
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
Další informace o konferenci Test