[no description] https://git.osdyson.ru/mirror/pkgsrc/atom?h=pkgsrc_2011Q1 2009-07-22T16:37:26Z 2009-07-22T16:37:26Z drochner drochner 2009-07-22T16:37:26Z urn:sha1:170dfc8f0a0503af099c3e938ae917ad30905421 bugfix: That bug might possibly cause database corruption if a large INSERT or UPDATE statement within a multi-statement transaction fails due to a uniqueness constraint but the containing transaction commits. 2005-02-24T16:05:25Z wiz wiz 2005-02-24T16:05:25Z urn:sha1:df619149a31cad965978b54a5400b432f070dae0 2005 February 15 (2.8.16) * Fix a bug that can lead to database corruption if there are two open connections to the same database and one connection does a VACUUM and the second makes some change to the database. * Correctly handle quoted names in CREATE INDEX statements. * Fix a naming conflict between sqlite.h and sqlite3.h. * Avoid excess heap usage when copying expressions. * Other minor bug fixes. 2004-08-04T19:59:58Z jlam jlam 2004-08-04T19:59:58Z urn:sha1:50038fcedf8e31ce78551a68156157254c7ece74 release over version 2.8.14 that fixes some memory allocation and quoting problems. 2004-03-31T05:50:17Z snj snj 2004-03-31T05:50:17Z urn:sha1:9f3d787a9d7283db50bfb028cb7aa4bbb9609aa1 FreeBSD 4 portability hint from Michal Pasternak. Some of the changes since 2.8.5 include: * Refactor parts of the code in order to make the code footprint smaller. The code is now also a little bit faster. * The built-in min() and max() functions now honor the difference between NUMERIC and TEXT datatypes. * New HH:MM:SS modifier to the built-in date/time functions. * Add function prototypes for the database encryption API. * Fix a bug that might corrupt the rollback journal if a power failure or external program halt occurs in the middle of a COMMIT. * Reduce the size and increase the speed of various modules. * Fix a potential database corruption problem on Unix. * Fix a 32-bit integer overflow problem that could result in corrupt indices in a database if large negative numbers (less than -2147483648) were inserted into a indexed numeric column. * Fix a locking problem on multi-threaded Linux implementations. * Fix a critical bug introduced in 2.8.0 which could cause database corruption. * The VACUUM command now works with the non-callback API * If the name of the database is an empty string, open a new database in a temporary file that is automatically deleted when the database is closed. * Performance enhancements in the lemon-generated parser * Documentation updates and typo fixes * Removed support for the Oracle8 outer join syntax. * Allow GLOB and LIKE operators to work as functions. * Make sure the journal file directory entry is committed to disk before writing the database file. 2003-12-30T14:41:09Z cjep cjep 2003-12-30T14:41:09Z urn:sha1:97504f113a70e021bd5d333f2ec443fbe9e259b8 2003-12-29T20:03:31Z cjep cjep 2003-12-29T20:03:31Z urn:sha1:67e12ebff42f6a935df1593c41bd2c72c0c2c6bd From Michal Pasternak in PR#23828. 2003-06-25T19:24:21Z tsarna tsarna 2003-06-25T19:24:21Z urn:sha1:4c84db7b4e85fc5e06e82e1725d4f904d5ff9b41 2003 June 4 (2.8.3) - Fix a problem that will corrupt the indices on a table if you do an INSERT OR REPLACE or an UPDATE OR REPLACE on a table that contains an INTEGER PRIMARY KEY plus one or more indices. - Add the ability for INSERT and UPDATE statements to refer to the "rowid" (or "_rowid_" or "oid") columns. - Other important bug fixes 2003 May 17 (2.8.2) - Fix a problem that will corrupt the database file if you drop a table from the main database that has a TEMP index. 2003 May 16 (2.8.1) - Reactivated the VACUUM command that reclaims unused disk space in a database file. - Added the ATTACH and DETACH commands to allow interacting with multiple database files at the same time. - Added support for TEMP triggers and indices. - Added support for in-memory databases. - Removed the experimental sqlite_open_aux_file(). Its function is subsumed in the new ATTACH command. - The precedence order for ON CONFLICT clauses was changed so that ON CONFLICT clauses on BEGIN statements have a higher precedence than ON CONFLICT clauses on constraints. - Many, many bug fixes and compatibility enhancements. 2001-10-20T18:51:37Z reinoud reinoud 2001-10-20T18:51:37Z urn:sha1:ab177a7efe163d947feee2d409f0795ef6166301 less invasive as posible without rewriting stuff. The main problems were the assumption that a pointer and an int had the same size. Also there were strange casts near calculations that were not nessisary. 2001-10-16T16:20:08Z jlam jlam 2001-10-16T16:20:08Z urn:sha1:36923eb954340ca233902e100fdf9589afeb3ad3 SQLite is a C library that implements an SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library. SQLite is not a client library used to connect to a big database server. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk.