DBD-SQLite

Changes for version 1.26_05

CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
Resolved #49716: Fixed $dbh->column_info to work according to the spec in DBI and added support for attached databases. (VLYON)
Tweaked not to hide a real error by a "not an error" issued by another sqlite3 function between the failed sqlite3 function and the sqlite_error to report. Note that this change makes some failures issue two relevant errors at a time. (ISHIGAKI)
Updated to SQLite 3.6.18 (DUNCAND)
Resolved #48393: previous effort was not enough; BegunWork should also be handled properly (ISHIGAKI)
Replaced last DBILOGFP with DBIc_LOGPIO(imp_xxh) (ISHIGAKI)
Tweaked t/08_busy.t not to fail just because it is tested under a very, very slow (virtual) machine. (ISHIGAKI)
Added a code to look for a compiler from Module::Install::Can. (ISHIGAKI)
Added documentation and an 'Escape' attribute for $sth->table_info. (VLYON)
Fixed $sth->primary_key_info to work according to the spec in DBI and changed the tests in t/27_metadata.t to reflect this. (VLYON)

Updated to SQLite 3.6.17 (ISHIGAKI)
Switched to use :memory: for most of the tests (ISHIGAKI)
Fixed a memory leak when prepare should fail (ISHIGAKI)
Added support for commit/rollback/update hooks (DAMI)
Added support for set_authorizer (DAMI)
Added support for collation_needed(), and reorganised driver API for user-defined collations (DAMI)
Exported constants from sqlite3.h into DBD::SQLite namespace (DAMI)
Added support in t/lib/Test.pm for checking both versions of driver-private methods ("func" / "sqlite_*") (DAMI)
Removed unused and obsolete "list_tables" from SQLite.xs (DAMI)
Added a default implementation for the REGEXP infix operator (DAMI)
Renamed several internal sqlite3_ functions to sqlite_ for clarity (ISHIGAKI)
Accept empty filename at connect (sqlite will open a tempfile) (DAMI)
Documented the connect() method (DAMI)
Replaced imp_dbh->in_tran with sqlite3_get_autocommit(), hoping this would fix the annoying rollback issues, including #48393 (ISHIGAKI)
META.yml requires is now generated instead of being derived from the (incorrect) PREREQ_PM values by ExtUtils::MakeMaker (ADAMK)

CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
Resolved #46831: table_info schema is incorrect and doesn't work with attached databases (VLYON/ISHIGAKI)
Updated to SQLite 3.6.15 (DUNCAND)
Resolved #44882: Use of $h->func() should be deprecated and replaced with calls to driver-private 'installed methods' (ISHIGAKI)
Added access to Online Backup functionality. (TJC)
Added enable_load_extension pod (ISHIGAKI)
Now private methods/functions return true after successful calls (#44871) (ISHIGAKI)
Removed all of the "croak"s (#44871) (ISHIGAKI)

Added ORDINAL_POSITION support for $dbh->column_info (ADAMK)
Applied several fixes from GFUJI to clean up code (#45578) (ISHIGAKI)
Skipped some of the unicode path tests under cygwin (#45166) (JDHEDDEN)
Added some explanation and workarounds for a SQL that compares a return value of a function with a numeric bind value (ISHIGAKI)