Received: from mail.netbsd.org (mail.netbsd.org [149.20.53.66]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "mail.NetBSD.org", Issuer "Postmaster NetBSD.org" (verified OK)) by mollari.NetBSD.org (Postfix) with ESMTPS id A69C5A63E0 for ; Sat, 7 Dec 2013 08:23:56 +0000 (UTC) Received: by mail.netbsd.org (Postfix, from userid 605) id 0A15F14A2CF; Sat, 7 Dec 2013 08:23:56 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 644D614A2CE for ; Sat, 7 Dec 2013 08:23:55 +0000 (UTC) X-Virus-Scanned: amavisd-new at NetBSD.org Received: from mail.netbsd.org ([127.0.0.1]) by localhost (mail.NetBSD.org [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id g_JUcnyZTBSP for ; Sat, 7 Dec 2013 08:23:54 +0000 (UTC) Received: from nef.pbox.org (ns.pbox.org [IPv6:2001:41d0:1:e836::1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.netbsd.org (Postfix) with ESMTPS id 4511114A2CA for ; Sat, 7 Dec 2013 08:23:54 +0000 (UTC) Received: from nef.pbox.org (localhost [127.0.0.1]) by nef.pbox.org (8.14.5/8.14.5/) with ESMTP id rB78NnIg028733 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Sat, 7 Dec 2013 09:23:50 +0100 (CET) Received: (from agc@localhost) by nef.pbox.org (8.14.5/8.14.5/Submit) id rB78NnYI026124 for pkgsrc-changes@netbsd.org; Sat, 7 Dec 2013 09:23:49 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id A493714A225 for ; Fri, 6 Dec 2013 19:26:59 +0000 (UTC) X-Virus-Scanned: amavisd-new at NetBSD.org Received: from mail.netbsd.org ([127.0.0.1]) by localhost (mail.NetBSD.org [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id 9AJ-qVavGnLd for ; Fri, 6 Dec 2013 19:26:59 +0000 (UTC) Received: from cvs.netbsd.org (cvs.NetBSD.org [IPv6:2001:4f8:3:7:2e0:81ff:fe30:95bd]) by mail.netbsd.org (Postfix) with ESMTP id CDEED14A218 for ; Fri, 6 Dec 2013 19:26:58 +0000 (UTC) Received: by cvs.netbsd.org (Postfix, from userid 500) id 8226096; Fri, 6 Dec 2013 19:26:58 +0000 (UTC) Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Fri, 6 Dec 2013 19:26:58 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc/databases To: pkgsrc-changes@netbsd.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20131206192658.8226096@cvs.netbsd.org> X-Greylist: Sender passed SPF test, not delayed by milter-greylist-4.4.3 (nef.pbox.org [0.0.0.0]); Sat, 07 Dec 2013 09:23:50 +0100 (CET) Sender: pkgsrc-changes-owner@NetBSD.org List-Id: pkgsrc-changes.NetBSD.org Precedence: bulk Module Name: pkgsrc Committed By: adam Date: Fri Dec 6 19:26:58 UTC 2013 Modified Files: pkgsrc/databases/sqlite3: Makefile distinfo pkgsrc/databases/sqlite3-docs: Makefile PLIST distinfo pkgsrc/databases/sqlite3-tcl: Makefile distinfo Log Message: Changes 3.8.2: Changed the defined behavior for the CAST expression when floating point values greater than +9223372036854775807 are cast into into integers so that the result is the largest possible integer, +9223372036854775807, instead of the smallest possible integer, -9223372036854775808. After this change, CAST(9223372036854775809.0 as INT) yields +9223372036854775807 instead of -9223372036854775808. ← Potentially Incompatible Change! Added support for WITHOUT ROWID tables. Added the skip-scan optimization to the query planner. Extended the virtual table interface, and in particular the sqlite3_index_info object to allow a virtual table to report its estimate on the number of rows that will be returned by a query. Update the R-Tree extension to make use of the enhanced virtual table interface. Add the SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option. Enhanced the comments that are inserted into EXPLAIN output when the SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option is enabled. Performance enhancements in the VDBE, especially to the OP_Column opcode. Factor constant subexpressions in inner loops out to the initialization code in prepared statements. Enhanced the ".explain" output formatting of the command-line shell so that loops are indented to better show the structure of the program. Enhanced the ".timer" feature of the command-line shell so that it shows wall-clock time in addition to system and user times. To generate a diff of this commit: cvs rdiff -u -r1.70 -r1.71 pkgsrc/databases/sqlite3/Makefile cvs rdiff -u -r1.81 -r1.82 pkgsrc/databases/sqlite3/distinfo cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/sqlite3-docs/Makefile cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/sqlite3-docs/PLIST \ pkgsrc/databases/sqlite3-docs/distinfo cvs rdiff -u -r1.51 -r1.52 pkgsrc/databases/sqlite3-tcl/Makefile cvs rdiff -u -r1.34 -r1.35 pkgsrc/databases/sqlite3-tcl/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files.