CVE-2019-19923
published 2019-12-24CVE-2019-19923: flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can…
PriorityP339high7.5CVSS 3.1
AVNACLPRNUINSUCNINAH
EPSS
6.81%
93.3th percentile
flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).
Affected
23 ranges
| Vendor | Product | Version range | Fixed in |
|---|---|---|---|
| chromium | chromium | >= 0 < 80.0.3987.106-1 | 80.0.3987.106-1 |
| chromium | chromium | >= 0 < 80.0.3987.106-1 | 80.0.3987.106-1 |
| chromium | chromium | >= 0 < 80.0.3987.106-1 | 80.0.3987.106-1 |
| chromium | chromium | >= 0 < 80.0.3987.106-1 | 80.0.3987.106-1 |
| debian | chromium | < chromium 80.0.3987.106-1 (bookworm) | chromium 80.0.3987.106-1 (bookworm) |
| debian | debian_linux | — | — |
| debian | debian_linux | — | — |
| debian | sqlite3 | < chromium 80.0.3987.106-1 (bookworm) | chromium 80.0.3987.106-1 (bookworm) |
| ghost | sqlite3 | >= 0 < 3.30.1+fossil191229-1 | 3.30.1+fossil191229-1 |
| ghost | sqlite3 | >= 0 < 3.30.1+fossil191229-1 | 3.30.1+fossil191229-1 |
| ghost | sqlite3 | >= 0 < 3.30.1+fossil191229-1 | 3.30.1+fossil191229-1 |
| ghost | sqlite3 | >= 0 < 3.30.1+fossil191229-1 | 3.30.1+fossil191229-1 |
| ghost | sqlite3 | >= 0 < 3.11.0-1ubuntu1.4 | 3.11.0-1ubuntu1.4 |
| ghost | sqlite3 | >= 0 < 3.22.0-1ubuntu0.3 | 3.22.0-1ubuntu0.3 |
| chrome_chrome | — | — | |
| opensuse | backports_sle | — | — |
| opensuse | leap | — | — |
| oracle | mysql_workbench | <= 8.0.19 | — |
| redhat | enterprise_linux_desktop | — | — |
| redhat | enterprise_linux_server | — | — |
| redhat | enterprise_linux_workstation | — | — |
| siemens | sinec_infrastructure_network_services | < 1.0.1.1 | 1.0.1.1 |
| sqlite | sqlite | — | — |
CVSS provenance
nvdv3.17.5HIGHCVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
nvdv2.05.0MEDIUMAV:N/AC:L/Au:N/C:N/I:N/A:P
osv8.8HIGH
vendor_ubuntu8.8HIGH
vendor_debian7.5HIGH
vendor_redhat7.5HIGH
Stop checking back — get the weekly exploitation signal.
Every Monday: what got weaponized or added to CISA KEV in the last seven days — each CVE cross-linked to its PoC, Nuclei template, and detection rule. Free, one email a week, unsubscribe in one click.
CISA ICS
Siemens SIMATIC S7-1500 CPU 1518(F)-4 PN/DP MFP V3.1
cisa_ics·2023-12-14
Siemens SIMATIC S7-1500 CPU 1518(F)-4 PN/DP MFP V3.1
ICS Advisory
##
Siemens SIMATIC S7-1500 CPU 1518(F)-4 PN/DP MFP V3.1
Release DateDecember 14, 2023
Alert CodeICSA-23-348-10
As of January 10, 2023, CISA will no longer be updating ICS security advisories for Siemens product vulnerabilities beyond the initial advisory. For the most up-to-date information on vulnerabilities in this advisory, please see Siemens' ProductCERT Security Advisories (CERT Services | Services | Siemens Global).
View CSAF
## 1. EXECUTIVE SUMMARY
- CVSS v3 9.8
- ATTENTION: Exploitable remotely/low attack complexity
- Vendor: Siemens
- Equipment: SIMATIC S7-1500 CPU 1518(F)-4 PN/DP MFP V3.1
- Vulnerabilities: Improper Restriction of XML External Entity Reference, Time-of-check Time-of-use (TOCTOU) Race Condition, Command Injection, Miss
CISA ICS
Siemens SINEC INS
cisa_ics·2022-03-10·CVSS 5.9
[MEDIUM] Siemens SINEC INS
## Archived Content In an effort to keep CISA.gov current, the archive contains outdated information that may not reflect current policy or programs.
ICS Advisory
##
Siemens SINEC INS
Last RevisedMarch 10, 2022
Alert CodeICSA-22-069-09
## 1. EXECUTIVE SUMMARY
- CVSS v3 9.8
- ATTENTION: Exploitable remotely/low attack complexity
- Vendor: Siemens
- Equipment: SINEC INS
- Vulnerability: Using Components with Known Vulnerabilities
## 2. RISK EVALUATION
Successful exploitation of this vulnerability in third-party components could allow an attacker to interfere with the affected product in various ways.
## 3. TECHNICAL DETAILS
## 3.1 AFFECTED PRODUCTS
Siemens reports this vulnerability affects the following SINEC INS (Infrastructure Netw
Ubuntu
SQLite vulnerabilities
vendor_ubuntu·2020-03-10·CVSS 8.8
CVE-2019-13734 [HIGH] SQLite vulnerabilities
Title: SQLite vulnerabilities
Summary: Several security issues were fixed in SQLite.
It was discovered that SQLite incorrectly handled certain shadow tables. An
attacker could use this issue to cause SQLite to crash, resulting in a
denial of service, or possibly execute arbitrary code. (CVE-2019-13734,
CVE-2019-13750, CVE-2019-13753)
It was discovered that SQLite incorrectly handled certain corrupt records.
An attacker could use this issue to cause SQLite to crash, resulting in a
denial of service, or possibly execute arbitrary code. (CVE-2019-13751)
It was discovered that SQLite incorrectly handled certain queries. An
attacker could use this issue to cause SQLite to crash, resulting in a
denial of service, or possibly execute arbitrary code. This issue only
affected Ubuntu 19.10. (CVE
Chrome
Stable Channel Update for Desktop: CVE-2019-19923
vendor_chrome·2020-02-04·CVSS 7.5
CVE-2019-19923 [MEDIUM] Stable Channel Update for Desktop: CVE-2019-19923
Stable Channel Update for Desktop
CVE-2019-19923: Out of bounds memory access in SQLite. Reported by Richard Lorenz, SAP on 2020-01-16
[$1000][ 1026546 ] Low CVE-2020-6408: Insufficient policy enforcement in CORS
Reported by Zhong Zhaochen of andsecurity
Severity: medium
Red Hat
sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference
vendor_redhat·2020-01-08·CVSS 7.5
CVE-2019-19923 [HIGH] CWE-476 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference
sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference
flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).
Package: sqlite (Red Hat Enterprise Linux 5) - Not affected
Package: sqlite (Red Hat Enterprise Linux 6) - Not affected
Package: sqlite (Red Hat Enterprise Linux 7) - Not affected
Debian
CVE-2019-19923: chromium - flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT D...
vendor_debian·2019·CVSS 7.5
CVE-2019-19923 [HIGH] CVE-2019-19923: chromium - flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT D...
flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).
Scope: local
bookworm: resolved (fixed in 80.0.3987.106-1)
bullseye: resolved (fixed in 80.0.3987.106-1)
forky: resolved (fixed in 80.0.3987.106-1)
sid: resolved (fixed in 80.0.3987.106-1)
trixie: resolved (fixed in 80.0.3987.106-1)
GHSA
GHSA-5gmx-grg5-hh7x: flattenSubquery in select
ghsa_unreviewed·2022-05-24
CVE-2019-19923 [MEDIUM] CWE-476 GHSA-5gmx-grg5-hh7x: flattenSubquery in select
flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).
OSV
sqlite3 vulnerabilities
osv·2020-03-10·CVSS 8.8
CVE-2019-13734 [HIGH] sqlite3 vulnerabilities
sqlite3 vulnerabilities
It was discovered that SQLite incorrectly handled certain shadow tables. An
attacker could use this issue to cause SQLite to crash, resulting in a
denial of service, or possibly execute arbitrary code. (CVE-2019-13734,
CVE-2019-13750, CVE-2019-13753)
It was discovered that SQLite incorrectly handled certain corrupt records.
An attacker could use this issue to cause SQLite to crash, resulting in a
denial of service, or possibly execute arbitrary code. (CVE-2019-13751)
It was discovered that SQLite incorrectly handled certain queries. An
attacker could use this issue to cause SQLite to crash, resulting in a
denial of service, or possibly execute arbitrary code. This issue only
affected Ubuntu 19.10. (CVE-2019-19880)
It was discovered that SQLite incorrectly handle
OSV
CVE-2019-19923: flattenSubquery in select
osv·2019-12-24·CVSS 7.5
CVE-2019-19923 [HIGH] CVE-2019-19923: flattenSubquery in select
flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).
No detection rules found.
No public exploits indexed.
Bugzilla
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-30]
bugzilla·2020-01-10·CVSS 7.5
CVE-2019-19923 [HIGH] CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-30]
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-30]
This is an automatically created tracking bug! It was created to ensure
that one or more security vulnerabilities are fixed in affected versions
of fedora-30.
For comments that are specific to the vulnerability please use bugs filed
against the "Security Response" product referenced in the "Blocks" field.
For more information see:
http://fedoraproject.org/wiki/Security/TrackingBugs
When submitting as an update, use the fedpkg template provided in the next
comment(s). This will include the bug IDs of this tracking bug as well as
the relevant top-level CVE bugs.
Please also mention the CVE IDs being fixed in the RPM ch
Bugzilla
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference
bugzilla·2020-01-08·CVSS 7.5
CVE-2019-19923 [HIGH] CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference
flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).
Upstream fix:
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
Discussion:
Created sqlite tracking bugs for this issue:
Affects: fedora-31 [bug 1788847]
---
Created sqlite tracking bugs for this issue:
Affects: fedora-30 [bug 1789799]
---
This issue has been addressed in the following products:
Red Hat Enterprise Linux 6 Supplementary
Via RHSA-2020:0514 https://access.redhat.co
Bugzilla
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-31]
bugzilla·2020-01-08·CVSS 7.5
CVE-2019-19923 [HIGH] CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-31]
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-31]
This is an automatically created tracking bug! It was created to ensure
that one or more security vulnerabilities are fixed in affected versions
of fedora-31.
For comments that are specific to the vulnerability please use bugs filed
against the "Security Response" product referenced in the "Blocks" field.
For more information see:
http://fedoraproject.org/wiki/Security/TrackingBugs
When submitting as an update, use the fedpkg template provided in the next
comment(s). This will include the bug IDs of this tracking bug as well as
the relevant top-level CVE bugs.
Please also mention the CVE IDs being fixed in the RPM ch
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.htmlhttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.htmlhttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.htmlhttps://access.redhat.com/errata/RHSA-2020:0514https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdfhttps://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35https://security.netapp.com/advisory/ntap-20200114-0003/https://usn.ubuntu.com/4298-1/https://www.debian.org/security/2020/dsa-4638https://www.oracle.com/security-alerts/cpuapr2020.htmlhttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.htmlhttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.htmlhttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.htmlhttps://access.redhat.com/errata/RHSA-2020:0514https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdfhttps://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35https://security.netapp.com/advisory/ntap-20200114-0003/https://usn.ubuntu.com/4298-1/https://www.debian.org/security/2020/dsa-4638https://www.oracle.com/security-alerts/cpuapr2020.html
2019-12-24
Published