UBUNTU-CVE-2019-19923

See a problem?
Please try reporting it to the source first.
Source
https://ubuntu.com/security/CVE-2019-19923
Import Source
https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2019/UBUNTU-CVE-2019-19923.json
JSON Data
https://api.osv.dev/v1/vulns/UBUNTU-CVE-2019-19923
Related
Published
2019-12-24T16:15:00Z
Modified
2019-12-24T16:15:00Z
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).

References

Affected packages

Ubuntu:18.04:LTS / sqlite3

Package

Name
sqlite3
Purl
pkg:deb/ubuntu/sqlite3?arch=src?distro=bionic

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
3.22.0-1ubuntu0.3

Affected versions

3.*

3.19.3-3
3.20.1-2
3.21.0-1
3.22.0-1
3.22.0-1ubuntu0.1
3.22.0-1ubuntu0.2

Ecosystem specific 

{
    "availability": "No subscription required",
    "ubuntu_priority": "medium",
    "binaries": [
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "lemon"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "lemon-dbgsym"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "libsqlite3-0"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "libsqlite3-0-dbgsym"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "libsqlite3-dev"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "libsqlite3-tcl"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "libsqlite3-tcl-dbgsym"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "sqlite3"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "sqlite3-dbgsym"
        },
        {
            "binary_version": "3.22.0-1ubuntu0.3",
            "binary_name": "sqlite3-doc"
        }
    ]
}