2017-05-24 22:08:51 by Adam Ciarcinski | Files touched by this commit (1) |
Log message:
Match sqlite3 version
|
2017-03-30 17:56:06 by Adam Ciarcinski | Files touched by this commit (1) |
Log message:
Follow sqlite3 version
|
2017-02-13 18:44:01 by Adam Ciarcinski | Files touched by this commit (8) |
Log message:
SQLite Release 3.17.0 On 2017-02-13
* Approximately 25% better performance from the R-Tree extension.
* Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for \
byteswapping when available.
* Uses the sqlite3_blob key/value access object instead of SQL for pulling \
content out of R-Tree nodes
* Other miscellaneous enhancements such as loop unrolling.
* Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
* Increase the default lookaside size from 512,125 to 1200,100 as this provides \
better performance while only adding 56KB of extra memory per connection. \
Memory-sensitive applications can restore the old default at compile-time, \
start-time, or run-time.
* Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(), and \
__builtin_mul_overflow() when available. (All compiler built-ins can be omitted \
with the SQLITE_DISABLE_INTRINSIC compile-time option.)
* Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which can result in \
significantly smaller database files for some applications, at the risk of being \
incompatible with older versions of SQLite.
* Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for improved performance.
* Added the SQLITE_UINT64_TYPE compile-time option as an analog to SQLITE_INT64_TYPE.
* Perform some UPDATE operations in a single pass instead of in two passes.
* Enhance the session extension to support WITHOUT ROWID tables.
* Fixed performance problems and potential stack overflows when creating views \
from multi-row VALUES clauses with hundreds of thousands of rows.
* Added the sha1.c extension.
* In the command-line shell, enhance the ".mode" command so that it \
restores the default column and row separators for modes "line", \
"list", "column", and "tcl".
* Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it works in WAL mode as \
long as the pages being read are not in the WAL file.
* Enhance the LEMON parser generator so that it can store the parser object as a \
stack variable rather than allocating space from the heap and make use of that \
enhancement in the amalgamation.
* Other performance improvements. Uses about 6.5% fewer CPU cycles.
Bug Fixes:
* Throw an error if the ON clause of a LEFT JOIN references tables to the right \
of the ON clause. This is the same behavior as PostgreSQL. Formerly, SQLite \
silently converted the LEFT JOIN into an INNER JOIN.
* Use the correct affinity for columns of automatic indexes.
* Ensure that the sqlite3_blob_reopen() interface can correctly handle short rows.
|
2017-01-07 11:23:00 by Adam Ciarcinski | Files touched by this commit (6) |
Log message:
Changes 3.16.2:
Fix the REPLACE statement for WITHOUT ROWID tables that lack secondary indexes \
so that it works correctly with triggers and foreign keys. This was a new bug \
caused by performance optimizations added in version 3.16.0. Ticket 30027b613b4
Fix the sqlite3_value_text() interface so that it correctly translates content \
generated by zeroblob() into a string of all 0x00 characters. This is a \
long-standing issue discovered after the 3.16.1 release by OSS-Fuzz
Fix the bytecode generator to deal with a subquery in the FROM clause that is \
itself a UNION ALL where one side of the UNION ALL is a view that contains an \
ORDER BY. This is a long-standing issue that was discovered after the release of \
3.16.1. See ticket 190c2507.
Adjust the sqlite3_column_count() API so it more often returns the same values \
for PRAGMA statements as it did in prior releases, to minimize disruption to \
applications that might be using that interface in unexpected ways.
|
2017-01-02 18:52:24 by Adam Ciarcinski | Files touched by this commit (8) |
Log message:
SQLite Release 3.16.0 On 2017-01-02
Uses 9% fewer CPU cycles. (See the CPU performance measurement report for \
details on how the this performance increase was computed.)
Added experimental support for PRAGMA functions.
Added the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE option to sqlite3_db_config().
Enhance the date and time functions so that the 'unixepoch' modifier works for \
the full span of supported dates.
Changed the default configuration of the lookaside memory allocator from 500 \
slots of 128 bytes each into 125 slots of 512 bytes each.
Enhanced "WHERE x NOT NULL" partial indexes so that they are usable if \
the "x" column appears in a LIKE or GLOB operator.
Enhanced sqlite3_interrupt() so that it interrupts checkpoint operations that \
are in process.
Enhanced the LIKE and GLOB matching algorithm to be faster for cases when the \
pattern contains multiple wildcards.
Added the SQLITE_FCNTL_WIN32_GET_HANDLE file control opcode.
Added ".mode quote" to the command-line shell.
Added ".lint fkey-indexes" to the command-line shell.
Added the .imposter dot-command to the command-line shell.
Added the remember(V,PTR) SQL function as a loadable extension.
Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE to \
better reflect the implications of using it.
Bug Fixes:
Fix a long-standing bug in the query planner that caused incorrect results on a \
LEFT JOIN where the left-hand table is a subquery and the join constraint is a \
bare column name coming from the left-hand subquery. Ticket 2df0107b.
Correctly handle the integer literal -0x8000000000000000 in the query planner.
|
2016-11-29 09:46:48 by Adam Ciarcinski | Files touched by this commit (3) |
Log message:
SQLite Release 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.
* Fix a crash that can occur following an out-of-memory condition in the \
built-in instr() function.
* In the JSON extension, fix the JSON validator so that it correctly rejects \
invalid backslash escapes within strings.
|
2016-11-06 15:51:49 by Adam Ciarcinski | Files touched by this commit (1) |
Log message:
Sync with sqlite3.15.1
|
2016-10-22 02:18:39 by Kamil Rytarowski | Files touched by this commit (6) | |
Log message:
Upgrade lemon 1.0 from sqlite 3.5.9 to lemon 1.0 from sqlite 3.15.0
pkgsrc changes
==============
Bind this package with databases/sqlite3 to get immediate updates along
with the sqlite3 package.
Set new versioning policy and concatenate versions of lemon and sqlite3.
The reasoning for it is as follows:
- currently lemon is an integral part of sqlite3
- lemon has its own conservative versioning regardless of changes in its code
- leave room for possible standalone lemon package with bumped versions
- reflect reality and make it human readable without checking the sources
Set LICENSE to public-domain.
Install documentation in the HTML format.
Compile with LDFLAGS set.
Finally don't use databases/sqlite3/Makefile.common as lemon is not
distributed in the same archive. Make use of Makefile.version that does the
same job of tracking upstream.
Do not set PKGCONFIG_OVERRIDE in Makefile.common, it is not accessible in
sqlite3-tcl.
Upstream changelog
==================
Changes are unknown, but at least the program acquired a -T command line
option used by brlcad.
|
2015-11-03 04:29:40 by Alistair G. Crooks | Files touched by this commit (1995) |
Log message:
Add SHA512 digests for distfiles for devel category
Issues found with existing distfiles:
distfiles/eclipse-sourceBuild-srcIncluded-3.0.1.zip
distfiles/fortran-utils-1.1.tar.gz
distfiles/ivykis-0.39.tar.gz
distfiles/enum-1.11.tar.gz
distfiles/pvs-3.2-libraries.tgz
distfiles/pvs-3.2-linux.tgz
distfiles/pvs-3.2-solaris.tgz
distfiles/pvs-3.2-system.tgz
No changes made to these distinfo files.
Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden). All existing
SHA1 digests retained for now as an audit trail.
|
2012-10-31 12:19:55 by Aleksej Saushev | Files touched by this commit (1460) |
Log message:
Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.
|