Alex,
check by other queries whether it is the table which contains a
duplicate row, or if the SELECT gives a wrong answer.
Check what
SELECT * FROM ... WHERE symbole='1rPFTE';
returns.
Regards,
Heikki
At 12:04 PM 4/25/01 +0200, you wrote:
>Bonjour,
>
> Mysql-3.23.37 on Solaris 2.8.
>
> I created this table :
>
>CREATE TABLE livequote_last_PAR (
> symbole char(20) NOT NULL default '',
> id int(10) unsigned NOT NULL default '0',
> date datetime NOT NULL default '0000-00-00 00:00:00',
> last double(17,5) NOT NULL default '0.00000',
> volume int(10) unsigned NOT NULL default '0',
> PRIMARY KEY (symbole,id),
> KEY idx_id (id)
>) TYPE=Innobase;
>
> As you can see, (symbole,id) is the primary key.
>
> But :
>
>mysql> select * from livequote_last_PAR where symbole='1rPFTE' order by id
desc;
>+---------+-------+---------------------+----------+--------+
>| symbole | id | date | last | volume |
>+---------+-------+---------------------+----------+--------+
>| 1rPFTE | 33121 | 2001-04-25 11:59:39 | 78.70000 | 492 |
>| 1rPFTE | 33121 | 2001-04-25 11:59:39 | 78.70000 | 492 |
>| 1rPFTE | 33120 | 2001-04-25 11:59:39 | 78.70000 | 1290 |
>| 1rPFTE | 33120 | 2001-04-25 11:59:39 | 78.70000 | 1290 |
>| 1rPFTE | 33119 | 2001-04-25 11:59:29 | 78.70000 | 10 |
>| 1rPFTE | 33118 | 2001-04-25 11:59:04 | 78.70000 | 106 |
>| 1rPFTE | 33117 | 2001-04-25 11:58:49 | 78.70000 | 50 |
>| 1rPFTE | 33116 | 2001-04-25 11:57:57 | 78.70000 | 76 |
>| 1rPFTE | 33115 | 2001-04-25 11:57:33 | 78.60000 | 99 |
>| 1rPFTE | 33114 | 2001-04-25 11:56:44 | 78.70000 | 1768 |
>| 1rPFTE | 33113 | 2001-04-25 11:56:44 | 78.70000 | 118 |
>| 1rPFTE | 33112 | 2001-04-25 11:56:04 | 78.70000 | 1000 |
>+---------+-------+---------------------+----------+--------+
>12 rows in set (0.00 sec)
>
> I've not yet deeply explored what the problem is, but there is a
> problem.
>
> I will have to ckech exactly what queries my programs are doing in
> order to have this result, but there is a problem in mysql or innodb
> anyway I think.
>
> Regards,
> Alex.
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
