UBUNTU-CVE-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 cause a NULL pointer dereference (or incorrect results).

References

Affected packages

Ubuntu:18.04:LTS / sqlite3

Package

Name: sqlite3
Purl: pkg:deb/ubuntu/sqlite3@3.22.0-1ubuntu0.3?arch=source&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",
    "binaries": [
        {
            "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",
            "binary_version": "3.22.0-1ubuntu0.3"
        }
    ]
}