We're updating the issue view to help you get more done. 

MariaDB hangs on query with many logical condition

Description

MariaDB process hangs with 100% CPU usage, while executing simple query with many logical conditions. Same query on MySQL 5.6.23 tooks only fraction of second to complete.

To reproduce problem restore table from "testtable.sql" file and execute test.sql query.

Environment

10.0.21-MariaDB, Centos6

Status

Assignee

Oleksandr Byelkin

Reporter

Vytautas Bertašius

Components

Sprint

None

Fix versions

Affects versions

5.3.12
10.0.21
5.5
10.0
10.1

Priority

Critical