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

Labels

None

External issue ID

None

External issue ID

None

Components

Sprint

None

Fix versions

Affects versions

10.0
5.3.12
10.1
5.5
10.0.21

Priority

Critical