/ 
DBD-SQLite-1.26_05
⭐ Starred 28
Security Advisories (20)
CVE-2020-13434 (2020-05-24)

SQLite through 3.32.0 has an integer overflow in sqlite3_str_vappendf in printf.c.

CVE-2020-11656 (2020-04-09)

In SQLite through 3.31.1, the ALTER TABLE implementation has a use-after-free, as demonstrated by an ORDER BY clause that belongs to a compound SELECT statement.

CVE-2020-9327 (2020-02-21)

In SQLite 3.31.1, isAuxiliaryVtabOperator allows attackers to trigger a NULL pointer dereference and segmentation fault because of generated column optimizations.

CVE-2018-20506 (2019-04-03)

SQLite before 3.25.3, when the FTS3 extension is enabled, encounters an integer overflow (and resultant buffer overflow) for FTS3 queries in a "merge" operation that occurs after crafted changes to FTS3 shadow tables, allowing remote attackers to execute arbitrary code by leveraging the ability to run arbitrary SQL statements (such as in certain WebSQL use cases). This is a different vulnerability than CVE-2018-20346.

CVE-2015-3416 (2015-04-24)

The sqlite3VXPrintf function in printf.c in SQLite before 3.8.9 does not properly handle precision and width values during floating-point conversions, which allows context-dependent attackers to cause a denial of service (integer overflow and stack-based buffer overflow) or possibly have unspecified other impact via large integers in a crafted printf function call in a SELECT statement.

CVE-2015-3414 (2015-04-24)

SQLite before 3.8.9 does not properly implement the dequoting of collation-sequence names, which allows context-dependent attackers to cause a denial of service (uninitialized memory access and application crash) or possibly have unspecified other impact via a crafted COLLATE clause, as demonstrated by COLLATE"""""""" at the end of a SELECT statement.

CVE-2020-13630 (2020-05-27)

ext/fts3/fts3.c in SQLite before 3.32.0 has a use-after-free in fts3EvalNextRow, related to the snippet feature.

CVE-2019-8457 (2019-05-30)

SQLite3 from 3.6.0 to and including 3.27.2 is vulnerable to heap out-of-bound read in the rtreenode() function when handling invalid rtree tables.

CVE-2020-15358 (2020-06-27)

In SQLite before 3.32.3, select.c mishandles query-flattener optimization, leading to a multiSelectOrderBy heap overflow because of misuse of transitive properties for constant propagation.

CVE-2020-13632 (2020-05-27)

ext/fts3/fts3_snippet.c in SQLite before 3.32.0 has a NULL pointer dereference via a crafted matchinfo() query.

CVE-2020-13631 (2020-05-27)

SQLite before 3.32.0 allows a virtual table to be renamed to the name of one of its shadow tables, related to alter.c and build.c.

CVE-2020-13435 (2020-05-24)

SQLite through 3.32.0 has a segmentation fault in sqlite3ExprCodeTarget in expr.c.

CVE-2020-11655 (2020-04-09)

SQLite through 3.31.1 allows attackers to cause a denial of service (segmentation fault) via a malformed window-function query because the AggInfo object's initialization is mishandled.

CVE-2019-19646 (2019-12-09)

pragma.c in SQLite through 3.30.1 mishandles NOT NULL in an integrity_check PRAGMA command in certain cases of generated columns.

CVE-2019-19645 (2019-12-09)

alter.c in SQLite through 3.30.1 allows attackers to trigger infinite recursion via certain types of self-referential views in conjunction with ALTER TABLE statements.

CVE-2018-20346 (2018-12-21)

SQLite before 3.25.3, when the FTS3 extension is enabled, encounters an integer overflow (and resultant buffer overflow) for FTS3 queries that occur after crafted changes to FTS3 shadow tables, allowing remote attackers to execute arbitrary code by leveraging the ability to run arbitrary SQL statements (such as in certain WebSQL use cases), aka Magellan.

CVE-2018-8740 (2018-03-17)

In SQLite through 3.22.0, databases whose schema is corrupted using a CREATE TABLE AS statement could cause a NULL pointer dereference, related to build.c and prepare.c.

CVE-2017-10989 (2017-07-07)

The getNodeSize function in ext/rtree/rtree.c in SQLite through 3.19.3, as used in GDAL and other products, mishandles undersized RTree blobs in a crafted database, leading to a heap-based buffer over-read or possibly unspecified other impact.

CVE-2015-3415 (2015-04-24)

The sqlite3VdbeExec function in vdbe.c in SQLite before 3.8.9 does not properly implement comparison operators, which allows context-dependent attackers to cause a denial of service (invalid free operation) or possibly have unspecified other impact via a crafted CHECK clause, as demonstrated by CHECK(0&O>O) in a CREATE TABLE statement.

CVE-2016-6153 (2016-09-26)

os_unix.c in SQLite before 3.13.0 improperly implements the temporary directory search algorithm, which might allow local users to obtain sensitive information, cause a denial of service (application crash), or have unspecified other impact by leveraging use of the current working directory for temporary files.

Changes for version 1.26_05

  • Updated to SQLite 3.6.19 (ISHIGAKI)

Changes for version 1.26_04

  • 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)

Changes for version 1.26_03

  • 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 for version 1.26_02

  • 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)

Changes for version 1.26_01

  • 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)

Documentation

DBD::SQLite::Cookbook
The DBD::SQLite Cookbook

Modules

DBD::SQLite
Self-contained RDBMS in a DBI Driver

Provides

DBD::SQLite::_WriteOnceHash
in lib/DBD/SQLite.pm
DBD::SQLite::db
in lib/DBD/SQLite.pm
DBD::SQLite::dr
in lib/DBD/SQLite.pm

Other files