DBD-mysql
view release on metacpan or search on metacpan
* it seems catalogs *are* now supported - make statistics_info use them
* Warn that MariaDB's client library does not work
* Carefully compare library version numbers
* Correct email address
* correct keyword name MEDIUMBLOB
2024-09-19 Daniël van Eeden, DBI/DBD community (5.009)
* Cleanup obsolete mysql_errmsg and mysql_stats
* fix some queries with columns beginning with limit would fail
* implement statistics_info $unique_only
* fix(column_info): use show columns to describe
* Update Dockerfile
2024-07-30 Daniël van Eeden, DBI/DBD community (5.008)
* CI: Use Oracle MySQL containers
* 51bind_type_guessing.t: Update for 9.0.0 errorcodes
* MySQL 9.0.0 client library support
2024-07-01 Daniël van Eeden, DBI/DBD community (5.007)
* Fix calls to mysql_server_end()/mysql_library_end()
* Dockerfile: Update mysql-apt-config
2024-06-01 Daniël van Eeden, DBI/DBD community (5.006)
* Fix pod and ensure Test::Pod is installed
* CI: Test with MySQL 8.4
* Update test for `have_ssl` removal
2024-05-01 Daniël van Eeden, DBI/DBD community (5.005)
* docs: Update package names and MariaDB related things
* Rewrite yum name to dnf
* CI: Test against MySQL 8.3
* Replace mysql_stmt_bind_param() with mysql_stmt_bind_named_param()
* Cleanup deprecated functionality
2024-03-19 Daniël van Eeden, DBI/DBD community (5.004)
* Add deprecation warning for LISTFIELDS support
* Remove calls to mysql_reload() and mysql_list_fields()
* (ci_update) Update mysql-apt-config to 0.8.29-1
* Re-add documentation on how to workaround UTF-8 bug
* Remove legacy Bundle::DBD::mysql
2023-12-01 Daniël van Eeden, DBI/DBD community (5.003)
* Add ifdef for ER_CLIENT_INTERACTION_TIMEOUT
* Fix for issue 251. Also fixed case of "e<single int>"
* Docs: Update macOS docs
* CI: Add macOS
* Call mysql_library_init() and mysql_library_end()
* Update bug report address
* Check if handle is active when calling prepare
* Add missing testsocket option to the docs
* Add Dockerfile (#390)
* More cleanups of unneeded ifdefs (#385)
* Enable auto reconnect for ER_CLIENT_INTERACTION_TIMEOUT
* Try out issue template for GitHub
* 99compression.t: Only test on 8.x
* Only use MYSQL_OPT_COMPRESSION_ALGORITHMS on >=8.0.18
* Replace `mysql_ssl_set()` with `mysql_options()`
2023-10-24 Daniël van Eeden, DBI/DBD community (5.002)
* Add support for compression algorighm selection (#372)
* Correct handling of mysql_enable_utf8mb4 (#363)
* tests: Remove have_transactions usage from 50commit.t
* Makefile: Clearly report that MySQL 8.x is needed and do some cleanup
* add DBD::mysql::client_version() to have the client version without DB connections
* Update version test for v5.x
2023-10-04 Daniël van Eeden, DBI/DBD community (5.001)
* Only support MySQL 8.x as MySQL 5.7 is going EOL soon
* Remove use of MYSQL_OPT_RECONNECT
* Remove option to disable SSL/TLS at compile time
* Only support MySQL 5.7 GA client libraries
* Remove support for MySQL Connector/C 6.0.x
* Cleanup ifdef's for pre-5.7 MySQL
* Cleanup ifdef's for MySQL 4.x and earlier
* Remove MySQL Embedded support (libmysqld)
* Replace my_bool with bool
* Remove MySQL Fabric support
2018-10-25 Daniël van Eeden, Patrick Galbraith,
DBI/DBD community (4.050)
* Fix SQL syntax for statements that have "...limit = ?" #288
* Make tests pass on MySQL 4.1 #286
* Travis-CI: Install Test::Deep #281
* Fix undefined ssl_verify_set on MySQL 5.0 and before #283
* Fix compilation on MySQL 4.1 #283
* Move Travis to dbdeployer (#284) #284
* Fix compiling on 8.0.0 and 8.0.1 #285
* Fix compatibility with MariaDB 10.3 #291
2018-10-25 Daniël van Eeden, Patrick Galbraith,
DBI/DBD community (4.049)
* Fix MariaDB issue #262
* Various fixes for travis builds
* Fix to issue 187: Don't declare enum_type as static
* Fix regex for removing database from DSN again
* Allow to call $sth->mysql_async_ready and $sth->mysql_async_result more times without discarding result state 201
2018-09-15 Daniël van Eeden, Patrick Galbraith, Michiel Beijen,
DBI/DBD community (4.048)
* Fix corrupted META.json so cpan installations work as expected.
https://github.com/perl5-dbi/DBD-mysql/issues/263
* Fix issue 251: unable to insert "." with bind_type_guessing on
2018-09-08 Daniël van Eeden, Patrick Galbraith, DBI/DBD community (4.047)
* Add options needed for public key based security.
* Allow several spaces after LIMIT clause.
* Basic GTID tracking.
* Fix GCC 8.1 warnings
* Fix warning: unused variable ‘buffer_len’
* Fix warning about bind->is_null assignment with incompatible pointer type
* Get rid of warning about unused variable ssl_verify_set
* Fix space/tab issue which leads to misleading indentation
* Change spaces/tabs to get rid of GCC8 warning
2018-03-09 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.046_01)
* Updated documentation re. multithreading (Daniël van Eeden)
* Remove #IFDEFs for code detecting ancient DBI versions. The minimum
DBI version we require is version 1.609 from 2009!
* ChopBlanks should not trim binary fields (urcheon)
* Skipped test which failed on OpenBSD because Proc::ProcessTable does not
come with a 'size' attribute on this platform (glasswalk3r, pali)
2017-06-29 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.043)
YOUR ATTENTION PLEASE, THIS IS A REVERT TO 4.041
This version is the same as 4.041 with all its bugs and
limitations. In version 4.042 there were some changes to Unicode handling
that turned out to be causing issues with existing implementations.
While it is possible to argue that the old behaviour was wrong and buggy,
lots of applications and scripts were depending on this behaviour so it
is NOT a good idea to change this.
There were lots of commits since 4.041, we'll add those back bit by bit
in a future release, excluding the ones which cause problems.
2017-??-?? Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.042_01)
* Use Devel::CheckLib 1.09 or newer, fixes
https://github.com/perl5-dbi/DBD-mysql/issues/109
* Improve CI testing on AppVeyor: caching, path to cpan, configure deps (pali)
* Specify bigint as test dependency.
2017-03-08 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.042)
* Full release to include development releases 4.041_2 and 4.041_1.
2017-02-28 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.041_2)
* Statement handle now also has mysql_sock attribute, just as database handle.
(by Pali)
* Fix type conversions for magic types. Issue reported by Dmitriy Yatsenko and
Giovanni Bechis, fix by Pali.
https://lists.amavis.org/pipermail/amavis-users/2016-December/004674.html
https://github.com/perl5-dbi/DBD-mysql/issues/78
* Fix UTF8-encoding of table names, field names, warnings and error messages.
Reported by Tanabe Yoshinori, fix by Pali.
https://rt.cpan.org/Public/Bug/Display.html?id=120141
* Fix mysql_auto_reconnect when using mysql_server_prepare (pali). Reported by
Vladimir Marek.
https://github.com/perl5-dbi/DBD-mysql/pull/95
* Improve regex for removing database from dsn (pali)
https://rt.cpan.org/Public/Bug/Display.html?id=118837
* Locate MySQL libs using Devel::CheckLib (pali)
* Support async on Windows (pali)
* Fix test suite on range of older and newer MySQL and MariaDB versions
(https://github.com/perl5-dbi/DBD-mysql/pull/87)
* Fix compilation on MySQL 4.1 (pali)
* Do not leak dangling pointer to mysql result (pali)
* Fix logic when assigning to variable bind_comment_placeholders (pali)
* mysql_fd() still returned file descriptor after closing connection.
Reported by Larry Leszczynski, fixed by Pali Rohár.
(https://rt.cpan.org/Public/Bug/Display.html?id=110983)
* Fix parsing configure libs from mysql_config --libs output in Makefile.PL
Libraries in mysql_config --libs output can be specified by library name
with the -l prefix or by absolute path to library name without any prefix.
Parameters must start with a hyphen, so treat all options without leading
hyphen in mysql_config --libs output as libraries with full path.
Partially fixes bug https://rt.cpan.org/Public/Bug/Display.html?id=100898
Fix by Pali Rohár.
* Fix support for magic scalars (pali)
(https://github.com/perl5-dbi/DBD-mysql/pull/76)
2016-12-12 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.041_1)
* Unicode fixes: when using mysql_enable_utf8 or mysql_enable_utf8mb4,
previous versions of DBD::mysql did not properly encode input statements
to UTF-8 and retrieved columns were always UTF-8 decoded regardless of the
column charset.
Fix by Pali Rohár.
Reported and feedback on fix by Marc Lehmann
(https://rt.cpan.org/Public/Bug/Display.html?id=87428)
Also, the UTF-8 flag was not set for decoded data:
(https://rt.cpan.org/Public/Bug/Display.html?id=53130)
* Return INTs with ZEROFILL as strings. Reported by Knarf, fix by Pali Rohár.
(https://rt.cpan.org/Public/Bug/Display.html?id=118977)
2016-11-28 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.041)
* Fix use-after-free for repeated fetchrow_arrayref calls when
mysql_server_prepare=1
Function dbd_st_fetch() via Renew() can reallocate output buffer for
mysql_stmt_fetch() call. But it does not update pointer to that buffer in
imp_sth->stmt structure initialized by mysql_stmt_bind_result() function.
That leads to use-after-free in any mysql function which access
imp_sth->stmt structure (e.g. mysql_stmt_fetch()).
This patch fix this problem and properly updates pointer in imp_sth->stmt
structure after Renew() call.
This is a medium level security issue to which the Debian security team
assigned identifier CVE-2016-1251. Discovered and fixed by Pali Rohár.
* auto_reconnect now also matches CR_SERVER_LOST, previously this only
matched CR_SERVER_GONE.
Fixes http://bugs.mysql.com/bug.php?id=27613
Fix suggested by Wouter de Jong.
* Fix compilation fixes (Pali Rohár).
2016-11-19 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.040)
* Since 4.038 we had problems compiling on big-endian architectures, such
as MIPS, s390 and Sparc. Thanks to Salvatore Bonaccorso @ Debian project
(https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=844538)
and Vladimir Marek (https://rt.cpan.org/Public/Bug/Display.html?id=118835)
for reporting the issues. Fix by Pali Rohár.
Fix integer types when server side prepare statements are enabled
Fixed problems:
* SQL_BIGINT was incorrectly handled as 32bit MYSQL_TYPE_LONG type instead
64bit MYSQL_TYPE_LONGLONG which led to integer overflow/underflow
* 32bit MYSQL_TYPE_LONG was used for perl's IV storage when IV was 64bit
and 64bit MYSQL_TYPE_LONGLONG was used when IV was 32bit
* All unsigned types were handled as signed, so all high positive values
were treated as negative
* Numeric conversions in perl which led to overflow/underflow was ignored
even when mysql strict mode was enabled
* Test t/41int_min_max.t was running only for normal non-prepared statements
* Test t/40server_prepare.t used incorrect SQL type for big (64bit) integers
2016-11-15 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.039)
* Fix for security issue Out-of-bounds read by DBD::mysql CVE-2016-1249 (pali)
2016-10-30 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.038_01)
* Fix compilation of embedded server (pali)
(https://github.com/perl5-dbi/DBD-mysql/pull/68)
* Fix compilation against libmariadbclient. First version by
H.Merijn Brand, improved by Bernt Johnsen @ Oracle.
(https://rt.cpan.org/Ticket/Display.html?id=42723)
* Updated documentation, cruft cleanup (as always)
2008-10-24 Patrick Galbraith <patg at patg dot net> (4.010)
* Fix to dbd_bind_ph() for uninitialized value 'buffer_length'
thanks for bug report and patch from Askniel.com (thanks!)
2008-10-21 Patrick Galbraith <patg at patg dot net> (4.009)
* Fix to re-enable TAKE_IMP_DATA_VERSION. Still have to ensure DBI version 1.607 or higher
* Fix to escaped single quotes throwing off bind param detection. Patch from Zhurs (zhurs@yandex.ru) Spasibo!
2008-8-15 Patrick Galbraith <patg at patg dot net> (4.008)
* Multi statement patch, thanks to Chris Heath!
* Disabled TAKE_IMP_DATA_VERSION because segfault with DBI < 1.607
* #29528: bind_param(..., SQL_FLOAT) ignores exponents - fixed, Thanks to
Tokuhiro Matsuno!
* Cleanups to make mysqlEmb work under Cygwin - Thanks to Chris Rodgers
<http://rodgers.org.uk/> !
* Modified and disabled tests for MySQL version < 4.1 for unsupported features
2008-5-11 Patrick Galbraith <patg at patg dot net> (4.007)
* Took out mysql_server_init call where not needed
* Complete re-write of test suit to use Test::More - tons of cleanups!
* Makefile.PL changes to use current user in 'make test' if not defined
2007-12-26 Patrick Galbraith <patg at patg dot net> (4.006)
* Cleanups on OS X compile
* Fixes to syntax errors on AIX
* Removed test code that was leaving trace files around
2007-3-22 Patrick Galbraith <patg at patg dot net> (4.005)
* Fixed mysql_warning issue < 4.1 (reminers, patches, help from ROAM, (issue 25713)
* makerealclean patch from ROAM (issue #25714)
* sqlstate cleanup patch from ROAM
* Replaced all references to dbis to use imp_xxh per DBI best practices
* Fix to dbd_st_destroy - added back previously removed 'free everything' code which
had been moved to dbd_st_finish, causing a crash upon freeing of bind values
after all rows resulting from one execution of a query have been fetched. This meant
that next attempt to execute the prepared statement would segfault. This
work thanks to Rainer Weikusat!
* Removed all 'FindNewTable' calls in all tests. Just use 't1' for all tests to
simplify things. Plus, this is how MySQL internall tests.
* Better 'skip test' logic in some tests that were still running when they shouldn't
have been.
2007-3-22 Patrick Galbraith <patg at patg dot net> Jim Winstead <jimw@mysql.com> (4.004)
* Work around a bug in old 3.23 servers by specifying NOT NULL for fields used
as a primary key in tests. (Bug #20325, reported by Julian Ladisch)
* Add support for mysql_warning_count statement handle attribute. (Bug #25457,
patch from Philip Stoev)
* Add support for mysql_multi_statements connection option. (RT #12322, based
on patch from Doug Morris)
* Had to bump to 4.003 do to print statement in mysql.pm that made it
into the dist. Even though you can delete a file on CPAN, you cannot
re-upload it if it's the same name. Mea Culpa.
* UTF8-Flag not set with flag mysql_enable_utf8 and column collation utf8_bin patch,
Joost Diepenmaat, (RT #24738)
* Fixed do_error definition (Scott Hildreth, Tim Bunce)
* Conversion of test suite to Test::More
2007-3-5 Patrick Galbraith <patg at patg dot net> Jim Winstead <jimw@mysql.com> (4.003)
* Fix inclusion of non-primary keys in primary_key_info. (Bug #26786,
reported and patch by Dave Rolsky)
2007-3-1 Patrick Galbraith <patg at patg dot net> Jim Winstead <jimw@mysql.com> (4.002)
* Fix re-exec of Makefile.PL when forcing $ENV{LANG} to 'C'. (RT #25233,
reported by Slaven Rezic)
* Rewrote table_info method to support all arguments (previously it would
only ever return all of the tables in the current database, no matter what
was specified)
* Fixed $DBD::mysql::VERSION to be a string instead of a float, which caused
problems for certain locales
* Fixed bug #23974. $dbh->column_info now returns handle with no rows upon
table not existing. Much thanks to Tim Bunce for help fixing the problem
in mysql.pm vs. dbdimp.c
* Removed #ifdefs for do error (sqlstate being passed as last arg depending on
version)
* Fixed insertid test to work with auto_increment_increment replication setup.
* Patch from Tim Bunce fixing do() not set $dbh->{Statement} attribute,
which prevented DBD::Profile from giving correct results for calls to do()
and causing ShowErrorStatement to possibly report the wrong statement in the
error message
* Patch from Tim Bunce clearing out the sth attribute cache when switching
between result, sets which prevented the adjustedment of NUM_OF_FIELDS
* Cleanup of several unused variables
* Added support for wildcards in last argument of column_info().
* Add mysql_is_auto_increment to results of column_info(). (Bug #26603,
original patch from Dave Rolsky)
* Return the correct table type for both tables and views from the table_info()
method. (Bug #26603, original patch from Dave Rolsky)
* Add implementation of foreign_key_info() (Bug #26604, original patch from
Dave Rolsky, and final implementation based on Connector/J code)
2007-1-8 Jim Winstead <jimw@mysql.com> Patrick Galbraith <patg at patg dot net> (4.001)
* Fix handling of unsigned integer values in result sets when using
server-side prepared statements (they were not retrieved at all).
* Fix handling of signed integer values when using server-side prepared
statements (they were being forced to unsigned values).
* Do not tell Perl that the contents of binary fields are UTF-8.
[rt.cpan.org #22123], original patch by Joost Diepenmaat
* Fix double-free of bound parameters when freeing statements. (Bug #20559)
* Make sure to handle "magical" values in a couple of places. (Bug #20104)
* Update the hints about what to do when zlib is found missing while
linking. (Bug #13803, reported by Philip Stoev)
* Explicitly initialize the MySQL client library to avoid possible race
conditions in a multithreaded application. (Bug #21792)
* Fix warning when no connection attributes are passed to the connect
method (Bug #17323, reported by Phil Randal)
* Removed redundant warnings when commit or rollback is called while
AutoCommit is enabled. [rt.cpan.org #15802], reported by Tyler MacDonald
* Report correct type for decimal columns from MySQL 5.0 and later
[rt.cpan.org #18294], reported by Ray Zimmerman
* Fix t/40bindparam.t to work when ANSI_QUOTES SQL_MODE is set.
[rt.cpan.org #21521], reported by David Wheeler
* Return a statement handle with an error when column_info is called on
( run in 0.583 second using v1.01-cache-2.11-cpan-75ffa21a3d4 )