SQLite Bug and GPF only when database is encrypted

[emeasoft]

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.

error.png (12.91 KiB) Visto 4671 veces

What could be causing this problem?

TIA,
Juliano

[ignacio]

Hello,

We are aware of this problem. Please check if with the LIMIT 999999999 clause the problem disappears. TIA.

Regards

[emeasoft]

Thanks Ignacio!! We will do that for now.

Regards,
Juliano

[emeasoft]

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

[jfgimenez]

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.

[emeasoft]

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,

[jfgimenez]

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.

[emeasoft]

Many thanks for the help José!

Regards,
Juliano