SQLCipher(v) compatibility with openssl(v)

[Nithin_SC]

@developernotes @sjlombardo Migrating from 3.3.1 to 4.4.0 with PRAGMA cipher_compatibility = 3
.
1)Everything is working well with below order of PRAGMA calls and data retained from 3.3.1 after moving to 4.4.0. Note no “REKEY”
a)PRAGMA key=“x’PKCS5_PBKDF2_HMAC_KEY”
b)PRAGMA cipher_compatibility = 3;

2)But fails in below use case
1)On migrating to 4.4.0, Open DB with old key which was used in 3.3.1 with cipher_compatibility=3 is pass.
2)rekey with newer key and encrypt the database using sqlcipher_export. as mentioned in option 3 in link. Note no PRAGMA called.
“ATTACH DATABASE ‘sqlcipher-4.db’ AS sqlcipher4 KEY ‘’;
SELECT sqlcipher_export(‘sqlcipher4’);
DETACH DATABASE sqlcipher4;”

Upgrading to SQLCipher 4

The recent release of SQLCipher 4 introduces many new performance and security enhancements for applications that use SQLCipher for secure local data storage. However, the introduction of new default algorithms, increased KDF iterations and a larger page size means that SQLCipher 4 will not open older databases by default. This document provides guidance on the upgrade options available to applications that have previously integrated SQLCipher versions 1 through 3. Option 1: Database File Migr…

3)Try opening with cipher_compatibility=3 with new key fails to open the DB.

Please share your thoughts. Is the settings a issue here?

Thanks
Nithin