Index: pages/arch.in ================================================================== --- pages/arch.in +++ pages/arch.in @@ -77,11 +77,12 @@

Parser

The parser assigns meaning to tokens based on their context. The parser for SQLite is generated using the -Lemon LALR(1) parser generator. +Lemon +LALR(1) parser generator. Lemon does the same job as YACC/BISON, but it uses a different input syntax which is less error-prone. Lemon also generates a parser which is reentrant and thread-safe. And Lemon defines the concept of a non-terminal destructor so that it does not leak memory when syntax errors are encountered. Index: pages/changes.in ================================================================== --- pages/changes.in +++ pages/changes.in @@ -18,10 +18,42 @@ global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } + +chng {2016-11-28 (3.15.2)} { +

  • Multiple bug fixes to the [row value] logic that was introduced in version 3.15.0. +
  • Fix a NULL pointer dereference in ATTACH/DETACH following a maliciously constructed + syntax error. Ticket + [https://www.sqlite.org/src/info/2f1b168ab4d4844|2f1b168ab4d4844]. +
  • Fix a crash that can occur following an out-of-memory condition + in the built-in [instr()] function. +
  • In the [json1|JSON extension], fix the JSON validator so that it correctly rejects + invalid backslash escapes within strings. +

    Hashes: +

  • SQLITE_SOURCE_ID: "2016-11-28 19:13:37 bbd85d235f7037c6a033a9690534391ffeacecc8" +
  • SHA1 for sqlite3.c: 06d77b42a3e70609f8d4bbb97caf53652f1082cb +} {patchagainst 1 patchagainst 2} + +chng {2016-11-04 (3.15.1)} { +
  • Added [SQLITE_FCNTL_WIN32_GET_HANDLE] file control opcode. +
  • Fix the [VACUUM] command so that it spills excess content to disk rather + than holding everything in memory, and possible causing an out-of-memory + error for larger database files. This fixes an issue introduced by + version 3.15.0. +
  • Fix a case (present since 3.8.0 - [dateof:3.8.0]) + where OR-connected terms in the ON clause of a LEFT JOIN + might cause incorrect results. Ticket + [https://www.sqlite.org/src/info/34a579141b2c5ac|34a579141b2c5ac]. +
  • Fix a case where the use of [row values] in the ON clause of a LEFT JOIN + might cause incorrect results. Ticket + [https://www.sqlite.org/src/info/fef4bb4bd9185ec8f|fef4bb4bd9185ec8f]. +

    Hashes: +

  • SQLITE_SOURCE_ID: "2016-11-04 12:08:49 1136863c76576110e710dd5d69ab6bf347c65e36" +
  • SHA1 for sqlite3.c: e7c26a7be3e431dd06898f8d262c4ef240c07366 +} {patchagainst 1} chng {2016-10-14 (3.15.0)} {
  • Added support for [row values].
  • Allow [deterministic SQL functions] in the WHERE clause of a [partial index].
  • Added the "[modeof|modeof=filename]" URI parameter on the unix VFS Index: pages/chronology.in ================================================================== --- pages/chronology.in +++ pages/chronology.in @@ -26,10 +26,12 @@ # A small amount of manual editing and de-duplication followed. # # Manually edit the list for each subsequent release. # foreach line [split { +bbd85d235f|2016-11-28|Version 3.15.2 +1136863c76|2016-11-04|Version 3.15.1 707875582f|2016-10-14|Version 3.15.0 29dbef4b85|2016-09-12|Version 3.14.2 a12d805977|2016-08-11|Version 3.14.1 d5e9805702|2016-08-08|Version 3.14 fc49f556e4|2016-05-18|Version 3.13.0 Index: pages/famous.in ================================================================== --- pages/famous.in +++ pages/famous.in @@ -121,13 +121,12 @@ famous_user php http://www.php.net/ php.gif { The popular [http://www.php.net/ | PHP] programming language comes with both SQLite2 and SQLite3 built in. } famous_user python http://www.python.org/ python.gif { - SQLite comes bundled with the - [http://docs.python.org/lib/module-sqlite3.html | Python] - programming language since Python 2.5. + All [http://docs.python.org/lib/module-sqlite3.html | Python] + distributions since Python 2.5 include SQLite. } famous_user xojo http://www.xojo.com/ xojo.png { SQLite comes bundled with the [http://www.xojo.com/|Xojo] programming environment (formerly [http://www.realbasic.com/ | REALbasic]) Index: pages/index.in ================================================================== --- pages/index.in +++ pages/index.in @@ -12,11 +12,11 @@ SQLite is the [most used] database engine in the world. More Info


    Latest Release:   -Version 3.15.0 ([dateof:3.15.0]). +Version 3.15.2 ([dateof:3.15.2]). Download Prior Releases

    @@ -69,15 +69,10 @@ image expensify.png width 225 height 32 blurb "We power the most exciting companies in the world using SQLite." } - {name Facebook - url https://www.facebook.com/ - image fb.gif - blurb "Giving people the power to share and make the world more open and connected." - } } set sep { var sponsors = [} set nspons 0 foreach spons $sponsors { hd_putsnl $sep\173 Index: pages/news.in ================================================================== --- pages/news.in +++ pages/news.in @@ -16,10 +16,20 @@ regsub -all {[Tt]icket #(\d+)} $txt \ {\0} txt hd_resolve "
    $txt
    " hd_puts "
    " } + +newsitem {2016-11-28} {Release 3.15.2} { +SQLite [version 3.15.2] is a bug-fix patch release that fixes several minor +issues in the 3.15.0 and 3.15.1 releases. +} + +newsitem {2016-11-04} {Release 3.15.1} { +SQLite [version 3.15.1] is a bug-fix patch release that fixes some minor +issues in the 3.15.0 release. +} newsitem {2016-10-14} {Release 3.15.0} { SQLite [version 3.15.0] is a regularly scheduled maintenance release. The key feature in this release is the added support for [row values]. There are also other enhancements and Index: pages/rowvalue.in ================================================================== --- pages/rowvalue.in +++ pages/rowvalue.in @@ -175,11 +175,11 @@ WHERE (year,month,day) BETWEEN (2015,9,12) AND (2016,9,12);

    Search against multi-column keys

    -

    Suppose we want to know the order number, product number, and quanity +

    Suppose we want to know the order number, product number, and quantity for any item in which the product number and quantity match the product number and quantity of any item in order number 365: SELECT ordid, prodid, qty