Re[2]: Primary key not unique on Innodb tables.

2001-04-25 Thread BAUMEISTER Alexandre
Heikki, I did the downgrade to Mysql-3.23.36. I don't have this problem with 3.23.36 ! Alex. HT check by other queries whether it is the table which contains a HT duplicate row, or if the SELECT gives a wrong answer. HT Check what HT SELECT * FROM ... WHERE symbole='1rPFTE'; HT

Re[2]: Primary key not unique on Innodb tables.

2001-04-25 Thread BAUMEISTER Alexandre
Heikki, Another exemple : mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ |

Re[2]: Primary key not unique on Innodb tables.

2001-04-25 Thread BAUMEISTER Alexandre
Heikki, HT check by other queries whether it is the table which contains a HT duplicate row, or if the SELECT gives a wrong answer. HT Check what HT SELECT * FROM ... WHERE symbole='1rPFTE'; HT returns. Really strange : mysql select * from livequote_last_PAR where symbole='1rPFTE' order