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]
