Some notes on 3.8.12: (Brilliant release btw, thanks) I've been following the thread about the version numbering, and at first thought the OP was a little over-enthusiastic about increasing version numbers prematurely, but then after reading the release notes, I have to agree to some extent - That is - I am not sure we should be changing the way SQLite is versioned altogether, but maybe a bit more prolific in the release versions? This definitely feels like a 3.9 release rather than a 3.8.12. I mean it introduces functionality that a 3.8.11 engine won't be able to comprehend - and not just one obscure item either.
-------------------------------- The Indexed expressions document (https://www.sqlite.org/draft/expridx.html) notes that the expression must be exactly reproduced in the query to make use of it (i.e. exactly as it was defined in the CREATE INDEX statement). It goes on to note that "exactly" means syntactically equivalent (not mathematically etc.), which is great, and that whitespace does not matter. What about Capitalization and quotation? i.e. - for this schema: i.e. - for this schema: CREATE TABLE t2(x,y,z); CREATE INDEX t2xy ON t2(x+y); Would these all be equivalent? SELECT * FROM t2 WHERE X+y=22; SELECT * FROM t2 WHERE "x" + "y" = 22; SELECT * FROM t2 WHERE "x" + Y = 22; Whatever the answer, may it be added to the documentation please? (A short example like the above would suffice I think). ----------------------------- Documentation error in the Restrictions section (typo): "2. Expressions in CREATE INDEX *statmeent* may contain function calls, but only to functions whose output is always determined completely by its..." ------------------------------ Documentation error in the Release notes (pluralization): "Enhance the dbstat virtual table <https://www.sqlite.org/draft/dbstat.html> so that it can be used as *a table-valued functions <https://www.sqlite.org/draft/vtab.html#tabfunc2>* where the argument is..." Thanks, Ryan
