By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,224 Members | 1,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,224 IT Pros & Developers. It's quick & easy.

Insert bug into MyISAM table (Linux + MySQL 3.23.56)

P: n/a
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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.