bug 0.8.2.9 version

mna · Post by **mna** » 27.12.2006, 17:30

create a table named T1 with 2 row (Nom, Prenom) as text
create data like
Nom1,Prenom1
Nom2,Prenom2
Nom2,Prenom3
Nom4,Alphonse,
...

try

select count(*) from T1 where Prenom like "A%";

then clic back to the "data tab" and you will see that all yours data were lost and you will see something like ;
Nom4,Alphonse
Nom4,Alphonse
Nom4,Alphonse
Nom4,Alphonse
Nom4,Alphonse,
....

good luke to debug.
am using sqlite administrator 0.8.2.9 in french language.

Orbmu2k · Post by **Orbmu2k** » 29.12.2006, 01:13

seems to be a bug on the zeoslib with tables without primary key field.

for workaround, add an autoincrement pk field to the table, close db and reopen it.

mna · Post by **mna** » 29.12.2006, 11:02

Orbmu2k wrote:seems to be a bug on the zeoslib with tables without primary key field.

for workaround, add an autoincrement pk field to the table, close db and reopen it.

that's right, if i add a primary key all is working properly.

thank for your answer.
you have done a great job regarding sqlite administrator.
and because it's the "epoch", i wish you an happy new year