summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2019-10-25postgresql12: fix nls option supporttriaxx1-2/+2
2019-10-25postgresql11: fix nls option supporttriaxx2-7/+3
2019-10-25postgresql12: make nls option on by defaulttriaxx1-3/+3
2019-10-25postgresql11: make nls option on by defaulttriaxx1-3/+3
2019-10-25postgresql11: make nls support optionaltriaxx9-335/+345
2019-10-24postgresql12: make nls support optionaltriaxx8-297/+305
2019-10-23databases/ruby-sequel: update to 5.25.0taca3-8/+11
Update ruby-sequel to 5.25.0. === 5.25.0 (2019-10-01) * Fix Sequel::SQL::NumericMethods#coerce to not raise NoMethodError if super method is not defined (jeremyevans) (#1645) * Allow setting a default for a column that already has a default on Microsoft SQL Server (jeremyevans) * Fix keyword argument separation warnings on Ruby master branch in csv_serializer plugin (jeremyevans) * Add association_multi_add_remove plugin for adding/removing multiple associated objects in a single method call (AlexWayfer, jeremyevans) (#1641, #1643) * Make sharding plugin integrate with server_block extension (jeremyevans)
2019-10-23databases/ruby-moneta: update to 1.2.0taca3-10/+20
1.2.0 * Adapters::Sequel - fix for compatibility with new version of JDBC SQLite * Adapters::Couch - refactor of error handling, #clear, #merge!, #slice, rev caching * Fallback - add fallback proxy (#162) * Pool - rewrite to enable limiting of size, gradual shrinking * Enumerable - add proxy providing Enumerable API (using #each_key) * Adapters::Couch, Adapters::RestClient - add Faraday :adapter option * Adapters::Couch - add :full_commit and :batch options to some operations * Adapters::LRUHash - rewrite to take advantage of ordered hashes * Adapters::ActiveRecord - recover from deadlock during increment
2019-10-23databases/ruby-hiera: update to 3.6.0taca2-7/+7
Update ruby-hiera to 3.6.0 No change except version.
2019-10-21Switch sphinx to versioned deps.adam2-6/+9
2019-10-21py-psycopg2: updated to 2.8.4adam2-7/+7
Psycopg 2.8.4 The release brings a few assorted bugfixes and adds support for Python 3.8 and PostgreSQL 12. A more detailed changes list is * Fixed building with Python 3.8. * Don't swallow keyboard interrupts on connect when a password is specified in the connection string. * Don't advance replication cursor when the message wasn't confirmed. * Fixed inclusion of time.h on linux. * Fixed int overflow for large values in Column.table_oid and Column.type_code. * errorcodes map and errors classes updated to PostgreSQL 12. * Wheel package compiled against OpenSSL 1.1.1d and PostgreSQL at least 11.4.
2019-10-19py-apsw: updated to 3.29.0adam2-8/+8
3.29.0: Added constants: SQLITE_DBCONFIG_DQS_DML, SQLITE_DBCONFIG_DQS_DDL, SQLITE_DBCONFIG_LEGACY_ALTER_TABLE Updated Connection.config() with all current SQLITE_DBCONFIG constants. Also fixes APSW issue 249
2019-10-18Revbump all Go packages after lang/go112 updatebsiegert5-9/+10
2019-10-16(databases/p5-DBIx-Class-EncodedColumn) Fix build (PERL5_MODULE_TYPE) and ↵mef1-6/+7
TEST_DEPENDS+= 1. convert PERL5_MODULE_TYPE from 'Module::Build' to 'Module::Build::Tiny' - config log says => Can't locate Module/Build/Tiny.pm in @INC 2. Convert BUILD_DEPENDS to TEST_DEPENDS 3. Add one TEST_DEPENDS (p5-Test-Exception-[0-9]*)
2019-10-16prometheus: updated to 2.13.0adam2-8/+7
2.13.0: [SECURITY/BUGFIX] UI: Fix a Stored DOM XSS vulnerability with query history CVE-2019-10215. [CHANGE] Metrics: renamed prometheus_sd_configs_failed_total to prometheus_sd_failed_configs and changed to Gauge [ENHANCEMENT] Include the tsdb tool in builds. [ENHANCEMENT] Service discovery: add new node address types for kubernetes. [ENHANCEMENT] UI: show warnings if query have returned some warnings. [ENHANCEMENT] Remote write: reduce memory usage of the series cache. [ENHANCEMENT] Remote read: use remote read streaming to reduce memory usage. [ENHANCEMENT] Metrics: added metrics for remote write max/min/desired shards to queue manager. [ENHANCEMENT] Promtool: show the warnings during label query. [ENHANCEMENT] Promtool: improve error messages when parsing bad rules. [ENHANCEMENT] Promtool: more promlint rules. [BUGFIX] Promtool: fix recording inconsistency due to duplicate labels. [BUGFIX] UI: fixes service-discovery view when accessed from unhealthy targets. [BUGFIX] Metrics format: OpenMetrics parser crashes on short input. [BUGFIX] UI: avoid truncated Y-axis values.
2019-10-15Attempt to fix PLIST with default options.schmonz1-1/+15
2019-10-15py-redis: updated to 3.3.11adam2-7/+7
3.3.11 * Further fix for the SSLError -> TimeoutError mapping to work on obscure releases of Python 2.7. 3.3.10 * Fixed a potential error handling bug for the SSLError -> TimeoutError mapping introduced in 3.3.9. 3.3.9 * Mapped Python 2.7 SSLError to TimeoutError where appropriate. Timeouts should now consistently raise TimeoutErrors on Python 2.7 for both unsecured and secured connections.
2019-10-14mysql57: updated to 5.7.28adam10-64/+58
Changes in MySQL 5.7.28 Configuration Notes It is now possible to compile MySQL 5.7 using OpenSSL 1.1.1, enabling compilation support for MySQL 5.7 against OpenSSL even when OpenSSL 1.0.2 reaches End of Life status at the end of 2019. All MySQL 5.7 builds now use OpenSSL. MySQL no longer supports using yaSSL as the SSL library, and source distributions no longer include yaSSL. The WITH_SSL CMake option no longer permits bundled (use yaSSL) as a valid value, and the default option value has changed from bundled to system (use the version of OpenSSL installed on the host system). sys Schema Notes The sys.schema_unused_indexes view now filters out unique indexes. The sys.ps_is_consumer_enabled() function now produces an error rather than returning NULL if the argument is an unknown non-NULL consumer name. Previously, sys schema sources were maintained in a separate Git repository. sys schema sources now are included with and maintained within MySQL source distributions (under scripts/sys_schema). The sys.version view is deprecated and will be removed in a future MySQL version. Affected applications should be adjusted to use an alternative instead. For example, use the VERSION() function to retrieve the MySQL server version. Bugs Fixed InnoDB: An ALTER TABLE ... ENCRYPTION = 'Y' operation on a MyISAM table failed to raise an error indicating that the storage engine does not support encryption. The INPLACE algorithm did not check encryption support before updating metadata in the .frm file. To address this issue, an encryption support flag was added. The ALTER TABLE ... ENCRYPTION = 'Y' operation now checks the flag and reports an error if the storage engine does not support encryption. InnoDB: Delete marked rows were able to acquire an external read lock before a partial rollback was completed. The external read lock prevented conversion of an implicit lock to an explicit lock during the partial rollback, causing an assertion failure. InnoDB: A long running ALTER TABLE ... ADD INDEX operation with concurrent inserts caused semaphore waits. Replication: A deadlock involving three threads could occur if a START SLAVE statement was issued to start the SQL thread on a slave while the SQL thread was still in the process of being stopped, and a request for the slave status was made at the same time. The issue has now been fixed by releasing a lock earlier while the SQL thread is being stopped. Replication: A locking issue in the WAIT_FOR_EXECUTED_GTID_SET() function could cause the server to hang in certain circumstances. The issue has now been corrected. Replication: On a multi-threaded slave with GTIDs in use and MASTER_AUTO_POSITION set to ON, following an unexpected halt the slave would attempt relay log recovery, which failed if relay logs had been lost, preventing replication from starting. However, this step was unnecessary as GTID auto-positioning can be used to restore any missing transactions. In a recovery situation, the slave now checks first whether MASTER_AUTO_POSITION is set to ON, and if it is, skips relay log recovery. When generating C source from SQL scripts, Some utf8-encoded characters were split across lines. Thanks to Przemysław Skibiński for the patch. For Solaris, mysqld.cc contained a prototype for memcntl() that is no longer needed. The prototype has been removed. For Solaris, -DWITH_SSL=system did not work when compiling with GCC. MySQL builds configured with -DWITHOUT_SERVER=1 failed. For the keyring_aws plugin, some valid region values for the keyring_aws_region system variable were rejected. For debug builds, an assertion could be raised during UNION queries when computing the combined data type of a GEOMETRY column and SELECT * FROM (SELECT NULL). For authentication using an LDAP authentication plugin, if the user DN portion was empty and group mapping was configured, authentication assigned an incorrect user DN and skipped the user search. mysqlpump produced an error when run against a server older than MySQL 5.7. A possible integer overflow due to unsigned integer type casting could lead to later buffer overflow due to arbitrary size memory allocation. Attempted use of a freed object during MeCab plugin initialization caused a segmentation fault. For MySQL installed using RPM packages, an initialization script that tested server connectivity misbehaved if the client account authenticated using an LDAP authentication plugin. Improper locking during storage engine initialization could cause a server exit. On a GTID-enabled server, concurrent execution of DROP USER and a prepared statement that accessed a view could deadlock. A query with a WHERE clause whose predicate contained a numeric value in scientific notation was not handled correctly. VS2019 produced compilation errors with debug compilation selected due to use of the /ZI flag. Now /Z7 is used instead. The client library could dereference a null pointer while fetching result set metadata from the server. In READ UNCOMMITTED isolation level, a segmentation fault occurred under heavy load from memcached clients. An externally stored BLOB column that was being updated by one transaction was read by another transaction as having a NULL value and a non-zero data length. Arguments for the TIMESTAMPADD() function could be reversed for prepared statements. With the thread_pool plugin enabled, the sys.processlist and sys.session views displayed a thread name rather than the actual user name. The delete_latency column in the sys.schema_index_statistics view incorrectly referred to the SUM_TIMER_INSERT column of the Performance Schema table_io_waits_summary_by_index_usage table rather than the SUM_TIMER_DELETE column. In output from the sys.diagnostics() procedure, the latency column for the user_summary_by_file_io_type view was incorrectly displayed in raw picoseconds rather than as a formatted value. MySQL Enterprise Encryption functions could apply Diffie-Hellman (DH) methods to non-DH keys, resulting in unpredictable results or server exit. Password masking was incomplete for SHOW PROCESSLIST and some INFORMATION_SCHEMA and Performance Schema tables. The -DWITH_EXAMPLE_STORAGE_ENGINE=1 CMake option was ignored but should not have been. If -DWITH_EXAMPLE_STORAGE_ENGINE=0 is given, the EXAMPLE storage engine is built as a plugin.
2019-10-14mysql56-client: remove unused patchesadam5-260/+0
2019-10-14mysql56: updated to 5.6.46adam9-57/+49
Changes in MySQL 5.6.46 Configuration Notes It is now possible to compile MySQL 5.6 using OpenSSL 1.1.1, enabling compilation support for MySQL 5.6 against OpenSSL even when OpenSSL 1.0.2 reaches End of Life status at the end of 2019. In addition, MySQL 5.6 now supports TLSv1.1 and TLSv1.2 protocols for encrypted connections. This applies to MySQL Server, MySQL clients such as mysql and mysqldump, and master/slave replication. Previously, MySQL 5.6 supported only TLSv1, so TLSv1.1/TLSv1.2 support enables use of more secure TLS protocols. It also enables connecting from MySQL 5.6 clients and replication slaves to MySQL 5.7 and higher servers that have TLSv1 disabled, which previously was not possible. It also means that MySQL 5.7 and higher clients that do not want to use TLSv1 can connect to MySQL 5.6 servers. All MySQL 5.6 builds now use OpenSSL. MySQL no longer supports using yaSSL as the SSL library, and source distributions no longer include yaSSL. The WITH_SSL CMake option no longer permits bundled (use yaSSL) as a valid value, and the default option value has changed from bundled to system (use the version of OpenSSL installed on the host system). Bugs Fixed Improper locking during storage engine initialization could cause a server exit. A query with a WHERE clause whose predicate contained a numeric value in scientific notation was not handled correctly. VS2019 produced compilation errors with debug compilation selected due to use of the /ZI flag. Now /Z7 is used instead. Password masking was incomplete for SHOW PROCESSLIST and some INFORMATION_SCHEMA and Performance Schema tables. The -DWITH_EXAMPLE_STORAGE_ENGINE=1 CMake option was ignored but should not have been. If -DWITH_EXAMPLE_STORAGE_ENGINE=0 is given, the EXAMPLE storage engine is built as a plugin.
2019-10-14Update to 0.00020wen2-9/+8
Upstream changes: 0.00020 2019-09-25 - Skip author tests unless AUTHOR_TESTING is set 0.00019 2019-09-19 - Skip author tests unless DBIC::TimeStamp is avail 0.00018 2019-09-16 08:00:00 - Bugfix author tests (#130447, by jplesnik) - Previous release was broken 0.00017 2019-09-03 - Add '.' to @inc (perlpunk) - Update prereqs (perlpunk) 0.00016 2019-06-12 - Add charset option in ::Digest to handle non-ASCII strings, RT#127553 (rrwo)
2019-10-11sqlite3: updated to 3.30.1adam5-19/+20
SQLite Release 3.30.1: Fix a bug in the query flattener that might cause a segfault for nested queries that use the new FILTER clause on aggregate functions. Cherrypick fixes for other obscure problems found since the 3.30.0 release.
2019-10-10py-alembic: updated to 1.2.1adam3-8/+11
1.2.1 bug [bug] [command] Reverted the name change of the “revisions” argument to command.stamp() to “revision” as apparently applications are calling upon this argument as a keyword name. Pull request courtesy Thomas Bechtold. Special translations are also added to the command line interface so that it is still known as “revisions” in the CLI. [bug] [tests] Removed the “test requirements” from “setup.py test”, as this command now only emits a removal error in any case and these requirements are unused. 1.2.0 feature [feature] [command] Added new --purge flag to the alembic stamp command, which will unconditionally erase the version table before stamping anything. This is useful for development where non-existent version identifiers might be left within the table. Additionally, alembic.stamp now supports a list of revision identifiers, which are intended to allow setting up muliple heads at once. Overall handling of version identifiers within the alembic.stamp command has been improved with many new tests and use cases added. [feature] [runtime] Added new feature MigrationContext.autocommit_block(), a special directive which will provide for a non-transactional block inside of a migration script. The feature requres that: the database driver (e.g. DBAPI) supports the AUTOCOMMIT isolation mode. The directive also necessarily needs to COMMIT the existing transaction in progress in order to enter autocommit mode. [feature] [commands] Added “post write hooks” to revision generation. These allow custom logic to run after a revision Python script is generated, typically for the purpose of running code formatters such as “Black” or “autopep8”, but may be used for any arbitrary post-render hook as well, including custom Python functions or scripts. The hooks are enabled by providing a [post_write_hooks] section in the alembic.ini file. A single hook is provided which runs an arbitrary Python executable on the newly generated revision script, which can be configured to run code formatters such as Black; full examples are included in the documentation. [feature] [environment] Added new flag --package to alembic init. For environments where the Alembic migration files and such are within the package tree and importable as modules, this flag can be specified which will add the additional __init__.py files in the version location and the environment location.
2019-10-10py-sqlalchemy: updated to 1.3.10adam2-7/+7
1.3.10 mssql [mssql] [bug] Fixed bug in SQL Server dialect with new “max_identifier_length” feature where the mssql dialect already featured this flag, and the implementation did not accommodate for the new initialization hook correctly. oracle [oracle] [bug] Fixed regression in Oracle dialect that was inadvertently using max identifier length of 128 characters on Oracle server 12.2 and greater even though the stated contract for the remainder of the 1.3 series is that this value stays at 30 until version SQLAlchemy 1.4. Also repaired issues with the retrieval of the “compatibility” version, and removed the warning emitted when the “v$parameter” view was not accessible as this was causing user confusion. 1.3.9 orm [orm] [bug] Fixed regression in selectinload loader strategy caused by 4775 (released in version 1.3.6) where a many-to-one attribute of None would no longer be populated by the loader. While this was usually not noticeable due to the lazyloader populating None upon get, it would lead to a detached instance error if the object were detached. [orm] [bug] Passing a plain string expression to Session.query() is deprecated, as all string coercions were removed in 4481 and this one should have been included. The literal_column() function may be used to produce a textual column expression. [orm] [bug] A warning is emitted for a condition in which the Session may implicitly swap an object out of the identity map for another one with the same primary key, detaching the old one, which can be an observed result of load operations which occur within the SessionEvents.after_flush() hook. The warning is intended to notify the user that some special condition has caused this to happen and that the previous object may not be in the expected state. engine [engine] [usecase] Added new create_engine() parameter create_engine.max_identifier_length. This overrides the dialect-coded “max identifier length” in order to accommodate for databases that have recently changed this length and the SQLAlchemy dialect has not yet been adjusted to detect for that version. This parameter interacts with the existing create_engine.label_length parameter in that it establishes the maximum (and default) value for anonymously generated labels. Additionally, post-connection detection of max identifier lengths has been added to the dialect system. This feature is first being used by the Oracle dialect. sql [sql] [bug] Characters that interfere with “pyformat” or “named” formats in bound parameters, namely %, (, ) and the space character, as well as a few other typically undesirable characters, are stripped early for a bindparam() that is using an anonymized name, which is typically generated automatically from a named column which itself includes these characters in its name and does not use a .key, so that they do not interfere either with the SQLAlchemy compiler’s use of string formatting or with the driver-level parsing of the parameter, both of which could be demonstrated before the fix. The change only applies to anonymized parameter names that are generated and consumed internally, not end-user defined names, so the change should have no impact on any existing code. Applies in particular to the psycopg2 driver which does not otherwise quote special parameter names, but also strips leading underscores to suit Oracle (but not yet leading numbers, as some anon parameters are currently entirely numeric/underscore based); Oracle in any case continues to quote parameter names that include special characters. [sql] [usecase] Added an explicit error message for the case when objects passed to Table are not SchemaItem objects, rather than resolving to an attribute error. sqlite [sqlite] [usecase] Added support for sqlite “URI” connections, which allow for sqlite-specific flags to be passed in the query string such as “read only” for Python sqlite3 drivers that support this. mssql [mssql] [bug] Added identifier quoting to the schema name applied to the “use” statement which is invoked when a SQL Server multipart schema name is used within a Table that is being reflected, as well as for Inspector methods such as Inspector.get_table_names(); this accommodates for special characters or spaces in the database name. Additionally, the “use” statement is not emitted if the current database matches the target owner database name being passed. oracle [oracle] [bug] Restored adding cx_Oracle.DATETIME to the setinputsizes() call when a SQLAlchemy Date, DateTime or Time datatype is used, as some complex queries require this to be present. This was removed in the 1.2 series for arbitrary reasons. [oracle] [usecase] The Oracle dialect now emits a warning if Oracle version 12.2 or greater is used, and the create_engine.max_identifier_length parameter is not set. The version in this specific case defaults to that of the “compatibility” version set in the Oracle server configuration, not the actual server version. In version 1.4, the default max_identifier_length for 12.2 or greater will move to 128 characters. In order to maintain forwards compatibility, applications should set create_engine.max_identifier_length to 30 in order to maintain the same length behavior, or to 128 in order to test the upcoming behavior. This length determines among other things how generated constraint names are truncated for statements like CREATE CONSTRAINT and DROP CONSTRAINT, which means a the new length may produce a name-mismatch against a name that was generated with the old length, impacting database migrations. misc [bug] [tests] Fixed unit test regression released in 1.3.8 that would cause failure for Oracle, SQL Server and other non-native ENUM platforms due to new enumeration tests added as part of 4285 enum sortability in the unit of work; the enumerations created constraints that were duplicated on name.
2019-10-10databases/sql-alchemy: Mark as non-Freegdt1-1/+9
License is boutique and not in licenses/, so set to generic-nonlicense for now. Set RESTRICTED due to entity use restrictions, and because at least some entities/people may not distribute, set NO_*_ON_*. (I hope this is what the package authors intended...)
2019-10-10py-asyncpg: updated to 0.19.0adam3-8/+10
asyncpg v0.19.0 Improvements Add support for SCRAM-SHA-256 authentication. Add PostgreSQL 12 support Bug Fixes Remove preexec_fn hack from test cluster management Fix DeprecationWarning in the docstring of copy_from_query() Allow specifying the target version when generating the release log Check for .flake8 after importing flake8 Include .flake8 in PyPI tarball fix timezone type label in docs Fix _StatementCache.clear() PS memory leak fix for warning_callback not yet defined Fix assertion fail on copy_records_to_table Do not look for a port in a Unix socket domain path Unquote connection string components properly Remove superfluous transaction from a cursor example
2019-10-07Remove unused files; cleanupadam10-135/+35
2019-10-07postgresql12: added version 12.0adam47-1/+5494
Release 12: General performance improvements, including: * Optimizations to space utilization and read/write performance for B-tree indexes * Partitioning performance enhancements, including improved query performance on tables with thousands of partitions, improved insertion performance with INSERT and COPY, and the ability to execute ALTER TABLE ATTACH PARTITION without blocking queries * Automatic (but overridable) inlining of common table expressions (CTEs) * Reduction of WAL overhead for creation of GiST, GIN, and SP-GiST indexes * Support for covering GiST indexes, via the INCLUDE clause * Multi-column most-common-value (MCV) statistics can be defined via CREATE STATISTICS, to support better plans for queries that test several non-uniformly-distributed columns Enhancements to administrative functionality, including: * REINDEX CONCURRENTLY can rebuild an index without blocking writes to its table * pg_checksums can enable/disable page checksums (used for detecting data corruption) in an offline cluster * Progress reporting statistics for CREATE INDEX, REINDEX, CLUSTER, VACUUM FULL, and pg_checksums Support for the SQL/JSON path language Stored generated columns Nondeterministic ICU collations, enabling case-insensitive and accent-insensitive grouping and ordering New authentication features, including: * Encryption of TCP/IP connections when using GSSAPI authentication * Discovery of LDAP servers using DNS SRV records * Multi-factor authentication, using the clientcert=verify-full option combined with an additional authentication method in pg_hba.conf
2019-10-05sqlite3: updated to 3.30.0adam5-21/+29
SQLite Release 3.30.0 Add support for the FILTER clause on aggregate functions. Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses. The index_info and index_xinfo pragmas are enhanced to provide information about the on-disk representation of WITHOUT ROWID tables. Add the sqlite3_drop_modules() interface, allowing applications to disable automatically loaded virtual tables that they do not need. Improvements to the .recover dot-command in the CLI so that it recovers more content from corrupt database files. Enhance the RBU extension to support indexes on expressions. Change the schema parser so that it will error out if any of the type, name, and tbl_name columns of the sqlite_master table have been corrupted and the database connection is not in writable_schema mode. The PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list commands are now enabled in all builds by default. Disable them using -DSQLITE_OMIT_INTROSPECTION_PRAGMAS. Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config(). Added the TCL Interface config method in order to be able to disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options from TCL. Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to prevent those functions from being used inside triggers and views. The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op.
2019-10-02py-peewee: updated to 3.11.2adam3-8/+11
3.11.2 * Implement `hash` interface for `Alias` instances, allowing them to be used in multi-source queries. 3.11.1 * Fix bug in new `_pk` / `get_id()` implementation for models that explicitly have disabled a primary-key. 3.11.0 * Fixes 1991. This particular issue involves joining 3 models together in a chain, where the outer two models are empty. Previously peewee would make the middle model an empty model instance (since a link might be needed from the source model to the outermost model). But since both were empty, it is more correct to make the intervening model a NULL value on the foreign-key field rather than an empty instance. * An unrelated fix came out of the work on 1991 where hashing a model whose primary-key happened to be a foreign-key could trigger the FK resolution query. This patch fixes the `Model._pk` and `get_id()` interfaces so they no longer introduce the possibility of accidentally resolving the FK. * Allow `Field.contains()`, `startswith()` and `endswith()` to compare against another column-like object or expression. * Workaround for MySQL prior to 8 and MariaDB handling of union queries inside of parenthesized expressions (like IN). * Be more permissive in letting invalid values be stored in a field whose type is INTEGER or REAL, since Sqlite allows this. * `TimestampField` resolution cleanup. Now values 0 *and* 1 will resolve to a timestamp resolution of 1 second. Values 2-6 specify the number of decimal places (hundredths to microsecond), or alternatively the resolution can still be provided as a power of 10, e.g. 10, 1000 (millisecond), 1e6 (microsecond). * When self-referential foreign-keys are inherited, the foreign-key on the subclass will also be self-referential (rather than pointing to the parent model). * Add TSV import/export option to the `dataset` extension. * Add item interface to the `dataset.Table` class for doing primary-key lookup, assignment, or deletion. * Extend the mysql `ReconnectMixin` helper to work with mysql-connector. * Fix mapping of double-precision float in postgres schema reflection. Previously it mapped to single-precision, now it correctly uses a double. * Fix issue where `PostgresqlExtDatabase` and `MySQLConnectorDatabase` did not respect the `autoconnect` setting.
2019-09-28py-sqlrelay: fix buidling when multiple Python versions are installedadam3-8/+14
2019-09-28openldap-server: put DB_CONFIG where is should beadam2-3/+3
2019-09-27openldap-server: fix PR pkg/50679triaxx3-7/+9
pkgsrc changes: --------------- * Make the configuration file DB_CONFIG installed only if 'bdb' option is enabled
2019-09-26Revbump all Go packages after 1.12.10 update.bsiegert5-8/+10
ok wiz@ for PMC
2019-09-22abook: Update abook to 0.6.1tm3-10/+14
0.6.1 - custom output format (Rapha�l Droz) - remove duplicates (Fabio Zanini) - merge entries (Fabio Zanini) - mutt groups support (Fabio Zanini) - vcard initial input filter (Michael Krolikowski) - vcard parser improvements (Fabio Zanini, Rapha�l Droz) - color support (Thorsten Wi?~_mann) - mouse support (Thorsten Wi?~_mann) - extra-fields deletion bugfix (Jorrit Tijben) - additional keybindings (Hagen Fuchs) - autotools update (Fabio Zanini) - case-sensitive ldif fields parsing (Christian Brabandt) - ldif standard input support (Rapha�l Droz) - ldif extensible field management rewrite (Rapha�l Droz) - html output fixes (St�phane Aulery) - memory bugfixes (Peter Wu) - vcard birthday export fix (Gaetan Bisson)
2019-09-21phpmyadmin: update to 4.9.1tm3-9/+452
4.9.1 (2019-09-21) - Routine fix for an issue that has been reported as CVE-2019-12922 - issue #15313 Added support for Twig 2 - issue #15315 Fix cannot edit or export column with default CURRENT_TIMESTAMP in MySQL >= 8.0.13 - issue Fix a TypeError in Import class with PHP 8 - issue #14270 Fix Middle-click on foreign key link broken - issue #14363 Fix broken relational links in tables - issue #14987 Fix weird error for empty collation - issue #15334 Fix export of GIS visualisation not working (PNG, PDF, SVG) - issue #14918 Use hex for the phpMyAdmin session token - issue Added GB18030 Chinese collations description - issue Added Russian, Swedish, Slovak and Chinese UCA 9.0.0 collations description - issue Added description for the _ks (kana-sensitive) collation suffix - issue Added description for the _nopad (NO PAD) collation suffix - issue #15404 Remove array/string curly braces access - issue #15427 Fixed "FilterLanguages" option does not work (configuration) - issue #15202 Fixed creating user with single quote in password results in no password user - issue #14950 Fixed left database overview "add column" triggers error - issue #15363 Fix remove unexpected quotes on text fields (structure and insert) - issue Fix NULL wrongly checked on field change - issue #15388 Fix allow to rollback an empty statement - issue #14291 Fixed incorrect linkage from one table's value to another table - issue #15446 Fix tables added from other databases are not collapsing in the designer section - issue #14945 Fix designer page save fails if dB name contains period - issue Display an error when trying to import in designer a table that's already imported - issue Fix many bugs when adding new tables to designer - issue Update CodeMirror to v5.48.4 - issue Update jQuery Migrate to v3.1.0 - issue Update jQuery Validation to v1.19.1 - issue Update jQuery to v3.4.1 - issue Update js-cookie to v2.2.1 - issue Remove fieldset closing tag when setting global privileges - issue #15425 Fix backslash in column name resulting an error in editing - issue #15380 Fix Status - Advisor error - issue #15439 Fix designer page status not updated when added a new table from another database - issue #15440 Fix page number is not being updated in the URL after saving a designer's page - issue Fix reloading a designer's page - issue Fix designer full screen mode button and text stuck when exiting full-screen mode
2019-09-18databases/mysql56-server: remove SUBST for none existing filetaca1-10/+1
Remove SUBST and CHECK_INTERPRETER_SKIP for none existing file.
2019-09-18Recursive revbump from audio/pulseaudioryoon1-1/+2
2019-09-17mongo-tools: updated to 3.4.23adam8-66/+51
Match with mongodb3
2019-09-17mongodb3: updated to 3.4.23adam3-9/+8
3.4.23: findAndModify ignores filter expressions that are not objects Only acquire a collection IX lock to write the lastVote document Recent service file change may cause cyclic dependencies Rebuild mongodb by building.md and failed to build due to ModuleNotFoundError: No module named 'Cheetah' with MSVC on windows Stop testing PyMongo with Python 2.6 in drivers-nightly mongos should reset chunk size tracking information when autosplit = false or splitvector returns too few split points Always waitUntilDurable when writing lastVote document Fix issue with rename collection WiredTigerLAS.wt grows when lagged node is in maintenance mode Do not use a global variable to encode 'multikeyPath' information when writing out catalog documents Add Ubuntu 14.04 to v3.4 Add DSI module to perf.yml Add new shell startup banner 3.4.22: Bump Windows package dependencies Propagate ${branch_name} Evergreen expansion to fuzzer invocation sys-perf: Use bootstrap.overrides in bootstrap.yml config file Make sleep command check that server clock has advanced before returning SysV init scripts should verify PIDfile exists instead of failing Update Enterprise License Make ReadWriteAbility::_canAcceptNonLocalWrites AtomicWord<bool> to prevent torn reads. Choose clock source for reading current time dynamically at startup Platform Support: Remove Enterprise RHEL 6.7 zSeries from 3.4 and 3.6 Ability to disable authorization via x509 extensions Our init scripts check /proc/[pid]/stat should validate that `(${procname})` is the process' command name. Disable SSL_MODE_RELEASE_BUFFERS in ASIO ReplicationCoordinatorImpl::_random isn't robust to replica set members being started at the same time Update banner inclusions for vendored tools Temporarily handle ipv6 failures due to s390x machine without ipv6 enabled MongoDB's yaml-cpp is rejected by latest MSVC Reduce file handle usage in File based Sorter FTDC is calling boost::filesystem without passing an error_code parameter Symlink /data to Z instead of C Add Evergreen task to sanity check fuzzer can parse JavaScript tests Decrement egress counter when scoped connection not returned to the pool scons should fail early if invoked with wrong Python interpreter Attach IDs to users Upgrade yaml-cpp >= 0.6.0 Implement ClockSource::waitForConditionUntil() patch_files.txt doesn't distinguish between enterprise and community files Remove npm test command from "run jstestfuzz" Evergreen function systemd unit for mongod starts before multi.user target Add requirements.txt for resmoke.py
2019-09-15(databases/p5-SQL-Translator) Add DEPENDS+= p5-File-ShareDir-Installmef1-1/+2
2019-09-14p5-DBD-Mock: note p5-Module-Build-Tiny dependencygutteridge1-1/+2
Fix bulk builds by noting this depends on p5-Module-Build-Tiny.
2019-09-14repmgr: PLIST fix for PostgreSQL with/without LLVMadam2-5/+10
2019-09-13databases/ruby-sequel: update to 5.24.0taca3-9/+15
=== 5.24.0 (2019-09-01) * Add Database#skip_logging? private method designed for extensions to force query timing even if no logger is present (adam12) (#1640) * Allow a hostname specified in a defaults_file in the mysql2 adapter, by not explicitly setting :host (sapio-bdeamer) (#1638) * Convert all database array types to Ruby arrays in the jdbc adapter (jeremyevans) * Add static_cache_cache plugin for caching rows for static_cache models to a file to avoid database queries during model initialization (jeremyevans) * Add :cache_file plugin option to pg_auto_constraint_validations plugin, for caching metadata to a file for faster initialization (jeremyevans) * Support :unique_deferrable and :primary_key_deferrable column options (jeremyevans) * Support :generated_always_as column option on PostgreSQL 12+ (jeremyevans) === 5.23.0 (2019-08-01) * Work around a bug on jdbc-sqlite3 3.27.2.1 when parsing schema for tables with columns with default values (jeremyevans) * Work around a bug in jdbc-sqlite3 3.27.2.1 when in Database#foreign_key_list in the jdbc/sqlite3 adapter (jeremyevans) * Make Dataset#execute* private methods respect explicit servers option, fixing Dataset#paged_each in the postgres adapter when sharding (jeremyevans) (#1632) * Handle instances of subclasses of core classes when wrapping objects in the pg_json extension (jeremyevans) (#1631) * Support :ansi Database option in the tinytds adapter (kenaniah) (#1629) * Support cross-database and linked servers when parsing schema on Microsoft SQL Server (kenaniah) (#1629) * Add insert_conflict plugin for automatically handling unique constraint conflicts when saving new model instances on PostgreSQL 9.5+ and SQLite 3.24.0+ (jeremyevans) * Avoid errors when parsing schema in the mock sqlite adapter (jeremyevans) * Avoid possible thread-safety issue in the timezones support (jeremyevans) * Handle offsets when typecasting an array or hash to datetime when Sequel.datetime_class = Time (jeremyevans) * Support Sequel.datetime_class = Time when using the named_timezones extension (jeremyevans)
2019-09-13Update to 1.60wen3-20/+7
Upstream changes: 1.60 - 2019-05-29 * No changes since 1.59_01 1.59_01 - 2019-04-28 * Add support for parsing PostgreSQL dollar-quoted strings * Add support for materialized views in Oracle producer * switched JSON backend from JSON.pm to JSON::MaybeXS * Port Makefile.PL from Module::Install to Distar * Synchronise the version number across all modules
2019-09-13Update to 2.034000wen2-8/+7
Upstream changes: 2.034000 2019-08-02 10:45:04-07:00 America/Los_Angeles - Added dt_SQL_subtract to ::DateMethods1 (Thanks Thomas Klausner!) (closes GH#96)
2019-09-12Update to 1.64wen2-8/+7
Upstream changes: 1.64 2019-08-12 - Switched to a production version 1.63_05 2019-07-12 - Upgraded SQLite to 3.29.0 - Added sqlite_get_autocommit private method (GH#52) - Addded new db_config constants, notably to prohibit double-quoted string literals 1.63_04 2019-05-25 - Upgraded SQLite to 3.28.0 - Modified doc for sqlite_db_filename which actually returns undef or an empty string (GH#50) - Fixed ->quote($blob, SQL_BLOB) to quote correctly (GH#51, pali++) 1.63_03 2019-02-15 - Applied a patch to fix segmentation fault on 32-bit big-endian platforms by Niko Tyni (GH#45) 1.63_02 2019-02-14 - Upgraded SQLite to 3.27.1 - Let a URI filename test skip if SQLite is compiled with URI filename support (GH#47) 1.63_01 2019-01-26 - Made sure an internal hv is initialized (GH#45) - Fixed a number of tests to skip - Bumped up Test::More requirement - Replaced bundled Test::NoWarnings with Test::FailWarnings - Handle 'unknown' op in DBD::SQLite::VirtualTable::PerlData (Corion++)
2019-09-12Update to 1.49wen2-8/+7
Upstream changes: 1.49 2019-09-12T12:59:51Z - Fixing tests that fail on some old versions of Perl 1.48 2019-09-12T06:34:47Z - Added execution_history feature to enable tracking of multiple executes for prepared statements. - Added support for $dbh->table_info calls - Fixed bug rt91055 "insert IGNORE" doesn't raise last_insert_id - Fixed bug rt82243 Bug with Regex in DBD::Mock::Session 1.47 2019-09-06T10:03:39Z - Applied Max Carey's patch from rt86294 adding support for nested keys to fetchall_hashref - Added experimental Connection Callbacks feature - Fixed build for Perl v5.8 1.46 2019-09-04T12:02:08Z - Added git-repo url to meta-data - Fixed bug rt70587 Spelling Mistake - Added regex support to mock_add_resultset
2019-09-10php-redis3: update to 3.1.6otis2-9/+9
Update php-redis3 from release 3.1.3 to release 3.1.6. * Changes between 3.1.3 and 3.1.4: The primary new feature phpredis 3.1.4 is the ability to send MULTI .. EXEC blocks in pipeline mode. There are also many bugfixes and minor improvements to the api, listed below: * Allow mixing MULTI and PIPELINE modes (experimental)! [5874b0] (Pavlo Yatsukhnenko) * Added integration for coverty static analysis and fixed several warnings [faac8b0, eff7398, 4766c25, 0438ab4, 1e0b065, 733732a, 26eeda5, 735025, 42f1c9, af71d4] (Pavlo Yatsukhnenko) * Fixed link to redis cluster documentation [3b0b06] (Pavlo Yatsukhnenko) * Remove unused PHP_RINIT and PHP_RSHUTDOWN functions [c760bf] (Pavlo Yatsukhnenko) * Removed duplicate HGET in redis array hash table, formatting [d0b9c5] (Pavlo Yatsukhnenko) * Treat NULL bulk as success for session read [659450] (Pavlo Yatsukhnenko) * Refactor redis_send_discard [ea15ce] (Pavlo Yatsukhnenko) * Updated runtime exception handling [8dcaa4, 7c1407] (Pavlo Yatsukhnenko) * Added a github issue template [61aba9] (Pavlo Yatsukhnenko) * Initialize gc member of zend_string [37f569) (Pavlo Yatsukhnenko) * Fix valgrind warnings [471ce07, 1ab89e1, b624a8b] (Pavlo Yatsukhnenko) * Fix php5/php7 compatibility layer [1ab89e, 4e3225] (Pavlo Yatsukhnenko) * Fix typo in README.markdown [e47e44] (Mark Shehata) * Improve redis array rehash [577a91] (Pavlo Yatsukhnenko) * Change redis array pure_cmds from zval to hashtable [a56ed7] (Pavlo Yatsukhnenko) * Don't try to set TCP_NODELAY on a unix socket and don't warn on multiple calls to pipeline [d11798, 77aeba] (Michael Grunder) * Use zend_string rather than char* for various context fields (err, prefix, etc) [2bf7b2] (Pavlo Yatsukhnenko) * Various other library fixes [142b51, 4452f6, e672f4, 658ee3, c9df77, 4a0a46] (Pavlo Yatsukhnenko) * Changes between 3.1.4 and 3.1.5: This is interim release which contains only bug fixes. * Fix segfault when extending Redis class in PHP 5 [d23eff] (Pavlo Yatsukhnenko) * Fix RedisCluster constructor with PHP 7 strict scalar type [5c21d7] (Pavlo Yatsukhnenko) * Allow to use empty string as persistant_id [344de5] (Pavlo Yatsukhnenko) * Fix cluster_init_seeds. [db1347] (@adlagares) * Fix z_seeds may be a reference [42581a] (@janic716) * PHP >=7.3 uses zend_string for php_url elements [b566fb] (@fmk) * Changes between 3.1.5 and 3.1.6: This release conains only fix of RedisArray distributor hashing function which was broken in 3.1.4. Huge thanks to @rexchen123
2019-09-06databases/mysql56-client: allow build with OpenSSL 1.1.xtaca9-6/+316
* Allow mysql56-{client,server} build with OpenSSL 1.1.x. * Reduce a few useless warnings.