← All database systems

Apache DataFusion is supported by SQLancer — the main repository ships a testing implementation for it. SQLancer is credited with 54 bugs in it, reported between 2024-06-20 and 2025-09-08. Its source is at apache/datafusion.

How the project uses SQLancer

Official testing

The Apache DataFusion project maintains SQLancer testing setup in its own repository (docs/source/contributor-guide/testing.md).

DataFusion uses the [SQLancer] for "fuzz" testing: it generates random SQL queries and execute them against DataFusion to find bugs.
docs/source/contributor-guide/testing.md in the Apache DataFusion repository states that the project uses SQLancer.
docs/source/contributor-guide/testing.md last verified 2026-09-13

How the bugs break down

By year reported

2024
48
2025
6

Who found them

Found by someone outside the project
54

By status

Fixed
52
Open
2

By symptom

Unclassified
54

By technique

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

Why each bug counts

The report names SQLancer
54

Who reported them (2)

2010YOUY01
53
LorrensP-2158466
1

Every bug on record (54)

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
2025-09-08 Incorrect null literal handling for `to_local_time()` function (SQLancer) fixed — 2010YOUY01
2025-09-03 Schema error in a query with `RIGHT ANTI JOIN` (SQLancer) fixed — 2010YOUY01
2025-09-03 Incorrect null handling for `%` operator (SQLancer) fixed — 2010YOUY01
2025-07-13 Arithmetic expression on `Date` type with `Null` returns planning error (SQLancer) fixed — 2010YOUY01
2025-07-05 Panic happens when adding a decimal256 to a float (SQLancer) fixed — 2010YOUY01
2025-01-06 Panic in a query with NATURAL JOIN (SQLancer) fixed — 2010YOUY01
2024-10-08 Panic in `simplify_expressions` optimizer rules when running an aggregate query (SQLancer) fixed — 2010YOUY01
2024-10-08 Panic in `nth_value` window function (SQLancer) fixed — 2010YOUY01
2024-10-02 Panic in scalar function `approx_percentile_cont_with_weight` (SQLancer) fixed — 2010YOUY01
2024-10-02 Incorrect NULL handling in `lead` window function (SQLancer) fixed — 2010YOUY01
2024-10-01 Panic when an invalid expression in GROUP BY clause (SQLancer) fixed — 2010YOUY01
2024-09-15 `Utf8View` column produced incorrect result in a natural join query (SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-09-05 A join SQL query with ambiguous table reference executes without error (SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-09-04 Bug in `nth_value()` window function for `NULL` input (SQLancer) fixed — 2010YOUY01
2024-08-24 `octet_length()` function not working for StringView columns (SQLancer) fixed — 2010YOUY01
2024-08-24 Internal error in `regexp_replace()` for some StringView input (SQLancer) fixed — 2010YOUY01
2024-08-23 Panic in `substring()` scalar function (SQLancer) fixed — 2010YOUY01
2024-08-20 Panic in `NTH_VALUE()` window function (SQLancer) fixed — 2010YOUY01
2024-08-20 A simple count() query caused Internal Error in PhysicalOptimizer (SQLancer) fixed — 2010YOUY01
2024-08-19 SQL query with window function `PARTITION BY` caused panic in 'tokio-runtime-worker' (SQLancer) fixed — 2010YOUY01
2024-08-19 Internal Error in `APPROX_PERCENTILE_CONT` window function (SQLancer) fixed — 2010YOUY01
2024-08-15 Panics in `MIN()/MAX()` aggregate functions (SQLancer) fixed — 2010YOUY01
2024-08-15 Invalid aggregate SQL query with `HAVING` can be executed without error (SQLancer-TLP) fixed TLP 2010YOUY01
2024-08-15 Internal error in `approx_percentile_cont()` aggregate function (SQLancer) fixed — 2010YOUY01
2024-08-07 `ILIKE` string operator not working for `NULL` literal (SQLancer) fixed — 2010YOUY01
2024-08-07 Crash bug in `APPROX_PERCENTILE_CONT` aggregate function (SQLancer) fixed — 2010YOUY01
2024-08-07 Crash bug in `APPROX_PERCENTILE_CONT_WITH_WEIGHT` aggregate function (SQLancer) fixed — 2010YOUY01
2024-08-07 Crash bug in `APPROX_MEDIAN` aggregate function (SQLancer) fixed — 2010YOUY01
2024-07-31 Scalar NULL literal in aggregate functions are not supported (SQLancer) fixed — 2010YOUY01
2024-07-31 Incorrect result returned by a group by query (SQLancer-TLP) fixed TLP 2010YOUY01
2024-07-31 Incorrect result returned by `UNION ALL` (SQLancer-TLP) fixed TLP 2010YOUY01
2024-07-29 Incorrect result returned by a NLJ query with filter (SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-07-24 A valid SQL query returned 'Schema error: ...' (SQLancer) fixed — 2010YOUY01
2024-07-23 Internal error when regex operator `~` is used with `List`s (SQLancer) fixed — 2010YOUY01
2024-07-23 Incorrect predicate evaluation result in a query (SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-07-23 Incorrect `NULL` handling for regex match `~` (SQLancer) fixed — 2010YOUY01
2024-07-20 Internal error when there is a bitwise operation in `order by` clause (SQLancer) open — 2010YOUY01
2024-07-19 Query with `order by acos(sin(v1))` panic (SQLancer) fixed — 2010YOUY01
2024-07-19 Crash bug when `log()` is used in `order by` clause (SQLancer) fixed — 2010YOUY01
2024-07-11 LEFT/RIGHT OUTER JOIN failed to detect ambiguous column reference (SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-07-11 Internal Error for an INNER JOIN query (SQLancer) fixed — 2010YOUY01
2024-07-11 Crash bug from an inner join query (SQLancer) fixed — 2010YOUY01
2024-07-11 A projection pushdown related bug (SQLancer-TLP) fixed TLP 2010YOUY01
2024-07-05 Incorrect result for a Nested Loop Join query (Found by SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-07-04 `bitwise*` operators won't check arguments type when short circuited (Found by SQLancer-NoREC) open NOREC 2010YOUY01
2024-07-04 Non-deterministic `SUM()` aggregate function result (found by SQLancer-TLP) fixed TLP 2010YOUY01
2024-07-04 Bug in Nested Loop Join (Found by SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-07-03 `where` clause incorrectly reject `NULL` literal (by SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-07-03 Error evaluating clause `where COL_BIGINT < 1e100` (Found by SQLancer-NoREC) fixed NOREC 2010YOUY01
2024-06-23 Tracking issue: Overflow bugs in scalar math functions found by SQLancer fixed — LorrensP-2158466
2024-06-23 Overflow bug in negate arithmetic operator (found by SQLancer) fixed — 2010YOUY01
2024-06-23 Overflow bug in POW scalar function (found by SQLancer) fixed — 2010YOUY01
2024-06-23 Overflow bug in FACTORIAL scalar function (found by SQLancer) fixed — 2010YOUY01
2024-06-20 Bugs in LCM/GCD scalar functions (found by SQLancer) fixed — 2010YOUY01

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.