← All database systems

CrateDB has no testing implementation in the main SQLancer repository. SQLancer is credited with 81 bugs in it, reported between 2023-09-11 and 2026-08-21. Its source is at crate/crate.

How the bugs break down

By year reported

2023
12
2024
25
2025
8
2026
25
Year not recorded
11

Who found them

Found by the SQLancer project
81

By status

Fixed
79
Confirmed
1
Open
1

By symptom

Unclassified
81

By technique

Technique not recorded
81

Why each bug counts

The reproducer carries SQLancer's generated schema
53
Filed by someone who runs SQLancer campaigns
28

Who reported them (6)

Suyang Zhong
31
suyZhong
20
wanteatfruit
13
Yibo-Dong
11
YuanchengJiang
3
Zhaokun Xiang
3

Every bug on record (81)

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
2026-08-21 `string_agg` leaves stale delimiters with row-dependent window delimiters fixed — Yibo-Dong
2026-08-21 UNION filter pushdown breaks branch types fixed — Yibo-Dong
2026-08-21 HashJoin keeps an intra-side predicate open — Yibo-Dong
2026-08-19 `CROSS JOIN … WHERE l.x = r.x` drops a correlated `Filter` after rewrite to HashJoin fixed — wanteatfruit
2026-08-19 REGEXP filter merged into `Collect` over an `INDEX OFF` text column matches no rows fixed — wanteatfruit
2026-08-18 `array_agg` ignores a running window frame fixed — Yibo-Dong
2026-08-18 `SMALLINT` `RANGE` window boundaries raise `ClassCastException` fixed — Yibo-Dong
2026-08-18 Outer filter pushdown changes window results fixed — Yibo-Dong
2026-08-14 `NULL = ALL (empty)` drops the row when the compared column is a window output fixed — wanteatfruit
2026-08-14 Inconsistent behavior of `starts_with(col, '')` on a TEXT column fixed — wanteatfruit
2026-08-13 `ROUND(x, N)` with a large-magnitude negative `N` hangs fixed — wanteatfruit
2026-08-13 UNION ALL with an empty equi-join branch makes ORDER BY leak rows fixed — wanteatfruit
2026-08-13 Range predicates on a `NUMERIC`/DECIMAL column with `INDEX OFF` silently return zero rows fixed — wanteatfruit
2026-08-04 `string_agg` over a single-row moving frame raises an internal error fixed — Yibo-Dong
2026-08-04 `UNION ALL` branch reading a relation with an extra column shifts column position fixed — wanteatfruit
2026-08-04 `FULL OUTER JOIN` returns wrong answer due to `optimizer_rewrite_filter_on_outer_join_to_inner_join` fixed — wanteatfruit
2026-08-04 `DESC RANGE` window frames can produce negative counts fixed — Yibo-Dong
2026-08-04 Window aggregate `FILTER` crashes when the filter predicate is `NULL` fixed — Yibo-Dong
2026-08-04 Window `sum` returns `0` for a frame containing only `NULL` fixed — Yibo-Dong
2026-08-04 Merge filter and move filter on a `PARTITIONED` table drop rows fixed — wanteatfruit
2026-08-04 LAG ignores a row-dependent offset expression fixed — Yibo-Dong
2026-08-03 `RANK()` / `DENSE_RANK()` with explicit frame returns wrong answer fixed — wanteatfruit
2026-08-03 UNION ALL + ORDER BY on an unselected column fails on `XX000` fixed — wanteatfruit
2026-07-31 `WHERE ` silently dropped when the column is projected with an alias through a join + ... fixed — wanteatfruit
2026-05-01 Unexpected ANTI JOIN Result fixed — Zhaokun Xiang
2025-12-19 Unexpected Inner Join Result fixed — Zhaokun Xiang
2025-10-11 Unexpected Left Join Result fixed — Zhaokun Xiang
2025-04-10 Unexpected result when using `IP` addresses fixed — suyZhong
2025-04-10 Unexpected result when querying a partitioned table by a `BOOLEAN` column fixed — suyZhong
2025-04-10 Unexpected result when comparing `CHAR` values with newline fixed — suyZhong
2025-02-09 Unexpected results when using `LEFT JOIN` with a subquery fixed — suyZhong
2025-02-09 Unexpected results when using `ARRAY_POSITION` fixed — suyZhong
2025-02-09 Unexpected results when querying `BOOLEAN` values fixed — suyZhong
2024-11-30 Unexpected result when using multiple `RIGHT JOIN` fixed — suyZhong
2024-11-11 Unexpected result when `RIGHT JOIN` a subquery fixed — suyZhong
2024-11-11 Potential hang when `LEFT JOIN` a subquery with `EXP` fixed — suyZhong
2024-11-01 Unexpected Results Using NULLIF with VARCHAR fixed — Suyang Zhong
2024-11-01 Unexpected Result when using LEFT JOIN fixed — Suyang Zhong
2024-11-01 Unexpected Result when using IN fixed — Suyang Zhong
2024-10-03 Unexpected result when comparing `FLOAT` in a partitioned table fixed — suyZhong
2024-09-29 Unexpected result when comparing `IP` fixed — suyZhong
2024-09-29 Unexpected result when comparing `CHAR` with `''` fixed — suyZhong
2024-09-25 OutOfMemory when creating table with large replicas fixed — suyZhong
2024-09-23 Unexpected result when using `ARRAY(TEXT)` in `IN` fixed — suyZhong
2024-09-12 Unexpected result when using bigint in `ORDER BY` fixed — suyZhong
2024-09-12 Unexpected result when querying partitioned table with `CASE WHEN` fixed — suyZhong
2024-09-02 Unexpected result when casting integer as boolean fixed — Suyang Zhong
2024-08-02 Unexpected result when using LTRIM with NULL as second argument fixed — Suyang Zhong
2024-03-22 Unexpected result when using LIKE fixed — Suyang Zhong
2024-02-27 Unexpected result when using INNER JOIN and CASE in filter fixed — Suyang Zhong
2024-02-22 Unexpected result when using OR fixed — Suyang Zhong
2024-02-16 Weird string substitution when using JDBC fixed — suyZhong
2024-02-02 Unexpected result when using `REPLACE` fixed — suyZhong
2024-02-02 Unexpected result when using `LTRIM` fixed — suyZhong
2024-02-02 Unexpected result when using % with NULL fixed — Suyang Zhong
2024-01-26 Unexpected results when using AND fixed — Suyang Zhong
2024-01-26 Unexpected result when using CONCAT_WS containing NULL fixed — Suyang Zhong
2024-01-18 Unexpected result when using string comparison AND IS NULL fixed — Suyang Zhong
2023-12-24 Unexpected Result when using IS NOT NULL fixed — Suyang Zhong
2023-12-16 Unexpected result when using BETWEEN AND fixed — Suyang Zhong
2023-12-16 Unexpected result when Concatenating NULL fixed — Suyang Zhong
2023-12-15 Inconsistent Results executing multiple statements at once fixed — suyZhong
2023-11-29 Unexpected Results Using NULLIF fixed — Suyang Zhong
2023-11-29 Unexpected Results Using Boolean fixed — Suyang Zhong
2023-11-22 Unexpected Results when Using Concat Operator fixed — Suyang Zhong
2023-11-14 Unexpected Results when Using AND Operator fixed — Suyang Zhong
2023-10-08 Unexpected Exception with `ORDER BY` clause with `UNION` fixed — YuanchengJiang
2023-10-05 Incorrect result returned by `UNION` fixed — YuanchengJiang
2023-10-05 Couldn't create execution plan from logical plan because of: Index 2 out of bounds for length 2 fixed — YuanchengJiang
2023-09-11 Unexpected result when using CASE statement fixed — Suyang Zhong
— Unexpected results when using system information functions fixed — Suyang Zhong
— Unexpected results when using OBJECT nulls fixed — Suyang Zhong
— Unexpected results when matching empty string with indexing disabled fixed — Suyang Zhong
— Unexpected result when using escape character in LIKE fixed — Suyang Zhong
— Unexpected result when using empty OBJECT literal fixed — Suyang Zhong
— Unexpected result when using PG_GET_PARTKEYDEF fixed — Suyang Zhong
— Unexpected result when using FORMAT_TYPE fixed — Suyang Zhong
— Unexpected result when using DEFAULT during creating table fixed — Suyang Zhong
— Unexpected result when using CURRENT_SETTING fixed — Suyang Zhong
— Unexpected result when querying with boolean comparisons fixed — Suyang Zhong
— Unexpected result when querying partitioned table with null values verified — 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.