summaryrefslogtreecommitdiff
path: root/databases/p5-DBD-SQLite
AgeCommit message (Collapse)AuthorFilesLines
2021-12-08revbump for icu and libffiadam1-2/+2
2021-10-26databases: Replace RMD160 checksums with BLAKE2s checksumsnia1-2/+2
All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz
2021-10-07databases: Remove SHA1 distfile hashesnia1-2/+1
2021-05-24*: recursive bump for perl 5.34wiz1-2/+2
2021-04-21revbump for textproc/icuadam1-2/+2
2020-11-05*: Recursive revbump from textproc/icu-68.1ryoon1-1/+2
2020-09-06p5-DBD-SQLite: update to 1.66.wiz2-12/+8
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
2020-08-31*: bump PKGREVISION for perl-5.32.wiz1-2/+2
2020-06-02Revbump for icuadam1-2/+2
2020-04-12Recursive revision bump after textproc/icu updateadam1-1/+2
2019-09-12Update to 1.64wen2-8/+7
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++)
2019-08-11Bump PKGREVISIONs for perl 5.30.0wiz1-2/+2
2019-06-30Update packages using a search.cpan.org HOMEPAGE to metacpan.org.nia1-2/+2
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.
2019-04-03Recursive revbump from textproc/icuryoon1-1/+2
2019-01-27Update to 1.62wen2-8/+7
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
2018-12-09revbump after updating textproc/icuadam1-1/+2
2018-12-04Update to 1.60wen2-8/+7
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)
2018-08-22Recursive bump for perl5-5.28.0wiz1-2/+2
2018-07-20Recursive revbump from textproc/icu-62.1ryoon1-2/+2
2018-04-14revbump after icu updateadam1-1/+2
2018-04-10Update to 1.58wen2-7/+7
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++)
2018-03-04p5-DBD-SQLite: update to 1.56.wiz2-8/+7
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
2017-11-30Revbump after textproc/icu updateadam1-2/+2
2017-09-18revbump for requiring ICU 59.xmaya1-2/+2
2017-06-05Recursive revbump from lang/perl5 5.26.0ryoon1-2/+2
2017-04-22Revbump after icu updateadam1-1/+2
2017-01-01Updated p5-DBD-SQLite to 1.54.wiz2-8/+7
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
2016-12-04Recursive revbump from textproc/icu 58.1ryoon1-1/+2
2016-11-16Updated p5-DBD-SQLite to 1.52.wiz2-8/+7
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++)
2016-06-08Bump PKGREVISION for perl-5.24.wiz1-2/+2
2016-04-11Recursive revbump from textproc/icu 57.1ryoon1-1/+2
2016-02-11Update 1.48 to 1.50mef2-8/+7
------------------- 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)
2015-11-03Add SHA512 digests for distfiles for databases categoryagc1-1/+2
Problems found with existing distfiles: distfiles/D6.data.ros.gz distfiles/cstore0.2.tar.gz distfiles/data4.tar.gz distfiles/sphinx-2.2.7-release.tar.gz No changes made to the cstore or mariadb55-client distinfo files. Otherwise, existing SHA1 digests verified and found to be the same on the machine holding the existing distfiles (morden). All existing SHA1 digests retained for now as an audit trail.
2015-10-10Recursive revbump from textproc/icuryoon1-1/+2
2015-06-14Update to 1.48:wiz2-7/+6
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)
2015-06-12Recursive PKGREVISION bump for all packages mentioning 'perl',wiz1-2/+2
having a PKGNAME of p5-*, or depending such a package, for perl-5.22.0.
2015-04-06Revbump after updating textproc/icuadam1-1/+2
2014-12-10Update to 1.46:wiz2-6/+6
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)
2014-10-26Update to 1.44:wiz2-7/+6
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)
2014-10-09Remove pkgviews: don't set PKG_INSTALLATION_TYPES in Makefiles.wiz1-3/+1
2014-10-09Remove SVR4_PKGNAME, per discussion on tech-pkg.wiz1-2/+1
2014-10-07Revbump after updating libwebp and icuadam1-1/+2
2014-06-09Update to 1.42. From the changelog:schmonz2-8/+7
- 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)
2014-05-29Bump for perl-5.20.0.wiz1-2/+2
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.
2014-04-09recursive bump from icu shlib major bump.obache1-1/+2
2014-02-01s/LOCALBASE/BUILDLINK_PREFIX.sqlite3/ to handle builtin sqlite.markd1-2/+2
2014-01-28Update to 1.40:wiz2-7/+6
1.40 Sun 28 Jul 2013 - NetBSD also doesn't like the _XOPEN_SOURCE hack (ISHIGAKI) - Resolved #86080: PATCH: statistics_info support (DDICK)
2013-10-19Revbump after updating textproc/icuadam1-2/+2
2013-07-13This package bundles its own copy of SQLite 3.7.17. The bundledschmonz3-4/+23
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.
2013-07-10Update to 1.39. From the changelog:schmonz2-7/+6
- 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)