DBD-SQLite
view release on metacpan or search on metacpan
- Updated to SQLite 3.8.7.2
- Restored regexp support in PerlData virtual table
by secure reimplementation using closure (DAMI++)
1.45_04 2014-10-28
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Changed to apply quotemeta() to parameters while building
a query for a virtual table using PerlData for security.
(RIBASUSHI++ and MAUKE++) (DAMI, ISHIGAKI)
1.45_03 2014-10-25
- Fixed regression of 0 as integer (ISHIGAKI)
1.45_02 2014-10-23
- Improved int overflow handling under 32bit strawberry perl
(ISHIGAKI)
1.45_01 2014-10-22
- Updated to SQLite 3.8.7 (ISHIGAKI)
- Resolved #76395 (hopefully): int values over 32 bit in length
produce an error "datatype mismatch" (ISHIGAKI)
1.44 2014-10-22
- Switched to a production version. (ISHIGAKI)
1.43_09 2014-10-20
- Resolved #99583: Legacy DOS 8.3 filename support incompatible
with SQLITE WAL journal mode (spotted by Pat Horton) (ISHIGAKI)
- 1.43_07/08 were not VC6 compatible (ISHIGAKI)
1.43_08 2014-08-21
- Updated to SQLite 3.8.6, which should fix a unique index
issue: see http://www.sqlite.org/src/info/9a6daf340df99ba93c
for details (ISHIGAKI)
1.43_07 2014-07-30
- Resolved #97598: Crash on disconnect with virtual tables (FTS4)
(patch and test code by Rob++) (ISHIGAKI)
1.43_06 2014-07-22
- Fixed compile error/warning for older perls (reported by ribasushi)
(ISHIGAKI)
1.43_05 2014-07-21
- No significant code changes; removed unnecessary dependencies.
1.43_04 2014-07-21
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Resolved #96877: sql statements should be converted to utf8 (DAMI)
If you set sqlite_unicode to true, SQL statements will be upgraded
to avoid inconsistency between embedded params and bind params.
- Resolved #96494: [PATCH] add SYSTEM TABLE to table_info() type
list (MJP)
- Supported virtual tables in Perl, and added two sample tables
(DAMI++)
1.43_03 2014-06-12
- Updated to SQLite 3.8.5, which should fix query planner's
issues in SQLite (ISHIGAKI)
- Fixed busy_timeout to accept 0 to disable (reported by zdm)
(ISHIGAKI)
- Resolved #95511: primary_key_info fails to return names for
named primary keys (Kenneth Kroenlein)
- Resolved #96050: Segfault in disconnected sqlite_db_filename
(reported by Alex Vandiver) (ISHIGAKI)
1.43_02 2014-03-26
- Limited -std=gnu99 to solaris gcc only, though it may be
harmless in many cases (mattp++) (ISHIGAKI)
1.43_01 2014-03-26
- Added -std=gnu99 for solaris gcc users (reported by mattp++)
(ISHIGAKI)
1.42 2014-03-20
- Switched to a production version. (ISHIGAKI)
1.41_07 2014-03-13
- Updated to SQLite 3.8.4.1, which fixed several obscure bugs on
"ORDER BY" or "DISTINCT". (ISHIGAKI)
1.41_06 2014-02-12
- Updated to SQLite 3.8.3.1, which fixed a SQLite bug in 3.8.2
(bundled in DBD::SQLite 1.41_04/5) that could cause queries to
omit valid out rows. (ISHIGAKI)
1.41_05 2014-01-22
- Resolved #92322: Failure under heavily parallelized tests
(ISHIGAKI)
- Disabled Test::NoWarnings in a test
1.41_04 2014-01-12
- Updated to SQLite 3.8.2 (ISHIGAKI)
- Resolved #90211: Error in documentation (Felix Li)
- Resolved #89351: DBD-SQLite won't compile on Cygwin 64 bit
(Warren Young++) (ISHIGAKI)
- Tweaked sqlite_see_if_its_a_number not to guess data types of
bind values with explicit type specification (via bind_param()
etc) (mje++, ilmari++) (ISHIGAKI)
1.41_03 2013-09-05
- Updated to SQLite 3.8.0.2 (ISHIGAKI)
1.41_02 2013-08-30
- Updated to SQLite 3.8.0.1 to resolve #88228 (RIBASUSHI++)
(ISHIGAKI)
1.41_01 2013-08-27
*** NOTICE ON NEXT GENERATION QUERY PLANNER ***
- As of SQLite 3.8.0, SQLite's query planner has been rewritten.
According to the author, the new query planner should give
exactly the same result (though perhaps with a little less CPU
time spent planning) for simple queries, and for complex
queries, it can in many cases provide a much faster answer.
See http://www.sqlite.org/queryplanner-ng.html for details.
*** NOTICE ON PARTIAL INDICES ***
- Database files created by SQLite 3.8.0 are still readable and
writable by prior versions, but if you use partial indices
introduced in SQLite 3.8.0, those files become unreadable and
- Resolved #52573: Manual Transaction handling seems to be
broken (hopefully) (ISHIGAKI)
1.27 2009-11-23
- Switching to a production version
1.26_07 2009-11-15
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Foreign keys support is once again disabled by default.
It seems to have a greater impact than we expected and
it actually broke things. This feature probably will be
enabled by default by the sqlite team in the future, and
eventually you'll need to cope with it, but right now we
agreed with some discussion to give you more time to be
prepared. If you use referential stuff in your schema
(which sqlite ignores now) should do extensive testing
to ensure that they will work when you issue "PRAGMA
foreign_keys = ON". (ISHIGAKI)
- Updated to SQLite 3.6.20 (DUNCAND)
- Resolved #50935: there remained old "unicode" attribute usage
in the pod, spotted by ASHLEY. (ISHIGAKI)
1.26_06 2009-10-28
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Removed undocumented (and most probably unused) reset method
from a statement handle (which was only accessible via func().)
Simply use "$sth->finish" instead. (ISHIGAKI)
- Now DBD::SQLite supports foreign key constraints by default.
Long-ignored foreign keys (typically written for other DB
engines) will start working. If you don't want this feature,
issue a pragma to disable foreign keys. (ISHIGAKI)
- Renamed "unicode" attribute to "sqlite_unicode" for integrity.
Old "unicode" attribute is still accessible but will be
deprecated in the near future. (ISHIGAKI)
- You can see file/line info while tracing even if you compile
with a non-gcc compiler. (ISHIGAKI)
- Major code refactoring. (ISHIGAKI)
- Pod reorganized, and some of the missing bits (including
pragma) are added. (ISHIGAKI)
1.26_05 2009-10-15
- Updated to SQLite 3.6.19 (ISHIGAKI)
1.26_04 2009-10-06
*** 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)
- 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)
- 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)
1.26_03 2009-08-12
- 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)
1.26_02 2009-06-19
*** 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)
1.26_01 2009-05-05
- 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)
1.25 2009-04-23
- Amalgamation conversion turned out to be quicker than expected.
- Changing to a production release. (ADAMK)
1.24_02 2009-04-22
- Merging various externally-contributed annotations from
- Added SQL_NULLABLE_UNKNOWN; still wonders if the error above
should be ignored or not (ISHIGAKI)
1.22_01 2009-04-09
- Resolved #25371: Calls sv_utf8_upgrade on strings going into
the database to make sure latin-1 strings are not saved as
Malformed UTF-8 character in the SQLite TEXT column (MIYAGAWA)
1.21 2009-04-09
- Fixed the issue that execute on inactive handles returned
0 instead of undef, which made a DBIC test broken (ISHIGAKI)
1.20 2009-04-07
- Moving to the first production release of the new era.
- Check DBI version in Makefile.PL (CHORNY)
- Bundling Test::NoWarings into /inc to remove a dependency (ADAMK)
- Correcting use 5.00503 to 5.006 in SQLite.pm (ADAMK)
1.19_10 2009-04-06
- A few more tests moved to Test::More (ADAMK)
- We need DBIXS_REVISION, which appeared in DBI 1.57.
Bumping up our dependency to match it and confirmed myself
that DBD::SQLite actually builds against 1.57 (ADAMK)
- Resolved #40594: $sth->{NULLABLE} implementation (ISHIGAKI)
- Resolved #29629: sqlite where length issue (actually this has
been fixed before) (ISHIGAKI)
- Applied an enable_load_extension patch from RT #32998 (ISHIGAKI)
- Resolved #42940: DBD-SQLite make test faild (ADAMK)
- Resolved #26460: Sorting numeric values in aggregate functions (ADAMK)
- Resolved #32889: prepare_cached does not work correctly (ADAMK)
- Resolved #34828: Please add support for user-defined collations (ADAMK)
- Made Test::NoWarnings an optional module (CORION)
1.19_09 2009-04-05
- Require perl 5.6 because dependencies require it
- Updated ppport.h to the most recent release 3.17 (ADAMK)
- Adding $DBI::VERSION diag to help diagnose FAIL reports (ADAMK)
- #29519 was only resolved on Win32. Applied a more comprehensive
patch (JHEDDEN)
- Rewrote 28_schemachange.t in Test::More style (ADAMK)
- Bug fix in 28_schemachange.t rewrite re fork/connect (DUNCAND)
- Resolved #44779: [t/03insert.t] last_insert_id returns undef where 4
is expected (DUNCAND, CHORNY; that is, DUNCAND debugged and solved
the ticket based on _08, which was a flaw in the Makefile.PL
involving an always-applied -Dno_last_insert_id, but it turns out
CHORNY had inadvertantly applied the fix in the name of DBI cleaning)
- Starting to use Test::NoWarnings in the test scripts (ADAMK)
- Added link to MailingList resource (ADAMK)
- Squelch warnings inless PrintWarn is set in line with guidance from
the DBI documentation (ADAMK)
- Resolved #29058: don't quote a bind param (as a text) if it
looks like a number (ISHIGAKI)
- Resolved #27553: prepare_cached and analyze issue (actually
this has been fixed before) (ISHIGAKI)
1.19_08 2009-04-04
- Bumped minimum DBI dependency to 1.43 so last_insert_id is supported
in DBI (ADAMK)
- Resolved #30558: INSERT After PK Failure Also Fails Using
Prepared (ADAMK)
- Resolved #42567: Core dump in t/07busy.t after test 4 (mutex and/or
memory corruption) (ADAMK)
- Resolved #32100: t/06error.t fails using SQLite 3.5.4 (ADAMK)
- Resolved #35904: Test failure: Bus error t/08create_function
test (ADAMK)
- Resolved #9792: Crashes upon re-executing a statement (ADAMK)
- Resolved #21472: Spurious "not an error" and "bind or column index
out of range" errors (MSERGEANT)
- Resolved #32723: last_insert_rowid should handle sqlite_int64,
not int (ADAMK)
- Resolved #37215: memory leaks in sqlite_db_disconnect (ADAMK)
- Resolved #33441: unlimited memory accumulation (ADAMK)
- Resolved #31324: Incorrect Implementation of column names within
sqlite_st_FETCH_attrib (ADAMK)
- Resolved #32570: segmentation fault during tests 07 & 08 (ADAMK)
- Resolved #41631: Dot doesn't work in quoted column aliases (ADAMK)
- Resolved #403: test failure on "Testing select speed (large table) (ADAMK)
- Resolved #35769: dbimp.c uses uninitialized variables. (ADAMK)
- Resolved #27701 and #27702: (unnamed) (ADAMK)
- Resolved #31239: prepare_cached...statement handle
DBIx::ContextualFetch::st=HASH still Active (ADAMK)
- Resolved #41047: Re: Bug#506157: libdbd-sqlite3-perl: unsufficient
error message while opening database for writing (ADAMK)
- Resolved #25196 (bug in prepare?) (ADAMK)\
- Resolved #36651: Bug involving "closing dbh with active
statement handles" (ADAMK)
- Resolved #34408: Primary key name wrong with newline in
CREATE TABLE (ADAMK)
- Resolved #34600: t/06_error.t stalling (ADAMK)
- Resolved #22688: DBD::SQLITE Error Report (ADAMK)
1.19_07 2009-04-04
- Starting to work the RT queue now the basics are settled.
Many of the items marked as resolved by my just indicate that I have
confirmed someone else applied the fix. (ADAMK)
- Re-enable and fix t/70schemachange.t, as per RT #43448 (CORION)
- Added a canary test to probe for RT #36863
(segfault on OSX 10.5.2) (CORION)
- Added resources links to META.yml (ADAMK)
- Resolved #30502: t\70schemachange.t fails on Windows (ADAMK)
- Resolved #30167: Specify configuration depenencies with
"configure_requires" (ADAMK)
- Resolved #17623: make test fails when DBI_DSN is not
DBD::SQLite (ADAMK)
- Resolved #13631: wish: column_info support() (CORION)
- Resolved #39938: Read-access to development repository (ADAMK)
- Resolved #18617: Build error under win32 (ADAMK)
- Resolved #35838: support for DBI::column_info call (CORION)
- Resolved #29497: POD content bug (ADAMK)
- Resolved #29520: 1.14 fails in test 6 (ADAMK)
- Resolved #44647: Makefile.PL syntax error (ADAMK)
- Resolved #29519: t/70schemachange.t failure (ADAMK)
- Resolved #20286: DBD::SQLite leaks file descriptors (ADAMK)
- Resolved #21406: DBD-SQLite 1.13 broke Class-DBI (ADAMK)
- Resolved #4591: Test suite (t/t50*.t) is order dependent / bug in
t/lib.pl? (ADAMK)
- Resolved #36467: Name "DBD::SQLite::sqlite_version" used
only once (ADAMK)
- Resolved #7753: DBD::SQLite error shouldn't include extraneous
info (ADAMK)
( run in 1.143 second using v1.01-cache-2.11-cpan-cdf2f3d4e48 )