summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2012-07-06Changes 5.5.25a:adam2-6/+6
* A regression bug in the optimizer could cause excessive disk usage for UPDATE statements.
2012-07-06Updating package for Perl 5 module DBD::SQLite in databases/p5-DBD-SQLitesno2-8/+7
from 1.35nb1 to 1.37. Upstream changes (since 1.35): 1.37 to be released - Updated to SQLite 3.7.12.1 (ISHIGAKI) 1.36_04 Sat 19 May 2012 - Final developer release - Updated to SQLite 3.7.12 (ISHIGAKI) - Tweaked Makefile.PL to behave better during the Bsymbolic check (HMBRAND) - Added SQLITE_WITHOUT_ZONEMALLOC for older MacOS X (ISHIGAKI) 1.36_03 Mon 7 May 2012 - Updated to SQLite 3.7.11 (ISHIGAKI) - Fix >32bit integer truncation and other sqlite_set_result condition issue (Yuriy Kaminskiy) - Fix integer overflow in passing argument to perl function (Yuriy Kaminskiy) - Convert unsigned -> int64 when possible (Yuriy Kaminskiy) - Turned datatype mismatch error (introduced in 1.34_02) into a warning (you can disable this warning by setting PrintWarn attribute to false). (ISHIGAKI) - Refactored sqlite_is_number to fix various corner cases (ISHIGAKI) 1.36_02 Thu 23 Feb 2012 - Downgraded SQLite to 3.7.9, as 3.7.10 turned out to be broken on the latest MacOS X (due to a missing symbol), and broke other modules that typically use temporary tables under a few environments too. As of this writing, would-be 3.7.11 seems fine, but it would take another month to be released. (ISHIGAKI) 1.36_01 Thu 19 Jan 2012 *** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS *** - Updated to SQLite 3.7.10 (ISHIGAKI) Note that this release changed the default schema format number, that means newly created database files will be unreadable by SQLite version prior to 3.3.0 (2006-01-10) (or DBD::SQLite prior to 1.12) unless you explicitly issue "PRAGMA legacy_file_format=ON". - Enabled SQLITE_ENABLE_FTS4 - Enabled SQLITE_ENABLE_STAT3 - Resolved #73159: FTS tokenizer segfault (ISHIGAKI) - Resolved #73787: sqlite_see_if_its_a_number causes a buffer overflow (ISHIGAKI) - Resolved #73314 for DBD-SQLite: binding of 64bit integers fail on 1.34_02 (ISHIGAKI) - Implemented sqlite_trace and sqlite_profile methods for simpler tracing/profiling; use DBI_TRACE/DBI_PROFILE for more complicated cases (ISHIGAKI)
2012-07-06Updating package for Perl 5 module DBD::CSV in databases/p5-DBD-CSV fromsno2-7/+7
0.33 to 0.35. pkgsrc changes: - bump version required for Text::CSV_XS to newly recommended version Upstream changes: 0.35 - 2012-05-24, H.Merijn Brand * Improved documentation (including mje's contribution) * Tested under 5.16.0 (installed) 0.34 - 2012-05-12, H.Merijn Brand * Updated copyright to 2012 * Require 5.8.1, as DBI does * Tested against perl-5.16.0-RC0 + DBI-1.620
2012-07-05Updating package for Perl 5 module DBI in databases/p5-DBI from 1.620 tosno2-7/+7
1.622. pkgsrc changes: - fixing download directory Upstream changes: Changes in DBI 1.622 (svn r15327) 6th June 2012 Fixed lack of =encoding in non-ASCII pod docs. RT#77588 Corrected typo in DBI::ProfileDumper thanks to Finn Hakansson. Changes in DBI 1.621 (svn r15315) 21st May 2012 Fixed segmentation fault when a thread is created from within another thread RT#77137, thanks to Dave Mitchell. Updated previous Changes to credit Booking.com for sponsoring Dave Mitchell's recent DBI optimization work.
2012-07-02Revbump after updating boostadam1-2/+2
2012-07-01Security update to version 9.1.4.morr19-38/+28
Changes: * Fix incorrect password transformation in contrib/pgcrypto's DES crypt() function (Solar Designer) * Ignore SECURITY DEFINER and SET attributes for a procedural language's call handler (Tom Lane) * Make contrib/citext's upgrade script fix collations of citext arrays and domains over citext (Tom Lane) * Allow numeric timezone offsets in timestamp input to be up to 16 hours away from UTC (Tom Lane) * Fix timestamp conversion to cope when the given time is exactly the last DST transition time for the current timezone (Tom Lane) * Fix text to name and char to name casts to perform string truncation correctly in multibyte encodings (Karl Schnaitter) * Fix memory copying bug in to_tsquery() (Heikki Linnakangas) * Ensure txid_current() reports the correct epoch when executed in hot standby (Simon Riggs) * Fix planner's handling of outer PlaceHolderVars within subqueries (Tom Lane) * Fix planning of UNION ALL subqueries with output columns that are not simple variables (Tom Lane) * Fix slow session startup when pg_attribute is very large (Tom Lane) * Ensure sequential scans check for query cancel reasonably often (Merlin Moncure) * Ensure the Windows implementation of PGSemaphoreLock() clears ImmediateInterruptOK before returning (Tom Lane) * Show whole-row variables safely when printing views or rules (Abbas Butt, Tom Lane) * Fix COPY FROM to properly handle null marker strings that correspond to invalid encoding (Tom Lane) * Fix EXPLAIN VERBOSE for writable CTEs containing RETURNING clauses (Tom Lane) * Fix PREPARE TRANSACTION to work correctly in the presence of advisory locks (Tom Lane) * Fix truncation of unlogged tables (Robert Haas) * Ignore missing schemas during non-interactive assignments of search_path (Tom Lane) * Fix bugs with temporary or transient tables used in extension scripts (Tom Lane) * Ensure autovacuum worker processes perform stack depth checking properly (Heikki Linnakangas) * Fix logging collector to not lose log coherency under high load (Andrew Dunstan) * Fix logging collector to ensure it will restart file rotation after receiving SIGHUP (Tom Lane) * Fix "too many LWLocks taken" failure in GiST indexes (Heikki Linnakangas) * Fix WAL replay logic for GIN indexes to not fail if the index was subsequently dropped (Tom Lane) * Correctly detect SSI conflicts of prepared transactions after a crash (Dan Ports) * Avoid synchronous replication delay when committing a transaction that only modified temporary tables (Heikki Linnakangas) * Fix error handling in pg_basebackup (Thomas Ogrisegg, Fujii Masao) * Fix walsender to not go into a busy loop if connection is terminated (Fujii Masao) * Fix memory leak in PL/pgSQL's RETURN NEXT command (Joe Conway) * Fix PL/pgSQL's GET DIAGNOSTICS command when the target is the function's first variable (Tom Lane) * Ensure that PL/Perl package-qualifies the _TD variable (Alex Hunsaker) * Fix PL/Python functions returning composite types to accept a string for their result value (Jan Urbanski) * Fix potential access off the end of memory in psql's expanded display (\x) mode (Peter Eisentraut) * Fix several performance problems in pg_dump when the database contains many objects (Jeff Janes, Tom Lane) * Fix memory and file descriptor leaks in pg_restore when reading a directory-format archive (Peter Eisentraut) * Fix pg_upgrade for the case that a database stored in a non-default tablespace contains a table in the cluster's default tablespace (Bruce Momjian) * In ecpg, fix rare memory leaks and possible overwrite of one byte after the sqlca_t structure (Peter Eisentraut) * Fix contrib/dblink's dblink_exec() to not leak temporary database connections upon error (Tom Lane) * Fix contrib/dblink to report the correct connection name in error messages (Kyotaro Horiguchi) * Fix contrib/vacuumlo to use multiple transactions when dropping many large objects (Tim Lewis, Robert Haas, Tom Lane) * Update time zone data files to tzdata release 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands;
2012-07-01Security update to version 9.0.8.morr20-40/+28
Changes: * Fix incorrect password transformation in contrib/pgcrypto's DES crypt() function (Solar Designer) * Ignore SECURITY DEFINER and SET attributes for a procedural language's call handler (Tom Lane) * Allow numeric timezone offsets in timestamp input to be up to 16 hours away from UTC (Tom Lane) * Fix timestamp conversion to cope when the given time is exactly the last DST transition time for the current timezone (Tom Lane) * Fix text to name and char to name casts to perform string truncation correctly in multibyte encodings (Karl Schnaitter) * Fix memory copying bug in to_tsquery() (Heikki Linnakangas) * Ensure txid_current() reports the correct epoch when executed in hot standby (Simon Riggs) * Fix planner's handling of outer PlaceHolderVars within subqueries (Tom Lane) * Fix slow session startup when pg_attribute is very large (Tom Lane) * Ensure sequential scans check for query cancel reasonably often (Merlin Moncure) * Ensure the Windows implementation of PGSemaphoreLock() clears ImmediateInterruptOK before returning (Tom Lane) * Show whole-row variables safely when printing views or rules (Abbas Butt, Tom Lane) * Fix COPY FROM to properly handle null marker strings that correspond to invalid encoding (Tom Lane) * Ensure autovacuum worker processes perform stack depth checking properly (Heikki Linnakangas) * Fix logging collector to not lose log coherency under high load (Andrew Dunstan) * Fix logging collector to ensure it will restart file rotation after receiving SIGHUP (Tom Lane) * Fix WAL replay logic for GIN indexes to not fail if the index was subsequently dropped (Tom Lane) * Fix memory leak in PL/pgSQL's RETURN NEXT command (Joe Conway) * Fix PL/pgSQL's GET DIAGNOSTICS command when the target is the function's first variable (Tom Lane) * Fix potential access off the end of memory in psql's expanded display (\x) mode (Peter Eisentraut) * Fix several performance problems in pg_dump when the database contains many *bjects (Jeff Janes, Tom Lane) * Fix pg_upgrade for the case that a database stored in a non-default tablespace contains a table in the cluster's default tablespace (Bruce Momjian) * In ecpg, fix rare memory leaks and possible overwrite of one byte after the sqlca_t structure (Peter Eisentraut) * Fix contrib/dblink's dblink_exec() to not leak temporary database connections upon error (Tom Lane) * Fix contrib/dblink to report the correct connection name in error messages (Kyotaro Horiguchi) * Fix contrib/vacuumlo to use multiple transactions when dropping many large *bjects (Tim Lewis, Robert Haas, Tom Lane) * Update time zone data files to tzdata release 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands;
2012-07-01Security update to version 8.4.12.morr14-28/+21
Changes: * Fix incorrect password transformation in contrib/pgcrypto's DES crypt() function (Solar Designer) * Ignore SECURITY DEFINER and SET attributes for a procedural language's call handler (Tom Lane) * Allow numeric timezone offsets in timestamp input to be up to 16 hours away from UTC (Tom Lane) * Fix timestamp conversion to cope when the given time is exactly the last DST transition time for the the current timezone (Tom Lane) * Fix text to name and char to name casts to perform string truncation correctly in multibyte encodings (Karl Schnaitter) * Fix memory copying bug in to_tsquery() (Heikki Linnakangas) * Fix planner's handling of outer PlaceHolderVars within subqueries (Tom Lane) * Fix slow session startup when pg_attribute is very large (Tom Lane) * Ensure sequential scans check for query cancel reasonably often (Merlin Moncure) * Ensure the Windows implementation of PGSemaphoreLock() clears ImmediateInterruptOK before returning (Tom Lane) * Show whole-row variables safely when printing views or rules (Abbas Butt, Tom Lane) * Fix COPY FROM to properly handle null marker strings that correspond to invalid encoding (Tom Lane) * Ensure autovacuum worker processes perform stack depth checking properly (Heikki Linnakangas) * Fix logging collector to not lose log coherency under high load (Andrew Dunstan) * Fix logging collector to ensure it will restart file rotation after receiving SIGHUP (Tom Lane) * Fix WAL replay logic for GIN indexes to not fail if the index was subsequently dropped (Tom Lane) * Fix memory leak in PL/pgSQL's RETURN NEXT command (Joe Conway) * Fix PL/pgSQL's GET DIAGNOSTICS command when the target is the function's first variable (Tom Lane) * Fix potential access off the end of memory in psql's expanded display (\x) mode (Peter Eisentraut) * Fix several performance problems in pg_dump when the database contains many objects (Jeff Janes, Tom Lane) * Fix contrib/dblink's dblink_exec() to not leak temporary database connections upon error (Tom Lane) * Fix contrib/dblink to report the correct connection name in error messages (Kyotaro Horiguchi) * Update time zone data files to tzdata release 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands; also historical corrections for Canada.
2012-07-01Remove PKGREVISIONmorr7-14/+7
2012-07-01Security update to version 8.3.19.morr5-10/+11
Changes: * Fix incorrect password transformation in contrib/pgcrypto's DES crypt() function (Solar Designer) * If a password string contained the byte value 0x80, the remainder of the password was ignored, causing the password to be much weaker than it appeared. With this fix, the rest of the string is properly included in the DES hash. Any stored password values that are affected by this bug will thus no longer match, so the stored values may need to be updated. (CVE-2012-2143) * Ignore SECURITY DEFINER and SET attributes for a procedural language's call handler (Tom Lane) * Applying such attributes to a call handler could crash the server. (CVE-2012-2655) * Allow numeric timezone offsets in timestamp input to be up to 16 hours away from UTC (Tom Lane) * Some historical time zones have offsets larger than 15 hours, the previous limit. This could result in dumped data values being rejected during reload. * Fix timestamp conversion to cope when the given time is exactly the last DST transition time for the current timezone (Tom Lane) * This oversight has been there a long time, but was not noticed previously because most DST-using zones are presumed to have an indefinite sequence of future DST transitions. * Fix text to name and char to name casts to perform string truncation correctly in multibyte encodings (Karl Schnaitter) * Fix memory copying bug in to_tsquery() (Heikki Linnakangas) * Fix slow session startup when pg_attribute is very large (Tom Lane) * If pg_attribute exceeds one-fourth of shared_buffers, cache rebuilding code that is sometimes needed during session start would trigger the synchronized-scan logic, causing it to take many times longer than normal. The problem was particularly acute if many new sessions were starting at once. * Ensure sequential scans check for query cancel reasonably often (Merlin Moncure) * A scan encountering many consecutive pages that contain no live tuples would not respond to interrupts meanwhile. * Ensure the Windows implementation of PGSemaphoreLock() clears ImmediateInterruptOK before returning (Tom Lane) * This oversight meant that a query-cancel interrupt received later in the same query could be accepted at an unsafe time, with unpredictable but not good consequences. * Show whole-row variables safely when printing views or rules (Abbas Butt, Tom Lane) * Corner cases involving ambiguous names (that is, the name could be either a table or column name of the query) were printed in an ambiguous way, risking that the view or rule would be interpreted differently after dump and reload. Avoid the ambiguous case by attaching a no-op cast. * Ensure autovacuum worker processes perform stack depth checking properly (Heikki Linnakangas) * Previously, infinite recursion in a function invoked by auto-ANALYZE could crash worker processes. * Fix logging collector to not lose log coherency under high load (Andrew Dunstan) * The collector previously could fail to reassemble large messages if it got too busy. * Fix logging collector to ensure it will restart file rotation after receiving SIGHUP (Tom Lane) * Fix PL/pgSQL's GET DIAGNOSTICS command when the target is the function's first variable (Tom Lane) * Fix several performance problems in pg_dump when the database contains many objects (Jeff Janes, Tom Lane) * pg_dump could get very slow if the database contained many schemas, or if many objects are in dependency loops, or if there are many owned sequences. * Fix contrib/dblink's dblink_exec() to not leak temporary database connections upon error (Tom Lane) * Update time zone data files to tzdata release 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands; also historical corrections for Canada.
2012-07-01Add desktopdb.mk and bump PKGREVISION for 118 packages as reported bydholland3-6/+9
pkglint. If any of these are wrong for some reason, please revert/adjust.
2012-06-30Mark this BROKEN. It has been unbuildable for years and appears to bedholland1-1/+3
dead upstream. It will be removed in due course (not immediately) unless someone steps up to fix it.
2012-06-25Request explicit template specialisation before doing it implicitly tojoerg2-1/+25
fix build with clang.
2012-06-23Use <fcntl.h> rather than <sys/file.h>, should fix Solaris build.dholland2-13/+16
2012-06-22Make package honor PKGMANDIR.sbd3-16/+5
2012-06-18Regen patch-ai; it rejects on Linux.dholland2-7/+8
2012-06-18Honor ${PKGINFODIR} in INSTALLATION_DIRS; should fix Linux builddholland1-2/+2
2012-06-16Remove 52 from PHP_VERSIONS_ACCEPTED.dholland1-2/+2
2012-06-16Remove php-dbase which is only supported by PHP 5.2.taca3-20/+1
2012-06-16* php-sqlite is obsoleted by PHP 5.4.taca1-6/+11
* Add usage of PHP_BASE_VERS in PKGNAME.
2012-06-16Restrict to php 5.2.x and 5.3.x since php-sqlite support is obsoleted by PHP ↵taca1-1/+3
5.4.
2012-06-15Fix build with C99 compilers.joerg2-1/+19
2012-06-15Add and enable ruby-mysql2.taca1-1/+2
2012-06-15Add ruby-mysql2 version 0.3.11 package.taca4-0/+84
Mysql2 Mysql2 is a modern, simple and very fast Mysql library for Ruby - binding to libmysql. The Mysql2 gem is meant to serve the extremely common use-case of connecting, querying and iterating on results. Some database libraries out there serve as direct 1:1 mappings of the already complex C API's available. This one is not. It also forces the use of UTF-8 (or binary) for the connection (and all strings in 1.9, unless Encoding.default_internal is set then it'll convert from UTF-8 to that encoding) and uses encoding-aware MySQL API calls where it can.
2012-06-14Bump PKGREVISION for those RUBY_RAILS_STRICT_DEP is set to no implicitly now.taca4-5/+8
(Relax dependency to Ruby on Rails component packages.)
2012-06-14Set RUBY_RAILS_STRICT_DEP to yes.taca1-1/+2
2012-06-14Update ruby-activerecord31 to 3.1.6.taca2-5/+6
pkgsrc change: add RUBY_RAILS_STRICT_DEP which will be enabled later. ## Rails 3.1.6 (Jun 12, 2012) * protect against the nesting of hashes changing the table context in the next call to build_from_hash. This fix covers this case as well. CVE-2012-2695
2012-06-14Update ruby-activerecord3 to 3.0.14.taca2-5/+6
pkgsrc change: add RUBY_RAILS_STRICT_DEP which will be enabled later. ## Rails 3.0.14 (Jun 12, 2012) * protect against the nesting of hashes changing the table context in the next call to build_from_hash. This fix covers this case as well. CVE-2012-2695
2012-06-14Recursive PKGREVISION bump for libxml2 buildlink addition.sbd71-101/+142
2012-06-13Update ruby-activerecord32 to 2.3.6.taca1-4/+4
## Rails 3.2.6 (Jun 12, 2012) ## * protect against the nesting of hashes changing the table context in the next call to build_from_hash. This fix covers this case as well. CVE-2012-2695 * Revert earlier 'perf fix' (see 3.2.4 changelog / GH #6289). This change introduced a regression (GH #6609). assoc.clear and assoc.delete_all have loaded the association before doing the delete since at least Rails 2.3. Doing the delete without loading the records means that the `before_remove` and `after_remove` callbacks do not get invoked. Therefore, this change was less a fix a more an optimisation, which should only have gone into master. *Jon Leighton*
2012-06-12Add inet6 to default suggested options. It's 2012.wiz3-5/+8
2012-06-11Changes 3.7.13:adam7-22/+24
* In-memory databases that are specified using URI filenames are allowed to use shared cache, so that the same in-memory database can be accessed from multiple database connections. * Recognize and use the mode=memory query parameter in URI filenames. * Avoid resetting the schema of shared cache connections when any one connection closes. Instead, wait for the last connection to close before reseting the schema. * In the RTREE extension, when rounding 64-bit floating point numbers to 32-bit for storage, always round in a direction that causes the bounding box to get larger. * Adjust the unix driver to avoid unnecessary calls to fchown(). * Add interfaces sqlite3_quota_ferror() and sqlite3_quota_file_available() to the test_quota.c module. * The sqlite3_create_module() and sqlite3_create_module_v2() interfaces return SQLITE_MISUSE on any attempt to overload or replace a virtual table module. The destructor is always called in this case, in accordance with historical and current documentation.
2012-06-09Replace python interpreter in two files. Bump PKGREVISION.wiz1-2/+4
2012-06-08Fix build on SunOS when optimization of -O2 or greater is used.fhajny1-1/+8
2012-06-04Allow ruby-dm-types to depend on ruby-stringex 1.3 and later.taca1-4/+4
Bump PKGREVISION.
2012-06-04Update pear-DB to 1.7.14.obache2-6/+7
PR 46534 by Wen Heping. While here, set LICENSE=php. Changes since 1.7.13: All drivers: * Made the definition of DB_common::raiseError() compatible with PEAR::raiseError() by adding dummy parameters. Request 11581. * Fixed SKIP block in the 20locale.phpt test. * Fixed non-persistent connections to really be non-persistent when unserialising. Bug 15115. ibase: * Changed the order of regular expressions applied when mapping errors so that constraint violations in PHP 4.4 are actually reported as constraint violations and not table not found errors. * Fixed a test that should have been skipped in PHP 4.4. ifx: * Use PCRE rather than ereg. Bug 17722, patch by Olle Jonsson. mssql: * Fix escaping of string values with lines ending in a backslash character. Bug 16117. oci8: * Fix for last_query reconstruction with lots of placeholders. Bug 12418, patch by Nicholas Evans. * Fix replacement of values in last_query for :bind's numbered over 10. Bug 14603. * Unset $_prepared_queries in freePrepared(). Bug 14271. pgsql: * Added special-case to handle SAVEPOINT queries as manip queries. Bug 12260. * Implement rudimentary support for WITH...SELECT queries. Bug 17136. sqlite: * Added support for another error message in the SQLite driver. Bug 12105, patch by Adam Ashley. * Implement auto_increment support in tableInfo(). Request 13193.
2012-06-03PKGREVISION bump (to 5) matching rev 1.33 of distinfo and associateddholland1-2/+2
patches, which was even described as changing installed headers for client packages but I apparently spaced on it. noted by obache.
2012-06-02Changes 5.5.25:adam3-7/+18
* The --safe-mode server option now is deprecated and will be removed in MySQL 5.6. * Performance: InnoDB: Improved the algorithm related to adaptive flushing. This fix increases the rate of flushing in cases where compression is used and the data set is larger than the buffer pool, leading to eviction. * InnoDB: In a transaction using the REPEATABLE READ isolation level, an UPDATE or DELETE statement for an InnoDB table could sometimes overlook rows recently committed by other transactions. As explained in Section 14.3.9.2, “Consistent Nonlocking Reads”, DML statements within a REPEATABLE READ transaction apply to rows committed by other transactions, even if a query could not see those rows. * InnoDB: The Innodb_buffer_pool_pages_flushed status variable was incorrectly set to twice the value it should be. Its value should never exceed the value of Innodb_pages_written. * InnoDB: The error handling and message was improved for attempting to create a foreign key with a column referencing itself. The message suggested a potential problem with the data dictionary, when no such problem existed. * InnoDB: The CHECK TABLE statement could fail for a large InnoDB table due to a timeout value of 2 hours. For typical storage devices, the issue could occur for tables that exceeded approximately 200 or 350 GB, depending on I/O speed. The fix relaxes the locking performed on the table being checked, which makes the timeout less likely. It also makes InnoDB recognize the syntax CHECK TABLE QUICK, which avoids the possibility of the timeout entirely. * Replication: It was theoretically possible for concurrent execution of more than one instance of SHOW BINLOG EVENTS to crash the MySQL Server. * Replication: Statements using AUTO_INCREMENT, LAST_INSERT_ID(), RAND(), or user variables could be applied in the wrong context on the slave when using statement-based replication and replication filtering server options (see Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”). * Replication: An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based binary logging or replication. Such statements are now marked as unsafe and fail with an error when using the STATEMENT binary logging format. For more information, see Section 16.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”, as well as Section 16.4.1.1, “Replication and AUTO_INCREMENT”.
2012-06-02bump PKGREV for geos shlib name changedrochner1-2/+2
2012-06-02Update ruby-activerecord32 to 3.2.5.taca1-4/+4
3.2.4 had some regression related problem. ## Rails 3.2.4 (May 31, 2012) ## * Perf fix: Don't load the records when doing assoc.delete_all. GH #6289. *Jon Leighton* * Association preloading shouldn't be affected by the current scoping. This could cause infinite recursion and potentially other problems. See GH #5667. *Jon Leighton* * Datetime attributes are forced to be changed. GH #3965 * Fix attribute casting. GH #5549 * Fix #5667. Preloading should ignore scoping. * Predicate builder should not recurse for determining where columns. Thanks to Ben Murphy for reporting this! CVE-2012-2661
2012-06-02Update ruby-activerecord31 to 3.1.5.taca2-6/+6
## Rails 3.1.5 (May 31, 2012) ## * Fix type_to_sql with text and limit on mysql/mysql2. Fix GH #3931. * only log an error if there is a logger. fixes #5226 * fix activerecord query_method regression with offset into Fixnum * predicate builder should not recurse for determining where columns. Thanks to Ben Murphy for reporting this! CVE-2012-2661
2012-06-02Update ruby-activerecord3 to 3.0.13.taca1-4/+4
* Rails 3.0.13 (May 31, 2012) * Bugfix circular reference while saving has_one relationship * Test for circular reference while saving has_one relationship * Fixed typo in composed_of example with Money#<=> * predicate builder should not recurse for determining where columns. Thanks to Ben Murphy for reporting this! CVE-2012-2661
2012-06-02Update ruby-sequel to 3.36.0.taca3-7/+16
=== 3.36.0 (2012-06-01) * Use Bignum generic type when dumping unsigned integer types that could potentially overflow 32-bit signed integer values (stu314) * Support :transform option in the nested_attributes plugin, for automatically preprocessing input hashes (chanks) * Support :unmatched_pk option in the nested_attributes plugin, can be set to :create for associated objects with natural keys (chanks) * Support composite primary keys in the nested_attributes plugin (chanks) * Allow Model#from_json in the json_serializer plugin to use set_fields if a :fields option is given (jeremyevans) * Support :using option to set_column_type on PostgreSQL, to force a specific conversion from the old value to the new value (jeremyevans) * Drop indexes in the reverse order that they were added in the schema dumper (jeremyevans) * Add :index_names option to schema dumper method, can be set to false or :namespace (stu314, jeremyevans) * Add Database#global_index_namespace? for checking if index namespace is global or per table (jeremyevans) * Fix typecasting of time columns on jdbc/postgres, before could be off by a millisecond (jeremyevans) * Add document explaining Sequel's object model (jeremyevans) * Attempt to detect more disconnect errors in the mysql2 adapter (jeremyevans) * Add is_current? and check_current to the migrators, for checking/raising if there are unapplied migrations (pvh, jeremyevans) (#487) * Add a jdbc subadapter for the Progress database (Michael Gliwinski, jeremyevans) * Add pg_inet extension, for working with PostgreSQL inet and cidr types (jeremyevans) * Fix bug in model column setters when passing an object that raises an exception for ==('') (jeremyevans) * Add eager_each plugin, which makes each on an eagerly loaded dataset do eager loading (jeremyevans) * Fix bugs when parsing foreign keys for tables with explicit schema on PostgreSQL (jeremyevans) * Remove Database#case_sensitive_like on SQLite (jeremyevans) * Remove Database#single_value in the native sqlite adapter (jeremyevans) * Make Dataset#get work with nil and false arguments (jeremyevans) * Make json_serializer plugin respect :root=>:collection and :root=>:instance options (jeremyevans) * Support savepoints in prepared transactions on MySQL 5.5.23+ (jeremyevans) * Add pg_json extension, for working with PostgreSQL 9.2's new json type (jeremyevans) * In the optimistic locking plugin, make refresh and save after a failed save work correctly (jeremyevans) * Support partial indexes on Microsoft SQL Server 2008 (jeremyevans) * Make Database#call pass blocks (jeremyevans) * Support :each when preparing statements, useful for iterating over large datasets (jeremyevans) * Support :if_exists and :cascade options when dropping indexes on PostgreSQL (jeremyevans) * Support :concurrently option when adding and dropping indexes on PostgreSQL (jeremyevans) * Make Database#transaction on PostgreSQL recognize :synchronous, :read_only, and :deferrable options (jeremyevans) * Support :sql_mode option when connecting to MySQL (jeremyevans) * Apply :timeout MySQL connection setting on do, jdbc, and swift adapters (jeremyevans) * Don't set Sequel::Model.db automatically when creating an anonymous class with an associated database object (jeremyevans) * Add :connection_handling=>:queue option to the threaded connection pools, may reduce chance of stale connections (jeremyevans) (#481) * Handle JRuby 1.7 exception handling changes when connecting in the jdbc adapter (jeremyevans) (#477) * Make *_to_one association setters be noops if you pass a value that is the same as the cached value (jeremyevans) * Make Model#refresh return self when using dirty plugin (jeremyevans)
2012-06-01update to 3.3.2drochner18-377/+434
changes: many fixes and improvements, most visibly: the use of py-bsddb3 is now officially supported
2012-06-01Update ruby-sequel to 3.35.0.taca3-12/+15
=== 3.35.0 (2012-05-01) * Correctly handle parsing schema for tables in other databases on MySQL (jeremyevans) * Add DSL support for the modulus operator (%), similar to the bitwise operators (jeremyevans) * Fix possible thread-safety issues on non-GVL ruby implementations (jeremyevans) * Allow truncation of multiple tables at the same time on PostgreSQL (jeremyevans) * Allow truncate to take a :cascade, :only, and :restart options on PostgreSQL (hgimenez, jeremyevans) * Allow json and xml serializers to support :array option in class to_json method to serialize existing array of model instances (jeremyevans) * Add dirty plugin, which saves the initial value of the column when the value is changed (jeremyevans) * create_table now supports an :as option to create a table directly from the results of a query (jeremyevans) * The :index option when creating columns in the schema generator can now be a hash of options passed to index (jeremyevans) * Parsing the default column values in the oracle adapter no longer requires superuser privileges (Jason Hines) * Add Database#cache_schema to allow schema caching to be turned of, useful for development modes where models are reloaded (jeremyevans) * Correctly handle errors that occur when rolling back transactions (jeremyevans) * Recognize identity type in the schema dumper (jeremyevans) (#468) * Don't assign instance variables to Java objects, for future JRuby 2.0 support (jeremyevans) (#466) * Use date and timestamp formats that are multilanguage and not DATEFORMAT dependent on Microsoft SQL Server (jeremyevans) * Add Database#log_exception, which logs when a query raises an exception, for easier overriding (jeremyevans) (#465) * Make the migrators only use transactions by default if the database supports transactional DDL (jeremyevans) * Add Database#supports_transactional_ddl? for checking if DDL statements can be rolled back in transactions (jeremyevans) * Don't use auto parameterization when using cursors in the pg_auto_parameterize extension (jeremyevans) (#463) * No longer escape backslashes in strings by default, fixes doubled backslashes on some adapters (jeremyevans) * Escape blackslash-carriage return-line feed in strings on Microsoft SQL Server (mluu, jeremyevans) (#462, #461) * Remove Array#all_two_pairs? (jeremyevans) * Remove Dataset#disable_insert_returning on PostgreSQL (jeremyevans) * Remove support for PostgreSQL <8.2 (jeremyevans) * Remove support for Ruby <1.8.7 (jeremyevans)
2012-05-31Use more standard headers; should fix Solaris build.dholland2-5/+7
2012-05-31Changes 5.3.21:adam4-8/+34
* Fixed incompatibility problems of Java DPL with JDK7, so DPL will now work with JDK7. * Added a flag to allow database locking to be disabled from the SQL API. * Fixed a bug that could allocate a heap data page in a region after the region creation has been undone. * Redundant whitespaces are now ignored in DB_CONFIG lines pertaining to directories, e.g. set_data_dir. * Fixed a bug that caused DB_ENV->backup to stop early if DB_BACKUP_FILES was not set and a non-DB file was in the data directory. * Fixed a rare race condition that could cause a crash if two processes opened the same database at the same time. * Fixed missing cross compiling capability for the JDBC driver. * Allow the same system/machine to host both a master and a replica database through the use of relative pathnames. * Fixed a bug in the Java API where EnvironmentConfig.setCreateDir would fail to configure the environment. * Fixed an assert failure in btreeCompare when allocating memory in the wrong thread was causing a memory leak. * Fixed a bug in the Java API where concurrent operations that change the database schema could lead to a hang. * Added JDBC code to the code base and updated the windows build files to include the JDBC solution. * Fixed a bug where the heap's region size was not getting swapped correctly in mixed-endian environments. * Fixed a bug in the db_sql_jdbc project file for vs2010 that was preventing it from building correctly.
2012-05-30Update to 0.52, provided by wen in PR 46499.wiz2-6/+8
0.52 2012-05-29T18:32:42Z - The DBI params are now encapsulated in a code reference, rather than stored as the passed array, so that the password is less likely to be displayed in a dump. Idea borrowed from Rose::DB. Patch from Brad Bowman. - Eliminated warning about the non-portability of a v-string on older Perls. Thanks to Mark Lawrence for the report (Issue #17). - Removed a couple of leftover examples of the `catch` feature removed in v0.50. Thanks to Randy Stauner for the patch! - Eliminated more "Use of qw(...) as parentheses" syntax errors in tests when running on Perl 5.17. - Add mention of DBI Callbacks parameter to the docs, as folks often ask for this functionality, not realizing that the DBI already provides it. Randy Stauner. 0.51 2012-02-18T00:14:48Z - Fixed internal exception handling on Perls less than 5.14, where some exceptions woult not be propagated to the caller. 0.50 2012-02-14T18:25:07Z - The `catch` functionality has been completely removed. Any `catch` block passed to `run()`, `txn()`, or `svp()` will be ignored. Errors will trigger fatal exceptions. - Removed the `with` method, which was deprecated in 0.34. Use `mode()` instead. - Fixed bad method call attempted when an `svp()` block failed. Thanks to Ricardo SIGNES for the regression test and the fix. - Fixed creation of the SQLite driver savepoint methods so that they exist and work even if the driver is loaded before DBD::SQLite. Thanks to Ricardo SIGNES for the regression test and the fix.
2012-05-29Remove GNU_PROGRAM_PREFIX variable (discussed in pkgsrc-users@)cheusov1-6/+3
2012-05-29Fix build with Clang.joerg2-1/+40
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-02 00:06:56 +0000