---
id: CVE-2019-19242
title: >-
  SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case
  in sqlite3ExprCodeTarget in expr.c.
summary: >-
  SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case
  in sqlite3ExprCodeTarget in expr.c.
severity: medium
cvss: 5.9
cvssVector: 'CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H'
cwe:
  - CWE-476
  - CWE-89
vendor: sqlite
product: sqlite
affected:
  - sqlite = 3.30.1
  - ubuntu_linux = 12.04
  - ubuntu_linux = 16.04
  - ubuntu_linux = 18.04
  - ubuntu_linux = 19.04
  - ubuntu_linux = 19.10
  - enterprise_linux = 8.0
  - mysql_workbench <= 8.0.19
  - sinec_infrastructure_network_services < 1.0.1.1
patched:
  - sinec_infrastructure_network_services 1.0.1.1
published: '2019-11-27'
updated: '2026-10-14'
sourceUpdated: '2026-10-14T07:16:50.910'
source: NVD
sourceUrl: 'https://nvd.nist.gov/vuln/detail/CVE-2019-19242'
references:
  - url: 'https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf'
    label: cve@mitre.org
  - url: >-
      https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c
    label: cve@mitre.org
  - url: 'https://usn.ubuntu.com/4205-1/'
    label: cve@mitre.org
  - url: 'https://www.oracle.com/security-alerts/cpuapr2020.html'
    label: cve@mitre.org
  - url: 'https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf'
    label: af854a3a-2127-422b-91ae-364da2661108
  - url: >-
      https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c
    label: af854a3a-2127-422b-91ae-364da2661108
  - url: 'https://usn.ubuntu.com/4205-1/'
    label: af854a3a-2127-422b-91ae-364da2661108
  - url: 'https://www.oracle.com/security-alerts/cpuapr2020.html'
    label: af854a3a-2127-422b-91ae-364da2661108
  - url: 'https://cert-portal.siemens.com/productcert/html/ssa-389290.html'
    label: 0b142b55-0307-4c5a-b3c9-f314f3fb7c5e
  - url: 'https://cert-portal.siemens.com/productcert/html/ssa-398330.html'
    label: 0b142b55-0307-4c5a-b3c9-f314f3fb7c5e
  - url: >-
      https://security.access.redhat.com/data/csaf/v2/vex/2019/cve-2019-19242.json
  - url: 'https://access.redhat.com/security/cve/CVE-2019-19242'
  - url: 'https://bugzilla.redhat.com/show_bug.cgi?id=1778867'
  - url: 'https://www.cve.org/CVERecord?id=CVE-2019-19242'
  - url: 'https://nvd.nist.gov/vuln/detail/CVE-2019-19242'
tags:
  - nvd
  - csaf
  - vex
  - red-hat
epss: 0.02538
epssPercentile: 0.84568
ingestedAt: '2026-10-14T07:21:04.823Z'
---

## Overview

SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.

## Affected

- `sqlite = 3.30.1`
- `ubuntu_linux = 12.04`
- `ubuntu_linux = 16.04`
- `ubuntu_linux = 18.04`
- `ubuntu_linux = 19.04`
- `ubuntu_linux = 19.10`
- `enterprise_linux = 8.0`
- `mysql_workbench <= 8.0.19`
- `sinec_infrastructure_network_services < 1.0.1.1`

## Remediation

Upgrade past the affected range:

- `sinec_infrastructure_network_services 1.0.1.1`

## Vendor advisories

- **Red Hat VEX** · Moderate · updated 2026-10-14 · [vex](https://security.access.redhat.com/data/csaf/v2/vex/2019/cve-2019-19242.json)