← All database systems

DuckDB is supported by SQLancer — the main repository ships a testing implementation for it. SQLancer is credited with 302 bugs in it, reported between 2020-04-07 and 2026-09-07. Its source is at duckdb/duckdb.

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

Official testing

The DuckDB project keeps a regression test for each SQLancer finding under test/issues/rigger/, so the bugs it found stay fixed.

# description: SQLancer bug that found a crash in the instr implementation
test/issues/rigger/instr_crash.test in the DuckDB repository, one of the files the project keeps for this.
test/issues/rigger/instr_crash.test last verified 2026-09-13

How the bugs break down

By year reported

2020
85
2021
1
2022
7
2023
39
2024
9
2025
52
2026
103
Year not recorded
6

Who found them

Found by the SQLancer project
286
Found by someone outside the project
15
Reporter not recorded
1

By status

Fixed
271
Confirmed
9
Open
22

By symptom

Logic bug
30
Unexpected error
13
Crash
32
Unclassified
227

By technique

Technique not recorded
268
Ternary Logic Partitioning (TLP)
34

Why each bug counts

Filed by someone who runs SQLancer campaigns
112
The reproducer carries SQLancer's generated schema
102
Listed in the project's own bug repository
46
The report names a SQLancer oracle
33
The report names SQLancer
9

Who reported them (8)

Manuel Rigger
75
DerZc
48
Yibo-Dong
39
suyZhong
38
Zhaokun Xiang
24
Chi Zhang
23
wanteatfruit
14
Suyang Zhong
9

Every bug on record (309)

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-09-07 Expression::HasParameter crashes planning a correlated subquery with a STRUCT-access join predicate open — suyZhong
2026-08-31 Unexpected results when comparing a LIST column open — suyZhong
2026-08-31 Unexpected results when a sampled scan of an indexed column filtered by `IN (VALUES ...)` open — suyZhong
2026-08-31 Unexpected results of `UNION ALL` over two identical RIGHT JOINs with an `EXISTS` in the ON clause open — suyZhong
2026-08-31 INTERNAL Error: "Failed to bind column reference" for `unnest()` in a comma cross join open — suyZhong
2026-08-31 INTERNAL Error and SIGSEGV in string functions applied to `printf('%c', 255)` fixed — suyZhong
2026-08-27 Unexpected Left Join Result fixed — TheoristCoder
2026-08-18 `ROW_NUMBER` argument order ignores a singleton following frame fixed — Yibo-Dong
2026-08-18 `QUALIFY` volatile predicates are pushed below a window aggregate open — Yibo-Dong
2026-08-18 `NTILE` with argument `ORDER BY` fails on a future-only `ROWS` frame fixed — Yibo-Dong
2026-08-18 `MODE(... ORDER BY ...)` can use a stale tie-break value in a sliding ROWS frame fixed — Yibo-Dong
2026-08-18 Streaming `NTH_VALUE IGNORE NULLS` loses a found value fixed — Yibo-Dong
2026-08-18 Optimized window ordering mis-associates a volatile key with `LIST` input rows open — Yibo-Dong
2026-08-16 Wrong `MEDIAN` / `QUANTILE_CONT` / `LIST` over an inner join fixed — wanteatfruit
2026-08-16 Dict-surviving hash join InternalException on a RIGHT join whose build is a nested-loop of two identity has... open — wanteatfruit
2026-08-14 `SUBSTR` ASCII fast path clamps a hugely negative start; Unicode path returns empty fixed — wanteatfruit
2026-08-14 WindowSelfJoinOptimizer returns wrong results when PARTITION BY contains duplicate keys fixed — wanteatfruit
2026-08-12 Segmentation fault on `AGE(...)` call in `GROUP BY` fixed — wanteatfruit
2026-08-11 `ROW_NUMBER() <= k` triggers an `arg_min`/`arg_max` error fixed — wanteatfruit
2026-08-11 INTERNAL Error with `QUALIFY` over a view and a type cast open — wanteatfruit
2026-08-11 INTERNAL Error on a flag-joined view and `QUALIFY` open — wanteatfruit
2026-08-10 INTERNAL Error when ASOF JOIN's left child is EXCEPT ALL / INTERSECT ALL fixed — wanteatfruit
2026-08-09 `partial_aggregate_pushdown` returns wrong holistic aggregate results over joins fixed — Yibo-Dong
2026-08-09 `last(DISTINCT x)` can return the non-distinct last value fixed — Yibo-Dong
2026-08-09 `aggregate_function_rewriter` leaves a stale `GROUPING()` binding for ordered `list()` open — Yibo-Dong
2026-08-09 Unexpected result of `UNION ALL` over filtered LEFT JOIN branches fixed — suyZhong
2026-08-09 Unexpected result of `IS NULL` filter on a RIGHT JOIN open — suyZhong
2026-08-09 RANGE PRECEDING over an INTERVAL order key can exclude the lower endpoint fixed — Yibo-Dong
2026-08-09 PERCENT_RANK with argument ORDER BY can split peers when the argument order is a prefix of the window order fixed — Yibo-Dong
2026-08-09 LEAD/LAG ignores EXCLUDE GROUP fixed — Yibo-Dong
2026-08-09 INTERNAL Error: regexp_full_match() on a non-constant pattern is not marked fallible fixed — suyZhong
2026-08-09 Dynamic ROWS NULL PRECEDING bound can reuse a previous frame start fixed — Yibo-Dong
2026-08-09 Duplicate PARTITION BY expressions can make different window partitions share results fixed — Yibo-Dong
2026-08-08 `INTERNAL Error: Operator occurrence N was reconstructed more than once` on `INNER JOIN` with a single-side... fixed — wanteatfruit
2026-08-04 Segmentation fault on `RIGHT_SEMI` hash join over a window-aggregate view fixed — wanteatfruit
2026-08-03 Top-N MIN with row-dependent n fails in a singleton window frame open — Yibo-Dong
2026-08-03 Row-dependent `APPROX_TOP_K` capacity is rejected by the combine window path fixed — Yibo-Dong
2026-08-03 MODE(DISTINCT ...) can ignore the window ORDER BY input order fixed — Yibo-Dong
2026-08-03 MAD FILTER over an excluded ROWS frame can include filtered/excluded rows fixed — Yibo-Dong
2026-08-03 HISTOGRAM_EXACT with row-dependent bins fails in a singleton window frame fixed — Yibo-Dong
2026-08-03 HISTOGRAM window combine double-counts NaN map keys fixed — Yibo-Dong
2026-08-03 FIRST_VALUE without window ORDER BY ignores a singleton ROWS frame fixed — Yibo-Dong
2026-07-29 INTERNAL Error: Vector::Reference used on vector of different type (BIGINT/VARCHAR) -- COALESCE over a self... fixed — wanteatfruit
2026-07-29 INTERNAL Error: Failed to bind column reference -- quantified ALL/ANY subquery in a non-inner join conditio... fixed — wanteatfruit
2026-07-27 Crashes when `DISTINCT` over a `VARIANT` at greater than 7 rows. fixed — wanteatfruit
2026-07-20 Unexpected result when `NOT` applied to a LIST `<` comparison open — suyZhong
2026-07-19 Unexpected result when comparing `STRUCT` values in a `JOIN` open — suyZhong
2026-07-18 INTERNAL Error: Attempted to access index 0 within vector of size 0 open — suyZhong
2026-07-08 top_n_window_elimination ignores ROW_NUMBER argument ORDER BY fixed — Yibo-Dong
2026-07-08 top_n_window_elimination can rank NaN before finite values fixed — Yibo-Dong
2026-07-08 top_n_window_elimination can produce a NULL row for ROW_NUMBER on empty input fixed — Yibo-Dong
2026-07-08 top_n_window_elimination can drop rows when ROW_NUMBER orders by a nullable expression fixed — Yibo-Dong
2026-07-07 RANGE offset 0 frames can split duplicate ORDER BY peers fixed — Yibo-Dong
2026-07-07 BITSTRING_AGG without explicit min/max fails as a window aggregate fixed — Yibo-Dong
2026-07-06 filter_pushdown can turn a correlated aggregate comparison below a window into NULL rows open — Yibo-Dong
2026-07-06 Value functions reject argument ORDER BY with EXCLUDE fixed — Yibo-Dong
2026-07-06 CUME_DIST with argument ORDER BY can underflow on future ROWS frames fixed — Yibo-Dong
2026-07-03 top_n_window_elimination can collapse duplicate payload rows fixed — Yibo-Dong
2026-07-03 ROW_NUMBER over read_duckdb can return 0-based file-local row numbers fixed — Yibo-Dong
2026-07-03 Internal error in common_subplan for UNION of QUALIFY ROW_NUMBER EXCEPT branches fixed — Yibo-Dong
2026-07-03 COUNT(*) over a reversed ROWS frame can return a negative count fixed — Yibo-Dong
2026-06-25 Wrong results for LIST(DISTINCT ... ORDER BY ...) window aggregate fixed — Yibo-Dong
2026-06-25 Wrong result: FIRST_VALUE crosses partition fixed — Yibo-Dong
2026-06-25 Wrong result: FILL ignores ROWS frame fixed — Yibo-Dong
2026-06-24 Wrong results for DISTINCT window aggregates fixed — Yibo-Dong
2026-06-24 Inherited named window fails to resolve earlier base window fixed — Yibo-Dong
2026-06-09 json_transform generate incorrect results on NUL symbol fixed — DerZc
2026-06-09 dateformat does not work for the top layer date value fixed — DerZc
2026-06-09 VARIANT changes the json_type of value fixed — DerZc
2026-06-09 The fullkey field incorrectly escapes keys containing special characters fixed — DerZc
2026-06-09 Inconsistency between type cast to fixed array and unfixed array fixed — DerZc
2026-06-08 json_object and json_group_object silently drop the NULL-key entry fixed — DerZc
2026-06-08 ignore_errors makes read_ndjson_objects accept invalid json object fixed — DerZc
2026-06-08 Unexpected result of json_deserialize_sql fixed — DerZc
2026-06-08 Unexpected error triggered by array_to_json fixed — DerZc
2026-06-08 Unexpected error `Unrecognized option "ROW_GROUP_SIZE" for csv` and for json fixed — DerZc
2026-06-08 Unexpected error `No function matches the given name and argument types 'json_type(JSON, INTEGER_LITERAL)'` open — DerZc
2026-06-08 Unexpected error `Invalid Input Error` for COPY FROM open — DerZc
2026-06-08 JSON keys are case-sensitive at the top level but case-insensitive at nested levels in read_json open — DerZc
2026-06-08 INTERNAL Error: Unsupported type arrived at JSON create function fixed — DerZc
2026-06-08 Data type lost in PARQUET file fixed — DerZc
2026-06-08 COPY FROM has different behaviors with different option order fixed — DerZc
2026-05-28 INTERNAL Error: Attempted to dereference unique_ptr that is NULL! fixed — DerZc
2026-05-22 INTERNAL Error: Unsupported type arrived at JSON create function fixed — DerZc
2026-05-22 INTERNAL Error: Calling StringValue::Get on a NULL value fixed — DerZc
2026-05-22 INTERNAL Error: Attempting to dereference an optional pointer that is not set fixed — DerZc
2026-05-22 INTERNAL Error: Attempted to access index 0 within vector of size 0 fixed — DerZc
2026-05-20 Incorrect result of json_serialize_sql fixed — DerZc
2026-05-20 INTERNAL Error: 'back' called on an empty vector! fixed — DerZc
2026-05-19 Unexpected Parser Error: Expected but did not find property 'cte_map' in json object: fixed — DerZc
2026-05-19 Optimizer triggers parser error on JSON fixed — DerZc
2026-05-19 Internal error: Expected vector of type VARCHAR, but found vector of type LIST triggered by json_keys fixed — DerZc
2026-05-19 Internal Error: Unsupported type arrived at JSON create function fixed — DerZc
2026-05-19 INTERNAL Error: Attempted to dereference unique_ptr that is NULL! fixed — DerZc
2026-04-13 Logical inconsistency: The SQL we geenenrated in the form of TLP is inconsistent with the result of the ori... fixed TLP Jasper0209
2026-03-17 Floating point exception (core dumped) fixed — DerZc
2026-02-03 Unexpected error `LIMIT/OFFSET cannot be negative` in the subquery of prepared statement fixed — DerZc
2026-02-03 Inconsistent results between equivalent normal and prepared SELECT fixed — DerZc
2026-01-28 inefficient query plan generated by normal SELECT open — DerZc
2026-01-28 Less efficient query plan generated by normal SELECT than the equivalent prepared SELECT open — DerZc
2026-01-27 Unexpected error in the HAVING clause of subquery fixed — DerZc
2026-01-04 Unexpected Floating point exception fixed — DerZc
2026-01-04 Inconsistent behaviour of normal and prepared statement when use values with different types in CASE WHEN fixed — DerZc
2025-12-25 Potential Unexpected Results of `CONCAT(NULL)` fixed — suyZhong
2025-12-08 Unexpected result when using `POSITIONAL JOIN` fixed — suyZhong
2025-12-05 multiple joins crash with 'Execute called with a result vector of type INTEGER that does not match expressi... fixed — Zhaokun Xiang
2025-12-01 Unexpected Result when Using Utility Function `ALIAS` fixed — suyZhong
2025-12-01 Potential Unexpected Result when Using `TRY` Expression fixed — suyZhong
2025-11-29 Unexpected Execution Result fixed — Zhaokun Xiang
2025-11-05 Should-be rejected conversions unexpectedly execute successfully in the join and cause bugs verified — Zhaokun Xiang
2025-09-24 Unexpected error triggered by LENGTH(NULL) fixed — DerZc
2025-09-23 Inconsistency between prepared statement and normal query when negation a big integer fixed — DerZc
2025-09-13 Unexpected error in prepared statement fixed — DerZc
2025-09-12 INTERNAL Error: Attempted to dereference unique_ptr that is NULL fixed — suyZhong
2025-09-11 Incorrect results for predicate with TRY_CAST fixed — joyemang33
2025-08-22 [DEV BUILD] DuckDB Crash with Correlated Aggregation inside a WITH clause fixed — joyemang33
2025-08-14 Unexpected Inner Join Result fixed — Zhaokun Xiang
2025-08-11 Inconsistenct behaviour on ORDER BY fixed — DerZc
2025-08-11 Inconsistenct behaviour between prepared statement and normal statement fixed — DerZc
2025-08-11 CHECK Constraints trigger unexpected type cast fixed — DerZc
2025-08-07 [nightly build] Incorrect handling with CTE and EXIST fixed — joyemang33
2025-08-05 A wrong anti-join result when joining with an empty table fixed — Zhaokun Xiang
2025-07-31 `HAVING FIRST` returns undeterministic result fixed — DerZc
2025-07-19 Inconsistent behavior between CROSS JOIN and implicit JOIN in SELECT fixed — joyemang33
2025-07-16 Unexpected internal error in joins fixed — Zhaokun Xiang
2025-07-10 Segmentation fault when JOIN with a VIEW fixed — suyZhong
2025-07-06 Deterministic query return undeterministic results fixed — DerZc
2025-07-05 Wrong inner join result when handling join condition related to primary key fixed — Zhaokun Xiang
2025-07-05 Query on TPC-H Benchmark Crashes Server Due to Abnormal Memory and CPU Usage fixed — joyemang33
2025-07-05 Binder Error about a non-existent table name verified — Zhaokun Xiang
2025-07-01 Unexpected result of prepared statement fixed — DerZc
2025-06-25 Unexpected Internal Error with Delim join - binding index out of range fixed — Zhaokun Xiang
2025-06-25 Strange Estimated Cardinality and Suboptimal Plan in TPC-DS Q31 Caused by Insufficient Filter Pushdown fixed — joyemang33
2025-06-21 Unexpected Join Crash fixed — Zhaokun Xiang
2025-06-11 Unexpected Execution Result fixed — Zhaokun Xiang
2025-06-11 Assertion Failure in INNER JOIN fixed — Zhaokun Xiang
2025-06-05 Wrong multiple join result fixed — Zhaokun Xiang
2025-05-28 Unexpected internal error in multi-join query fixed — Zhaokun Xiang
2025-05-28 A inner join meets INTERNAL Error: Failed to bind column reference fixed — Zhaokun Xiang
2025-05-20 Wrong inner join result fixed — Zhaokun Xiang
2025-04-25 Unexpected results when comparing `NULL` values fixed — suyZhong
2025-04-23 Wrong inner Join result fixed — Zhaokun Xiang
2025-04-09 Unexpected result when using `LEFT JOIN` fixed — suyZhong
2025-04-06 Unexpected Left Join Result fixed — Zhaokun Xiang
2025-03-31 multiple right joins produce wrong result fixed — Zhaokun Xiang
2025-03-27 Unexpected result when `RIGHT JOIN` with a subquery fixed — suyZhong
2025-03-24 An Anti-Join produces wrong result fixed — Zhaokun Xiang
2025-03-22 Anti-join meets INTERNAL Error: Attempted to dereference unique_ptr that is NULL fixed — Zhaokun Xiang
2025-03-08 Unexpected Join Internal Error verified — Zhaokun Xiang
2025-02-05 Wrong join result fixed — Zhaokun Xiang
2025-02-05 Unexpected results after indexing a column with multiple rows fixed — suyZhong
2025-02-05 Multiple Join Crash with Vector::Reference used on vector of different type fixed — Zhaokun Xiang
2025-01-08 Unexpected result when using `BETWEEN` and `CASE WHEN` fixed — suyZhong
2025-01-07 INTERNAL Error: Vector::Reference used on vector of different type fixed — suyZhong
2025-01-07 INTERNAL Error: Failed to bind column reference fixed — suyZhong
2025-01-05 "Binder Error: Referenced table not found!" occurred in the HAVING clause of subquery closed not a bug — DerZc
2024-12-28 INTERNAL Error: ConstantFilter constant cannot be NULL - use IsNullFilter instead fixed — suyZhong
2024-11-27 INTERNAL Error: Attempted to access index 0 within vector of size 0 fixed — suyZhong
2024-11-14 Unexpected result when using `INTERVAL` and `INNER JOIN` subquery fixed — suyZhong
2024-10-26 Unexpected result when comparing `BLOB` fixed — suyZhong
2024-10-03 Unexpected result of comparison of nested types containing `NULL` closed not a bug TLP suyZhong
2024-09-19 Unexpected result when casting `TIMESTAMP_S` to `TIME` fixed TLP suyZhong
2024-09-14 INTERNAL Error: Attempted to dereference unique_ptr that is NULL fixed — suyZhong
2024-09-13 Unexpected result when comparing `STRUCT` with `INET` fixed TLP suyZhong
2024-09-12 Inconsistent results when casting `BIT` and `VARBINARY` fixed — suyZhong
2024-09-10 Unexpected result after creating index on `DATE` column fixed — suyZhong
2023-12-30 INTERNAL Error: Failed to bind column reference "" [1.2] (bindings: [1.1]) fixed — Suyang Zhong
2023-11-28 Missing Results when using Floating-point in BETWEEN fixed — Suyang Zhong
2023-11-26 Unexpected Results when using IS NOT NULL fixed — Suyang Zhong
2023-08-23 Recursive SQL Query Leads to Infinite Loop fixed — suyZhong
2023-06-30 Unexpected hang on subquery fixed — Chi Zhang
2023-06-16 Unexpected results on common table expressions fixed — Chi Zhang
2023-06-05 Inconsistent result of `AVG` on big float number verified — Chi Zhang
2023-05-23 Unexpected results related to `INDEX` fixed — Chi Zhang
2023-05-21 DuckDB hang on `DELETE` fixed — Chi Zhang
2023-05-20 Inconsistent results of subquery in `INSERT` and `SELECT`, and an unexpected error fixed — Chi Zhang
2023-05-17 Segmentation fault on `SELECT` fixed — Chi Zhang
2023-05-16 DuckDB hang on `DELETE` fixed — Chi Zhang
2023-05-13 Unexpected error `Invalid Error: Argument index "0" out of range` fixed — DerZc
2023-05-11 DuckDB JDBC throws `Resource temporarily unavailable` closed not a bug — SuriZhang
2023-05-08 Unexpected results of `IN` with redundant values list verified — Chi Zhang
2023-05-02 Unexpected error `unknown signature: bit_length(string) (desired )` verified — Chi Zhang
2023-04-27 Unexpected results might be related to `BIT` and `INDEX` fixed — Chi Zhang
2023-04-26 `INTERNAL Error: Logical column index 1 out of range` fixed — Chi Zhang
2023-04-24 Unexpected results of `CASE` and `BETWEEN` fixed — Chi Zhang
2023-04-21 `internal error: expected subquery to be lazily planned as a routine` fixed — Chi Zhang
2023-04-19 Unexpected results on specific values fixed — Chi Zhang
2023-04-19 Hang on `SELECT` query fixed — Chi Zhang
2023-04-15 Unexpected results when integer overflow unknown — Chi Zhang
2023-04-15 Unexpected results of `TIME` value under JDBC unknown — Chi Zhang
2023-04-13 internal error: failed to parse locale "": language: tag is not well-formed fixed — Chi Zhang
2023-04-13 DuckDB JDBC driver segfault at duplicate method call fixed — SuriZhang
2023-04-13 Different returned datatype of a `CASE` statement in different query. verified — Chi Zhang
2023-04-12 Unexpected result when take subquery as operand verified — Chi Zhang
2023-04-12 The `AVG` function modify the value of `REAL` in some query fixed — DerZc
2023-04-09 kvcoord: setting `kv.range_descriptor_cache.size=0` results in range iterator to retry endlessly fixed — Chi Zhang
2023-04-04 internal error: null rejection requested on non-null column fixed — Chi Zhang
2023-04-04 Incorrect result by subquery and join fixed — Chi Zhang
2023-03-27 INSERT statement returns unexpected exception fixed — SuriZhang
2023-03-25 Segmentation fault on `BETWEEN` fixed — Chi Zhang
2023-03-25 Incorrect results might caused by `INDEX` fixed — DerZc
2023-03-13 INTERNAL Error: Failed to bind column reference "" [18.2] (bindings: [18.1]) fixed — fuzzerofducks
2023-03-10 Segmentation Fault on Select query on table with column of array type. fixed — nish-d
2023-03-10 Inconsistencies Found When Comparing Null Values within Rows fixed — suyZhong
2023-03-10 Crash When Updating after Commit fixed — suyZhong
2023-03-09 Crash When Altering Schema fixed — suyZhong
2023-02-12 Internal Error: Calling StringValue::Get on a NULL value fixed — Suyang Zhong
2023-02-02 TestDuckDBJDBC::test_lots_of_decimals is broken fixed — SuriZhang
2022-11-19 Results are different between Python Interface and CLI when executing queries with UNION and LIMIT closed not a bug — suyZhong
2022-10-13 Crash When Creating Index unknown — bajinsheng
2022-09-24 /usr/include/c++/9/bits/unique_ptr.h:347:9: runtime error: reference binding to null pointer of type 'struc... fixed — fuzzerofducks
2022-09-23 Catalog Error: Table with name t4 does not exist! Did you mean "t0"? Catalog Error: Table with name t4 does... fixed — fuzzerofducks
2022-09-08 Catalog Error: Table with name t0 does not exist! Did you mean "t44"? Catalog Error: Table with name t0 doe... fixed — fuzzerofducks
2022-09-07 Catalog Error: Table with name t25 does not exist! Did you mean "t0"? Catalog Error: Table with name t25 do... fixed — fuzzerofducks
2022-08-12 Catalog Error: Table with name t0 does not exist! Did you mean "t1"? Catalog Error: Table with name t0 does... fixed — fuzzerofducks
2022-05-11 Unexpected Error for RTRIM Function in Where Clause fixed — kokrui
2022-05-06 BETWEEN with subquery and column results in unexpected error fixed — kokrui
2021-01-27 Filter issue with `IN` and `NULL` fixed — hannes
2020-12-13 Comparison with boolean unexpectedly evaluates to false fixed TLP mrigger
2020-09-28 Typeof does not work when using JDBC fixed — mrigger
2020-09-24 Getting a query plan using JDBC fixed — mrigger
2020-09-24 Buffer overflow in duckdb::ART::IteratorNext fixed — Manuel Rigger
2020-08-18 DuckDB JDBC driver issue in the presence of other JDBC drivers fixed — mrigger
2020-06-24 Column ID mismatch in adaptive filters fixed — hannes
2020-05-26 Maven artifact & JDBC driver fat JAR fixed — mrigger
2020-05-07 SELECT with RIGHT JOIN causes an assertion failure "Assertion `!finalized' failed" fixed — Manuel Rigger
2020-05-06 Query using LEFT() results in a segmentation fault fixed — Manuel Rigger
2020-05-05 UPDATE on altered table results in an error "Could not find node in column segment tree" fixed — Manuel Rigger
2020-05-05 DROP column results in an assertion failure unique.index < base.columns.size(). fixed — Manuel Rigger
2020-05-05 DROP column results in an assertion failure unique.index < base.columns.size() 2 fixed — Manuel Rigger
2020-05-05 ALTER TYPE with USING results in an assertion failure "types.size() > 0" fixed — Manuel Rigger
2020-05-05 ALTER TABLE results in an assertion failure "Assertion `expr.return_type == vector.type' failed" fixed — Manuel Rigger
2020-05-04 Query on altered table results in a segmentation fault fixed — Manuel Rigger
2020-05-04 Failed ALTER COLUMN results in a "Transaction conflict" error that cannot be aborted fixed — Manuel Rigger
2020-05-02 Building duckdb_java.cpp fails with an include error fixed — mrigger
2020-05-01 Large argument to RPAD results in std::bad_alloc fixed — Manuel Rigger
2020-05-01 Incorrect result for MIN() on expression involving rowid fixed TLP Manuel Rigger
2020-04-29 GROUP BY does not take COLLATE into account fixed TLP Manuel Rigger
2020-04-29 BETWEEN with COLLATE NOACCENT.NOCASE expression results in a segfault/ASan failure fixed — Manuel Rigger
2020-04-28 UPDATE results in crash or assertion failure fixed — Manuel Rigger
2020-04-27 STDDEV_POP unexpectedly does not fetch any rows fixed — Manuel Rigger
2020-04-26 Expression with LIKE and comparison causes an assertion failure fixed — Manuel Rigger
2020-04-25 Subtracting a large integer from a DATE results in a "double free or corruption" fixed — Manuel Rigger
2020-04-25 Query with complex ORDER BY causes an incorrect rowid value fixed TLP Manuel Rigger
2020-04-25 Predicate checking for an empty string yields an incorrect result fixed TLP Manuel Rigger
2020-04-25 NOACCENT.NOCASE comparison with a special character results in a segmentation fault fixed — Manuel Rigger
2020-04-25 Creating an index on rowid results in an internal error "Failed to bind column reference" fixed — Manuel Rigger
2020-04-25 Comparison with a DATE yields an incorrect result fixed TLP Manuel Rigger
2020-04-25 Comparing a string with a boolean yields an incorrect result after UPDATE fixed TLP Manuel Rigger
2020-04-25 A select with BETWEEN and VARCHAR cast results in an incorrect result fixed TLP Manuel Rigger
2020-04-25 A negative DATE results in a "double free or corruption" crash fixed — Manuel Rigger
2020-04-24 Updated value in column is not visible in a SELECT fixed TLP Manuel Rigger
2020-04-24 SUBSTRING with an invalid start position causes a segmentation fault fixed — Manuel Rigger
2020-04-24 DISTINCT malfunctions for BOOLEAN fixed TLP Manuel Rigger
2020-04-19 Query using PREFIX() results in an error std::bad_alloc fixed — Manuel Rigger
2020-04-19 Incorrect result for BETWEEN query that casts column to boolean fixed TLP Manuel Rigger
2020-04-16 REVERSE() on special character results in "Assertion `strcmp(dataptr, normalized) == 0' failed." fixed — Manuel Rigger
2020-04-15 SELECT with CASE expression causes an assertion failure "Assertion `!entry.first->Equals(&expr)' failed" fixed — Manuel Rigger
2020-04-15 Incorrect result for SUM() and negative number fixed TLP Manuel Rigger
2020-04-14 RIGHT JOIN results in Assertion `filter->expressions.size() == 1' failed fixed — Manuel Rigger
2020-04-13 [JDBC] Special character causes the JVM to terminate with "basic_string::_M_construct null not valid" fixed — Manuel Rigger
2020-04-13 Unexpected result for SUM() upon overflow fixed TLP Manuel Rigger
2020-04-13 SELECT on view with text constant in ORDER BY crashes fixed — Manuel Rigger
2020-04-13 Query with SIMILAR TO results in "Assertion `strlen(dataptr) == length' failed" fixed — Manuel Rigger
2020-04-13 Nested MAX() results in nondeterministic result or double free fixed TLP Manuel Rigger
2020-04-13 Nested CASE expression results in Assertion `other.auxiliary->type == VectorBufferType::STRING_BUFFER' failed fixed — Manuel Rigger
2020-04-13 Assertions in the JDBC build of DuckDB? fixed — mrigger
2020-04-12 UPDATE causes subsequent query to segfault fixed — Manuel Rigger
2020-04-12 SELECT on DATE column with a large negative value results in a "double free or corruption" fixed — Manuel Rigger
2020-04-12 Query with JOIN and WHERE condition unexpectedly fetches a value not present in the table fixed TLP Manuel Rigger
2020-04-12 Query that uses the CONCAT() function and OR expression crashes fixed — Manuel Rigger
2020-04-12 Overflow when casting from REAL to INT results in "Invalid TypeId -1" fixed — Manuel Rigger
2020-04-12 Nondeterministic clause when using an UNION query and HAVING clause fixed TLP Manuel Rigger
2020-04-12 Incorrect result for query that uses REGEXP_MATCHES() fixed TLP Manuel Rigger
2020-04-12 Incorrect result for predicate with shift on a BIGINT column fixed TLP Manuel Rigger
2020-04-12 Incorrect result for a JOIN predicate t1.c0 IN (t0.c0) and WHERE predicate t1.c0<=t0.c0 fixed TLP Manuel Rigger
2020-04-12 GROUP BY clause results in non-deterministic result fixed TLP Manuel Rigger
2020-04-12 Fetching from table and view results in a crash fixed — Manuel Rigger
2020-04-12 Fetching a TIMESTAMP column results in an error fixed — mrigger
2020-04-11 The trigonometric functions can result in -nan fixed TLP Manuel Rigger
2020-04-11 ROUND() evaluates to -nan fixed TLP Manuel Rigger
2020-04-11 Query with comparison on boolean column results in "Invalid type: Invalid Type [BOOL]: Invalid type for index" fixed — Manuel Rigger
2020-04-11 Query with an AND predicate, NOT and comparison yields an incorrect result fixed TLP Manuel Rigger
2020-04-11 Query with a negative shift predicate yields an incorrect result fixed TLP Manuel Rigger
2020-04-11 Query using the LN() function does not terminate fixed — Manuel Rigger
2020-04-11 LEFT JOIN with comparison on integer columns results in "Not implemented: Unimplemented type for nested loo... fixed — Manuel Rigger
2020-04-11 Incorrect result after an INSERT violates a UNIQUE constraint fixed TLP Manuel Rigger
2020-04-11 Casting a large number to REAL and multiplying it with zero results in -nan fixed TLP Manuel Rigger
2020-04-10 SIMILAR TO results in an incorrect result fixed TLP Manuel Rigger
2020-04-10 RIGHT JOIN with a predicate that compares two integer columns results in an "Unhandled type" error fixed — Manuel Rigger
2020-04-10 Query results in an error "INTERNAL: Failed to bind column reference "c0" [5.0] (bindings: [6.0])" fixed — Manuel Rigger
2020-04-10 LEFT JOIN on column with NULL value results in a segmentation fault fixed — Manuel Rigger
2020-04-10 INSERT results in an error "Not implemented: Cannot create data from this type" fixed — Manuel Rigger
2020-04-10 Creating an empty table results in a crash fixed — Manuel Rigger
2020-04-10 A RIGHT JOIN unexpectedly fetches rows fixed TLP Manuel Rigger
2020-04-09 SELECT causes JDBC driver to crash fixed — Manuel Rigger
2020-04-08 SIMILAR TO results in an "Unknown error -1" fixed — Manuel Rigger
2020-04-08 INSERT causes an abort with "terminate called after throwing an instance of 'duckdb::InvalidTypeException'" fixed — Manuel Rigger
2020-04-08 Comparison on UNIQUE NUMERIC column causes a query to omit a row in the result set fixed TLP Manuel Rigger
2020-04-08 Comparison of two boolean columns in different tables results in an error "Not implemented: Unimplemented t... fixed — Manuel Rigger
2020-04-07 PRAGMA table_info provides no output fixed — mrigger
2020-04-07 A predicate NOT(NULL OR TRUE) unexpectedly evaluates to TRUE fixed TLP Manuel Rigger
2020-04-07 A comparison column=column unexpectedly evaluates to TRUE for column=NULL fixed TLP Manuel Rigger
— `INTERNAL Error: Unimplemented type for normalify` in select query fixed — —
— Unexpected result when using IN with TIME values verified — Suyang Zhong
— Unexpected result when using IN with DATE values fixed — Suyang Zhong
— Unexpected result when casting negative integer to BIT fixed — Suyang Zhong
— Unexpected result after creating index on varchar column fixed — Suyang Zhong
— Unexpected Result When Using `IS DISTINCT FROM` and `CASE WHEN` in a JOIN clause 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.