CVE-2019-19923

See a problem?
Please try reporting it to the source first.
Source
https://cve.org/CVERecord?id=CVE-2019-19923
Import Source
https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19923.json
JSON Data
https://api.osv.dev/v1/vulns/CVE-2019-19923
Downstream
DEBIAN (1)
MGASA (1)
openSUSE (7)
RHSA (2)
SUSE (2)
UBUNTU (1)
Related
openSUSE (7)
SUSE (2)
Published
2019-12-24T16:15:11Z
Modified
2026-08-07T14:52:58Z
Severity
  • 7.5 (High) CVSS_V3 - CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H CVSS Calculator
Summary
[none]
Details

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

Database specific 
{
    "unresolved_ranges":  [
        {
            "cpes":  [
                "cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "last_affected":  "8.0.19"
                }
            ],
            "source":  "CPE_RANGE",
            "vendor_product":  "oracle:mysql_workbench"
        },
        {
            "cpes":  [
                "cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "fixed":  "1.0.1.1"
                }
            ],
            "source":  "CPE_RANGE",
            "vendor_product":  "siemens:sinec_infrastructure_network_services"
        },
        {
            "cpes":  [
                "cpe:2.3:o:debian:debian_linux:10.0:*:*:*:*:*:*:*",
                "cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "introduced":  "9.0"
                },
                {
                    "last_affected":  "9.0"
                },
                {
                    "introduced":  "10.0"
                },
                {
                    "last_affected":  "10.0"
                }
            ],
            "source":  "CPE_STRING",
            "vendor_product":  "debian:debian_linux"
        },
        {
            "cpes":  [
                "cpe:2.3:a:opensuse:backports_sle:15.0:sp1:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "introduced":  "15.0-sp1"
                },
                {
                    "last_affected":  "15.0-sp1"
                }
            ],
            "source":  "CPE_STRING",
            "vendor_product":  "opensuse:backports_sle"
        },
        {
            "cpes":  [
                "cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "introduced":  "15.1"
                },
                {
                    "last_affected":  "15.1"
                }
            ],
            "source":  "CPE_STRING",
            "vendor_product":  "opensuse:leap"
        },
        {
            "cpes":  [
                "cpe:2.3:o:redhat:enterprise_linux_desktop:6.0:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "introduced":  "6.0"
                },
                {
                    "last_affected":  "6.0"
                }
            ],
            "source":  "CPE_STRING",
            "vendor_product":  "redhat:enterprise_linux_desktop"
        },
        {
            "cpes":  [
                "cpe:2.3:o:redhat:enterprise_linux_server:6.0:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "introduced":  "6.0"
                },
                {
                    "last_affected":  "6.0"
                }
            ],
            "source":  "CPE_STRING",
            "vendor_product":  "redhat:enterprise_linux_server"
        },
        {
            "cpes":  [
                "cpe:2.3:o:redhat:enterprise_linux_workstation:6.0:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "introduced":  "6.0"
                },
                {
                    "last_affected":  "6.0"
                }
            ],
            "source":  "CPE_STRING",
            "vendor_product":  "redhat:enterprise_linux_workstation"
        }
    ]
}
References

Affected packages

Git / github.com/sqlite/sqlite

Affected ranges

Type
GIT
Repo
https://github.com/sqlite/sqlite
Events
Introduced
25e9591209453dc0904f8f0f1c4d5090c836e19b
Last Affected
25e9591209453dc0904f8f0f1c4d5090c836e19b
Fixed
396afe6f6aa90a31303c183e11b2b2d4b7956b35
Database specific
Show details 
{
    "cpe":  "cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*",
    "extracted_events":  [
        {
            "introduced":  "3.30.1"
        },
        {
            "last_affected":  "3.30.1"
        }
    ],
    "source":  [
        "CPE_STRING",
        "REFERENCES"
    ]
}

Affected versions

3.*
3.30.1
version-3.*
version-3.30.1

Database specific

source 
"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19923.json"
vanir_signatures 
[
    {
        "deprecated":  false,
        "digest":  {
            "function_hash":  "330814732743507439986540557302774929713",
            "length":  5590
        },
        "id":  "CVE-2019-19923-134f638b",
        "signature_type":  "Function",
        "signature_version":  "v1",
        "source":  "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
        "target":  {
            "file":  "src/select.c",
            "function":  "flattenSubquery"
        }
    },
    {
        "deprecated":  false,
        "digest":  {
            "line_hashes":  [
                "18104233075719913524635092338994927414",
                "231876987339024958742979482512986350232",
                "160277624447613318640615005514603846097",
                "8615964068487288384404672935273546870",
                "158745051547251140066162530979138522345",
                "183413588476470140403235573409063477251",
                "275703712529451719009097609695050452259"
            ],
            "threshold":  0.9
        },
        "id":  "CVE-2019-19923-5fb5e80f",
        "signature_type":  "Line",
        "signature_version":  "v1",
        "source":  "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
        "target":  {
            "file":  "src/select.c"
        }
    }
]
vanir_signatures_modified 
"2026-08-07T14:52:58Z"