The Vigil@nce team watches public vulnerabilities impacting your computers, and then offers security solutions, a vigilance database and tools to fix them.

Vulnerability of SQLite: denial of service via Sub-Select DISTINCT Window

Synthesis of the vulnerability 

An attacker can trigger a fatal error via Sub-Select DISTINCT Window of SQLite, in order to trigger a denial of service.
Vulnerable systems: MySQL Community, MySQL Enterprise, Solaris, Percona Server, SIMATIC, SQLite, Ubuntu.
Severity of this threat: 1/4.
Creation date: 26/11/2019.
Références of this weakness: cpuapr2020, CVE-2019-19244, SSB-439005, USN-4205-1, VIGILANCE-VUL-30980.

Description of the vulnerability 

An attacker can trigger a fatal error via Sub-Select DISTINCT Window of SQLite, in order to trigger a denial of service.
Full bulletin, software filtering, emails, fixes, ... (Request your free trial)

This vulnerability bulletin impacts software or systems such as MySQL Community, MySQL Enterprise, Solaris, Percona Server, SIMATIC, SQLite, Ubuntu.

Our Vigil@nce team determined that the severity of this security note is low.

The trust level is of type confirmed by the editor, with an origin of user account.

An attacker with a expert ability can exploit this cybersecurity note.

Solutions for this threat 

SQLite: patch for Sub-Select DISTINCT Window.
A patch is indicated in information sources.

Oracle MySQL: version 5.6.48.
The version 5.6.48 is fixed:
  https://support.oracle.com/rs?type=doc&id=2648128.1
  https://www.mysql.com/fr/downloads/
  https://dev.mysql.com/downloads/mysql/

Oracle MySQL: version 5.7.30.
The version 5.7.30 is fixed:
  https://support.oracle.com/rs?type=doc&id=2648128.1
  https://www.mysql.com/fr/downloads/
  https://dev.mysql.com/downloads/mysql/

Oracle MySQL: version 8.0.20.
The version 8.0.20 is fixed:
  https://support.oracle.com/rs?type=doc&id=2648128.1
  https://www.mysql.com/fr/downloads/
  https://dev.mysql.com/downloads/mysql/

Oracle Solaris: patch for third party software of April 2020 v2.
A patch is available:
  https://support.oracle.com/rs?type=doc&id=1448883.1

Percona Server: version 5.6.48-88.0.
The version 5.6.48-88.0 is fixed.

SIMATIC S7-1500 CPU 1518: workaround for GNU/Linux Vulnerabilities.
A workaround is indicated in the information source.

Ubuntu: new sqlite3 packages.
New packages are available:
  Ubuntu 19.10: libsqlite3-0 3.29.0-2ubuntu0.1, sqlite3 3.29.0-2ubuntu0.1
  Ubuntu 19.04: libsqlite3-0 3.27.2-2ubuntu0.2, sqlite3 3.27.2-2ubuntu0.2
  Ubuntu 18.04 LTS: libsqlite3-0 3.22.0-1ubuntu0.2, sqlite3 3.22.0-1ubuntu0.2
  Ubuntu 16.04 LTS: libsqlite3-0 3.11.0-1ubuntu1.3, sqlite3 3.11.0-1ubuntu1.3
  Ubuntu 12.04 ESM: libsqlite3-0 3.7.9-2ubuntu1.4, sqlite3 3.7.9-2ubuntu1.4
Full bulletin, software filtering, emails, fixes, ... (Request your free trial)

Computer vulnerabilities tracking service 

Vigil@nce provides applications vulnerabilities analysis. The Vigil@nce security watch publishes vulnerability bulletins about threats impacting the information system.