Jean-François RIGHI wrote:
>
> 1) We were working with an old version of System.data.sqlite.dll (1.0.66)
> wich was prety stable. But we needed to work with concat index (CREATE
> INDEX IDX ON TABLE_1 (FIELD1 || FIELD2) to upgrade performance. Since we
> changed the dll we often got a Database base disk is malformed issue. We
> can repair the base via an sql dump of the base. The issue itself is never
> exactly the same : we can have a duplicate  TRIGGER or TABLE or sometimes
> INSERT INTO with non valide data.
> 

Are you able to share the full schema for the database?

--
Joe Mistachkin @ https://urn.to/r/mistachkin

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to