On 12/9/15, David Baird <dhbaird at gmail.com> wrote: > > Looks like it's fixed, as long as I stick to new versions. *cross fingers*
Bisecting shows that the change in behavior occurred here: https://www.sqlite.org/src/timeline?c=56bc5ce8 As others have a pointed out, though, the "desired" behavior is "undocumented". SQLite nor any other SQL database engine is obligated to provide the behavior you want. It happens as you like purely by chance. Do not depend on this behavior since it might change at any moment, without warning. -- D. Richard Hipp drh at sqlite.org