In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
SQLite Bug and GPF only when database is encrypted
SQLite Bug and GPF only when database is encrypted
Hello Xailers,
We are having a bug and sometimes a GPF, but only when the database is encrypted.
Executing a query with ORDER BY LPAD(FIELD,XX) returns an empty array or an GPF error... but this error only happens when the database is protected with a password.
What could be causing this problem?
TIA,
Juliano
We are having a bug and sometimes a GPF, but only when the database is encrypted.
Executing a query with ORDER BY LPAD(FIELD,XX) returns an empty array or an GPF error... but this error only happens when the database is protected with a password.
What could be causing this problem?
TIA,
Juliano
- Adjuntos
-
- TestSQLite.zip
- (50.58 KiB) Descargado 180 veces
- ignacio
- Site Admin
- Mensajes: 9253
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
Re: SQLite Bug and GPF only when database is encrypted
Hello,
We are aware of this problem. Please check if with the LIMIT 999999999 clause the problem disappears. TIA.
Regards
We are aware of this problem. Please check if with the LIMIT 999999999 clause the problem disappears. TIA.
Regards
Re: SQLite Bug and GPF only when database is encrypted
Thanks Ignacio!! We will do that for now.
Regards,
Juliano
Regards,
Juliano
Re: SQLite Bug and GPF only when database is encrypted
Hello Ignacio,
This error happened again, but now when using the BETWEEN clause "SELECT * FROM TAB1 WHERE C03 BETWEEN ? AND ?" within the QueryArray method.
It returns a empty array, if I use the execute() or add LIMIT 99999... it runs fine.
Regards,
Juliano
This error happened again, but now when using the BETWEEN clause "SELECT * FROM TAB1 WHERE C03 BETWEEN ? AND ?" within the QueryArray method.
It returns a empty array, if I use the execute() or add LIMIT 99999... it runs fine.
Regards,
Juliano
Re: SQLite Bug and GPF only when database is encrypted
Juliano,
could you send to me the sqlite db which has that problem? I need the DB along the encrypt key and the sentences that cause the error.
Thanks in advance.
could you send to me the sqlite db which has that problem? I need the DB along the encrypt key and the sentences that cause the error.
Thanks in advance.
Re: SQLite Bug and GPF only when database is encrypted
Hello José,
The error happens on the example from the first post "TestSQLite.zip".
Just compile, execute and you will see the GPF error.
Regards,
The error happens on the example from the first post "TestSQLite.zip".
Just compile, execute and you will see the GPF error.
Regards,
Re: SQLite Bug and GPF only when database is encrypted
Juliano,
we have had to return to sqlite 3.8.7.1 due theese errors. Using this version seems to work all fine. However, we'll keep searching for which changes in sqlite has caused the problems.
we have had to return to sqlite 3.8.7.1 due theese errors. Using this version seems to work all fine. However, we'll keep searching for which changes in sqlite has caused the problems.