← Bugs over time

SQLancer is credited with 193 bugs reported in 2024, across 18 database systems, between 2024-01-01 and 2024-12-28. A further 4 reports were filed that year and rejected by the developers as invalid or duplicate; those are kept in the dataset and counted nowhere.

Which systems (18)

Apache DataFusion
48
Umbra
28
MonetDB
26
CrateDB
25
Dolt
12
Virtuoso
11
DuckDB
9
CockroachDB
6
QuestDB
6
Databend
5
Firebird
4
Apache Doris
3
ClickHouse
2
Apache Cloudberry
2
CnosDB
2
H2
2
TiDB
1
YugabyteDB
1

Each system's own page carries its whole history rather than this year's share: Apache DataFusion, Umbra, MonetDB, CrateDB, Dolt, Virtuoso, and 12 more.

How they break down

Who found them

Found by the SQLancer project
136
Found by someone outside the project
57

By status

Fixed
181
Confirmed
3
Open
9

By symptom

Unclassified
193

By technique

Technique not recorded
172
Non-optimizing Reference Engine Construction (NoREC)
11
Ternary Logic Partitioning (TLP)
10

Why each bug counts

The reproducer carries SQLancer's generated schema
93
The report names SQLancer
52
Listed in the project's own bug repository
29
Filed by someone who runs SQLancer campaigns
14
The report names a SQLancer oracle
5

Who reported them

Suyang Zhong
87
2010YOUY01
47
suyZhong
33
Ming Wei Tan
5
malwaregarry
5
YuanchengJiang
4
cockroach-teamcity
3
Benxiaohai001
2

Every bug reported in 2024 (197)

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 System Status Reporter
2024-12-28 INTERNAL Error: ConstantFilter constant cannot be NULL - use IsNullFilter instead DuckDB fixed suyZhong
2024-12-02 Crash when INNER JOIN with VIEW MonetDB fixed Suyang Zhong
2024-12-01 Unexpected Abort Umbra fixed Suyang Zhong
2024-12-01 Assertion failure when using UNION ALL Umbra fixed Suyang Zhong
2024-11-30 Unexpected result when using multiple `RIGHT JOIN` CrateDB fixed suyZhong
2024-11-29 roachtest: incorrect geo results with tlp CockroachDB fixed cockroach-teamcity
2024-11-28 Performance of Query 63 in TPC-DS Benchmark CockroachDB open bajinsheng
2024-11-27 INTERNAL Error: Attempted to access index 0 within vector of size 0 DuckDB fixed suyZhong
2024-11-14 Unexpected result when using `INTERVAL` and `INNER JOIN` subquery DuckDB fixed suyZhong
2024-11-12 Performance of Query 7 on TPC-H Benchmark CockroachDB open bajinsheng
2024-11-11 Unexpected result when `RIGHT JOIN` a subquery CrateDB fixed suyZhong
2024-11-11 Potential hang when `LEFT JOIN` a subquery with `EXP` CrateDB fixed suyZhong
2024-11-01 Unexpected Results when Using LEFT JOIN with VIEW on IS NOT NULL Umbra fixed Suyang Zhong
2024-11-01 Unexpected Results Using NULLIF with VARCHAR CrateDB fixed Suyang Zhong
2024-11-01 Unexpected Result when using LEFT JOIN CrateDB fixed Suyang Zhong
2024-11-01 Unexpected Result when using IN CrateDB fixed Suyang Zhong
2024-10-26 Unexpected result when comparing `BLOB` DuckDB fixed suyZhong
2024-10-08 Panic in `simplify_expressions` optimizer rules when running an aggregate query (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-10-08 Panic in `nth_value` window function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-10-03 Unexpected result of comparison of nested types containing `NULL` DuckDB closed not a bug suyZhong
2024-10-03 Unexpected result when comparing `FLOAT` in a partitioned table CrateDB fixed suyZhong
2024-10-02 Unexpected result when using BETWEEN with BOOLEAN values MonetDB fixed Suyang Zhong
2024-10-02 Panic in scalar function `approx_percentile_cont_with_weight` (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-10-02 Incorrect NULL handling in `lead` window function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-10-01 Unexpected Results when Using Multiple Comparison Umbra fixed Suyang Zhong
2024-10-01 Segmentation fault when Using NATURAL FULL JOIN Umbra fixed Suyang Zhong
2024-10-01 Unexpected result when using CASE WHEN MonetDB fixed Suyang Zhong
2024-10-01 Unexpected result when using BETWEEN operator MonetDB fixed Suyang Zhong
2024-10-01 Unexpected result when using AND and IS NOT NULL MonetDB fixed Suyang Zhong
2024-10-01 Panic when an invalid expression in GROUP BY clause (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-09-29 Unexpected result when comparing `IP` CrateDB fixed suyZhong
2024-09-29 Unexpected result when comparing `CHAR` with `''` CrateDB fixed suyZhong
2024-09-25 Internal error thrown in select query QuestDB fixed Ming Wei Tan
2024-09-25 OutOfMemory when creating table with large replicas CrateDB fixed suyZhong
2024-09-23 Crash when using `CHECK` constraint MonetDB fixed suyZhong
2024-09-23 Unexpected result when using `ARRAY(TEXT)` in `IN` CrateDB fixed suyZhong
2024-09-19 Unexpected result when casting `TIMESTAMP_S` to `TIME` DuckDB fixed suyZhong
2024-09-18 NULL record not retrieved if NULL is in WHERE clause QuestDB verified Ming Wei Tan
2024-09-15 `Utf8View` column produced incorrect result in a natural join query (SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-09-15 roachtest: tlp failed CockroachDB fixed cockroach-teamcity
2024-09-14 INTERNAL Error: Attempted to dereference unique_ptr that is NULL DuckDB fixed suyZhong
2024-09-13 Unexpected result when comparing `STRUCT` with `INET` DuckDB fixed suyZhong
2024-09-13 Unexpected result when using a record in WHERE filter CockroachDB fixed suyZhong
2024-09-13 Inconsistent representation of bool values ClickHouse open suyZhong
2024-09-12 Inconsistent results when casting `BIT` and `VARBINARY` DuckDB fixed suyZhong
2024-09-12 Unexpected result when using bigint in `ORDER BY` CrateDB fixed suyZhong
2024-09-12 Unexpected result when querying partitioned table with `CASE WHEN` CrateDB fixed suyZhong
2024-09-10 Unexpected result after creating index on `DATE` column DuckDB fixed suyZhong
2024-09-07 Assertion failure at `rel2bin_select` when using `STARTSWITH` MonetDB fixed suyZhong
2024-09-05 A join SQL query with ambiguous table reference executes without error (SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-09-04 Bug in `nth_value()` window function for `NULL` input (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-09-02 Unexpected results when using string concatenation for INTEGER Firebird fixed Suyang Zhong
2024-09-02 Unexpected error and crash after creating a partial index Firebird fixed Suyang Zhong
2024-09-02 Unexpected result when casting integer as boolean CrateDB fixed Suyang Zhong
2024-08-24 `octet_length()` function not working for StringView columns (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-24 Internal error in `regexp_replace()` for some StringView input (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-23 Panic in `substring()` scalar function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-23 [Bug] Error found by sqlancer Apache Cloudberry fixed shmiwy
2024-08-23 [Bug] Error detected by sqlancer Apache Cloudberry fixed shmiwy
2024-08-20 Panic in `NTH_VALUE()` window function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-20 A simple count() query caused Internal Error in PhysicalOptimizer (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-19 SQL query with window function `PARTITION BY` caused panic in 'tokio-runtime-worker' (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-19 Internal Error in `APPROX_PERCENTILE_CONT` window function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-15 Panics in `MIN()/MAX()` aggregate functions (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-15 Invalid aggregate SQL query with `HAVING` can be executed without error (SQLancer-TLP) Apache DataFusion fixed 2010YOUY01
2024-08-15 Internal error in `approx_percentile_cont()` aggregate function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-07 `ILIKE` string operator not working for `NULL` literal (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-07 Crash bug in `APPROX_PERCENTILE_CONT` aggregate function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-07 Crash bug in `APPROX_PERCENTILE_CONT_WITH_WEIGHT` aggregate function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-07 Crash bug in `APPROX_MEDIAN` aggregate function (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-08-03 Unexpected result when using IFNULL with large numbers MonetDB fixed Suyang Zhong
2024-08-02 Unexpected results when using logical operator in VIEW Umbra fixed Suyang Zhong
2024-08-02 Unexpected result when using LTRIM with NULL as second argument CrateDB fixed Suyang Zhong
2024-08-01 Unexpected Results when Using IN and BETWEEN AND for VIEW Umbra fixed Suyang Zhong
2024-08-01 FATAL ERROR when Using NATURAL FULL JOIN Umbra fixed Suyang Zhong
2024-07-31 Scalar NULL literal in aggregate functions are not supported (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-31 Incorrect result returned by a group by query (SQLancer-TLP) Apache DataFusion fixed 2010YOUY01
2024-07-31 Incorrect result returned by `UNION ALL` (SQLancer-TLP) Apache DataFusion fixed 2010YOUY01
2024-07-29 Incorrect result returned by a NLJ query with filter (SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-07-28 roachtest: tlp failure: false vs NULL CockroachDB fixed cockroach-teamcity
2024-07-25 Adding condition that is true we get no result from a table ClickHouse fixed qoega
2024-07-24 A valid SQL query returned 'Schema error: ...' (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-23 Internal error when regex operator `~` is used with `List`s (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-23 Incorrect predicate evaluation result in a query (SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-07-23 Incorrect `NULL` handling for regex match `~` (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-21 Unexpected result when using range comparison with `NULL` MonetDB fixed suyZhong
2024-07-20 Internal error when there is a bitwise operation in `order by` clause (SQLancer) Apache DataFusion open 2010YOUY01
2024-07-19 Query with `order by acos(sin(v1))` panic (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-19 Crash bug when `log()` is used in `order by` clause (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-11 LEFT/RIGHT OUTER JOIN failed to detect ambiguous column reference (SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-07-11 Internal Error for an INNER JOIN query (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-11 Crash bug from an inner join query (SQLancer) Apache DataFusion fixed 2010YOUY01
2024-07-11 A projection pushdown related bug (SQLancer-TLP) Apache DataFusion fixed 2010YOUY01
2024-07-05 Incorrect result for a Nested Loop Join query (Found by SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-07-04 `bitwise*` operators won't check arguments type when short circuited (Found by SQLancer-NoREC) Apache DataFusion open 2010YOUY01
2024-07-04 Non-deterministic `SUM()` aggregate function result (found by SQLancer-TLP) Apache DataFusion fixed 2010YOUY01
2024-07-04 Bug in Nested Loop Join (Found by SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-07-03 `where` clause incorrectly reject `NULL` literal (by SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-07-03 Error evaluating clause `where COL_BIGINT < 1e100` (Found by SQLancer-NoREC) Apache DataFusion fixed 2010YOUY01
2024-07-02 Unexpected results when using ORDER BY Virtuoso fixed Suyang Zhong
2024-07-02 Unexpected results after creating partial index Firebird fixed Suyang Zhong
2024-07-01 Unexpected Results when Using IN and BETWEEN AND for VIEW Umbra fixed Suyang Zhong
2024-07-01 Unexpected Results when Using CAST Umbra fixed Suyang Zhong
2024-06-27 [BUG][sqlancer]Query results are inconsistent CnosDB fixed Benxiaohai001
2024-06-26 Unexpected result when using `IS DISTINCT FROM` with constants MonetDB fixed suyZhong
2024-06-26 [BUG]During data writing, the insert statement deadlocks CnosDB fixed Benxiaohai001
2024-06-23 Tracking issue: Overflow bugs in scalar math functions found by SQLancer Apache DataFusion fixed LorrensP-2158466
2024-06-23 Overflow bug in negate arithmetic operator (found by SQLancer) Apache DataFusion fixed 2010YOUY01
2024-06-23 Overflow bug in POW scalar function (found by SQLancer) Apache DataFusion fixed 2010YOUY01
2024-06-23 Overflow bug in FACTORIAL scalar function (found by SQLancer) Apache DataFusion fixed 2010YOUY01
2024-06-23 bug: Overflow / divide by zero exceptions not detected in where clause Databend fixed malwaregarry
2024-06-23 Mismatch between SUM and AVERAGE due to optimisation Databend fixed Ming Wei Tan
2024-06-20 Bugs in LCM/GCD scalar functions (found by SQLancer) Apache DataFusion fixed 2010YOUY01
2024-06-09 [Bug] Error: num_columns!=merged_columns.size(), num_columns=3, merged_columns.size()=2 Apache Doris fixed malwaregarry
2024-06-09 [Bug] Bug with BIGINT boundary values Apache Doris fixed malwaregarry
2024-06-02 Unexpected result when using NULLIF and CAST in VIEW Umbra fixed Suyang Zhong
2024-06-02 Unexpected result when using LEFT JOIN and NULL values Umbra fixed Suyang Zhong
2024-06-01 Unexpected Results when Using NOT IN expression Umbra fixed Suyang Zhong
2024-06-01 Unexpected Results when Using IS NULL with empty VIEW Umbra fixed Suyang Zhong
2024-05-26 [Bug] Expression evaluate to NULL but is treated as FALSE in where clause Apache Doris fixed malwaregarry
2024-05-24 Unexpected result when using `IS DISTINCT FROM` MonetDB fixed suyZhong
2024-05-21 Incorrect result with window function and table joins QuestDB open YuanchengJiang
2024-05-21 Incorrect result when having NULL within the CASE...WHEN clause QuestDB open YuanchengJiang
2024-05-18 bug: WHERE clause not working as expected with null column values and string functions (`like`, `... Databend fixed malwaregarry
2024-05-18 `FALSE AND exp1 OR exp1` in WHERE clause results in Lost connection from server Databend fixed Ming Wei Tan
2024-05-18 WHERE clause not working as expected with NOT Databend fixed Ming Wei Tan
2024-05-18 Decimal overflow conversion error Databend unknown Ming Wei Tan
2024-05-15 Incorrect result when having null in case clause QuestDB fixed YuanchengJiang
2024-05-13 Incorrect result when having NULL with IN operation QuestDB fixed YuanchengJiang
2024-05-02 Unexpected results when using CASE WHEN with RIGHT JOIN Firebird fixed Suyang Zhong
2024-05-01 Unexpected Results when Using BETWEEN AND after CREATE INDEX Dolt fixed Suyang Zhong
2024-05-01 Unexpected Result when Querying with CONCAT Dolt fixed Suyang Zhong
2024-05-01 Panic when Using INNER JOIN with String in IN Dolt fixed Suyang Zhong
2024-04-11 OPTIMIZE TABLE t0 NOWAIT results in Got error -2 "Internal error < 0 (Not system error)" from sto... MariaDB closed duplicate Tan Ming Wei
2024-04-02 Unexpected result when using LEFT JOIN and VIEW Umbra fixed Suyang Zhong
2024-04-02 Crash when using INNER JOIN Umbra fixed Suyang Zhong
2024-04-01 Unexpected results when Using IN expression With INDEX Umbra fixed Suyang Zhong
2024-04-01 Unexpected results when Using BETWEEN With VIEW Umbra fixed Suyang Zhong
2024-04-01 Unexpected Result when Using -'' in IN Dolt fixed Suyang Zhong
2024-03-22 Unexpected result when using LIKE CrateDB fixed Suyang Zhong
2024-03-15 Unexpected results when using INNER JOIN and UNION Virtuoso fixed Suyang Zhong
2024-03-14 Unexpected results when using LEFT JOIN and UNION Virtuoso fixed Suyang Zhong
2024-03-14 Crash by CASE WHEN Virtuoso fixed Suyang Zhong
2024-03-13 Crash when using CONTAINS MonetDB fixed Suyang Zhong
2024-03-06 [YSQL][SQLancer] OOM handle related code in PG core dumps during test execution YugabyteDB open qvad
2024-03-01 Panic when Using INNER JOIN Dolt fixed Suyang Zhong
2024-02-27 Unexpected result when using NULL in BETWEEN MonetDB fixed Suyang Zhong
2024-02-27 Crash when INNER JOIN with CONTAINS MonetDB fixed Suyang Zhong
2024-02-27 Unexpected result when using INNER JOIN and CASE in filter CrateDB fixed Suyang Zhong
2024-02-22 Unexpected result when using CONTAINS and type casting MonetDB fixed Suyang Zhong
2024-02-22 Crash when using BETWEEN AND MonetDB fixed Suyang Zhong
2024-02-22 Unexpected result when using OR CrateDB fixed Suyang Zhong
2024-02-21 Unexpected results when using newline in string Firebird closed not a bug suyZhong
2024-02-20 Crash when using CAST and BETWEEN AND MonetDB fixed Suyang Zhong
2024-02-20 Crash by potentially use of bad escape characters MonetDB fixed Suyang Zhong
2024-02-19 Unexpected result when using SIGN MonetDB fixed Suyang Zhong
2024-02-19 Crash when using CONTAINS in ORDER BY clause MonetDB fixed Suyang Zhong
2024-02-18 Unexpected result when using AND with INTEGER MonetDB fixed Suyang Zhong
2024-02-18 Crash by IF and CHAR Dolt fixed Suyang Zhong
2024-02-16 Weird string substitution when using JDBC CrateDB fixed suyZhong
2024-02-07 Potential issue when multi-threading testing using virtuoso jdbc driver Virtuoso open suyZhong
2024-02-02 Unexpected result when using `REPLACE` CrateDB fixed suyZhong
2024-02-02 Unexpected result when using `LTRIM` CrateDB fixed suyZhong
2024-02-02 Unexpected result when using % with NULL CrateDB fixed Suyang Zhong
2024-02-01 Unexpected results when Using RIGHT JOIN Virtuoso fixed Suyang Zhong
2024-02-01 Unexpected result for INNER JOIN with IS NOT NULL MonetDB fixed Suyang Zhong
2024-01-31 Unexpected result when using BETWEEN and CAST MonetDB fixed Suyang Zhong
2024-01-31 Unexpected result when CREATE VIEW with WHERE NULL MonetDB fixed Suyang Zhong
2024-01-26 Unexpected results when using AND CrateDB fixed Suyang Zhong
2024-01-26 Unexpected result when using CONCAT_WS containing NULL CrateDB fixed Suyang Zhong
2024-01-25 Unexpected result when using trigonomeric functions H2 fixed Suyang Zhong
2024-01-25 Potential issue when using `ROUND` H2 fixed suyZhong
2024-01-24 Unexpected result when using BETWEEN in INNER JOIN MonetDB fixed Suyang Zhong
2024-01-24 Unexpected result when using AND/OR chain MonetDB fixed Suyang Zhong
2024-01-19 Unexpected results when using LEFT JOIN with NULL as predicate Virtuoso fixed Suyang Zhong
2024-01-19 Crash by CASE WHEN and unknown identifier Virtuoso fixed Suyang Zhong
2024-01-19 Unexpected results when comparing string with type conversion Dolt verified Suyang Zhong
2024-01-19 Crash by INNER JOIN Dolt fixed Suyang Zhong
2024-01-18 ERROR: AddressSanitizer: use-after-poison Umbra fixed Suyang Zhong
2024-01-18 Assertion failure when using COALESCE and CASE WHEN Umbra fixed Suyang Zhong
2024-01-18 Unexpected result when using string comparison AND IS NULL CrateDB fixed Suyang Zhong
2024-01-17 Runtime error when using overflow integers TiDB verified Suyang Zhong
2024-01-17 Unexpected result when using Boolean in IN Dolt fixed Suyang Zhong
2024-01-16 Crash when using BETWEEN operator and large integer Umbra fixed Suyang Zhong
2024-01-16 Unexpected results when comparing with empty string Dolt fixed Suyang Zhong
2024-01-15 Unexpected results when using NATURAL RIGHT JOIN with INDEX Umbra fixed Suyang Zhong
2024-01-15 ERROR: AddressSanitizer: stack-buffer-overflow Umbra fixed Suyang Zhong
2024-01-15 Assertion failure when using COT and BETWEEN AND Umbra fixed Suyang Zhong
2024-01-14 Unexpected results when using trigonometric functions Virtuoso fixed Suyang Zhong
2024-01-14 Unexpected results when using math functions Virtuoso fixed suyZhong
2024-01-14 Unexpected Results when using LEFT JOIN with NULL Virtuoso fixed Suyang Zhong
2024-01-14 Unexpected results when Casting to VARCHAR Umbra fixed Suyang Zhong
2024-01-13 Unexpected results when Using COS and IN expression Umbra fixed Suyang Zhong
2024-01-13 Assertion failure when using NATURAL JOIN Umbra fixed Suyang Zhong
2024-01-04 Unexpected Result when Using `-''` in `IN` Dolt fixed suyZhong
2024-01-01 Segmentation fault when Using NATURAL FULL JOIN Umbra fixed Suyang Zhong
2024-01-01 Unexpected Results when Using BETWEEN and LEFT JOIN Dolt fixed Suyang Zhong

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.