System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: aa0031e8705f5d86432cb93d0f9d494b6e35f193
Title: 'pragma mmap_size' doesn't return its new value after setting it
Status: Closed Type: Incident
Severity: Important Priority: Blocker
Subsystem: Native_Assembly Resolution: Works_As_Designed
Last Modified: 2018-12-22 18:16:42
Version Found In: 1.0.109
User Comments:
anonymous added on 2018-10-24 12:58:03:
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.

anonymous added on 2018-10-24 14:25:57:
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.

anonymous added on 2018-11-15 10:32:03:
Thanks for your response.

mistachkin added on 2018-12-22 18:16:42:
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.