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]

Reply via email to