Age | Commit message (Collapse) | Author | Files | Lines |
|
1.70 2021-08-01
- Switched to a production version
1.69_02 2021-07-30
- Fix doc to use the correct attribute with sqlite_ (GH#86, eekboek++)
- Modify the fix to silence the sqlite_unicode warning not to check
the attribute twice
- Fix an encoding issue of naive (GH#83, HaraldJoerg++)
1.69_01 2021-07-30
- Typo (GH#85, grr++)
- Silenced deprecation warning of sqlite_unicode not to break
tests of existing applications
1.68 2021-07-22
- Switched to a production version
1.67_07 2021-06-19
- Upgraded SQLite to 3.36.0
1.67_06 2021-06-14
- Experiment with another quadmath patch to see if it works
with an older version of FreeBSD
1.67_05 2021-06-13
- Made DBD_SQLITE_STRING_MODE constants exportable
1.67_04 2021-05-31
- Upgraded SQLite to 3.35.5
- Stop setting THREADSAFE=0 if perl has pthread (ie. 5.20+)
(Bjoern Hoehrmann++, GH#69, #72)
- Fixed a memory leak in ::VirtualTable
- Introduced "string_mode" handle attribute (Felipe Gasper++)
to fix long-standing issues of sqlite_unicode (GH#78, #68)
- Added a dependency from dbdimp.o to the *.inc files included
into dbdimp.c (Laurent Dami++, GH#74)
- Fixed an offset issue of VirtualTable (Laurent Dami++, GH#75)
1.67_03 2021-03-31
- Upgraded SQLite to 3.35.3
- Enabled math functions introduced in SQLite 3.35
- Fix quadmath issues (Tux++, leont++)
1.67_02 2020-12-06
- Upgraded SQLite to 3.34.0
- Added a few new constants
- Added sqlite_txn_state method to see internal state
of the backend
1.67_01 2020-11-24
- Switched to XSLoader (GH#63; toddr++)
- Use quadmath_snprintf if USE_QUADMATH is defined
- Use av_fetch instead of av_shift (norimy++)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1.66 2020-08-30
- Switched to a production version
1.65_03 2020-07-27
- Upgraded SQLite to 3.32.3
1.65_02 2020-02-08
- Upgraded SQLite to 3.31.1
1.65_01 2020-01-18
- Upgraded SQLite to 3.30.1
- Added several SQL_ types as alias (pali++)
- Fixed two initialization issues (ppisar++)
- Allowed create_function to return an array reference
to specify the type of the value
|
|
|
|
|
|
|
|
Upstream changes:
1.64 2019-08-12
- Switched to a production version
1.63_05 2019-07-12
- Upgraded SQLite to 3.29.0
- Added sqlite_get_autocommit private method (GH#52)
- Addded new db_config constants, notably to prohibit
double-quoted string literals
1.63_04 2019-05-25
- Upgraded SQLite to 3.28.0
- Modified doc for sqlite_db_filename which actually returns undef
or an empty string (GH#50)
- Fixed ->quote($blob, SQL_BLOB) to quote correctly (GH#51, pali++)
1.63_03 2019-02-15
- Applied a patch to fix segmentation fault on 32-bit big-endian
platforms by Niko Tyni (GH#45)
1.63_02 2019-02-14
- Upgraded SQLite to 3.27.1
- Let a URI filename test skip if SQLite is compiled with URI filename
support (GH#47)
1.63_01 2019-01-26
- Made sure an internal hv is initialized (GH#45)
- Fixed a number of tests to skip
- Bumped up Test::More requirement
- Replaced bundled Test::NoWarnings with Test::FailWarnings
- Handle 'unknown' op in DBD::SQLite::VirtualTable::PerlData (Corion++)
|
|
|
|
The former now redirects to the latter.
This covers the most simple cases where http://search.cpan.org/dist/name
can be changed to https://metacpan.org/release/name.
Reviewed by hand to hopefully make sure no unwanted changes sneak in.
|
|
|
|
Upstream changes:
1.62 2018-12-29
- Switched to a production version
1.61_04 2018-12-22
- Added sqlite_db_config method and new constants for it
- Added sqlite_defensive option to disallow dangerous SQLite features
- Exposed some of the hidden extended result codes
1.61_03 2018-12-19
- Upgraded SQLite to 3.26.0, which reportedly has a security fix
1.61_02 2018-12-01
- Added sqlite_backup_from_dbh/sqlite_backup_to_dbh methods
- Introduced sqlite_prefer_numeric_type database handle attribute
that changes the value of TYPE statement handle attribute
from an array of string to an array of integer, as an experimental
feature. Setting this may break your applications.
- Changed preferred bugtracker
1.61_01 2018-12-01
- Added ability to configure SQLITE_MAX_LENGT with environmental
variable (Roy Storey)
- Added sqlite_limit database handle method to change run-time limits
- Upgraded SQLite to 3.25.3
- Updated constants
|
|
|
|
Upstream changes:
1.60 2018-12-01
- Switched to a production version
1.59_03 2018-11-03
- Added a note on the long standing bug on TYPE statement
handle attribute
- Applied a doc patch on Virtual::PerlData by Björn Höhrmann
(GH-31)
1.59_02 2018-09-30
- Upgraded SQLite to 3.25.2
1.59_01 2018-09-17
- Upgraded SQLite to 3.25.0, with ALTER TABLE ... RENAME COLUMN
and UPSERT among others
- Added ::GetInfo (GH#32, Brendan Byrd)
- Fix to use a PV value as a virtual table column value
where appropriate (RT-124941)
- Add deferrability to foreign_key_info (mohawk2)
|
|
|
|
|
|
|
|
Upstream changes:
1.58 2018-03-28
- Switched to a production version.
1.57_01 2018-03-21
- Made it an error to fetch attributes from a statement
handle whose database handle is inactive (ribasushi++)
|
|
1.56 2018-02-28
- Switched to a production version.
1.55_07 2018-01-27
- This is a developer release to help testing DBIx::Class
- Upgraded SQLite to 3.22.0
- Disabled two STAT compile time options (tentatively),
which fixes RT-124227 anyway
1.55_06 2018-01-27
- This is a developer release to help testing DBIx::Class
- Downgraded SQLite to 3.19.3 because of a SQLite regression
(RT-124227, ribasushi++)
- Fixed some tests to adapt to a change in error format
introduced by the latest DBI
- Remove no warnings test from t/43_fts.t which failed under
some environments
1.55_05 2017-12-16
- Implemented ParamValues statement handle attribute (RT-123886)
1.55_04 2017-11-22
- Updated SQLite to 3.21.0
- Resolved #122581: statistics_info() doesn't work correctly
(John Deighan)
- Fixed typo (GH#26, ReneNyffenegger)
- Silenced some warnings (GH#25, Jacques Germishuys)
- Fixed no dot in @INC issue (GH#24, ribasushi)
- Fixed zero-length BLOB value is retrieved as undef
(GH#23, SATO Kentaro)
- Fixed VirtualTable::PerlData to use new ops added in SQLite 3.21.0
(GH#28, fschlich)
- noted on sqlite_extended_result_codes handle attribute
1.55_03 2017-02-14
- Updated SQLite to 3.17.0
1.55_02 2017-01-08
- Updated SQLite to 3.16.2
- Fixed statistics_info when only unique indexes were requested (Dave
Rolsky++). GitHub #21
1.55_01 2017-01-04
- Updated SQLite to 3.16.0
|
|
|
|
|
|
|
|
|
|
1.54 2016-12-24
- Switched to a production version.
- Resolved RT#119219: Trivial documentation bug in DBL::SQLite 1.52
1.53_01 2016-11-26
- Re-enabled perl tokenizer by calling sqlite_db_config
if SQLite >= 3.12
|
|
|
|
1.52 2016-11-15
- Switched to a production version.
1.51_07 2016-10-16
- Downgraded SQLite to 3.13.0 (RT#118395)
1.51_06 2016-10-15
- Updated SQLite to 3.15.0
1.51_05 2016-06-23
- Updated SQLite to 3.13.0
- Resolved #115465: column_info doesn't parse sizes with spaces
(ilmari++)
- Added two missing function declarations (rurban++)
1.51_04 2016-03-07
- Updated SQLite to 3.11.1, which fixed an FTS5 index
corruption issue
1.51_03 2016-02-20
- No code change
- Resolved #112220: t/62_regexp_multibyte_char_class.t fails
for perl >= 5.22.0 and non-utf8 locale (SREZIC++)
1.51_02 2016-02-20
- No code change; fixed a newly added test that only passed
under recent perls (>= 5.18)
1.51_01 2016-02-20
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Updated to SQLite 3.11.0.
As upstream disabled two-arg fts3_tokenizer() for security concern,
DBD::SQLite also stopped enabling it by default. If you do need
perl tokenizer, compile/install with SQLITE_ENABLE_FTS3_TOKENIZER
environmental variable.
- Applied a doc patch by Salvatore Bonaccorso
- Enabled (experimental) FTS5
- Fixed REGEXP function to work under sqlite_unicode correctly
(András Farkas++)
|
|
|
|
|
|
-------------------
1.50 2016-02-11
- Switched to a production version.
1.49_08 2016-01-30
- no significant code changes
- Resolved RT#111558: Virtual table tests depend on enhanced
query syntax availability (vlmarek++)
- Ingore FTS tests if FTS is not available
1.49_07 2016-01-21
- Updated to SQLite 3.10.2, which fixed a case-folding bug
in the LIKE operator introduced in SQLite 3.10.0.
1.49_06 2016-01-15
- Updated to SQLite 3.10.1, which fixed an old bug that could
generate incorrect results when a scalar subquery attempts
to use the block sorting optimization.
1.49_05 2016-01-11
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Updated to SQLite 3.10.0.
Because of the addition of LIKE/GLOB/REGEXP support on
virtual tables, previous ::PerlData virtual table got broken.
This is hopefully fixed by adding strlike/strglob functions
to DBD::SQLite but if you use this virtual table, please
test it carefully.
- Now you can make a database connection read-only if you
turn on the ReadOnly attribute when you connect. (RT #110439)
If you set it after you connect to a database, DBD::SQLite
warns because the database doesn't actually become read-only.
- Improved ::Constants
- to load DBD::SQLite by itself
- to expose SQLITE_VERSION_NUMBER
- introduced a few new (shorter) tags
1.49_04 2015-11-24
- Updated ::Constants
- Fixed a sqlite version number in a test (GH-14; NANIS++)
1.49_03 2015-11-05
- Updated to SQLite 3.9.2, with JSON support
1.49_02 2015-10-10
- Added a workaround to resolve #106950 Extra warnings
with savepoints (hopefully)
- Not to run tests for table_column_metadata unless
ENABLE_COLUMN_METADATA is set
1.49_01 2015-08-04
- Updated to SQLite 3.8.11.1
- Resolved #106151 SAVEPOINT bug
- Made sure to keep what's left in unprepared_statements when
allow_multiple_statements is set. (GH #11)
|
|
|
|
1.48 2015-06-12
- Switched to a production version. (ISHIGAKI)
1.47_05 2015-05-08
- Updated to SQLite 3.8.10
1.47_04 2015-05-02
- Used MY_CXT instead of a global variable
1.47_03 2015-04-16
- Added :all to EXPORT_TAGS in ::Constants
1.47_02 2015-04-16
- Updated to SQLite 3.8.9
- Added DBD::SQLite::Constants, from which you can import any
"useful" constants into your applications.
- Removed previous Cygwin hack as SQLite 3.8.9 compiles well again
- Now create_function/aggregate accepts an extra bit
(SQLITE_DETERMINISTIC) for better performance.
1.47_01 2015-02-17
*** (EXPERIMENTAL) CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Commented OPTIMIZE out of WriteMakefile (RT #94207).
If your perl is not compiled with -O2, your DBD::SQLite may
possibly behave differently under some circumstances.
(This release is to find notable examples from CPAN Testers).
- Set THREADSAFE to 0 under Cygwin to cope with an upstream
regression since 3.8.7 (GH #7).
- Updated to SQLite 3.8.8.2
- Resolved #35449: Fast DBH->do (ptushnik, ISHIGAKI)
|
|
having a PKGNAME of p5-*, or depending such a package,
for perl-5.22.0.
|
|
|
|
1.46 2014-12-10
- Switched to a production version. (ISHIGAKI)
1.45_06 2014-11-26
- Silenced a compile-time warning (Unescaped left brace
in regex is deprecated) in PerlData virtual table
under bleadperl
1.45_05 2014-11-25
- 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)
|
|
|
|
|
|
|
|
- Switched to a production version. (ISHIGAKI)
- Updated to SQLite 3.8.4.1, which fixed several obscure bugs on
"ORDER BY" or "DISTINCT". (ISHIGAKI)
- 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)
- Resolved #92322: Failure under heavily parallelized tests
(ISHIGAKI)
- Disabled Test::NoWarnings in a test
- 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)
- Updated to SQLite 3.8.0.2 (ISHIGAKI)
- Updated to SQLite 3.8.0.1 to resolve #88228 (RIBASUSHI++)
(ISHIGAKI)
*** 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
unwritable by older versions of (DBD::)SQLite. They'll be
readable/writable again by dropping partial indices.
- Resolved #87435: PATCH: statistics_info perldoc (DDICK)
- Resolved #87297: URI filenames in DBD::SQLite (ISHIGAKI)
|
|
Do it for all packages that
* mention perl, or
* have a directory name starting with p5-*, or
* depend on a package starting with p5-
like last time, for 5.18, where this didn't lead to complaints.
Let me know if you have any this time.
|
|
|
|
|
|
1.40 Sun 28 Jul 2013
- NetBSD also doesn't like the _XOPEN_SOURCE hack (ISHIGAKI)
- Resolved #86080: PATCH: statistics_info support (DDICK)
|
|
|
|
copy isn't as portable as what's in databases/sqlite3. Instead of
trying to fix the copy, declare a buildlink dependency on 3.7.17,
and let pkgsrc figure out how to fulfill it. Bump PKGREVISION.
|
|
- OpenBSD doesn't like the previous _XOPEN_SOURCE hack (ISHIGAKI)
- Disabled a unicode-related test for older perls (ISHIGAKI)
- Tentatively defined _XOPEN_SOURCE under *BSD systems to see
if it solves a compilation issue for threaded perls (ISHIGAKI)
- As of SQLite 3.7.15, SQLite's query optimizer was enhanced
and the result order of a SELECT statement without an ORDER
BY clause may be different from the one of the previous
versions. If your applications or tests mistakenly depend
on the arbitrary output order, they may be broken with this
enhancement.
- Updated to SQLite 3.7.17 (ISHIGAKI)
- Fixed tests that mistakenly made invalid assumptions about
the result order (ISHIGAKI)
- Added a brief note on useful pragmata. (ISHIGAKI)
- Resolved #85302: type fixes (ISHIGAKI)
- Updated to SQLite 3.7.16.1 (ISHIGAKI)
- Removed two obsolete pragma calls at login time (ISHIGAKI)
- Resolved #80344: Set SQLITE_DISABLE_DIRSYNC on AIX (suggested
by Steve Barnsley) (ISHIGAKI)
- Resolved #81536: primary_key_info returns the wrong KEY_SEQ
(VLYON)
- Resolved #84027: Finalizer() not called in (D. Richard Hipp)
- Resolved #84372: -Wpointer-sign warnings with utf8_hop
(RURBAN)
- Resolved #84373: Add test for RT #26775 "name)" key with
DISTINCT (RURBAN/ISHIGAKI)
- Resolved #70815: DBD::SQLite 1.33 build is broken under
Solaris using Sun C (RURBAN)
- Resolved #84380: Fix WINLIKE for mingw/msys (RURBAN)
- Added a note on DBD::SQLite and File::Temp (suggested by
TOKUHIROM) (ISHIGAKI)
- Resolved #56444: immediate transaction should be on by
default, and the doc be updated.
If you really need the deferred transaction (which had long
been the default), set sqlite_use_immediate_transaction
to false explicitly. (ISHIGAKI)
- Updated to SQLite 3.7.14 (ISHIGAKI)
- Added support for foreign_key_info (DAMI/ISHIGAKI)
- Added several methods to retrieve internal information such as
table_column_metadata/db_filename/*_status (ISHIGAKI/VOVKASM)
- Added sqlite_load_extension so that extensions can add
functions internally (ISHIGAKI)
- Resolved #77617: atoll () sometimes just is atol () (GAAS)
- Resolved #48084: improper "require utf8" in tests (ISHIGAKI)
- Resolved #77724: bug in primary_key_info with regard to column
names containing whitespace (ISHIGAKI)
- Resolved #79364: variance example of the doc (ISHIGAKI)
- Resolved #78833: utf8 flag for column names (JAMADAM)
(This hopefully resolved #72418 as well)
- Resolved #64177: ping() wipes out the errstr (ISHIGAKI)
- Resolved #79576: (patch) bind_param don't work with PADTMP
scalars (VOVKASM)
- Refactored primary_key_info to support attached databases
(ISHIGAKI)
|