summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2013-05-20Do not poison build flags with mysql-client bl3 dirs.fhajny2-2/+4
2013-05-20Changes 3.7.17:adam7-25/+29
Add support for memory-mapped I/O. Add the sqlite3_strglob() convenience interface. Assigned the integer at offset 68 in the database header as the Application ID for when SQLite is used as an application file-format. Added the PRAGMA application_id command to query and set the Application ID. Report rollback recovery in the error log as SQLITE_NOTICE_RECOVER_ROLLBACK. Change the error log code for WAL recover from SQLITE_OK to SQLITE_NOTICE_RECOVER_WAL. Report the risky uses of unlinked database files and database filename aliasing as SQLITE_WARNING messages in the error log. Added the SQLITE_TRACE_SIZE_LIMIT compile-time option. Increase the default value of SQLITE_MAX_SCHEMA_RETRY to 50 and make sure that it is honored in every place that a schema change might force a statement retry. Add a new test harness called "mptester" used to verify correct operation when multiple processes are using the same database file at the same time. Enhance the extension loading mechanism to be more flexible (while still maintaining backwards compatibility) in two ways: If the default entry point "sqlite3_extension_init" is not present in the loadable extension, also try an entry point "sqlite3_X_init" where "X" is based on the shared library filename. This allows every extension to have a different entry point, which allows them to be statically linked with no code changes. The shared library filename passed to sqlite3_load_extension() may omit the filename suffix, and an appropriate architecture-dependent suffix (".so", ".dylib", or ".dll") will be added automatically. Added many new loadable extensions to the source tree, including amatch, closure, fuzzer, ieee754, nextchar, regexp, spellfix, and wholenumber. See header comments on each extension source file for further information about what that extension does. Enhance FTS3 to avoid using excess stack space when there are a huge number of terms on the right-hand side of the MATCH operator. A side-effect of this change is that the MATCH operator can only accommodate 12 NEAR operators at a time. Enhance the fts4aux virtual table so that it can be a TEMP table. Added the fts3tokenize virtual table to the full-text search logic. Query planner enhancement: Use the transitive property of constraints to move constraints into the outer loops of a join whenever possible, thereby reducing the amount of work that needs to occur in inner loops. Discontinue the use of posix_fallocate() on unix, as it does not work on all filesystems. Improved tracing and debugging facilities in the Windows VFS. Bug fix: Fix a potential database corruption bug in shared cache mode when one database connection is closed while another is in the middle of a write transaction. Bug fix: Only consider AS names from the result set as candidates for resolving identifiers in the WHERE clause if there are no other matches. In the ORDER BY clause, AS names take priority over any column names. Bug fix: Do not allow a virtual table to cancel the ORDER BY clause unless all outer loops are guaranteed to return no more than one row result. Bug fix: Do not suppress the ORDER BY clause on a virtual table query if an IN constraint is used. Bug fix: The command-line shell gives an exit code of 0 when terminated using the ".quit" command. Bug fix: Make sure PRAGMA statements appear in sqlite3_trace() output. Bug fix: When a compound query that uses an ORDER BY clause with a COLLATE operator, make sure that the sorting occurs according to the specified collation and that the comparisons associate with the compound query use the native collation. Bug fix: Makes sure the authorizer callback gets a valid pointer to the string "ROWID" for the column-name parameter when doing an UPDATE that changes the rowid. Bug fix: Do not move WHERE clause terms inside OR expressions that are contained within an ON clause of a LEFT JOIN. Bug fix: Make sure an error is always reported when attempting to preform an operation that requires a collating sequence that is missing.
2013-05-20Update to 1.627wen2-6/+6
Upstream changes: Changes in DBI 1.627 - 16th May 2013 Fixed VERSION regression in DBI::SQL::Nano [Tim Bunce] Changes in DBI 1.626 - 15th May 2013 Fixed pod text/link was reversed in a few cases RT#85168 [H.Merijn Brand] Handle aliasing of STORE'd attributes in DBI::DBD::SqlEngine [Jens Rehsack] Updated repository URI to git [Jens Rehsack] Fixed skip() count arg in t/48dbi_dbd_sqlengine.t [Tim Bunce]
2013-05-20Explicitly set WITH_EMBEDDED_SERVER=OFF, because the default OFF doesn'tfhajny1-1/+2
seem to be respected.
2013-05-20Rely on mysql{55,56}-client's bl3 to restrict the dependency of serverfhajny2-10/+6
on client. Fixes situations where a binary mysql55-server package picks up mysql56-client as the best dependency because of the missing upper limit. Bump PKGREVISION.
2013-05-10Remove 83 from PGSQL_VERSIONS_ACCEPTED, as it's no longer available.fhajny3-6/+6
2013-05-10Fix interpretter skip pathfhajny1-4/+4
2013-05-10Pre-answer openldap autoconf run-tests for NetBSD cross-builds.riastradh1-1/+7
2013-05-09Massive revbump after updating graphics/ilmbase, graphics/openexr, textproc/icu.adam21-35/+42
2013-05-06Update p5-DBD-CSV to 0.38.hiramatsu2-7/+6
Changes from previous: ---------------------- * Fixed RT#80078, resulting in getline calls on undef (Benjamin Booth) * Require latest DBI and SQL::Statement * Updated copyright to 2013 * Fixes for DBI-1.623 (Jens Rehsack)
2013-05-06Update to 0.53wen2-7/+6
Upstream changes: 0.53 2013-03-20T06:04:34Z - Fixed some documentation typos, thanks to Mike O'Regan (Issue #22). - Fixed issue where an connection failure caused an unhelpful error (Issue #26).
2013-05-06Add more test() changes for the server.joerg69-30/+2165
2013-05-04Update to 2.5:wiz3-8/+17
What's new in psycopg 2.5 ------------------------- New features: - Added :ref:`JSON adaptation <adapt-json>`. - Added :ref:`support for PostgreSQL 9.2 range types <adapt-range>`. - `connection` and `cursor` objects can be used in ``with`` statements as context managers as specified by recent |DBAPI|_ extension. - Added `~psycopg2.extensions.Diagnostics` object to get extended info from a database error. Many thanks to Matthew Woodcraft for the implementation (:ticket:`#149`). - Added `connection.cursor_factory` attribute to customize the default object returned by `~connection.cursor()`. - Added support for backward scrollable cursors. Thanks to Jon Nelson for the initial patch (:ticket:`#108`). - Added a simple way to :ref:`customize casting of composite types <adapt-composite>` into Python objects other than namedtuples. Many thanks to Ronan Dunklau and Tobias Oberstein for the feature development. - `connection.reset()` implemented using :sql:`DISCARD ALL` on server versions supporting it. Bug fixes: - Properly cleanup memory of broken connections (:ticket:`#148`). - Fixed bad interaction of ``setup.py`` with other dependencies in Distribute projects on Python 3 (:ticket:`#153`). Other changes: - Added support for Python 3.3. - Dropped support for Python 2.4. Please use Psycopg 2.4.x if you need it. - `~psycopg2.errorcodes` map updated to PostgreSQL 9.2. - Dropped Zope adapter from source repository. ZPsycopgDA now has its own project at <http://github.com/psycopg/ZPsycopgDA>.
2013-05-04Added slapi support as an optionadam3-5/+18
2013-05-03Update to 0.46.gdt3-28/+6
- 0.46 | 2013-03-14 - bugfix: handle connection options w/o "backup" env var Previously, ‘pg-conndefaults’ expected every option to have a backup env var (e.g., option ‘#:host’ and env var ‘PGHOST’). For later versions of PostgreSQL which no longer maintain this 1:1 correspondance, Guile-PG would segfault. Now, in such cases, the value associated w/ the key ‘#:envvar’ in the alist returned by ‘pg-conndefaults’ is ‘#f’. - planned retirement - procedure ‘(database postgres) pg-getline’ - procedure ‘(database postgres) pg-getlineasync’ - procedure ‘(database postgres) pg-putline’ - procedure ‘(database postgres) pg-endcopy’ These procedures are obsoleted by ‘pg-get-copy-data’ and ‘pg-put-copy-data’. They WILL BE REMOVED by 2013-12-31. Actually, the first two were originally -- in Guile-PG 0.41 (2011-09-29) -- planned to be removed by 2012-12-31. Support has been extended for solidarity w/ the latter two. - bootstrap tools upgraded - GNU Texinfo 5.1 Copyright (C) 2002-2013 Thien-Thi Nguyen Copying and distribution of this file, with or without modification, are permitted provided the copyright notice and this notice are preserved.
2013-05-02Update to 0.08250wen2-12/+13
Update DEPENDS Upstream changes: 0.08250 2013-04-29 22:00 (UTC) * New Features / Changes - Rewrite from scratch the result constructor codepath - many bugfixes and performance improvements (the current codebase is now capable of outperforming both DBIx::DataModel and Rose::DB::Object on some workloads). Some notable benefits: - Multiple has_many prefetch - Partial prefetch - you now can select only columns you are interested in, while preserving the collapse functionality (collapse is now exposed as a first-class API attribute) - Prefetch of resultsets with arbitrary order (RT#54949, RT#74024, RT#74584) - Prefetch no longer inserts right-side table order_by clauses (massively helps the deficient MySQL optimizer) - Prefetch with limit on right-side ordered resultsets now works correctly (via aggregated grouping) - No longer order the insides of a complex prefetch subquery, unless required to satisfy a limit - Stop erroneously considering order_by criteria from a join under distinct => 1 (the distinct should apply to the main source only) - Massively optimize codepath around ->cursor(), over 10x speedup on some iterating workloads. - Support standalone \[ $sql, $value ] in literal SQL with bind specifications: \[ '? + ?', 42, 69 ] is now equivalent to \[ '? + ?', [ {} => 42 ], [ {} => 69 ] ] - Changing the result_class of a ResultSet in progress is now explicitly forbidden. The behavior was undefined before, and would result in wildly differing outcomes depending on $rs attributes. - Deprecate returning of prefetched 'filter' rels as part of get_columns() and get_inflated_columns() data - Invoking get_inflated_columns() no longer fires get_columns() but instead retrieves data from individual non-inflatable columns via get_column() - Emit a warning on incorrect use of nullable columns within a primary key - Limited checks are performed on whether columns without declared is_nullable => 1 metadata do in fact sometimes fetch NULLs from the database (the check is currently very limited and is performed only on resultset collapse when the alternative is rather worse) * Fixes - Fix _dbi_attrs_for_bind() being called befor DBI has been loaded (regression in 0.08210) - Fix update/delete operations on resultsets *joining* the updated table failing on MySQL. Resolves oversights in the fixes for RT#81378 and RT#81897 - Fix open cursors silently resetting when inherited across a fork or a thread - Properly support "MySQL-style" left-side group_by with prefetch - Fix $grouped_rs->get_column($col)->func($func) producing incorrect SQL (RT#81127) - Stop Sybase ASE storage from generating invalid SQL in subselects when a limit without offset is encountered - Even more robust behavior of GenericSubQuery limit dialect - Make sure deployment_statements() and cursor_class() are called on a resolved storage subclass * Misc - Fix tests failing due to unspecified resultset retrieval order (test suite now will pass with newest SQLite libs) 0.08210 2013-04-04 15:30 (UTC) * New Features / Changes - Officially deprecate the 'cols' and 'include_columns' resultset attributes - Remove ::Storage::DBI::sth() deprecated in 0.08191 * Fixes - Work around a *critical* bug with potential for data loss in DBD::SQLite - RT#79576 - Audit and correct potential bugs associated with braindead reuse of $1 on unsuccessful matches - Fix incorrect warning/exception originator reported by carp*() and throw_exception() 0.08209 2013-03-01 12:56 (UTC) * New Features / Changes - Debugging aid - warn on invalid result objects created by what seems like an invalid inheritance hierarchy * Fixes - Fix another embarrassing regression preventing correct refining of the search criteria on a prefetched relation (broken in 0.08205) - Fix incorrect callsite reporting by DBIC::Carp 0.08208 2013-02-20 09:56 (UTC) * New Features / Changes - A bunch of nonsensically named arguments to the SQL::Translator parser have been marked as deprecated (while still fully supported) * Fixes - Fix duplicated selected columns when calling 'count' when a same aggregate function is used more than once in a 'having' clause (RT#83305) - Prevent SQL::Translator::Producer::YAML from seeing the $dbh in a potentially connected $schema instance (RT#75394) * Misc - Fixup our distbuilding process to stop creating world-writable tarball contents (implicitly fixes RT#83084) - Added strict and warnings tests for all lib and test files 0.08206 2013-02-08 * Fixes - Fix dbh_do() failing to properly reconnect (regression in 0.08205) - Extra sanity check of a fresh DBI handle ($dbh). Fixes connection coderefs returning garbage (seen in the wild) * Misc - Only allow known globals in SQL::Translator leak allowance - General cleanup of error message texts - quote names/identifiers for easier reading - Stop t/52leaks.t from failing when AUTOMATED_TESTING=1
2013-05-02Update to 1.625wen2-6/+6
UPstream changes: Changes in DBI 1.625 (svn r15595) 28th March 2013 Fixed heap-use-after-free during global destruction RT#75614 thanks to Reini Urban. Changes in DBI 1.624 (svn r15576) 22nd March 2013 Fixed Gofer for hash randomization in perl 5.17.10+ RT#84146 Clarify docs for can() re RT#83207
2013-05-01Ignore interpretters in optional tools.fhajny1-1/+5
2013-04-29Don't define a macro called test. Expect GCC4-like compilers to providejoerg26-8/+696
__func__.
2013-04-29Update Cassandra to 1.2.4.fhajny3-283/+1702
Too many changes upstream, see changelog at: https://github.com/apache/cassandra/blob/cassandra-1.2.4/CHANGES.txt pkgsrc changes: - simplified config file handling - removed pre-install time user/group creation - proper data and log dir handling
2013-04-29Update p5-DBM-Deep to 2.0008.hiramatsu2-7/+6
Changes from previous: ---------------------- 2.0008 Jun 17 13:00:00 2012 PDT - Arrays and hashes retrieved from a database no longer create circular references (RT#77746). 2.0007 May 27 19:35:00 2012 PDT - Include one-line descriptions of each POD page after the name. Thanks to Yves Agostini for the patch and Gregor Herrmann for submitting it (RT#76378). - t/98_pod.t: Skip tests if Pod::Simple 3.21 is installed (RT#77419). 2.0006 Apr 1 17:15:00 2012 PDT - Er, try harder to get t/27_filehandle.t to work under TB2. 2.0005 Mar 25 13:05:00 2012 PDT - t/27_filehandle.t has been fixed again.
2013-04-28Looks like this patch has been forgottenadam1-0/+15
2013-04-24Update "phpmyadmin" package to version 3.5.8.1. Changes since 3.5.8:tron2-6/+6
- [security] Remote code execution (preg_replace), reported by Janek Vind (see PMASA-2013-2) - [security] Locally Saved SQL Dump File Multiple File Extension Remote Code Execution, reported by Janek Vind (see PMASA-2013-3)
2013-04-24Update databases/couchdb to 1.3.0. Changes since 1.2.1:jperkin5-62/+190
Version 1.3.0 ------------- HTTP Interface: * No longer rewrites the X-CouchDB-Requested-Path during recursive calls to the rewriter. * Limit recursion depth in the URL rewriter. Defaults to a maximum of 100 invocations but is configurable. * Fix _session for IE7. * Added Server-Sent Events protocol to db changes API. See http://www.w3.org/TR/eventsource/ for details. * Make password hashing synchronous when using the /_config/admins API. * Include user name in show/list ETags. * Experimental support for Cross-Origin Resource Sharing (CORS). See http://www.w3.org/TR/cors/ for details. Replicator: * The replicator will use a new server-wide UUID in checkpoint IDs to improve the chances of an efficient resume. Storage System: * Fixed unnecessary conflict when deleting and creating a document in the same batch. View Server: * Additional response headers may be varied prior to send(). * GetRow() is now side-effect free. Futon: * Disabled the link to the Futon test suite. These tests were causing problems when run from a browser, and are now available via the CLI instead. * Added view request duration to Futon. * Disable buttons for actions that the user doesn't have permissions to. Security: * Passwords are now hashed using the PBKDF2 algorithm with a configurable work factor. Test Suite: * Moved the JS test suite to the CLI. * Improved tracebacks printed by the JS CLI tests. * Improved the reliability of a number of tests. UUID Algorithms: * Added the utc_id algorithm. URL Rewriter & Vhosts: * Database name is encoded during rewriting (allowing embedded /'s, etc). * Reset rewrite counter on new request, avoiding unnecessary request failures due to bogus rewrite limit reports. Build System: * C/C++ compiler detection has been improved. * Autoconf v2.63 is now required if building from Git checkout directly. See DEVELOPERS file for more details. * Fixed issue in couchdb script where stopped status returns before process exits. Version 1.2.2 ------------- HTTP Interface: * Reset rewrite counter on new request, avoiding unnecessary request failures due to bogus rewrite limit reports. Build System: * Fixed issue in couchdb script where stopped status returns before process exits.
2013-04-24Revbump for all packages that have USE_TOOLS+=gssbd1-1/+2
2013-04-21Update to 4.023ryoon2-7/+6
Changelog: 2013-04-12 Patrick Galbraith et open source community <patg at patg dot net> (4.023) * Fix primary_key_info result ordering - https://github.com/CaptTofu/DBD-mysql/pull/39 - Dagfinn Ilmari Mannsåker * allow compilation with msvc - https://github.com/CaptTofu/DBD-mysql/pull/37 - Walde Christian * just to set MYSQL_OPT_WRITE_TIMEOUT and MYSQL_OPT_READ_TIMEOUT by dsn - https://github.com/CaptTofu/DBD-mysql/pull/36 - Naosuke Yokoe * just remove unnecessary "my" - https://github.com/CaptTofu/DBD-mysql/pull/34 - Shoichi Kaji * eval $ExtUtils::MakeMaker::VERSION requires for old ExtUtils::MakeMaker - https://github.com/CaptTofu/DBD-mysql/pull/32 - Daisuke Murase * Updated documentation to reflect that bugs will be reported at rt.cpan.org * Updated version * Chased tail finding issue with -1 being converted to max unsigned int in PS mode
2013-04-20Change version number of python buitin module packagesobache1-3/+2
form fixed `0' to main Python distribution version (PY_DISTVERSION) so that packages will be updated with main Python distribution update. no objection in tech-pkg@ for a week.
2013-04-20Changes 5.5.31:adam6-18/+36
MySQL no longer uses the default OpenSSL compression. Bug fixes.
2013-04-20Changes 5.6.11:adam9-77/+136
Replication: The functions GTID_SUBTRACT() and GTID_SUBSET() were formerly available in libmysqld only when it was built with replication support. Now these functions are always available when using this library, regardless of how it was built. MySQL no longer uses the default OpenSSL compression. There is now a distinct error code (ER_MUST_CHANGE_PASSWORD_LOGIN) for the error sent by the server to a client authenticating with an expired password. mysql_config_editor now supports --port and --socket options for specifying TCP/IP port number and Unix socket file name. mysqlcheck has a new --skip-database option. The option value is the name of a database (case sensitive) for which checks should be skipped. mysql_upgrade uses this option to upgrade the system tables in the mysql database before tables in other databases: It upgrade the mysql database, then all databases except the mysql database. This avoids problems that can occur if user tables are upgraded before the system tables. The only supported value for the innodb_mirrored_log_groups system variable is 1, so this variable is now deprecated. Setting it to 1 at startup results in a warning. Setting it to a value other than 1 at startup results in an error and the server exits. This variable will be removed in a future release.
2013-04-17Not all linux systems will have netstat(8), but if they don't then they'llsbd1-0/+18
have ss(8) which does the same thing. (With out netstat the build stalls in an endless for loop.) So add a hack that creates a tool named netstat from ss.
2013-04-15Update databases/pgbuildfarm to 4.10gls4-13/+18
From maintainer Nicolas Thauvin via mail to pkgsrc-users. There are two notable upstream changes : - the tarball is now hosted on pgbuildfarm.org instead of pgfoundry - the client has now support for modules allowing to control the build
2013-04-15Changes 3.7.16.2:adam7-22/+23
Fix a bug (present since version 3.7.13) that could result in database corruption on windows if two or more processes try to access the same database file at the same time and immediately after third process crashed in the middle of committing to that same file.
2013-04-14Don't provide own getopt on Solaris. May fix the Solaris build.dholland2-6/+6
2013-04-13Added virtuoso package to SUBDIRSjaapb1-1/+2
2013-04-13Added the virtuoso server, version 6.1.6.jaapb22-0/+917
Virtuoso is a multi-model data server that delivers a platform-agnostic solution for data management, access and integration. Services offered include: * relational data management * RDF data management * XML data management * free text content management & full text indexing * document web server * linked data server * web application server * web services deployment (SOAP or REST)
2013-04-13Changes 2.4.35:adam4-12/+11
Fixed liblmdb mdb_cursor_put with MDB_MULTIPLE Fixed liblmdb page rebalance Fixed liblmdb missing parens Fixed liblmdb mdb_cursor_del crash Fixed slapd syncrepl updateCookie status Fixed slapd connection logging Fixed slapd segfault on modify Fixed slapd-mdb to reject undefined attrs Fixed slapo-pcache with +/- attrsets Build Environment don't install DB_CONFIG if no BDB backends Documentation slapschema(8) fix tool name admin24 fixed pcache example admin24 fixed config examples
2013-04-13Hand in maintainership.ghen1-2/+2
2013-04-12Add and enable p5-App-Sqitch.schmonz1-1/+2
2013-04-12Add p5-App-Sqitch.schmonz3-0/+78
Sqitch is a VCS-aware SQL change management application. What makes it different from your typical migration-style approaches? A few things: * No opinions * Native scripting * VCS integration * Dependency resolution * No numbering * Bundling * Reduced duplication
2013-04-11All other postgresql83 packages were removed, and this one wasjnemeth3-24/+0
removed from the databases/Makefile, making it obvious that the postgresql maintainer intended to remove this one as well, so make it so.
2013-04-10Update the hiera Ruby database module to version 1.1.2 to prepare for thetonnerre3-10/+10
Puppet update. Changes are mostly bugfixes and simplifications, backwards compatibility and caching improvements.
2013-04-09Update "phpmyadmin" package to version 3.5.8. Changes since 3.5.7:tron2-7/+6
- bug #3828 MariaDB reported as MySQL - bug #3854 Incorrect header for Safari 6.0 - bug #3705 Attempt to open trigger for edit gives NULL - Use HTML5 DOCTYPE - [security] Self-XSS on GIS visualisation page, reported by Janek Vind - bug #3800 Incorrect keyhandler behaviour #2
2013-04-08Revert pkglint-induced nonsense.asau4-47/+106
2013-04-08update to 3.4.3drochner2-7/+6
changes: -bugfixes -translation updates
2013-04-08Remove "Trailing empty lines." and/or "Trailing white-space."rodent8-17/+14
2013-04-07Edited DESCR in the case of:rodent5-107/+47
File too long (should be no more than 24 lines). Line too long (should be no more than 80 characters). Trailing empty lines. Trailing white-space. Trucated the long files as best as possible while preserving the most info contained in them.
2013-04-06'The "+=" operator should only be used with lists.'rodent1-2/+2
2013-04-06'You can use "foo" instead of "${WRKSRC}/foo".'rodent4-8/+8
2013-04-06"Please write NetBSD.org instead of netbsd.org"rodent1-2/+2
2013-04-06'For consistency, please add a trailing slash to "http://example.com".'rodent1-2/+2