DrH recently posted to sqlite-dev "Version 3.6.2 contains a lot of code refactoring." So far I've found no reason to not pull 3.6.1, so I'm planning to stick with that. Once that's in, we might pull individual later patches onto the sqlite_google branch as warranted (*), but I don't want to get tied up pulling 3.6.1 and those patches at the same time.
http://www.sqlite.org/changes.html Things of interest to Gears (visible changes to SQL syntax or operation): 3.6.0 (7/16/08) - Various C macros get SQLITE_ prefix. Should only affect the build environment, maybe not even that. [I'll be reviewing things for new settings we need to pull in.] - IN/NOT-IN versus NULL handling in SQL code. This is about at the same level as when we discovered that undefined was being sent to the database as "undefined" - it wasn't even clear if people who depended on the behavior would even know they depended on it. Probably esoteric enough that it's not a big issue, and I can think of no way to work around it. - Result-column-names change may change rs.fieldName() and fieldByName() for some queries involving sub-selects. 3.5.4 (12/14/07) - New group_concat() function. 3.5.0 (9/4/07) - New VFS layer. This mostly doesn't affect us, but maybe something interesting will turn up. A change that didn't show at this level was that in many cases SQLite can use the page cache rather than an on-disk temporary table for small temporary tables. This can come up with sub-selects and triggers, and is a pretty big win. There are changes to the memory-allocation and thread handling, but I'll need to spend more time to understand whether we need to take any action WRT them. -scott (*) I think the following changes will want to be pulled in. I've tried to restrict to just those things which I believe probably were changed by something between 3.4.0 and 3.6.1. http://www.sqlite.org/cvstrac/chngview?cn=5613 Fixes bug in subquery-as-table with LIMIT clause. http://www.sqlite.org/cvstrac/chngview?cn=5596 Fixes bug in function-context initialization. http://www.sqlite.org/cvstrac/chngview?cn=5580 Fixes an issue with the rowid column name in views. I think. http://www.sqlite.org/cvstrac/chngview?cn=5578 Fixes bug in certain uses of count() with group by. http://www.sqlite.org/cvstrac/tktview?tn=3298 Fixes an issue with triggers on views. I haven't verified whether this is a new issue or not - if it's an old issue, I won't include this (since in that case nobody could depend on it since the statement wouldn't compile in the first place).
