Hi!
On Aug 06, David Bordas wrote:
> > 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 ?
> >
> 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 ?
Can you create a repeatable test case ?
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
