3.49.0 changes set dqs=off which is not the sqlite default yet

[atom-andrew]

Solution to issue cannot be found in the documentation.

• I checked the documentation.

Issue

302e685 sets SQLITE_DQS=0 but as far as I can tell, dqs=on remains the default setting for sqlite. The homebrew formula also seems to leave this setting at the default value. Setting dqs=off breaks python-diskcache among other packages (at least until grantjenks/python-diskcache#311 is merged), and is probably unexpected as the default behavior in sqlite itself has not changed. Note that this problem didn't surface until 3.49.1 was released because 3.49.0 was marked as broken.

Installed packages

sqlite

Environment info

n/a

[blooop]

I am affected by this. python-diskcache stopped working for me when sqlite==3.49.1. I have pinned to 3.48.0 for now.

[cocktailpeanut]

this is a severe issue as can be seen by all the backlinks, it's crazy that nobody has bothered to even respond. this basically breaks every new conda installation

[AncientMystic]

this is a severe issue as can be seen by all the backlinks, it's crazy that nobody has bothered to even respond. this basically breaks every new conda installation

not to mention everything these days is setup to force you to auto update with no choice in the matter and no way to really downgrade, so breaks like this get forced on everyone automatically, its just breaking everything for everyone with no option but to wait for a fix. i have been waiting this whole time for these issues to be resolved and it seems like a pretty easy fix to just change one setting and mark it as .2....