Hi list, I've got a little bug with MySQL. I can insert a row into my table but this row will not appear in the table :( Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz from MySQL team.
Table Description : mysql> desc Log_Forums; +--------------+----------------------+------+-----+---------+-------------- --+ | Field | Type | Null | Key | Default | Extra | +--------------+----------------------+------+-----+---------+-------------- --+ | Pseudo | char(16) | | PRI | | | | Date | timestamp(14) | YES | PRI | NULL | | | Numero | smallint(5) unsigned | | PRI | NULL | auto_increment | | Type_message | enum('0','1') | | | 0 | | +--------------+----------------------+------+-----+---------+-------------- --+ 4 rows in set (0.00 sec) And some code : mysql> select * from Log_Forums where Date="20030806111111"; Empty set (0.08 sec) mysql> insert into Log_Forums (pseudo,date,Type_Message) values ("doss08",20030806111111,"0"); Query OK, 1 row affected (0.00 sec) mysql> select * from Log_Forums where Date="20030806111111"; +--------+----------------+--------+--------------+ | Pseudo | Date | Numero | Type_message | +--------+----------------+--------+--------------+ | doss08 | 20030806111111 | 1 | 0 | +--------+----------------+--------+--------------+ 1 row in set (0.08 sec) mysql> insert into Log_Forums (pseudo,date,Type_Message) values ("coss08",20030806111111,"0"); Query OK, 1 row affected (0.00 sec) mysql> select * from Log_Forums where Date="20030806111111"; +--------+----------------+--------+--------------+ | Pseudo | Date | Numero | Type_message | +--------+----------------+--------+--------------+ | doss08 | 20030806111111 | 1 | 0 | +--------+----------------+--------+--------------+ 1 row in set (0.08 sec) As you can see, i can't find "coss08" in my table :( Table check is ok : mysql> check table Log_Forums; +----------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+-------+----------+----------+ | jeuxvideo.Log_Forums | check | status | OK | +----------------------+-------+----------+----------+ 1 row in set (0.15 sec) Table have got lots of records with pseudo="coucou". It seems now that i can't insert any row which pseudo < "coucou" Can someone help me ? Thanks David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]