summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2009-02-11Update to Metakit 2.4.9.7:joerg8-123/+23
- better UTF8 support in file & property names - bugfixes - Python 2.5 support for 64bit platforms
2009-02-11Sort PYTHON_VERSIONS_ACCEPTED.joerg1-2/+2
2009-02-11Fix for ssl support on OpenSolarisadrianp1-1/+12
2009-02-10Fixes typo (redundant `G'!).obache1-2/+2
2009-02-10Add missing *.lua files to PLIST.obache2-2/+6
Bump PKGREVISION.
2009-02-09Switch to Python 2.5 as default. Bump revision of all packages that havejoerg5-7/+10
changed runtime dependencies now.
2009-02-09Remove Python 2.1 support.joerg4-11/+4
2009-02-09Don't use libtclstub84 for sqlite3-tcl, but libtcl84 itself.joerg2-1/+15
2009-02-09Require a new enough sqlite3.joerg1-2/+2
2009-02-09Update ruby-tokyocabinet to 1.19, for tokyocabinet-1.4.4.obache3-11/+11
2009-02-07Changes 8.3.6:adam7-21/+27
* Make "DISCARD ALL" release advisory locks, in addition to everything it already did This was decided to be the most appropriate behavior. This could affect existing applications, however. * Fix whole-index GiST scans to work correctly This error could cause rows to be lost if a table is clustered on a GiST index. * Fix crash of xmlconcat(NULL) * Fix possible crash in ispell dictionary if high-bit-set characters are used as flags This is known to be done by one widely available Norwegian dictionary, and the same condition may exist in others. * Fix misordering of pg_dump output for composite types The most likely problem was for user-defined operator classes to be dumped after indexes or views that needed them. * Improve handling of URLs in headline() function * Improve handling of overlength headlines in headline() function * Prevent possible Assert failure or misconversion if an encoding conversion is created with the wrong conversion function for the specified pair of encodings * Fix possible Assert failure if a statement executed in PL/pgSQL is rewritten into another kind of statement, for example if an "INSERT" is rewritten into an "UPDATE" * Ensure that a snapshot is available to datatype input functions * Make it safer for SPI-using functions to be used within datatype I/O; in particular, to be used in domain check constraints * Avoid unnecessary locking of small tables in "VACUUM" * Fix a problem that sometimes kept "ALTER TABLE ENABLE/DISABLE RULE" from being recognized by active sessions * Fix a problem that made UPDATE RETURNING tableoid return zero instead of the correct OID * Allow functions declared as taking ANYARRAY to work on the pg_statistic columns of that type This used to work, but was unintentionally broken in 8.3. * Fix planner misestimation of selectivity when transitive equality is applied to an outer-join clause This could result in bad plans for queries like ... from a left join b on a.a1 = b.b1 where a.a1 = 42 ... * Improve optimizer's handling of long IN lists This change avoids wasting large amounts of time on such lists when constraint exclusion is enabled. * Prevent synchronous scan during GIN index build Because GIN is optimized for inserting tuples in increasing TID order, choosing to use a synchronous scan could slow the build by a factor of three or more. * Ensure that the contents of a holdable cursor don't depend on the contents of TOAST tables * Fix memory leak when a set-returning function is terminated without reading its whole result * Fix encoding conversion problems in XML functions when the database encoding isn't UTF-8 * Fix "contrib/dblink"'s dblink_get_result(text,bool) function * Fix possible garbage output from "contrib/sslinfo" functions * Fix incorrect behavior of "contrib/tsearch2" compatibility trigger when it's fired more than once in a command * Fix possible mis-signaling in autovacuum * Support running as a service on Windows 7 beta * Fix ecpg's handling of varchar structs * Fix configure script to properly report failure when unable to obtain linkage information for PL/Perl * Make all documentation reference pgsql-bugs and/or pgsql-hackers as appropriate, instead of the now-decommissioned pgsql-ports and pgsql-patches mailing lists * Update time zone data files to tzdata release 2009a (for Kathmandu and historical DST corrections in Switzerland, Cuba)
2009-02-07Changes 8.2.12:adam6-20/+26
* Improve handling of URLs in headline() function * Improve handling of overlength headlines in headline() function * Prevent possible Assert failure or misconversion if an encoding conversion is created with the wrong conversion function for the specified pair of encodings * Fix possible Assert failure if a statement executed in PL/pgSQL is rewritten into another kind of statement, for example if an "INSERT" is rewritten into an "UPDATE" * Ensure that a snapshot is available to datatype input functions * Make it safer for SPI-using functions to be used within datatype I/O; in particular, to be used in domain check constraints * Avoid unnecessary locking of small tables in "VACUUM" * Fix a problem that made UPDATE RETURNING tableoid return zero instead of the correct OID * Fix planner misestimation of selectivity when transitive equality is applied to an outer-join clause This could result in bad plans for queries like ... from a left join b on a.a1 = b.b1 where a.a1 = 42 ... * Improve optimizer's handling of long IN lists This change avoids wasting large amounts of time on such lists when constraint exclusion is enabled. * Ensure that the contents of a holdable cursor don't depend on the contents of TOAST tables * Fix memory leak when a set-returning function is terminated without reading its whole result * Fix "contrib/dblink"'s dblink_get_result(text,bool) function * Fix possible garbage output from "contrib/sslinfo" functions * Fix configure script to properly report failure when unable to obtain linkage information for PL/Perl * Make all documentation reference pgsql-bugs and/or pgsql-hackers as appropriate, instead of the now-decommissioned pgsql-ports and pgsql-patches mailing lists * Update time zone data files to tzdata release 2009a (for Kathmandu and historical DST corrections in Switzerland, Cuba)
2009-02-07Changes 8.1.16:adam6-21/+26
* Fix crash in autovacuum The crash occurs only after vacuuming a whole database for anti-transaction-wraparound purposes, which means that it occurs infrequently and is hard to track down. * Improve handling of URLs in headline() function * Improve handling of overlength headlines in headline() function * Prevent possible Assert failure or misconversion if an encoding conversion is created with the wrong conversion function for the specified pair of encodings * Avoid unnecessary locking of small tables in "VACUUM" * Ensure that the contents of a holdable cursor don't depend on the contents of TOAST tables * Fix uninitialized variables in "contrib/tsearch2"'s get_covers() function * Fix configure script to properly report failure when unable to obtain linkage information for PL/Perl * Make all documentation reference pgsql-bugs and/or pgsql-hackers as appropriate, instead of the now-decommissioned pgsql-ports and pgsql-patches mailing lists * Update time zone data files to tzdata release 2009a (for Kathmandu and historical DST corrections in Switzerland, Cuba)
2009-02-07Update p5-tokyotyrant to 1.5, for tokyotyrant-1.1.12.obache2-6/+6
2009-02-07Update tokyotyrant to 1.1.14.obache3-10/+8
2009-02-05 Mikio Hirabayashi <mikio@users.sourceforge.net> * ttutil.c (ttservstart, ttservaddtimedhandler): multiple tasks are now supported. * ttutil.c (ttsockrecv, ttsockgetint32, ttsockgetint64): performance was improved. * ttserver.c (do_extpc): new function. - Release: 1.1.14 2009-02-04 Mikio Hirabayashi <mikio@users.sourceforge.net> * tcrdb.c (tcrdbqrysearchout): a bug related to the protocol format was fixed. * tcrdb.c (tcrdbqrysearchget): new function. - Release: 1.1.13
2009-02-07Update p5-tokyocabinet to 1.22, for tokyocabinet-1.4.4.obache2-7/+7
2009-02-05Update TokyoCabinet to 1.4.4.obache5-34/+15
Changes: 2009-01-29 Mikio Hirabayashi <mikio@users.sourceforge.net> * tcutil.c (tcmapputproc, tctreeputproc, tcmdbputproc, tcndbputproc): new functions. * tchdb.c (tchdbputproc): new function. * tchdb.c (TDBTHREADYIELD): "sched_yield" is now used instead of "pthread_yield". * tcbdb.c (tcbdbputproc): new function. * tcbdb.c (tcbdbcurkey, tcbdbcurval): the type of the return value was modified. * tcfdb.c (tcfdbputproc): new function. * tcadb.c (tcadbputproc): new function. * tcadb.c (tcadbmisc): sub funcitons "put", "out", and "get" were added. * tcadb.c (tcstrisnum): new function. - Release: 1.4.4
2009-02-05add and enable openldap-nops and openldap-smbk5pwdjnemeth1-1/+3
2009-02-05Update from version 4.1.22nb2 to 4.1.22nb3.he2-4/+5
One minor change to the rc.d script: o Postpone setting pidfile to after /etc/rc.conf has been consulted, so that a non-default setting of mysqld_datadir takes effect. Without this, mysqld will not start with a non-default mysqld_datadir. Should fix PR#30636.
2009-02-04Upgrade from version 5.0.67 to 5.0.67nb1.he2-5/+14
Two changes to the rc.d script: 1) Move the setting of pidfile to a place so that setting mysqld_datadir in rc.conf will actually work; otherwise, if you use a non-default mysqld_datadir, mysqld will not start. 2) ad@ pointed me to http://bugs.mysql.com/bug.php?id=18526, and said that --skip-thread-priority should not be used on NetBSD, and the PR spoke about Darwin / OS/X. I'm guessing that this might work if the host platform is Linux or SunOS (the latter is unconfirmed). So add that option to the startup in all other cases.
2009-02-03Update TokyoTyrant to 1.1.12.obache6-18/+32
Changes: 2009-02-03 Mikio Hirabayashi <mikio@users.sourceforge.net> * myconf.c (nan): xBSDs are now supported. * ttserver (proc): parameter checking and warning were added. * tcrmgr.c (runmisc, procmisc): table database is now supported. * tcrdb.c (tcrdbtblput, tcrdbtblout, tcrdbtblget): new functions. * tcrdb.c (tcrdbtblsetindex, tcrdbtblgenuid, tcrdbqrysearch): new functions. - Release: 1.1.12
2009-02-01Add missing man pagemanu3-3/+6
2009-01-31Add openldap-nops, a slapd overlay to remove null-operationsmanu4-0/+46
2009-01-31Patch for building slapo-nops as a module (already committed upstream)manu2-1/+26
2009-01-31Fix dependencymanu1-2/+2
2009-01-31Fixes installation to DESTDIR.obache1-3/+3
2009-01-31Add openldap-smbk5pwd, a modular slapd overlay to sync passwords with manu4-0/+48
Kerberos and Samba. This replaces the smbk5pwd option of openldap-server
2009-01-31- Add optionnal DSO support to slapd.manu11-239/+34
- Bump revision of openldap-server because of that - Remove the smbk5pwd option, which will be moved to another package as module
2009-01-31Update from version 0.06 to version 0.07.seb2-7/+6
Upstream changes not documented...
2009-01-28Update from version 5.0.67nb1 to 5.0.67nb2.he1-4/+4
Pkgsrc changes: o Add patch from http://bugs.mysql.com/file.php?id=9232, referenced on http://bugs.mysql.com/bug.php?id=27884, to fix the vulnerability recorded in http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-4456. o Bump PKGREVISION (The regenerated patch checksums was overlooked initially - sorry!)
2009-01-28Update from version 5.0.67nb1 to 5.0.67nb2.he5-8/+81
Pkgsrc changes: o Add patch from http://bugs.mysql.com/file.php?id=9232, referenced on http://bugs.mysql.com/bug.php?id=27884, to fix the vulnerability recorded in http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-4456. o Bump PKGREVISION
2009-01-27Update TokyoCabinet to 1.4.3.obache4-19/+28
Changes: 2009-01-26 Mikio Hirabayashi <mikio@users.sourceforge.net> * tctdb.c (tctdbqryprocout): renamed as "tctdbqrysearchout". * tcadb.c (tcadbmisc): sub functions "searchget" and "searchget" were integrated. - Release: 1.4.3
2009-01-26Update TokyoCabinet to 1.4.2.obache3-8/+8
Changes: 2009-01-21 Mikio Hirabayashi <mikio@users.sourceforge.net> * tcutil.c (tcatof): new function. * tcbdb.c (tcbdbleafaddrec): allocation tuning of duplicated records was modified. * tcadb.c: all methods now support the table database API. - Release: 1.4.2
2009-01-25cvs rm empty patch file.ghen1-0/+0
2009-01-24Missing bits for OpenLDAP-2.4.13 updatemanu5-2197/+19
2009-01-24Upgrade to 2.4.13. Initial patches from ghen@manu4-6/+11
OpenLDAP 2.4.13 Release (2008/11/24) Added libldap dereference control support (ITS#5768) Fixed libldap parameter checking (ITS#5817) Fixed liblutil hex conversion (ITS#5699) Fixed liblutil returning undefined data (ITS#5748) Fixed libldap error code return (ITS#5762) Fixed libldap interaction with GnuTLS CN IP-based matches (ITS#5789) Fixed libldap MAXHOSTNAMELEN typo (ITS#5815) Fixed libldap Ipv6 detection (ITS#5739) Fixed libldap setuid usage with .ldaprc (ITS#4750) Fixed slapacl crasher (ITS#5820) Fixed slapd acl checks on ADD (ITS#4556,ITS#5723) Fixed slapd acl application to newly created backends (ITS#5572) Fixed slapd #if/#elif issues in thread includes (ITS#5824) Added slapd keyword add_content_acl for add checks (ITS#4556,ITS#5723) Fixed slapd concurrent access to connections (ITS#5814) Fixed slapd config backend olcLogFile support (ITS#5765) Fixed slapd contextCSN pending list (ITS#5709) Fixed slapd control criticality (ITS#5785) Added slapd dn.this search limits (ITS#5734) Fixed slapd error status on shutdown (ITS#5745) Fixed slapd filter substring handling (ITS#5803) Fixed slapd nameUIDPretty bitstring parsing (ITS#5750) Fixed slapd null termination of password (ITS#5794) Fixed slapd overlay/database open with real structure (ITS#5724) Fixed slapd parsing of read entry control (ITS#5741) Added slapd PMI schema (ITS#5695) Added slapd private databases in global overlays (ITS#5735,ITS#5736) Fixed slapd rdn generation when it isn't specified (ITS#5819) Fixed slapd slapd.conf validation to LDIF (ITS#5755) Fixed slapd startup scan for CSN (ITS#5640) Fixed slapd statslog printing of released entry (ITS#5775) Added slapd support for certificateListExactMatch (ITS#5700) Fixed slapd syncrepl event loss (ITS#5710) Fixed slapd syncrepl MOD of attrs with no EQ rule (ITS#5781) Fixed slapd syncrepl rename handling (ITS#5809) Fixed slapd syncrepl schema checking (ITS#5798) Fixed slapd syncrepl filter leak (ITS#5826) Fixed slapd undef promote (ITS#5783,ITS#5795) Added slapd What failed? control (ITS#5784) Fixed slapd-bdb/hdb invalid db crash (ITS#5698) Added slapd-bdb/hdb dbpagesize keyword Added slapd-bdb/hdb checksum keyword Fixed slapd-bdb/hdb indexing of entryDN (ITS#5790) Fixed slapd-bdb/hdb lookup of entryDN with equality (ITS#5791) Fixed slapd-bdb/hdb uninitialized bli_flag Fixed slapd-ldap snprintf buffer overflow test (ITS#4467) Fixed slapd-ldap search stop on minor failure (ITS#5816) Fixed slapd-ldif file rename on windows (ITS#5774) Fixed slapd-null read controls support (ITS#5757) Fixed slapd-sql value length with right index (ITS#5779) Fixed slapo-chain/translucent back-config support (ITS#5736) Fixed slapo-chain segv with search references (ITS#5742) Fixed slapo-collect compile with C89 (ITS#5747) Added slapo-constraint support for LDAP URI constraints (ITS#5704) Added slapo-constraint support for constraining rename (ITS#5703) Added slapo-constraint support for relax control (ITS#5705) Added slapo-constraint "set" type (ITS#5702) Fixed slapo-constraint filter parsing error (ITS#5751) Added slapo-dynlist URI restriction ability (ITS#5761) Fixed slapo-ppolicy unaligned BerElement (ITS#5770) Fixed slapo-rwm objectClass preservation (ITS#5760) Fixed slapo-rwm rewriting undefined filter (ITS#5731) Fixed slapo-rwm rewritten DN-valued attrs (ITS#5772) Fixed slapo-rwm reusing freed filter (ITS#5732) Fixed slapo-rwm entry get (ITS#5773) Fixed slapo-syncprov runqueue removal (ITS#5776) Fixed slapo-syncprov unreplicatable ops (ITS#5709) Fixed slapo-syncprov psearch leak (ITS#5827) Added slapo-translucent try local bind when remote fails (ITS#5656) Added slapo-translucent support for PasswordModify exop (ITS#5656) Fixed tools simple bind without SASL (ITS#5753) Fixed tools unaligned BerElement (ITS#5770) Fixed contrib nssov crash on empty groups (ITS#5800) Fixed contrib nssov crash with nssov-map (ITS#5801) Fixed contrib nssov filter and search limits (ITS#5802) Added contrib smbk5pwd honor principal expiration (ITS#5766) Build Environment Added ldapurl command Added slapd GSSAPI refactoring (ITS#5369) Added slapo-deref overlay (ITS#5768) Documentation admin24 added olcLimits to example (ITS#5746) admin24 consolidated on whitespace (ITS#5759) slapd.conf,config(5) subordinate/olcSubordinate keyword (ITS#5788) slapd.conf(5) fixed disable keyword for limits (ITS#5821) slapo-dds(5) manageDIT to relax (ITS#5780) slapo-dds(5) rootdn requirement added (ITS#5811) slapo-syncprov(5) sessionlog clarification (ITS#5806) OpenLDAP 2.4.12 Release (2008/10/12) Fixed libldap ldap_utf8_strchar arguments (ITS#5720) Fixed libldap TLS_CRLFILE (ITS#5677) Fixed liblutil executables on Windows (ITS#5604) Fixed liblutil microsecond overflows on Windows (ITS#5668) Fixed librewrite memory handling (ITS#5691) Fixed slapd aci performance (ITS#5636) Fixed slapd aci's with sets (ITS#5627) Fixed slapd attribute leak (ITS#5683) Fixed slapd config backend with index greater than sibs (ITS#5684) Fixed slapd custom attribute inheritance (ITS#5642) Fixed slapd dynacl mask handling (ITS#5637) Fixed slapd firstComponentMatch normalization (ITS#5634) Added slapd caseIgnoreListMatch (ITS#5608) Fixed slapd connection events enabled twice (ITS#5725) Fixed slapd memory handling (ITS#5691) Fixed slapd objectClass canonicalization (ITS#5681) Fixed slapd objectClass termination (ITS#5682) Fixed slapd overlay control registration (ITS#5649) Fixed slapd runqueue checking (ITS#5726) Fixed slapd spurious text output (ITS#5688) Fixed slapd socket closing on Windows (ITS#5606) Fixed slapd sortvals comparison (ITS#5578) Added slapd substitute syntax support (ITS#5663) Fixed slapd syncrepl contextCSN detection (ITS#5675) Fixed slapd syncrepl error logging (ITS#5618) Fixed slapd syncrepl runqueue interval (ITS#5719) Fixed slapd-bdb entry return if attr not present (ITS#5650) Fixed slapd-bdb olcDbMode syntax (ITS#5713) Fixed slapd-bdb/hdb release search entries earlier (ITS#5728,ITS#5730) Fixed slapd-bdb/hdb subtree search with empty suffix (ITS#5729) Fixed slapd-dnssrv memory handling (ITS#5691) Fixed slapd-ldap,slapd-meta invalid filter behavior (ITS#5614) Fixed slapd-meta memory handling (ITS#5691) Fixed slapd-meta objectClass filtering (ITS#5647) Fixed slapd-meta quarantine behavior (ITS#5592) Added slapd-ndb experimental backend Fixed slapd-relay initialization (ITS#5643) Fixed slapd-sql freeing of connection (ITS#5607) Fixed slapd-sql fault on NULL fields (ITS#5653) Fixed slapo-accesslog entryCSN generation on purge (ITS#5694) Fixed slapo-constraint string termination (ITS#5609) Fixed slapo-dynlist expansion with mapped attributes (ITS#5717) Fixed slapo-memberof internal operations DN (ITS#5622) Fixed slapo-pcache attrset crash (ITS#5665) Fixed slapo-pcache caching with invalid schema (ITS#5680) Fixed slapo-ppolicy control return on password modify exop (ITS#5711) Fixed slapo-rwm callback cleanup (ITS#5601,ITS#5687) Fixed slapo-rwm attr mapping and merging (ITS#5624) Fixed slapo-rwm objectClass filtering (ITS#5647) Fixed slapo-translucent back-config support (ITS#5689) Fixed slapo-translucent filter usage on merged entries (ITS#5679) Fixed slapo-unique filter validation (ITS#5581) Fixed slapo-unique suffix testing (ITS#5641) Build Environment Fixed ODBC library detection (ITS#5602) Removed pre-BerkeleyDB 4.4 support Added BerkeleyDB 4.7 support (ITS#5523) Included patch for BerkeleyDB 4.7.25 (build/db.4.7.25.patch) Added slapo-collect overlay with enhancements(ITS#5659) Documentation Added slapd-ldap(5), slapd-meta(5) noundeffilter (ITS#5614) Fixed slapd-ldap(5), slapd-meta(5), slapo-pcache(5) schema requirements (ITS#5680) Added slapo-collect(5) man page (ITS#5706) Added slapo-pcache(5) proxycheckcacheability option (ITS#5680) Added slapo-retcode(5) retcode.conf location (ITS#5633) admin24 dontusecopy control update (ITS#5718) admin24 guide updates (ITS#5616) admin24 octetString fix (ITS#5670)
2009-01-24+lua-tokyocabinetobache1-1/+2
2009-01-24Import lua-tokyocabinet-1.4 as databases/lua-tokyocabinet.obache6-0/+112
Tokyo Cabinet is a library of routines for managing a database. The database is a simple data file containing records, each is a pair of a key and a value. Every key and value is serial bytes with variable length. Both binary data and character string can be used as a key and a value. There is neither concept of data tables nor data types. Records are organized in hash table, B+ tree, or fixed-length array. This package provides Lua binding of Tokyo Cabinet.
2009-01-24Update TokyoCabinet to 1.4.1.obache3-8/+8
Changes: 2009-01-19 Mikio Hirabayashi <mikio@users.sourceforge.net> * tcutil.c (tctdbsearchimpl): optimized with macros. * tcbdb.c (tcbdbcurjumpimpl): a bug related to backword positioning was fixed. * tctdb.c (tctdbsearchimpl): a bug related to numeric range search was fixed. * tctdb.c (tctdbsetcache, tctdbforeach, tctdbqryproc): new functions. * tctdb.c (tctdbqryonecondmatch): new function. - Release: 1.4.1 2009-01-04 Mikio Hirabayashi <mikio@users.sourceforge.net> * tcutil.c (tccmpdecimal): equal numbers are now distinct by lexical order. * tcutil.c (tclistnew3, tcmapnew3): new functions. * tcutil.c (tcatoix, tclistinvert, tclog2l, tclog2d): new functions. * tcutil.c (tcstrsplit2, tcstrsplit3, tcstrsplit4): new functions. * tcutil.c (tcstrjoin2, tcstrjoin3, tcstrjoin4): new functions. * tchdb.c (tchdbputimpl): a bug of memory corruption was fixed. * tchdb.c (tchdbgetnext3): new function. * tcbdb.c (tcbdbleafaddrec): a bug of memory corruption was fixed. * tcbdb.c (tcbdboptimizeimpl): a bug related to parameter accession was fixed. * tctdb.h, tctdb.c, tcttest.c, tctmttest.c, tctmgr.c: new files. - Release: 1.4.0
2009-01-22Updated databases/rrdtool12martti3-11/+11
* rrd_graph: fix TICK for negative numbers * rrd_cgi: fix segfault in error reporting routine
2009-01-22Updated databases/rrdtool to 1.3.6martti3-26/+6
* many small updates to the POD documents. * improved win32 source * OSX compilation fixes * rrd_fetch: fix memory leak * rrd_cgi: fix segfault in error reporting routine * rrd_graph: fix TICK for negative numbers * rrd_graph: fix image size reporting for LP64BE architectures * rrd_resize: fix GROW for mmap (it was totally broken)
2009-01-21add 2 more patches from the distribution site, fixing a deadlockdrochner4-3/+262
and a segfault
2009-01-20Add -lintl on Solaris.sketch2-2/+6
2009-01-20Match all Solaris releases.sketch1-4/+3
2009-01-19Updating from version 1.15nb1 to 1.17.he3-23/+27
Pkgsrc changes: o Update patch to Makefile.PL to avoid reading stdin. Upstream changes: (Nothing marked 1.17 from upstream...) Version 1.16_04, released 4 January, 2009 ------------------------------------------ * added tests to prove valid quoting (most of them fail) * Reformat the source * add some (profiled) tweaks as removing useless regex to speed up SELECT * Fixed Bugs: * 14217 Does not correctly handle SQL statements with comments * 15686 Join syntax is case-sensitive, and common columns in natural joins are "ambiguous" [patch] * 13080 Cannot update a field based on its previous value * 26058 functions on computed columns aliased to the underlying column name are not called Version 1.16_03, released 1 January, 2009 ------------------------------------------ * removed *.orig and *.rej relicts Version 1.16_02, released 1 January, 2009 ------------------------------------------ * Changing join_2_tables to reduce memory usage when joining a lot of tables * Fixed Bugs: * 15688 Columns aliased with double quotes are a fatal error * 16579 Speed optimizations * 30590 Bug in SQL::Statement::is_number() * 41875 Bug in synopsis example Version 1.16_01, released 1 January, 2009 ------------------------------------------ * With this release, I'd like to welcome Jens Rehsack as co-maintainer of the SQL::Statement and SQL::Parser modules. Jens has added in some great improvements. Thanks Jens! -- Jeff * Adding a lot of join tests (once from Jeff, 48 from PostgreSQL official handbook) - no error of them will be corrected in the first run Thanks to Alexander Breibach <alexander.breibach@gmx.de> -- Jens
2009-01-19Updated databases/pear-MDB2_Driver_sqlite to 1.5.0b2abs3-10/+12
1.5.0b2 - fixed bug #12117: disconnect() does not work as documented - fixed bug #13815: incomplete regexp in the Reverse module - fixed bug #13928: Invalid triggers created for 'ON UPDATE' - fixed bug #14302: Connection errors were not always returned 1.5.0b1 - request #12731: added truncateTable() in the Manager module - request #12732: added vacuum() in the Manager module for OPTIMIZE/VACUUM TABLE abstraction - fixed bug #12924: correctly handle internal expected errors even with custom error handling - added standaloneQuery() and databaseExists() - request #13106: added unixtimestamp() in the Function module - fixed bug #13201: better regexp in errorInfo() - fixed bug #13283: replace() doesn't respect quote_identifiers option - fixed bug #13303: PRIMARY keys are not always returned in listTableConstraints() and in getTableConstraintDefinition() 1.5.0a2 - fixed bug #12105: new error message in the SQLite driver (patch by Adam Ashley) - fixed bug #12145: missing optional spaces in regexp in _getTableColumns() in the Reverse module - request #12012: added charset support in createDatabase() and collation support in createTable() for table fields 1.5.0a1 - initial support for FOREIGN KEY and CHECK constraints in the Reverse and Manager modules (on FK creation, some triggers are automatically created to enforce the FK constraint) - in listTableConstraints() in the Reverse module, also search in table definition for PRIMARY KEYs and FOREIGN KEYs - fixed bug #11428: propagate quote() errors with invalid data types - fixed bug #11790: avoid array_diff() because it has a memory leak in PHP 5.1.x - fixed bug #12083: createTable() in the Manager module now returns MDB2_OK on success, as documented - fixed bug #12146: wrong regex in _getTableColumns($sql) in the Reverse module - fixed bug #12269: tableInfo() in the Reverse module detect 'clob' data type as first option
2009-01-19Updated databases/pear-MDB2_Driver_pgsql to 1.5.0b2abs4-41/+12
1.5.0b2 - fixed bug #12117: disconnect() does not work as documented - fixed bug #13481: getTableConstraintDefinition() may return incomplete results - fixed bug #13877: UNIQUE index not always recognized as constraint - fixed bug #14292: alterTable() cannot change column type when no implicit cast is defined - fixed bug #14510: getTableFieldDefinition() does not unquote defaults - fixed bug #14828: unixtimestamp() generates invalid SQL for non-constant argument - fixed bug #15056: tableInfo does not work with pgsql schemas (added support to table schemas to Manager module) 1.5.0b1 - request #12731: added truncateTable() in the Manager module - request #12732: added vacuum() in the Manager module for OPTIMIZE/VACUUM TABLE abstraction - request #12800: added alterDatabase() in the Manager module - fixed bug #12846: missing escape in getSequenceName() on PostgreSQL 8.2.4 [thanks to Stephane Berthelot] - fixed bug #12920: added new error info and fixed escape method if connection doesn't exist [afz] - fixed bug #12922: use standaloneQuery() in alterDatabase() [afz] - fixed bug #12924: correctly handle internal expected errors even with custom error handling - added standaloneQuery() and databaseExists() - fixed bug #13112: the Reverse module does not know the timestamptz data type - request #13106: added unixtimestamp() in the Function module - fixed bug #13281: list FOREIGN KEY constraints in listTableConstraints() in the Manager module - fixed bug #13356: added float4 to _mapNativeDatatype() - fixed query in getTableConstraintDefinition() for FK constraints in the Reverse module (thanks to Andre Restivo) 1.5.0a2 - fixed bug #12376: getTableConstraintDefinition() in the Reverse module uses incorrect column number in certain cases (thanks to Dennis Birne) - request #12338: added 'disable_smart_seqname' option to make improved getSequenceName() behaviour optional (thanks to Dennis Birne) (@see bug #9106) - request #12012: added collation support in createDatabase() 1.5.0a1 - initial support for FOREIGN KEY and CHECK constraints in the Reverse and Manager modules - fixed bug #10986: Using more random statement names (request #11625) - request #11297: added support for "schema.table" (or "owner.table") notation in the Reverse module (related to bug #11207) - fixed bug #11428: propagate quote() errors with invalid data types - fixed bug in MDB2_Statement_pgsql::_execute(), called property of invalid object - fixed bug #11624: getSequenceName() returning incorrect results with multiple schemas and 'SET search_path' - fixed bug #11652: failed prepared queries containing the "::type" style of casting - fixed bug #11694: remove data type cast from DEFAULT value in getTableFieldDefinition() in the Reverse module - fixed bug #11753: NOTICEs in alterTable() in the Manager module - fixed bug #11790: avoid array_diff() because it has a memory leak in PHP 5.1.x - fixed some E_STRICT errors with PHP5 - fixed bug #12083: createTable() in the Manager module now returns MDB2_OK on success, as documented - fixed bug #12269: tableInfo() in the Reverse module detect 'clob' data type as first option
2009-01-19Updated databases/pear-MDB2_Driver_mysql to 1.5.0b2abs4-41/+12
1.5.0b2 - fixed bug #12117: disconnect() does not work as documented - fixed bug #13412: sometimes getTableConstraintDefinition() fails for FOREIGN KEYs - fixed bug #13581: wrong query in beginTransaction() for certain MySQL versions - request #13657: in setCharset(), use mysql_set_charset() if available [cwiedmann] - fixed bug #13928: Invalid triggers created for 'ON UPDATE' - fixed bug #15051: Cannot create constraints with field length - add index on FK column(s) or a FK constraint cannot be created in some cases 1.5.0b1 - fixed bug #11831: createTable() now supports tables with a multi-field PRIMARY KEY where one field is defined as AUTO_INCREMENT - request #11204: support AUTO_INCREMENT for FLOAT data type and UNSIGNED option for FLOAT and DECIMAL data type [afz] - fixed bug #11692: value of $db->supports('transactions') changes after query [afz] - request #12731: added truncateTable() in the Manager module - request #12732: added vacuum() in the Manager module for OPTIMIZE/VACUUM TABLE abstraction - request #12800: added alterDatabase() in the Manager module [afz] - fixed quoting in createDatabase() in the Manager module - fixed bug #12924: correctly handle internal expected errors even with custom error handling - added standaloneQuery() and databaseExists() - request #13106: added unixtimestamp() in the Function module - fixed regexp in listTableConstraints() in the Manager module to list FOREIGN KEY constraints - fixed bug #13180: MySQL driver tells SAVEPOINT is supported for MyISAM tables - fixed bug #13283: replace() doesn't respect quote_identifiers option - request #13313: setCharSet() supports 'COLLATE' too - fixed bug #13370: some capabilities depend on user options, so check them after a setOption() call - when triggers are supported, two triggers are created to emulate ON UPDATE / ON DELETE actions for FOREIGN KEY constraints. Known limitation: since mysql doesn't support multiple triggers with the same action time and event for one table, if there are multiple table referencing the same table, only the first one will have the triggers created. 1.5.0a2 - fixed bug #12516: error in FK constraint creation query - request #12012: added charset/collation support in createDatabase() 1.5.0a1 - fixed bug #10024: Added new option 'lob_allow_url_include' (default false) to [dis]allow inserting a LOB from an url (file, http, ...). - fixed bug #10986: Using more random statement names (request #11625) - fixed bug #11055: Using placeholders with := variable assignment fails [bekarau] - initial support for FOREIGN KEY constraints in the Manager and Reverse modules - request #11389: added many new MySQL 5.1 error codes in errorInfo() - fixed bug #11428: propagate quote() errors with invalid data types - fixed bug #11590: _getServerCapabilities() has to be called once per connection - fixed bug #11790: avoid array_diff() because it has a memory leak in PHP 5.1.x - fixed some E_STRICT errors with PHP5 - fixed bug #12010: MDB2_PORTABILITY_RTRIM option was ignored - fixed bug #12083: createTable() in the Manager module now returns MDB2_OK on success, as documented - fixed bug #12217: mysql_num_rows() returns FALSE on failure, not NULL (thanks to zaa@zaa.pp.ru) - fixed bug #12242: missing charset info in the Reverse module (patch by Carsten Wiedmann) - fixed bug #12269: tableInfo() in the Reverse module detect 'clob' data type as first option - fixed bug #12336: supply default value for NOT NULL timestamp fields
2009-01-19Updated databases/pear-MDB2 to 2.5.0b2abs4-41/+6
2.5.0b2 - fixed bug #12117: disconnect() does not work as documented - fixed bug #12912: replace() documentation - fixed bug #13811: _skipDelimitedStrings() fails on empty strings - fixed bug #13898: more tolerant check for 'new_link' DSN option - request #13929: added 'default_fk_action_ondelete' and 'default_fk_action_onupdate' options for default FOREIGN KEY constraints actions - fixed bug #14124: _skipDelimitedStrings() and prepare() fail with sql comments inside quoted strings - fixed bug #14179: declaration of MDB2_Driver_Common::raiseError() must be compatible with that of PEAR::raiseError() - fixed doc bug #14290: connect should mention the type of object returned - fixed bug #14831: $ignores in _skipDelimitedStrings() [patch by Aleksander Machniak] 2.5.0b1 - request #12731: added truncateTable() in the Manager module - request #12732: added vacuum() in the Manager module for OPTIMIZE/VACUUM TABLE abstraction - request #12800: added alterDatabase() in the Manager module [afz] - fixed bug #12924: correctly handle internal expected errors even with custom error handling - fixed bug #12991: new error code in errorInfo() [afz] - added databaseExists() method [afz] - request #13106: added unixtimestamp() in the Function module - added max_identifiers_length option 2.5.0a2 - fixed bug #12358: E_STRICT changes in latest alpha broke PHP4 compatibility - fixed bug #12351: wrong case for function PEAR::isError() in the Reverse module [was: IsError()] - fixed bug #12530: MDB2_Extended::autoPrepare() gives error if $types is null - request #12012: added charset/collation support in createDatabase() for the drivers that support this feature - added bindname_format option (this is the regexp used to recognize named placeholders in prepared statements) 2.5.0a1 - fixed bug #10024: Security fix for LOBs. Added an option to turn lob_allow_url_include off by default - fixed bug #11179: prepared statements with named placeholders fail if extra values are provided - request #11297: added support for "schema.table" (or "owner.table") notation in the Reverse module - initial support for FOREIGN KEY and CHECK constraints in the Reverse and Manager modules - fixed bug #11428: propagate quote() errors with invalid data types - added new test cases in the test suite - added LENGTH() function in the Function module - fixed bug #11612: raiseError() must be compatible with PEAR::raiseError() [PHP6] - fixed bug #11790: avoid array_diff() because it has a memory leak in PHP 5.1.x - fixed bug #11906: quoteIdentifier fails for names with dots - fixed bug #11975: Extended::autoExecute() does not work with Oracle when using LOBs (patch by Pieter Meulen, van der) - fixed some E_STRICT errors with PHP5 - fixed bug #12083: createTable() in the Manager module now returns MDB2_OK on success, as documented - fixed bug #12246: wrong check in MDB2::isStatement() (thanks to zaa@zaa.pp.ru)
2009-01-18Update from version 2.11.7 to 2.11.8.he2-6/+6
This despite one of the selftests still fail. Upstream changes: 2.11.8 Released December 28, 2008 - Fix minor bug in t/12placeholders.t test (CPAN bug #41723)