← All database systems

MonetDB has no testing implementation in the main SQLancer repository. SQLancer is credited with 139 bugs in it, reported between 2020-11-30 and 2026-08-17. Its source is at MonetDB/MonetDB.

A further 1 report was 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 project uses SQLancer

Official testing

The MonetDB project maintains its own SQLancer fork, 279 commit(s) ahead of upstream, last updated 2023-02-27.

sqlancer01
sql/test/SQLancer/Tests/All in the MonetDB repository is part of a SQLancer setup the project maintains.
sql/test/SQLancer/Tests/All last verified 2026-09-13
test -- sql/test/SQLancer/Tests/sqlancer05.
sql/test/Tests/orderby-nulls-first-last.test in the MonetDB repository states that the project uses SQLancer.
sql/test/Tests/orderby-nulls-first-last.test last verified 2026-09-13
MonetDB/sqlancer is a fork of sqlancer/sqlancer under the MonetDB project's own GitHub organisation, 279 commit(s) ahead of upstream.
/github.com/MonetDB/sqlancer last verified 2026-09-13

How the bugs break down

By year reported

2020
41
2024
26
2025
32
2026
19
Year not recorded
21

Who found them

Found by the SQLancer project
97
Found by someone outside the project
42

By status

Fixed
124
Open
15

By symptom

Unclassified
139

By technique

Technique not recorded
136
Ternary Logic Partitioning (TLP)
3

Why each bug counts

The reproducer carries SQLancer's generated schema
114
Filed by someone who runs SQLancer campaigns
24
The report names SQLancer
1

Who reported them (7)

Suyang Zhong
42
monetdb-team
41
Zhaokun Xiang
29
Yibo-Dong
18
suyZhong
5
TheoristCoder
3
fyr03
1

Every bug on record (140)

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-17 `prod` treats an all-NULL input differently from an empty input open — Yibo-Dong
2026-08-17 `field()` function returns multiple rows when the searched value appears more than once fixed — Yibo-Dong
2026-08-17 `NTH_VALUE` with a row-dependent `nth` returns a non-NULL value when the requested row is missing open — Yibo-Dong
2026-08-17 `LAG`/`LEAD` reuse the first default expression value at partition boundaries open — Yibo-Dong
2026-08-17 Window `GROUP_CONCAT` ignores aggregate `ORDER BY` open — Yibo-Dong
2026-08-17 Value functions lose an unordered `RANGE CURRENT ROW` frame open — Yibo-Dong
2026-08-17 Numeric `RANGE` frames cross interleaved partitions open — Yibo-Dong
2026-08-17 Numeric `RANGE NULLS LAST` includes the wrong rows open — Yibo-Dong
2026-08-09 `RANK() <= constant` drops rows tied at the cutoff rank open — Yibo-Dong
2026-08-09 Windowed `AVG` mis-merges a wide bounded frame open — Yibo-Dong
2026-08-09 Window `GROUP_CONCAT` mishandles a NULL separator fixed — Yibo-Dong
2026-08-09 ASC temporal `RANGE` frames mishandle NULL order keys open — Yibo-Dong
2026-08-06 `WHERE` treats an UNKNOWN boolean expression as true fixed — Yibo-Dong
2026-08-06 `RIGHT` returns the empty string for a one-character UTF-8 input open — Yibo-Dong
2026-08-06 `QUALIFY` with inline `ROW_NUMBER` leaks an `ORDER BY` column and filters the wrong rows open — Yibo-Dong
2026-08-05 `RANGE CURRENT ROW` ignores peer rows open — Yibo-Dong
2026-08-05 `NOT` over a false self-comparison returns `false` fixed — Yibo-Dong
2026-08-05 Dynamic `LAG` offset is ignored and behaves like offset 0 open — Yibo-Dong
2026-05-23 DECIMAL column values incorrectly returned as 0 in large JOIN result sets when connecting via pymonetdb open — fyr03
2025-12-09 Unexpected Anti Join Result fixed — Zhaokun Xiang
2025-11-29 Unexpected SEMI Join Result fixed — Zhaokun Xiang
2025-11-26 Unexpected ANTI JOIN Result fixed — Zhaokun Xiang
2025-11-07 Bug Report: Incorrect Boolean Expression Evaluation in WHERE Clause closed not a bug TLP AldonahZero
2025-10-24 Unexpected Error in Join fixed — Zhaokun Xiang
2025-10-23 Unexpected Crash in Left Join fixed — Zhaokun Xiang
2025-09-22 Unexpected Anti Join Result fixed — Zhaokun Xiang
2025-09-20 Unexpected Anti Join Result fixed — Zhaokun Xiang
2025-09-18 Unexpected Out of Memory fixed — Zhaokun Xiang
2025-09-18 Unexpected Crash fixed — TheoristCoder
2025-09-17 Unexpected Join Result fixed — Zhaokun Xiang
2025-09-13 Unexpected Right Join Result fixed — Zhaokun Xiang
2025-08-30 Unexpected execution result fixed — Zhaokun Xiang
2025-06-24 Incorrect Inner Join Result fixed — Zhaokun Xiang
2025-06-24 Incorrect Anti Join Result related to optimization fixed — Zhaokun Xiang
2025-06-24 Incorrect Anti Join Result fixed — Zhaokun Xiang
2025-06-19 Unexpected Right Join Crash fixed — Zhaokun Xiang
2025-06-19 Unexpected Right Join Assertion Error fixed — Zhaokun Xiang
2025-06-19 Unexpected Inner Join Crash fixed — Zhaokun Xiang
2025-06-13 Unexpected anti join crash fixed — TheoristCoder
2025-06-13 Unexpected Left Join Crash fixed — Zhaokun Xiang
2025-06-13 Unexpected Internal Error in Inner Join fixed — TheoristCoder
2025-06-11 Unexpected Execution Results fixed — Zhaokun Xiang
2025-05-19 Unexpected Inner Join Crash fixed — Zhaokun Xiang
2025-05-19 Unexpected Anti Join Crash fixed — Zhaokun Xiang
2025-05-19 Join with subquery crash fixed — Zhaokun Xiang
2025-05-18 Unexpected Out of Memory of Inner Join fixed — Zhaokun Xiang
2025-05-18 Unexpected Left Join Crash fixed — Zhaokun Xiang
2025-05-09 Unexpected Left Join Result fixed — Zhaokun Xiang
2025-04-09 Unexpected Right Join Result fixed — Zhaokun Xiang
2025-03-09 Unexpected execution result fixed — Zhaokun Xiang
2025-02-09 Unexpected execution result fixed — Zhaokun Xiang
2025-01-09 Unexpected execution result fixed — Zhaokun Xiang
2024-12-02 Crash when INNER JOIN with VIEW fixed — Suyang Zhong
2024-10-02 Unexpected result when using BETWEEN with BOOLEAN values fixed — Suyang Zhong
2024-10-01 Unexpected result when using CASE WHEN fixed — Suyang Zhong
2024-10-01 Unexpected result when using BETWEEN operator fixed — Suyang Zhong
2024-10-01 Unexpected result when using AND and IS NOT NULL fixed — Suyang Zhong
2024-09-23 Crash when using `CHECK` constraint fixed — suyZhong
2024-09-07 Assertion failure at `rel2bin_select` when using `STARTSWITH` fixed — suyZhong
2024-08-03 Unexpected result when using IFNULL with large numbers fixed — Suyang Zhong
2024-07-21 Unexpected result when using range comparison with `NULL` fixed — suyZhong
2024-06-26 Unexpected result when using `IS DISTINCT FROM` with constants fixed — suyZhong
2024-05-24 Unexpected result when using `IS DISTINCT FROM` fixed — suyZhong
2024-03-13 Crash when using CONTAINS fixed — Suyang Zhong
2024-02-27 Unexpected result when using NULL in BETWEEN fixed — Suyang Zhong
2024-02-27 Crash when INNER JOIN with CONTAINS fixed — Suyang Zhong
2024-02-22 Unexpected result when using CONTAINS and type casting fixed — Suyang Zhong
2024-02-22 Crash when using BETWEEN AND fixed — Suyang Zhong
2024-02-20 Crash when using CAST and BETWEEN AND fixed — Suyang Zhong
2024-02-20 Crash by potentially use of bad escape characters fixed — Suyang Zhong
2024-02-19 Unexpected result when using SIGN fixed — Suyang Zhong
2024-02-19 Crash when using CONTAINS in ORDER BY clause fixed — Suyang Zhong
2024-02-18 Unexpected result when using AND with INTEGER fixed — Suyang Zhong
2024-02-01 Unexpected result for INNER JOIN with IS NOT NULL fixed — Suyang Zhong
2024-01-31 Unexpected result when using BETWEEN and CAST fixed — Suyang Zhong
2024-01-31 Unexpected result when CREATE VIEW with WHERE NULL fixed — Suyang Zhong
2024-01-24 Unexpected result when using BETWEEN in INNER JOIN fixed — Suyang Zhong
2024-01-24 Unexpected result when using AND/OR chain fixed — Suyang Zhong
2020-11-30 Wrong result when dividing interval by literal float fixed — monetdb-team
2020-11-30 Some MAL function are mapped incorrectly fixed — monetdb-team
2020-11-30 Segfault on large chain of constant decimal multiplication fixed — monetdb-team
2020-11-30 SQLancer query: batcalc.between undefined fixed — monetdb-team
2020-11-30 SQLancer query: 'calc.bit' undefined fixed — monetdb-team
2020-11-30 SQLancer query: 'bat.append' undefined fixed — monetdb-team
2020-11-30 SQLancer query with wrong results fixed — monetdb-team
2020-11-30 SQLancer query with wrong results fixed — monetdb-team
2020-11-30 SQLancer query with wrong results fixed — monetdb-team
2020-11-30 SQLancer query copy on unique pair of columns fails and complex query with GDK error fixed — monetdb-team
2020-11-30 SQLancer query compilation error fixed — monetdb-team
2020-11-30 SQLancer project_bte: does not match always fixed — monetdb-team
2020-11-30 SQLancer insert function doesn't handle utf-8 strings fixed — monetdb-team
2020-11-30 SQLancer inputs not the same size fixed — monetdb-team
2020-11-30 SQLancer inputs not the same size fixed — monetdb-team
2020-11-30 SQLancer inner join reporting GDK error fixed — monetdb-team
2020-11-30 SQLancer generates query with unclear error message fixed — monetdb-team
2020-11-30 SQLancer generated SIGFPE fixed — monetdb-team
2020-11-30 SQLancer distinct aggregate with error on group by constant fixed — monetdb-team
2020-11-30 SQLancer crash on rtrim function fixed — monetdb-team
2020-11-30 SQLancer crash on query with HAVING fixed — monetdb-team
2020-11-30 SQLancer crash on long query fixed — monetdb-team
2020-11-30 SQLancer crash on join with coalesce fixed — monetdb-team
2020-11-30 SQLancer crash on join query fixed — monetdb-team
2020-11-30 SQLancer crash on delete query fixed — monetdb-team
2020-11-30 SQLancer crash on cross join on view fixed — monetdb-team
2020-11-30 SQLancer crash on complex query fixed — monetdb-team
2020-11-30 SQLancer crash on complex join fixed — monetdb-team
2020-11-30 SQLancer crash on coalesce fixed — monetdb-team
2020-11-30 SQLancer causing 'algebra.select' undefined error fixed — monetdb-team
2020-11-30 SQLancer causes assertion error on UTF8_strlen fixed — monetdb-team
2020-11-30 SQLancer calc.date undefined fixed — monetdb-team
2020-11-30 SQLancer calc.abs undefined fixed — monetdb-team
2020-11-30 SQLancer alter table add unique gives strange error message fixed — monetdb-team
2020-11-30 SQLancer algebra.select' undefined 2 fixed — monetdb-team
2020-11-30 SQLancer algebra.select undefined fixed — monetdb-team
2020-11-30 SQLancer aggr.subavg undefined fixed — monetdb-team
2020-11-30 SQLancer TLP query with wrong results 3 fixed TLP monetdb-team
2020-11-30 SQLancer TLP query with wrong results 2 fixed TLP monetdb-team
2020-11-30 SQLancer TLP query with wrong results fixed TLP monetdb-team
2020-11-30 Query randomly failing with Object not found fixed — monetdb-team
— Unexpected result when using STARTSWITH fixed — Suyang Zhong
— Unexpected result when using NULL constant in comparison fixed — Suyang Zhong
— Unexpected result when using LEVENSHTEIN fixed — Suyang Zhong
— Unexpected result when using IS DISTINCT FROM with RIGHT JOIN fixed — Suyang Zhong
— Unexpected result when using IS DISTINCT FROM with AND fixed — Suyang Zhong
— Unexpected result when using IS DISTINCT FROM in VIEW fixed — Suyang Zhong
— Unexpected result when casting integer to boolean in comparison fixed — Suyang Zhong
— Unexpected error when using NATURAL RIGHT JOIN fixed — Suyang Zhong
— Crash when using IS DISTINCT FROM with SIN fixed — Suyang Zhong
— Crash when integer overflow in ORDER BY fixed — Suyang Zhong
— Crash when creating view with HAVING fixed — Suyang Zhong
— Crash when creating view with GROUP BY fixed — Suyang Zhong
— Crash at strcpy_len () fixed — Suyang Zhong
— Assertion failure when using STARTSWITH with view fixed — Suyang Zhong
— Assertion failure when using STARTSWITH fixed — Suyang Zhong
— Assertion failure when using JAROWINKLER with empty string fixed — Suyang Zhong
— Assertion failure when using JAROWINKLER in ORDER BY clause fixed — Suyang Zhong
— Assertion failure when using INNER JOIN on STARTSWITH fixed — Suyang Zhong
— Assertion failure when using GROUP BY when CREATE VIEW fixed — Suyang Zhong
— Assertion failure when using CONTAINS fixed — Suyang Zhong
— Assertion failure when comparing INTERVAL value 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.