Vulnerability Name:

CVE-2019-19244 (CCN-172196)

Assigned:2019-11-25
Published:2019-11-25
Updated:2022-04-15
Summary:sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage.
CVSS v3 Severity:7.5 High (CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H)
6.5 Medium (Temporal CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/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): Low
Privileges Required (PR): None
User Interaction (UI): None
Scope:Scope (S): Unchanged
Impact Metrics:Confidentiality (C): None
Integrity (I): None
Availibility (A): High
5.3 Medium (CCN CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:L)
4.6 Medium (CCN Temporal CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/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): None
Integrity (I): None
Availibility (A): Low
CVSS v2 Severity:5.0 Medium (CVSS v2 Vector: AV:N/AC:L/Au:N/C:N/I:N/A:P)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Low
Authentication (Au): None
Impact Metrics:Confidentiality (C): None
Integrity (I): None
Availibility (A): Partial
5.0 Medium (CCN CVSS v2 Vector: AV:N/AC:L/Au:N/C:N/I:N/A:P)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Low
Athentication (Au): None
Impact Metrics:Confidentiality (C): None
Integrity (I): None
Availibility (A): Partial
Vulnerability Type:CWE-noinfo
Vulnerability Consequences:Denial of Service
References:Source: MITRE
Type: CNA
CVE-2019-19244

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

Source: XF
Type: UNKNOWN
sqlite-cve201919244-dos(172196)

Source: CCN
Type: SQLite GIT Repository
Fix a crash that could occur if a sub-select that uses both DISTINCT and window functions also used an ORDER BY that is the same as its select list.

Source: MISC
Type: Patch
https://github.com/sqlite/sqlite/commit/e59c562b3f6894f84c715772c4b116d7b5c01348

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-19244

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

    • Configuration 2:
  • cpe:/o:canonical:ubuntu_linux:19.04:*:*:*:*:*:*:*
  • OR cpe:/o:canonical:ubuntu_linux:19.10:*:*:*:*:*:*:*

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

    • Configuration 4:
  • 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:org.opensuse.security:def:7675
    P
    		libsqlite3-0-3.39.3-150000.3.20.1 on GA media (Moderate)
    2023-06-12
    oval:org.opensuse.security:def:51964
    P
    		Security update for libarchive (Low)
    2022-11-23
    oval:org.opensuse.security:def:740
    P
    		Security update for icu (Moderate)
    2022-09-07
    oval:org.opensuse.security:def:3641
    P
    		Security update for ncurses (Moderate) (in QA)
    2022-07-18
    oval:org.opensuse.security:def:6091
    P
    		Security update for rsyslog (Important)
    2022-07-06
    oval:org.opensuse.security:def:3455
    P
    		coolkey-1.1.0-148.3.1 on GA media (Moderate)
    2022-06-28
    oval:org.opensuse.security:def:3083
    P
    		gnome-keyring-3.20.0-28.3.18 on GA media (Moderate)
    2022-06-28
    oval:org.opensuse.security:def:94713
    P
    		libsqlite3-0-3.36.0-3.12.1 on GA media (Moderate)
    2022-06-22
    oval:org.opensuse.security:def:94567
    P
    		gnutls-3.7.3-150400.2.12 on GA media (Moderate)
    2022-06-22
    oval:org.opensuse.security:def:95318
    P
    		Security update for jackson-databind, jackson-dataformats-binary, jackson-annotations, jackson-bom, jackson-core (Important)
    2022-05-16
    oval:org.opensuse.security:def:102031
    P
    		Security update for the Linux Kernel (Live Patch 5 for SLE 15 SP3) (Important)
    2022-03-29
    oval:org.opensuse.security:def:99502
    P
    		 (Important)
    2022-01-17
    oval:org.opensuse.security:def:99701
    P
    		 (Moderate)
    2021-12-06
    oval:org.opensuse.security:def:100010
    P
    		 (Moderate)
    2021-10-27
    oval:org.opensuse.security:def:31687
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:59803
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:89200
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:23681
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:55953
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:84673
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:33980
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:30130
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:58018
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:87478
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:125609
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:51669
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:83337
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:32195
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:60373
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:89458
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:23976
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:56073
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:85743
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:34550
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:30250
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:58837
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:88196
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:126776
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:83457
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:33014
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:26137
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:57102
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:86151
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:5124
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:31279
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:59545
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:88512
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:127173
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:55250
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:84215
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:33722
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:29427
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:57510
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:86659
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:82634
    P
    		Security update for sqlite3 (Important)
    2021-09-23
    oval:org.opensuse.security:def:93102
    P
    		 (Moderate)
    2021-08-23
    oval:org.opensuse.security:def:101280
    P
    		libtdsodbc0-1.1.36-3.3.1 on GA media (Moderate)
    2021-08-09
    oval:org.opensuse.security:def:110972
    P
    		Security update for sqlite3 (Important)
    2021-07-19
    oval:org.opensuse.security:def:69693
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:94389
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:73666
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:93255
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:42100
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:8805
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:91966
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:99658
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:66859
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:99303
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:111619
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:93752
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:9752
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:92751
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:101471
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:5770
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:69892
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:73852
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:93098
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:9000
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:92161
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:99972
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:67180
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:107946
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:93966
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:10117
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:92949
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:70257
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:64544
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:98916
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:75927
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:93416
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:9363
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:92353
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:100308
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:69503
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:108697
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:94178
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:10303
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:8619
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:70443
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:99395
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:64730
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:99111
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:117461
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:76248
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:93572
    P
    		 (Important)
    2021-07-14
    oval:org.opensuse.security:def:9553
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:92552
    P
    		Security update for sqlite3 (Important)
    2021-07-14
    oval:org.opensuse.security:def:100636
    P
    		 (Important)
    2021-07-14
    oval:com.ubuntu.disco:def:2019192440000000
    V
    		CVE-2019-19244 on Ubuntu 19.04 (disco) - medium.
    2019-11-25
    oval:com.ubuntu.bionic:def:2019192440000000
    V
    		CVE-2019-19244 on Ubuntu 18.04 LTS (bionic) - medium.
    2019-11-25
    oval:com.ubuntu.xenial:def:2019192440000000
    V
    		CVE-2019-19244 on Ubuntu 16.04 LTS (xenial) - medium.
    2019-11-25
    BACK
    sqlite sqlite 3.30.1
    canonical ubuntu linux 19.04
    canonical ubuntu linux 19.10
    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