CVS log for pkgsrc/databases/sqlite/Makefile

Up to [cvs.NetBSD.org] / pkgsrc / databases / sqlite

Request diff between arbitrary revisions

Keyword substitution: kv
Default branch: MAIN

clean-up master site

databases/sqlite: reinstall masking in hash computation.

Suggested by Taylor Campbell.

databases/sqlite: add a minor fix to the lemon tool.

On NetBSD/powerpc, 'hash' ended up negative, causing a SEGV.
Instead, make the variable unsigned.
Bump PKGREVISION.

all: migrate homepages from http to https

pkglint -r --network --only "migrate"

As a side-effect of migrating the homepages, pkglint also fixed a few
indentations in unrelated lines. These and the new homepages have been
checked manually.

Convert all occurrences (353 by my count) of

	MASTER_SITES= 	site1 \
			site2

style continuation lines to be simple repeated

	MASTER_SITES+= site1
	MASTER_SITES+= site2

lines. As previewed on tech-pkg. With thanks to rillig for fixing pkglint
accordingly.

* .include "../../devel/readline/buildlink3.mk" with USE_GNU_READLINE=yes
  are replaced with .include "../../devel/readline/buildlink3.mk", and
  USE_GNU_READLINE are removed,

* .include "../../devel/readline/buildlink3.mk" without USE_GNU_READLINE
  are replaced with .include "../../mk/readline.buildlink3.mk".

Add explanations to DESCR for sqlite packages because it is quite
boggling that, e.g., py-sqlite2 is a wrapper for sqlite3.

Clean up out-of-srcdir build handling.

Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.

update to 2.8.17
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.

Support staged installation.

Recursive ABI depends update and PKGREVISION bump for readline-6.0 shlib
major change.

Reported by Robert Elz in PR 41345.

Match all Solaris releases.

fix building on SunOS-5.8/sparc and probably other SunOS-5.[6-9]

Mechanically replaced man/* with ${PKGMANDIR}/* in the definition of
INSTALLATION_DIRS, as well as all occurrences of ${PREFIX}/man with
${PREFIX}/${PKGMANDIR}.

Fixes PR 35265, although I did not use the patch provided therein.

Point MAINTAINER to pkgsrc-users@NetBSD.org in the case where no
developer is officially maintaining the package.

The rationale for changing this from "tech-pkg" to "pkgsrc-users" is
that it implies that any user can try to maintain the package (by
submitting patches to the mailing list).  Since the folks most likely
to care about the package are the folks that want to use it or are
already using it, this would leverage the energy of users who aren't
developers.

Recursive revision bump / recommended bump for gettext ABI change.

Override config.guess and config.sub for DragonFly.

Remove USE_GNU_TOOLS and replace with the correct USE_TOOLS definitions:

	USE_GNU_TOOLS	-> USE_TOOLS
	awk		-> gawk
	m4		-> gm4
	make		-> gmake
	sed		-> gsed
	yacc		-> bison

Remove USE_BUILDLINK3 and NO_BUILDLINK; these are no longer used.

fix path to pkgconfig file
(hope this was quick enough to avoid a PKGREVISION bump)

Update to 2.8.16:
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.

Libtool fix for PR pkg/26633, and other issues.  Update libtool to 1.5.10
in the process.  (More information on tech-pkg.)

Bump PKGREVISION and BUILDLINK_DEPENDS of all packages using libtool and
installing .la files.

Bump PKGREVISION (only) of all packages depending directly on the above
via a buildlink3 include.

PKGREVISION++

Point to correct location of VERSION file so we save the correct version
into pkgconfig file.
Addresses PR pkg/26875 by Ian Zagorskih.

Update databases/sqlite to 2.8.15.  This is a bug-fix maintenance
release over version 2.8.14 that fixes some memory allocation and
quoting problems.

update to 2.8.14
changes:
Fix the min() and max() optimizer so that it works when the FROM clause
 consists of a subquery.
Ignore extra whitespace at the end of of "." commands in the shell.
Bundle sqlite_encode_binary() and sqlite_decode_binary() with the library.
The TEMP_STORE and DEFAULT_TEMP_STORE pragmas now work.
Code changes to compile cleanly using OpenWatcom.
Fix VDBE stack overflow problems with INSTEAD OF triggers and NULLs in
 IN operators.
Add the global variable sqlite_temp_directory which if set defines
the directory in which temporary files are stored.
sqlite_interrupt() plays well with VACUUM.
Other minor bug fixes.

install manual page

Relinquish maintainership of packages to tech-pkg@NetBSD.org.

Update to sqlite-2.8.13.  Closes PR pkg/24660.

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.

LIBTOOL_OVERRIDE and SHLIBTOOL_OVERRIDE are now lists of shell globs
relative to ${WRKSRC}.  Remove redundant LIBTOOL_OVERRIDE settings that
are automatically handled by the default setting in bsd.pkg.mk.

replace deprecated USE_GMAKE with USE_GNU_TOOLS+=make.

Move WRKSRC definition away from the first paragraph in a Makefile.

update to 2.8.5
changes:
Make LIMIT work on a compound SELECT statement.
LIMIT 0 now shows no rows. Use LIMIT -1 to see all rows.
Correctly handle comparisons between an INTEGER PRIMARY KEY and a
	floating point number.
Fix several important bugs in the new ATTACH and DETACH commands.
Updated the NULL-handling document.
Allow NULL arguments in sqlite_compile() and sqlite_step().
Many minor bug fixes
Enhanced the "PRAGMA integrity_check" command to verify indices.
Added authorization hooks for the new ATTACH and DETACH commands.
Many documentation updates

s/netbsd.org/NetBSD.org/

Update sqlite to 2.8.3. Major relevant changes:

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.

Place WRKSRC where it belongs, to make pkglint happy; ok'ed by wiz.

Add http://www.sqlite.org/ as download site.

Update sqlite to version 2.8.0.

An update to 2.7.5 was provided in PR 19719 by Jarkko Torppa.

Main changes are support for endian-neutral databases, and a huge number of
bug fixes.

Prefer BUILDLINK_PREFIX.* to BUILDLINK_DIR.

buildlink1 -> buildlink2.

Major upgrade of Sqlite from version 2.1.7 to version 2.2.5

Lots of bug fixes in SQL parsing and supports more weildy SQL code like
using the right of an AS in athe column list of a SELECT as part of an
expression in the WHERE, ORDER BY, GROUP BY and/of HAVING clauses.

For a full report see the changelog on
http://www.hwaci.com/sw/sqlite/changes.html

Revert previous changes so that they can be done in the approriate way.

*** empty log message ***

Don't use c99 uint*_t types, since they're not defined on 1.5.2 and
previous releases. Instead, fall back on the trusty u_int*_t types
from <sys/types.h>

Fixes a problem uncovered on a recent 1.5.2 bulk build.

Small typo fixes to make `pkglint' happier....

Updated SQLite package to version 2.1.7 fixing

1) locking problems due to a few race conditions

2)  fixing a bug in `create temporary table' wich could contaminate the
main database file opened too

3) bug fix in b-tree subsystem that could sometimes cause the first row of
a table to be repeated during a database scan.

Update sqlite package to version 2.1.4 (2001-12-04) incorporating lockup
bugs removal, fixing the behaviour of comparison operators so that they are
consistent with the order of entries in an index, correct handling of
integers in SQL expressions that are larger than what can be represented by
the machine integer and locking protocol fixes.

The author also incorporated my suggestions after the messy LP64 patches I
made; its now a lot more clean allthough there are still a few warnings but
they are checked and OK.

Just noted that some important bugfixes were made to version 2.1.0 to make
version 2.1.1

Update SQLite package to version 2.1.0 from 2.0.5

databases/sqlite: SQL Database Engine In A C Library

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.

Initial revision