Age | Commit message (Collapse) | Author | Files | Lines |
|
Pointed out by Gergo Szakal in PR 36711.
|
|
|
|
|
|
Change since version 5.0.41:
- Functionality added or changed:
- A new status variable, Com_call_procedure, indicates the number of calls
to stored procedures. (Bug#27994)
- NDB Cluster: The server source tree now includes scripts to simplify
building MySQL with SCI support. For more information about SCI
interconnects and these build scripts, see Section 15.9.1,
Configuring MySQL Cluster to use SCI Sockets. (Bug#25470)
- Prior to this release, when DATE values were compared with DATETIME values
the time portion of the DATETIME value was ignored. Now a DATE value is
coerced to the DATETIME type by adding the time portion as 00:00:00. To
mimic the old behavior use the CAST() function in the following way:
SELECT date_field = CAST(NOW() as DATE);. (Bug#28929)
- A large number of bugs including these security problems have been fixed:
- A malformed password packet in the
connection protocol could cause the server to crash. Thanks for Dormando
for reporting this bug and providing details and a proof of concept.
(Bug#28984)
- CREATE TABLE LIKE did not require any privileges on the source table. Now
it requires the SELECT privilege. (Bug#25578)
- In addition, CREATE TABLE LIKE was not isolated from alteration by other
connections, which resulted in various errors and incorrect binary log
order when trying to execute concurrently a CREATE TABLE LIKE statement
and either DDL statements on the source table or DML or DDL statements on
the target table. (Bug#23667)
|
|
Suggested by pancake@ in PR #28573
|
|
|
|
the owner of all installed files is a non-root user. This change
affects most packages that require special users or groups by making
them use the specified unprivileged user and group instead.
(1) Add two new variables PKG_GROUPS_VARS and PKG_USERS_VARS to
unprivileged.mk. These two variables are lists of other bmake
variables that define package-specific users and groups. Packages
that have user-settable variables for users and groups, e.g. apache
and APACHE_{USER,GROUP}, courier-mta and COURIER_{USER,GROUP},
etc., should list these variables in PKG_USERS_VARS and PKG_GROUPS_VARS
so that unprivileged.mk can know to set them to ${UNPRIVILEGED_USER}
and ${UNPRIVILEGED_GROUP}.
(2) Modify packages to use PKG_GROUPS_VARS and PKG_USERS_VARS.
|
|
2007 June 18 (3.4.0)
* Fix a bug that can lead to database corruption if an SQLITE_BUSY
error occurs in the middle of an explicit transaction and that
transaction is later committed. Ticket #2409. See the
CorruptionFollowingBusyError wiki page for details.
* Fix a bug that can lead to database corruption if autovacuum mode
is on and a malloc() failure follows a CREATE TABLE or CREATE INDEX
statement which itself follows a cache overflow inside a transaction.
See ticket #2418.
* Added explicit upper bounds on the sizes and quantities of things
SQLite can process. This change might cause compatibility problems
for applications that use SQLite in the extreme, which is why the
current release is 3.4.0 instead of 3.3.18.
* Added support for Incremental BLOB I/O.
* Added the zeroblob API and the zeroblob() SQL function.
* Added support for Incremental Vacuum.
* Added the SQLITE_MIXED_ENDIAN_64BIT_FLOAT compile-time option to
suppport ARM7 processors with goofy endianness.
* Removed all instances of sprintf() and strcpy() from the core
library.
* Added support for International Components for Unicode (ICU) to
the full-text search extensions.
* In the windows OS driver, reacquire a SHARED lock if an attempt
to acquire an EXCLUSIVE lock fails. Ticket #2354
* Fix the REPLACE() function so that it returns NULL if the second
argument is an empty string. Ticket #2324.
* Document the hazards of type coversions in sqlite3_column_blob()
and related APIs. Fix unnecessary type conversions. Ticket #2321.
* Internationalization of the TRIM() function. Ticket #2323
* Use memmove() instead of memcpy() when moving between memory
regions that might overlap. Ticket #2334
* Fix an optimizer bug involving subqueries in a compound SELECT
that has both an ORDER BY and a LIMIT clause. Ticket #2339.
* Make sure the sqlite3_snprintf() interface does not zero-terminate
the buffer if the buffer size is less than 1. Ticket #2341
* Fix the built-in printf logic so that it prints "NaN" not "Inf"
for floating-point NaNs. Ticket #2345
* When converting BLOB to TEXT, use the text encoding of the main
database. Ticket #2349
* Keep the full precision of integers (if possible) when casting
to NUMERIC. Ticket #2364
* Fix a bug in the handling of UTF16 codepoint 0xE000
* Consider explicit collate clauses when matching WHERE constraints
to indices in the query optimizer. Ticket #2391
* Fix the query optimizer to correctly handle constant expressions
in the ON clause of a LEFT JOIN. Ticket #2403
* Fix the query optimizer to handle rowid comparisions to NULL
correctly. Ticket #2404
* Fix many potental segfaults that could be caused by malicious
SQL statements.
|
|
The new version fixes several bugs and addresses the security
vulerability reported in PMASA-2007-4.
|
|
Changes is in ChangeLog from perl-5.8 to perl-5.8.8.
|
|
|
|
changes: bugbixes
|
|
|
|
|
|
|
|
Patch provided by maintainer, Bartosz Kuzma in PR 36478.
Changes since 0.7.4:
Sun Sep 24 10:44:00 2006 Andrzej Kukula <akukula@gmail.com>
* setup.py:
+ it can now dynamically determine the path to SQL 2000 Developer
Tools, if win32api and win32con modules are available
+ simple Python version check to prevent most frequently asked
question
Wed Sep 13 01:20:00 2006 Andrzej Kukula <akukula@gmail.com>
* mssqldbmodule.c:
+ corrected misspellings in docstrings
+ fixed segfault on connection close with Python 2.5; thanks
Justin Francis <jfrancis@pivotalpayments.com>
* pymssql.py:
+ fixed two minor DB-API incompatibilities
(thanks Matthew Good <matt@matt-good.net>)
+ fixed datetime quoting (thanks Jan Finell <jfinell@regionline.fi>)
* pymssql should be able to build on cygwin (thanks rob@robnet.com)
* docstring fixes, webpage doc updates
Tue May 15 03:18:00 2006 Jooncheol Park <exman@users.sourceforge.net>
* setup.py, PKG-INFO, README: license change to LGPL
Wed Mar 15 08:18:00 2006 Andrzej Kukula <akukula@users.sourceforge.net>
* pymssql.py: fixed datetime issue
(thanks Jan Finell <jfinell@regionline.fi>)
Fri Feb 24 16:11:00 2006 Andrzej Kukula <akukula@users.sourceforge.net>
* mssqldbmodule.c: fixed typos in docstrings
(thanks Konstantin Veretennicov)
|
|
|
|
|
|
starting mysqld, otherwise if mysql_datadir has not been initialized
it will fail.
Patch from Edgar Fur via PR pkg/36138.
|
|
lang/guile to 1.8.1 from 1.6.8. These pkgs seemed to fail to build with
guile 1.8.1, but maybe can be easily fixed.
|
|
lbdb (0.35.1) unstable; urgency=low
* New mail address of Brian Salter-Duke <b_duke@bigpond.net.au>.
* Get rid of the SSL code from the previous version and add a comment to
the man page instead how you can use SSL (and also different ports)
using ldap[s]://foo[:port] URLs (Closes: #426316).
-- Roland Rosenfeld <roland@debian.org> Mon, 28 May 2007 11:03:22 +0200
lbdb (0.35) unstable; urgency=low
* activate flavortest in emacen-install to avoid warnings and slow
upgrades (Closes: #399775).
* Avoid loosing the first entry from VCF file. Thanks to
Tino Keitel <tino.keitel+debbugs@tikei.de> for providing a patch
(Closes: #405312).
* Remove vcquery in distclean target (Closes: #405321).
* Use defaults for $KEEP_DUPES and $SORT_OUTPUT in lbdbq
(Closes: #422214).
* Update mutt_ldap_query.pl from
http://www.courville.org/mediawiki/index.php/Mutt_ldap_query which
adds SSL support.
|
|
databases/p5-Rose-DB
databases/p5-Rose-DB-Object
databases/p5-SQL-ReservedWords
devel/p5-Clone-PP
devel/p5-Data-OptList
devel/p5-Rose-Object
devel/p5-Sub-Exporter
devel/p5-Sub-Install
time/p5-DateTime-Format-MySQL
time/p5-DateTime-Format-Pg
time/p5-Rose-DateTime
time/p5-Time-Clock
|
|
Rose::DB::Object is a base class for objects that encapsulate a
single row in a database table. It provides the following functions:
* Create a row in the database by saving a newly constructed object.
* Initialize an object by loading a row from the database.
* Update a row by saving a modified object back to the database.
* Delete a row from the database.
* Fetch an object referred to by a foreign key in the current object.
(i.e., "one to one" and "many to one" relationships.)
* Fetch multiple objects that refer to the current object, either directly
through foreign keys or indirectly through a mapping table. (i.e., "one
to many" and "many to many" relationships.)
* Load an object along with "foreign objects" that are related through any
of the supported relationship types.
|
|
Rose::DB is a wrapper and abstraction layer for DBI-related
functionality. A Rose::DB object "has a" DBI object; it is not a
subclass of DBI.
Tip: Are you looking for an object-relational mapper (ORM)? If so,
please see the Rose::DB::Object module. Rose::DB::Object is an ORM
that uses this module to manage its database connections. Rose::DB
alone is simply a data source abstraction layer; it is not an ORM.
|
|
Reserved SQL words by standard and vendors, including:
* ANSI/ISO
* DB2
* MySQL
* ODBC
* Oracle
* PostgreSQL
* SQL Server
* SQLite
* Sybase
|
|
the upper version.
|
|
|
|
Patch provided by Mark E. Perkins in PR 36465.
$MODULE = "MLDBM::Sync"; $VERSION = '.30'; $DATE = '2002/07/03';
+ Added MLDBM to the list of PREREQ_PM modules for better CPAN installation
$MODULE = "MLDBM::Sync"; $VERSION = .27; $DATE = '2002/06/23';
+ Added note to error for Lock upgrade during ReadLock
for case of doing unintentional write with construct like:
tied(%dbm)->ReadLock;
my $v = $dbm{'key'}{'key2'}; # will error with write !!
^^^^^^^^^
Thanks to Steve Keith for noting this bizarre perl behavior.
+ bench/bench_sync.pl now creates a test dbm in the local directory
being run instead of /tmp ... benchmark results were being skewed
since /tmp could be a fast RAM cache file system like tmpfs on Linux
+ Added MANIFEST.SKIP for building
+ t/taint.t perl taint check test added.
+ escape inbound file parameter for safe taint checking
$MODULE = "MLDBM::Sync"; $VERSION = .25; $DATE = '2001/11/11';
+ Honors the $MLDBM::RemoveTaint setting when MLDBM::Sync object is created,
storing for later creation of the MLDBM tied object
$MODULE = "MLDBM::Sync"; $VERSION = .23; $DATE = '2001/11/08';
+ Updated AUTHORS section with perl license reference.
+ ./bench/bench_sync.pl has -n argument to specify # of reads/writes
where default is 100
+ ./bench/bench_sync.pl has --bundle argument to allows for reads/writes
in locked sections of that #, which improves performance.
+ $dbm->Size() for Tie::TextDir now adds size of directory as
reported by OS. This still does not seem to take into account
the extra file inode overhead on a file system like ext2 linux
but its better now at least.
$MODULE = "MLDBM::Sync"; $VERSION = .21; $DATE = '2001/10/31';
+ Added support in CLEAR() & SyncSize() for a tie directory
based data structure like Tie::TextDir
$MODULE = "MLDBM::Sync"; $VERSION = .19; $DATE = '2001/10/15';
- Fixed keys(%hash), where one of the keys was boolean FALSE
like '', or 0. Bug found by Elliot Glaysher.
$MODULE = "MLDBM::Sync"; $VERSION = .17; $DATE = '2001/10/11';
- Make EXISTS safe after explicity tied hash ReadLock()
- For loops in MLDBM::Sync::SDBM_File that are friendlier
to perl5.004_04
- Better Lock() return value, whether or not a lock has
previously been acquired
|
|
Patch provided by Mark E. Perkins in PR 36465.
1.815 4 February 2007
* A few casting cleanups for building with C++ from Steve Peters.
* Fixed problem with recno which happened if you changed directory after
opening the database. Problem reported by Andrew Pam.
|
|
Patch provided by Mark E. Perkins in PR 36465.
0.31 15th Oct 2006
* Fixed DB_GET_BOTH. Tnanks to Thomas Drugeon for spotting the typo
in typemap and supplying a regression test for this fix.
0.30 11th Sept 2006
* Fixed queue test harness for Berkeley DB 4.5 compliance
* Added $env->lsn_reset, $txn->set_timeout, $env->set_timeout &
$env->get_timeout, $txn->set_tx_max, $txn->get_tx_max
0.29 2nd July 2006
* Fixes for cursor get from secondary where primary os recno.
* Added db_compact
0.28 11th June 2006
* Fixes for secondary where primary is recno.
* GET_BOTH_RANGE wasn't working. It is now.
* Added FreeBSD hints to README - patch supplied by David Landgren
in #17675 from rt.cpan.org
|
|
1.49
- Thanks to Backcountry.com for sponsoring work on this release. [GSM]
- Add the statement handle attribute ParamTypes, and fix an error
in ParamValues. ParamTypes requires DBI 1.49 or better. [GSM]
- Strip the final newline from error messages, so that die can add
in the line number. (CPAN bug #18900) [GSM]
- Make workaround for PQresultErrorField not returning proper
result when an error is set and we are connecting via TCP/IP.
This allows correct $dbh->state() values. [GSM]
- Fix incorrect quoting preventing compiling. (CPAN bug #18640)
- Add support for quoting and binding of geometric types: POINT,
LINE, LSEG, BOX, PATH, POLYGON, and CIRCLE. Also added the
TID type. [GSM]
|
|
Changes in 1.56:
Fixed printf arg warnings thanks to JDHEDDEN.
Fixed returning driver-private sth attributes via gofer.
Changed pod docs docs to use =head3 instead of =item
so now in html you get links to individual methods etc.
Changed default gofer retry_limit from 2 to 0.
Changed tests to workaround Math::BigInt broken versions.
Changed dbi_profile_merge() to dbi_profile_merge_nodes()
old name still works as an alias for the new one.
Added DBI_GOFER_RANDOM env var that can be use to trigger random
failures and delays when executing gofer requests. Designed to help
test automatic retry on failures and timeout handling.
Added lots more docs to all the DBD::Gofer and DBI::Gofer classes.
Changes in 1.55:
Fixed set_err() so HandleSetErr hook is executed reliably, if set.
Fixed accuracy of profiling when perl configured to use long doubles.
Fixed 42prof_data.t on fast systems with poor timers thanks to Malcolm Nooning.
Fixed potential corruption in selectall_arrayref and selectrow_arrayref
for compiled drivers, thanks to Rob Davies.
Rebuild your compiled drivers after installing DBI.
Changed some handle creation code from perl to C code,
to reduce handle creation cost by ~20%.
Changed internal implementation of the CachedKids attribute
so it's a normal handle attribute (and initially undef).
Changed connect_cached and prepare_cached to avoid a FETCH method call,
and thereby reduced cost by ~5% and ~30% respectively.
Changed _set_fbav to not croak when given a wrongly sized array,
it now warns and adjusts the row buffer to match.
Changed some internals to improve performance with threaded perls.
Changed DBD::NullP to be slightly more useful for testing.
Changed File::Spec prerequisite to not require a minimum version.
Changed tests to work with other DBMs thanks to ZMAN.
Changed ex/perl_dbi_nulls_test.pl to be more descriptive.
Added more functionality to the (undocumented) Callback mechanism.
Callbacks can now elect to provide a value to be returned, in which case
the method won't be called. A callback for "*" is applied to all methods
that don't have their own callback.
Added $h->{ReadOnly} attribute.
Added support for DBI Profile Path to contain refs to scalars
which will be de-ref'd for each profile sample.
Added dbilogstrip utility to edit DBI logs for diff'ing (gets installed)
Added details for SQLite 3.3 to NULL handling docs thanks to Alex Teslik.
Added take_imp_data() to DBI::PurePerl.
Gofer related changes:
Fixed gofer pipeone & stream transports to avoid risk of hanging.
Improved error handling and tracing significantly.
Added way to generate random 1-in-N failures for methods.
Added automatic retry-on-error mechanism to gofer transport base class.
Added tests to show automatic retry mechanism works a treat!
Added go_retry_hook callback hook so apps can fine-tune retry behaviour.
Added header to request and response packets for sanity checking
and to enable version skew between client and server.
Added forced_single_resultset, max_cached_sth_per_dbh and max_cached_dbh_per_drh
to gofer executor config.
Driver-private methods installed with install_method are now proxied.
No longer does a round-trip to the server for methods it knows
have not been overridden by the remote driver.
Most significant aspects of gofer behaviour are controlled by policy mechanism.
Added policy-controlled caching of results for some methods, such as schema metadata.
The connect_cached and prepare_cached methods cache on client and server.
The bind_param_array and execute_array methods are now supported.
Worked around a DBD::Sybase bind_param bug (which is fixed in DBD::Sybase 1.07)
Added goferperf.pl utility (doesn't get installed).
Many other assorted Gofer related bug fixes, enhancements and docs.
The http and mod_perl transports have been remove to their own distribution.
Client and server will need upgrading together for this release.
|
|
4.5.0:
* Adds supports for compiling and linking with BerkeleyDB 4.5
* Python Bug #1599782: Fix segfault on bsddb.db.DB().type() due to
releasing the GIL when it shouldn't. (nnorowitz)
* Fixes a bug with bsddb.DB.stat where the flags and txn keyword
arguments are transposed.
* change test cases to use tempfile.gettempdir()
4.4.5:
* pybsddb Bug #1527939: bsddb module DBEnv dbremove and dbrename
methods now allow their database parameter to be None as the
sleepycat API allows.
4.4.4:
* fix DBCursor.pget() bug with keyword argument names when no data= is
supplied [SF pybsddb bug #1477863]
* add support for DBSequence objects [patch #1466734]
* support DBEnv.log_stat() method on BerkeleyDB >= 4.0 [patch #1494885]
* support DBEnv.lsn_reset() method on BerkeleyDB >= 4.4 [patch #1494902]
* add DB_ARCH_REMOVE flag and fix DBEnv.log_archive() to accept it without
potentially following an uninitialized pointer.
4.4.3:
* fix DBEnv.set_tx_timestamp to not crash on Win64 platforms (thomas.wouters)
* tons of memory leak fixes all over the code (thomas.wouters)
* fixes ability to unpickle DBError (and children) exceptions
|
|
|
|
Noted by OBATA Akio.
|
|
|
|
Multi-Version Concurrency Control (MVCC)
improves performance of highly concurrent, mixed read/write systems
by giving each user their own snapshot of the database and managing
concurrent changes by many users
Non-stop Upgrades
enables a replicated Oracle Berkeley DB system to be upgraded
without downtime. For customers that must maintain 99.999 percent
system uptime, this allows them to upgrade the Oracle Berkeley DB
database without taking down the entire system
Replication Framework
provides a pre-built and supported set of functions for quickly
building replicated or highly available systems, simplifying and
accelerating their development effort
|
|
1.48 Sun Mar 11 05:24:40 UTC 2007
* Fix a problem when left joins optimizer fails to calculate a boolean
expression because of lower case aggregators.
|
|
0.31 Thu Mar 30 05:28:20 PST 2006
- more schema update stuff:
- added Column::sql_alter_column
- added Table::sql_alter_table
- added DBSchema::sql_update_schema and DBSchema::update_schema
0.30 Thu Feb 16 16:43:01 PST 2006
- "Too much uptime"
- Remove buggy debugging from Column.pm
- Remove removed TODO from MANIFEST
0.29 Thu Feb 16 13:54:42 PST 2006
- Column::sql_add_column fix when adding primary keys to Pg 7.2.x
- workaround for PAUSE parsing of DBIx::DBSchema::DBD::Pg version: move
DBD::Pg verison checking after $VERSION declaration, thanks Andreas!
- kludge: allow scalar ref default to force quoting off, to add things
like functions and empty values as defaults
- Move TODO file to DBSchema.pm and DBS/Column.pm BUGS sections
0.28 Wed Nov 30 09:46:47 PST 2005
- Initial SQLite support from Jesse Vincent
- fix typo in DBIx::DBSchema::DBD POD doc
|
|
1.06 03/23/2007
- MP2/AuthDBI: Fixed Apache::AuthDBI::debug() to
actually work.
Submitted by: [Kevin Appel <kappel@tgic.com>]
- Bump minium required perl version to 5.6.1 to match DBI
(Changes in DBI 1.49 (svn rev 2287), 29th November 2005)
Philip M. Gollucci <pgollucci@p6m7g8.com>
|
|
2007 April 25 (3.3.17)
* When the "write_version" value of the database
header is larger than what the library understands,
make the database read-only instead of unreadable.
* Other minor bug fixes
2007 April 18 (3.3.16)
* Fix a bug that caused VACUUM to fail if NULLs
appeared in a UNIQUE column.
* Reinstate performance improvements that were added
in 3.3.14 but regressed in 3.3.15.
* Fix problems with the handling of ORDER BY expressions
on compound SELECT statements in subqueries.
* Fix a potential segfault when destroying locks on
WinCE in a multi-threaded environment.
* Documentation updates.
2007 April 9 (3.3.15)
* Fix a bug introduced in 3.3.14 that caused a rollback
of CREATE TEMP TABLE to leave the database connection
wedged.
* Fix a bug that caused an extra NULL row to be
returned when a descending query was interrupted by
a change to the database.
* The FOR EACH STATEMENT clause on a trigger now
causes a syntax error. It used to be silently ignored.
* Fix an obscure and relatively harmless problem that
might have caused a resource leak following an I/O
error.
* Many improvements to the test suite. Test coverage
now exceeded 98%
2007 April 2 (3.3.14)
* Fix a bug in 3.3.13 that could cause a segfault
when the IN operator is used one one term of a
two-column index and the right-hand side of the IN
operator contains a NULL.
* Added a new OS interface method for determining
the sector size of underlying media: sqlite3OsSectorSize().
* A new algorithm for statements of the form INSERT
INTO table1 SELECT * FROM table2 is faster and
reduces fragmentation. VACUUM uses statements of
this form and thus runs faster and defragments
better.
* Performance enhancements through reductions in disk I/O:
* Do not read the last page of an overflow chain
when deleting the row - just add that page to
the freelist.
* Do not store pages being deleted in the rollback journal.
* Do not read in the (meaningless) content of
pages extracted from the freelist.
* Do not flush the page cache (and thus avoiding
a cache refill) unless another process changes
the underlying database file.
* Truncate rather than delete the rollback
journal when committing a transaction in
exclusive access mode, or when committing the
TEMP database.
* Added support for exclusive access mode using
"PRAGMA locking_mode=EXCLUSIVE"
* Use heap space instead of stack space for large
buffers in the pager - useful on embedded platforms
with stack-space limitations.
* Add a makefile target "sqlite3.c" that builds an
amalgamation containing the core SQLite library C
code in a single file.
* Get the library working correctly when compiled
with GCC option "-fstrict-aliasing".
* Removed the vestigal SQLITE_PROTOCOL error.
* Improvements to test coverage, other minor bugs
fixed, memory leaks plugged, code refactored and/or
recommented in places for easier reading.
|
|
|
|
affected packages.
|
|
|
|
|
|
pkg-build-options.mk procedure.
|
|
|
|
|
|
|
|
databases/zope-mysql
lang/py-extclass
textproc/py-dtml
www/py-pcgi
www/py-zpublisher
www/zope
No objection from pkgsrc-users.
cVS: ----------------------------------------------------------------------
|