← All database systems

MySQL is supported by SQLancer — the main repository ships a testing implementation for it. SQLancer is credited with 43 bugs in it, reported between 2019-06-15 and 2020-04-01. Its source is at mysql/mysql-server.

A further 9 reports were filed and rejected by the developers as invalid or duplicate. Those are kept in the dataset for transparency and are excluded from every count here.

How the bugs break down

By year reported

2019
25
2020
7
Year not recorded
11

Who found them

Found by the SQLancer project
32
Reporter not recorded
11

By status

Fixed
17
Fixed in documentation
2
Confirmed
13
Unknown
11

By symptom

Logic bug
21
Unexpected error
9
Crash
1
Unclassified
12

By technique

Technique not recorded
22
Pivoted Query Synthesis (PQS)
14
Ternary Logic Partitioning (TLP)
7

Why each bug counts

Listed in the project's own bug repository
22
The report names a SQLancer oracle
21

Who reported them (2)

Manuel Rigger
31
mrigger
1

Every bug on record (52)

One row per report, newest first, each linking to the report itself. Rejected reports are marked and are not part of any count above.

Reported Report Status Technique Reporter
2020-04-04 BETWEEN computes incorrect result when comparing DECIMAL with a string closed not a bug TLP Manuel Rigger
2020-04-01 The IN operator malfunctions for floating-poing numbers closed not a bug TLP Manuel Rigger
2020-04-01 Incorrect result when comparing a floating-point number with an integer verified TLP Manuel Rigger
2020-04-01 Comparison on FLOAT column and large value malfunctions verified TLP Manuel Rigger
2020-04-01 BETWEEN query malfunctions for special character and TEXT index verified TLP Manuel Rigger
2020-03-31 Incorrect result when comparing an UNSIGNED INT with a floating-point number verified TLP Manuel Rigger
2020-03-31 Incorrect result for query that uses an AND operator on floats closed not a bug TLP Manuel Rigger
2020-03-31 BETWEEN malfunctions when comparing large numbers verified TLP Manuel Rigger
2020-03-31 BETWEEN malfunctions when comparing a string containing a newline verified TLP Manuel Rigger
2020-03-31 A predicate that compares 0 with -0 yields an incorrect result fixed TLP Manuel Rigger
2019-07-23 DISABLE KEYS, DELAY_KEY_WRITE results in "Data truncated for functional index" closed duplicate — Manuel Rigger
2019-07-23 CAST of STRING with newlines to SIGNED/UNSIGNED returns unexpected result closed duplicate — Manuel Rigger
2019-06-26 SET key_cache_* and key_buffer_* variables fails nondeterministically verified — Manuel Rigger
2019-06-26 Query with GREATEST function malfunctions fixed PQS Manuel Rigger
2019-06-26 Non-unique functional index prevents PRIMARY KEY from being dropped closed duplicate — Manuel Rigger
2019-06-26 Index makes DELETE fail with "Truncated incorrect DOUBLE value" closed not a bug — Manuel Rigger
2019-06-25 Unexpected result for IN operator and constants fixed in documentation PQS Manuel Rigger
2019-06-25 Setting sort_buffer_size to a large value causes query to go out of memory fixed — Manuel Rigger
2019-06-25 SET GLOBAL on rbr_exec_mode fails verified — Manuel Rigger
2019-06-25 Query involving &, <, and AND operators computes incorrect result fixed PQS Manuel Rigger
2019-06-25 Compare that uses UNSIGNED cast and function malfunctions in the MEMORY engine fixed PQS Manuel Rigger
2019-06-24 The logical operators &, |, and ^ do not ignore newlines in TEXT fixed PQS Manuel Rigger
2019-06-24 TEXT column used as boolean incorrectly evaluates to false fixed PQS Manuel Rigger
2019-06-24 IN operator issue when comparing signed column and the column cast to unsigned verified PQS Manuel Rigger
2019-06-24 Function return value with newline yields wrong result when used as a boolean fixed PQS Manuel Rigger
2019-06-24 CAST of negative function return value to UNSIGNED malfunctions with BIGINT fixed PQS Manuel Rigger
2019-06-24 BENCHMARK() returns NULL in some cases but is documented to always return 0 fixed in documentation PQS Manuel Rigger
2019-06-24 AND/OR/XOR compute wrong result for small floating-point numbers in TEXT columns fixed PQS Manuel Rigger
2019-06-23 CHECK TABLE FOR UPGRADE crashes server (segfault) fixed — Manuel Rigger
2019-06-23 CHECK TABLE FOR UPGRADE crashes server (segfault) fixed — mrigger
2019-06-22 XOR operator returns incorrect result for strings with a floating-point number fixed PQS Manuel Rigger
2019-06-22 Row is not fetched when using a function expression that should yield TRUE fixed PQS Manuel Rigger
2019-06-22 Duplicate entry for key 'PRIMARY' when querying information_schema.TABLES fixed — Manuel Rigger
2019-06-21 The negation of a "<=>" comparison malfunctions depending on the column's type fixed PQS Manuel Rigger
2019-06-20 Functional index seems to malfunction with UNSIGNED column fixed — Manuel Rigger
2019-06-20 DROP PRIMARY KEY on UNIQUE PRIMARY KEY does not update information_schema.column verified — Manuel Rigger
2019-06-20 DROP COLUMN error on INVISIBLE UNIQUE INDEX that refers to constant expression closed not a bug — Manuel Rigger
2019-06-20 Applying NOT twice on an integer results in wrong result in WHERE condition closed duplicate PQS Manuel Rigger
2019-06-18 "Can't find record" error in SELECT statement 2 (HEAP engine) verified — Manuel Rigger
2019-06-18 "Can't find record" error in SELECT statement 1 (MyISAM engine) verified — Manuel Rigger
2019-06-15 REPAIR TABLE on a functional table marks it as crashed verified — Manuel Rigger
— https://bugs.mysql.com/bug.php?id=99183 unknown — —
— https://bugs.mysql.com/bug.php?id=114534 unknown — —
— https://bugs.mysql.com/bug.php?id=114533 unknown — —
— https://bugs.mysql.com/bug.php?id=112264 unknown — —
— https://bugs.mysql.com/bug.php?id=112243 unknown — —
— https://bugs.mysql.com/bug.php?id=112242 unknown — —
— https://bugs.mysql.com/bug.php?id=111471 unknown — —
— Inserting a NULL and a value which rounds to 0 into a DECIMAL column causes result set mismatch unknown — —
— Creating an index on an integer-type column, then inserting a value which rounds to 1, causes result set mi... unknown — —
— Creating an index in between two NULL inserts causes inconsistent CERT result unknown — —
— BETWEEN malfunctions for DECIMAL and TEXT unknown — —

Every figure on this page is computed from _data/impact/. The attribution policy explains what has to be true for a bug to be counted.