[sqlite] Problem with a simple select

[Mehdi AMINI]

Hello,


I've populated a 5MB database with a QT app.
I've got problem with a simple select query.

Here is the table's schema:

CREATE TABLE Perf ( IdEvent int,
                    IdComp int,
                    place smallint,
                    tps1 float,
                    pen1 smallint,
                    tps2 float,
                    pen2 smallint,
                    total float,
                    PointsOfficiel smallint,
                    PointsClassement smallint,
                    PRIMARY KEY (IdEvent, IdComp) );


Those requests don't return the same lines.

SELECT idEvent, idComp from Perf WHERE IdEvent=20055480;
SELECT * from Perf WHERE IdEvent=20055480;

I'm not SQL expert, but in my opinion there's no reason for that.
The first request, with only column in Primary key, seems to work and give
99 lines.
The second one return 99 lines, but only 18 with IdEvent=20055480, others
lines are one record (same Idevent and Idcomp) wich is show 81 times.

I hope my description was clear enough.
I'm looking for a way to debug that.

Thanks for your help


Mehdi