> 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
>
>
So i've make a dump of this table and import it on a new server.
There, i haven't got any problem.
Si i tried to understand how to make MySQL work like it must works.
In fact my table have got 1200 different pseudos and always 60K records.
When i'm doing an insert, i also do a delete ...
But pseudo "coucou" is repeated 53250 times.
I tried something like :
insert into Log_Forums (pseudo,date,Type_Message) values
("buh08",20030806111111,"0");
Don't work.
But if i do :
update Log_Forums set pseudo ="boucou" where pseudo="coucou";
then
insert into Log_Forums (pseudo,date,Type_Message) values
("buh08",20030806111111,"0");
WORK ...
That seems that a large number of one specific pseudo make MySQL consider
that this value will be the lowest possible value.
Can someone have some clue to help me ?
Thx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
