System.Data.SQLite

Hi,

After upgrading System.Data.SQLite.Core NuGet package from 1.0.108 to 1.0.109.1 or 1.0.109.2, and setting mmap_size to any value other than 0, querying its new value with 'pragma mmap_size' doesn't return the expected value but 0.

As a side note, and because I don't see this behaviour documented, there's no result from 'pragma mmap_size' working with a :memory: database instead of 0.

Thanks in advance.

This new behaviour only occurs when mmap_size is set on a connection, which is then closed, and queried after on a different connection to the same database.

If mmap_size is set and then queried on the same connection, it gets the expected result.

Thanks for your response.

This appears to be working exactly as designed.  The mmap_size value is not
persistent.  To be effective, it must be set on each newly opened connection.