Vulnerability Name:

CVE-2019-19242 (CCN-172151)

Assigned:2019-11-21
Published:2019-11-21
Updated:2022-04-19
Summary:SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.
CVSS v3 Severity:5.9 Medium (CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H)
5.2 Medium (Temporal CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H/E:U/RL:O/RC:C)
Exploitability Metrics:Attack Vector (AV): Network
Attack Complexity (AC): High
Privileges Required (PR): None
User Interaction (UI): None
Scope:Scope (S): Unchanged
Impact Metrics:Confidentiality (C): None
Integrity (I): None
Availibility (A): High
7.3 High (CCN CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:L/A:L)
6.4 Medium (CCN Temporal CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:L/A:L/E:U/RL:O/RC:C)
Exploitability Metrics:Attack Vector (AV): Network
Attack Complexity (AC): Low
Privileges Required (PR): None
User Interaction (UI): None
Scope:Scope (S): Unchanged
Impact Metrics:Confidentiality (C): Low
Integrity (I): Low
Availibility (A): Low
CVSS v2 Severity:4.3 Medium (CVSS v2 Vector: AV:N/AC:M/Au:N/C:N/I:N/A:P)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Medium
Authentication (Au): None
Impact Metrics:Confidentiality (C): None
Integrity (I): None
Availibility (A): Partial
7.5 High (CCN CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:P/A:P)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Low
Athentication (Au): None
Impact Metrics:Confidentiality (C): Partial
Integrity (I): Partial
Availibility (A): Partial
Vulnerability Type:CWE-476
Vulnerability Consequences:Other
References:Source: MITRE
Type: CNA
CVE-2019-19242

Source: CONFIRM
Type: Patch, Third Party Advisory
https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf

Source: XF
Type: UNKNOWN
sqlite-cve201919242-unspecified(172151)

Source: CCN
Type: SQLite GIT Repository
Fix a problem that comes up when using generated columns that evaluation

Source: MISC
Type: Patch, Third Party Advisory
https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c

Source: UBUNTU
Type: Third Party Advisory
USN-4205-1

Source: CCN
Type: IBM Security Bulletin 1143496 (Watson Studio Local)
Multiple Vulnerabilities in SQLite affects IBM Watson Studio Local

Source: CCN
Type: IBM Security Bulletin 3523059 (PowerAI)
A security vulnerability has been identified in SQLite shipped with PowerAI.

Source: CCN
Type: IBM Security Bulletin 6198350 (InfoSphere Guardium Activity Monitor)
IBM Security Guardium is affected by an SQLite vulnerability

Source: CCN
Type: IBM Security Bulletin 6335281 (Data Risk Manager)
IBM Data Risk Manager is affected by multiple vulnerabilities

Source: N/A
Type: Patch, Third Party Advisory
N/A

Source: CCN
Type: WhiteSource Vulnerability Database
CVE-2019-19242

Vulnerable Configuration:Configuration 1:
  • cpe:/a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*

    • Configuration 2:
  • cpe:/o:canonical:ubuntu_linux:12.04:*:*:*:esm:*:*:*
  • OR cpe:/o:canonical:ubuntu_linux:16.04:*:*:*:lts:*:*:*
  • OR cpe:/o:canonical:ubuntu_linux:18.04:*:*:*:lts:*:*:*
  • OR cpe:/o:canonical:ubuntu_linux:19.04:*:*:*:*:*:*:*
  • OR cpe:/o:canonical:ubuntu_linux:19.10:*:*:*:*:*:*:*

    • Configuration 3:
  • cpe:/o:redhat:enterprise_linux:8.0:*:*:*:*:*:*:*

    • Configuration 4:
  • cpe:/a:oracle:mysql_workbench:*:*:*:*:*:*:*:* (Version <= 8.0.19)

    • Configuration 5:
  • cpe:/a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:* (Version < 1.0.1.1)

    • Configuration CCN 1:
  • cpe:/a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*
  • AND
  • cpe:/a:ibm:watson_studio_local:1.2.3:*:*:*:*:*:*:*
  • OR cpe:/a:ibm:powerai:1.6.0:*:*:*:*:*:*:*
  • OR cpe:/a:ibm:infosphere_guardium_activity_monitor:10.6:*:*:*:*:*:*:*
  • OR cpe:/a:ibm:infosphere_guardium_activity_monitor:11.0:*:*:*:*:*:*:*
  • OR cpe:/a:ibm:infosphere_guardium_activity_monitor:10.5:*:*:*:*:*:*:*
  • OR cpe:/a:ibm:data_risk_manager:2.0.6:*:*:*:*:*:*:*

    • * Denotes that component is vulnerable
    Oval Definitions
    Definition IDClassTitleLast Modified
    oval:com.ubuntu.disco:def:2019192420000000
    V
    		CVE-2019-19242 on Ubuntu 19.04 (disco) - low.
    2019-11-27
    BACK
    sqlite sqlite 3.30.1
    canonical ubuntu linux 12.04
    canonical ubuntu linux 16.04
    canonical ubuntu linux 18.04
    canonical ubuntu linux 19.04
    canonical ubuntu linux 19.10
    redhat enterprise linux 8.0
    oracle mysql workbench *
    siemens sinec infrastructure network services *
    sqlite sqlite 3.30.1
    ibm watson studio local 1.2.3
    ibm powerai 1.6.0
    ibm infosphere guardium activity monitor 10.6
    ibm infosphere guardium activity monitor 11.0
    ibm infosphere guardium activity monitor 10.5
    ibm data risk manager 2.0.6