← All database systems

Dolt has no testing implementation in the main SQLancer repository. SQLancer is credited with 167 bugs in it, reported between 2023-07-12 and 2026-11-01. Its source is at dolthub/dolt.

How the bugs break down

By year reported

2023
18
2024
12
2025
24
2026
113

Who found them

Found by the SQLancer project
167

By status

Fixed
125
Confirmed
1
Open
41

By symptom

Unclassified
167

By technique

Technique not recorded
167

Why each bug counts

Filed by someone who runs SQLancer campaigns
113
The reproducer carries SQLancer's generated schema
53
Listed in the project's own bug repository
1

Who reported them (6)

Yibo-Dong
94
Suyang Zhong
23
Zhaokun Xiang
19
EmilyOng
13
wanteatfruit
11
suyZhong
7

Every bug on record (167)

One row per report, newest first, each linking to the report itself. Rejected reports are marked and are not part of any count above.

<= ` and `>=` return rows where IS NULL on `dolt sql-server`)` has inconsistent behavior
Reported Report Status Technique Reporter
2026-11-01 Invalid CrossJoin in query plan fixed — Zhaokun Xiang
2026-08-18 Dolt skips empty strings in GROUP_CONCAT before a window wrapper fixed — Yibo-Dong
2026-08-18 Dolt returns NULL for a 25-hour TIME in a windowed TIME_TO_SEC call fixed — Yibo-Dong
2026-08-18 Dolt panics when LOAD_FILE receives a numeric argument below a window fixed — Yibo-Dong
2026-08-18 Dolt loses expression-index metadata in a windowed information_schema projection fixed — Yibo-Dong
2026-08-18 Dolt keeps boolean true separate from integer 1 in recursive UNION DISTINCT fixed — Yibo-Dong
2026-08-18 Dolt ignores default backslash escaping for wildcard characters in a window child open — Yibo-Dong
2026-08-18 Dolt collides distinct text tuples in COUNT(DISTINCT ...) before a window wrapper fixed — Yibo-Dong
2026-08-17 Dolt uppercases a lowercase non-ASCII initial in SOUNDEX fixed — Yibo-Dong
2026-08-17 Dolt swallows a child-expression evaluation error in SUM fixed — Yibo-Dong
2026-08-17 Dolt returns a wrong result for REGEXP_LIKE across partitions open — Yibo-Dong
2026-08-17 Dolt rejects a legal REGEXP_REPLACE position after the source fixed — Yibo-Dong
2026-08-17 Dolt reaches an analyzer internal error for a legal correlated LEFT JOIN LATERAL open — Yibo-Dong
2026-08-17 Dolt raises an internal child-count error for CURRENT_TIME(precision) fixed — Yibo-Dong
2026-08-17 Dolt mis-evaluates a correlated anti-join over a derived ROW_NUMBER() result open — Yibo-Dong
2026-08-17 Dolt ignores the PM marker in STR_TO_DATE fixed — Yibo-Dong
2026-08-17 Dolt exposes a user INVISIBLE column through SELECT * fixed — Yibo-Dong
2026-08-17 Dolt drops sql_select_limit open — Yibo-Dong
2026-08-16 `CEIL`/`FLOOR` of a windowed `DECIMAL` returns unexpected results fixed — wanteatfruit
2026-08-11 `STR_TO_DATE()` errors instead of propagating `NULL` fixed — Yibo-Dong
2026-08-11 `ORDER BY` + huge `LIMIT` (≥ 2^62) panics fixed — wanteatfruit
2026-08-11 `INET_NTOA` corrupts valid IPv4 values above signed 32-bit fixed — Yibo-Dong
2026-08-11 `COUNT()` counts the wrong column on `dolt sql-server` fixed — wanteatfruit
2026-08-11 Windowed recursive CTE names collide with a differently cased base table open — Yibo-Dong
2026-08-11 Windowed `TRIM(LEADING FROM str)` is rejected by the parser fixed — Yibo-Dong
2026-08-11 Windowed `HOUR()` returns `NULL` for a valid time-only value fixed — Yibo-Dong
2026-08-11 Window expression de-duplication folds case-sensitive literals fixed — Yibo-Dong
2026-08-11 UPDATE incorrectly permits a windowed target-table subquery open — Yibo-Dong
2026-08-11 Nested multi-column VIEW + self `EXISTS` → ERROR 1105 column-count mismatch open — wanteatfruit
2026-08-11 Nested CTE scope disappears inside a recursive CTE with a window query open — Yibo-Dong
2026-08-11 Identical nondeterministic window expressions are incorrectly merged fixed — Yibo-Dong
2026-08-11 Dolt: explicit Unicode-collation RANGE peers are split open — Yibo-Dong
2026-08-11 Dolt: `DISTINCT` window output with a composite outer sort reaches a stale field index open — Yibo-Dong
2026-08-11 Dolt window expression omits `LIKE ESCAPE` fixed — Yibo-Dong
2026-08-11 Dolt reaches an internal error on invalid window `ORDER BY` alias. open — Yibo-Dong
2026-08-11 Dolt reaches an internal error on grouped one-column input. open — Yibo-Dong
2026-08-11 Dolt panics on recursive CTE column-arity error. fixed — Yibo-Dong
2026-08-11 Dolt panics on empty `POLYGON` WKT fixed — Yibo-Dong
2026-08-11 Dolt panics on empty `LIKE ... ESCAPE ''` within window expressions fixed — Yibo-Dong
2026-08-11 Dolt panics on a numeric `FORMAT` locale from a window expression fixed — Yibo-Dong
2026-08-11 Dolt panics on `ROUND` on a date-valued window result fixed — Yibo-Dong
2026-08-11 Dolt panics on `RAND(NULL)` on a nil seed. fixed — Yibo-Dong
2026-08-11 Dolt panics on `INET6_ATON` on a non-string SQL argument fixed — Yibo-Dong
2026-08-11 Decimal `RANGE` offsets are rejected open — Yibo-Dong
2026-08-11 Date-valued window arithmetic appends a zero-time suffix open — Yibo-Dong
2026-08-11 Correlated `EXISTS` loses an empty aggregate row open — Yibo-Dong
2026-08-11 CRC32 rejects a legal binary value produced by a window fixed — Yibo-Dong
2026-08-09 `WHERE
fixed — wanteatfruit
2026-08-08 `TRIM` panics on a native `TIME` value fixed — Yibo-Dong
2026-08-08 `MIN` panics on a legal empty leading `ROWS` frame open — Yibo-Dong
2026-08-08 `LAST_INSERT_ID(NULL)` panics on a nil result fixed — Yibo-Dong
2026-08-08 `DEFAULT(column)` reaches an unresolved placeholder during SELECT analysis fixed — Yibo-Dong
2026-08-08 `CHAR` PAD SPACE values split a window partition open — Yibo-Dong
2026-08-08 `BIN_TO_UUID` panics for a NULL swap flag fixed — Yibo-Dong
2026-08-08 Window `AVG` drops a non-NULL nonnumeric `VARCHAR` open — Yibo-Dong
2026-08-08 Temporal `RANGE INTERVAL` endpoints use incompatible types open — Yibo-Dong
2026-08-08 Legal `BIT(2)` RANGE following frame panics fixed — Yibo-Dong
2026-08-08 Final window `ORDER BY` on a set operation panics fixed — Yibo-Dong
2026-08-08 Empty value-window frame is incorrectly non-nullable in CTAS fixed — Yibo-Dong
2026-08-08 Dolt sibling NTILE expressions reuse the first bucket count fixed — Yibo-Dong
2026-08-08 Dolt reverses the direction of a numeric `DESC RANGE` offset frame open — Yibo-Dong
2026-08-08 Dolt panics with `Interval.Eval`within standalone `INTERVAL` expression fixed — Yibo-Dong
2026-08-08 Dolt panics when `FIRST_VALUE` receives the star placeholder fixed — Yibo-Dong
2026-08-08 Dolt panics on an unchecked AST cast within prepared `CREATE PROCEDURE` fixed — Yibo-Dong
2026-08-08 Dolt panics on a non-numeric NTILE bucket expression fixed — Yibo-Dong
2026-08-08 Dolt loses an explicit full frame when a named window inherits a base window open — Yibo-Dong
2026-08-08 Dolt forms incorrect `RANGE` boundaries for a correlated computed order key open — Yibo-Dong
2026-08-08 Distinct window partition/order shapes collide in `PartitionId` open — Yibo-Dong
2026-08-06 `if(, , )` in a WHERE over a view raises internal error open — wanteatfruit
2026-08-06 `COUNT(*) OVER ()` returns 1 instead of the partition size fixed — wanteatfruit
2026-08-06 ` SPACE(n)` results in a hang when `n` is large open — wanteatfruit
2026-08-06 Dolt window `SUM` returns `0` for an all-NULL frame. fixed — Yibo-Dong
2026-08-06 Dolt returns a negative value for `ABS(-9223372036854775808)`. fixed — Yibo-Dong
2026-08-06 Dolt reports an internal row-index bug for invalid `NTILE(column)`. open — Yibo-Dong
2026-08-06 Dolt rejects unary negation of a `ROW_NUMBER()` window result. fixed — Yibo-Dong
2026-08-06 Dolt rejects a repeated window expression in `ORDER BY` as ambiguous. open — Yibo-Dong
2026-08-06 Dolt raises an internal row-index error for `EXISTS` with a window expression. open — Yibo-Dong
2026-08-06 Dolt panics when preparing/executing `CREATE EVENT`. fixed — Yibo-Dong
2026-08-06 Dolt panics when a named window inherits from an undefined window. fixed — Yibo-Dong
2026-08-06 Dolt panics for `FIRST_VALUE` with an empty `OVER ()` spec. fixed — Yibo-Dong
2026-08-06 Dolt misorders a window when `ORDER BY` contains a correlated scalar subquery. open — Yibo-Dong
2026-08-06 Dolt ignores secondary `ORDER BY` keys for `RANGE CURRENT ROW` peer groups. open — Yibo-Dong
2026-08-06 Dolt ignores `LIMIT` inside a correlated `EXISTS` subquery. fixed — Yibo-Dong
2026-08-06 Dolt converts valid date strings with leading or trailing whitespace to `NULL` fixed — Yibo-Dong
2026-08-06 Dolt arithmetic on `BIGINT UNSIGNED` values wraps into signed negative values. open — Yibo-Dong
2026-08-06 Dolt aggregate numeric coercion over `TIME` returns zero. fixed — Yibo-Dong
2026-08-06 Dolt `TIME_FORMAT` mishandles hour format specifiers for `TIME` values. fixed — Yibo-Dong
2026-08-06 Dolt `ONLY_FULL_GROUP_BY` recognizes functional dependency through a primary key but not through a `UNIQUE ... fixed — Yibo-Dong
2026-08-06 Dolt `JSON_EXTRACT` does not preserve large JSON integer values. open — Yibo-Dong
2026-08-06 Dolt `GROUP_CONCAT(expr1, expr2, ...)` ignores later expressions. fixed — Yibo-Dong
2026-08-06 Dolt `GROUP_CONCAT(BIT)` concatenates numeric text instead of BIT bytes. open — Yibo-Dong
2026-08-05 Dolt supports `BIT_AND`, `BIT_OR`, and `BIT_XOR` as ordinary aggregates, but the same functions fail when u... fixed — Yibo-Dong
2026-08-05 Dolt silently ignores `DISTINCT` for `COUNT` and `SUM` window aggregates. open — Yibo-Dong
2026-08-05 Dolt sibling window aggregates with different explicit frames reuse the wrong frame. fixed — Yibo-Dong
2026-08-05 Dolt raises an internal row-index error for empty`INSERT ()` open — Yibo-Dong
2026-08-05 Dolt raises an internal field-index error for sibling `SUM`/`AVG` windows open — Yibo-Dong
2026-08-05 Dolt panics when evaluating `LOCATE` with a negative start position. fixed — Yibo-Dong
2026-08-05 Dolt panics when `JSON_TABLE` is evaluated over JSON `null`. fixed — Yibo-Dong
2026-08-05 Dolt panics when `DEFAULT` is used in an `ON DUPLICATE KEY UPDATE` assignment. fixed — Yibo-Dong
2026-08-05 Dolt panics for a `RANGE BETWEEN CURRENT ROW AND 1 FOLLOWING` window over a `SET` order key. fixed — Yibo-Dong
2026-08-05 Dolt computes population statistical aggregates incorrectly for `INT` input. open — Yibo-Dong
2026-08-05 Dolt `RANGE BETWEEN 1 PRECEDING AND CURRENT ROW` over `BIGINT UNSIGNED` loses the current row at the lower ... open — Yibo-Dong
2026-08-05 Dolt `LAST_VALUE` with an explicit `RANGE` peer frame mishandles a `NULL` order key. open — Yibo-Dong
2026-08-03 `RPAD()/LPAD()` has unexpected behvior open — wanteatfruit
2026-08-03 Aggregate window function with `OVER (ORDER BY
fixed — wanteatfruit
2026-07-31 Correlated subquery over a column-split-rejoin view raises internal "unable to find field with index" plann... fixed — wanteatfruit
2026-07-02 Incorrect indexes in left outer lookup join fixed — Zhaokun Xiang
2026-07-01 Avoid RangeHeapJoin when lower and upper bounds are the same field fixed — Zhaokun Xiang
2026-06-02 `ColumnId`'s not added for `EmptyTable` during `assignExecIndexes`, causing offset when getting column index fixed — Zhaokun Xiang
2026-06-02 Disable RangeHeapJoin with string and number columns fixed — Zhaokun Xiang
2026-06-01 `abs` returns `null` when inputs are boolean values fixed — Zhaokun Xiang
2026-06-01 `NATURAL FULL JOIN` incorrectly parsed as `NATURAL RIGHT JOIN` fixed — Zhaokun Xiang
2026-02-01 `WHERE NOT EXISTS` from an empty view does not return correct results fixed — Zhaokun Xiang
2025-12-27 Booleans should not be used as keys for varchar index lookups fixed — Zhaokun Xiang
2025-12-25 Unexpected Anti Join Result fixed — Zhaokun Xiang
2025-12-21 Unexpected Anti Join Result fixed — Zhaokun Xiang
2025-12-20 Lookup Join returns incorrect result due to out-of-range key conversion fixed — Zhaokun Xiang
2025-12-11 Unexpected Result in ANTI-JOIN fixed — Zhaokun Xiang
2025-11-19 Unexpected ANTI JOIN Result fixed — Zhaokun Xiang
2025-11-18 Unexpected ANTI JOIN Result fixed — Zhaokun Xiang
2025-11-13 Unexpected `DAYOFMONTH` Result fixed — Zhaokun Xiang
2025-11-11 Unexpected UNION ALL Result of INNER JOIN and ANTI JOIN fixed — Zhaokun Xiang
2025-10-08 Use of invisible hash index under-fetches rows fixed — EmilyOng
2025-10-08 Incorrect use of negation in AntiJoinIncludingNulls fixed — EmilyOng
2025-10-07 Incorrect double-negation of integer fixed — EmilyOng
2025-09-12 Unexpected Result Under Hint fixed — Zhaokun Xiang
2025-06-09 Using an IFNULL with TINYINT param restricts the output as TINYINT fixed — EmilyOng
2025-06-08 Group-By with `IF` function fails to distinguish the integer "1" and the boolean value "true" fixed — EmilyOng
2025-04-05 Unexpected type conversion in IFNULL fixed — EmilyOng
2025-04-04 Incorrect optimization of AND operation in expression in WHERE clause fixed — EmilyOng
2025-03-31 Incorrect optimization of OR operation in expression in WHERE clause fixed — EmilyOng
2025-03-31 Incorrect negation of minimum signed integer fixed — EmilyOng
2025-03-31 Double negation is treated as original value in WHERE clause fixed — EmilyOng
2025-03-26 Unexpected invalid type error on boolean fixed — EmilyOng
2025-03-26 Unexpected crash when using GROUP BY with non-column position fixed — EmilyOng
2025-03-26 NULL in GROUP BY column is interpreted as 1 fixed — EmilyOng
2025-03-12 Unexpected ANTI JOIN Result fixed — Zhaokun Xiang
2024-05-01 Unexpected Results when Using BETWEEN AND after CREATE INDEX fixed — Suyang Zhong
2024-05-01 Unexpected Result when Querying with CONCAT fixed — Suyang Zhong
2024-05-01 Panic when Using INNER JOIN with String in IN fixed — Suyang Zhong
2024-04-01 Unexpected Result when Using -'' in IN fixed — Suyang Zhong
2024-03-01 Panic when Using INNER JOIN fixed — Suyang Zhong
2024-02-18 Crash by IF and CHAR fixed — Suyang Zhong
2024-01-19 Unexpected results when comparing string with type conversion verified — Suyang Zhong
2024-01-19 Crash by INNER JOIN fixed — Suyang Zhong
2024-01-17 Unexpected result when using Boolean in IN fixed — Suyang Zhong
2024-01-16 Unexpected results when comparing with empty string fixed — Suyang Zhong
2024-01-04 Unexpected Result when Using `-''` in `IN` fixed — suyZhong
2024-01-01 Unexpected Results when Using BETWEEN and LEFT JOIN fixed — Suyang Zhong
2023-12-29 Unexpected Results when Using ROUND() fixed — suyZhong
2023-12-28 Panic when Using BETWEEN AND fixed — Suyang Zhong
2023-12-17 Previous panic concerning CASE WHEN fixed — suyZhong
2023-12-13 Unexpected Results when Using IN after Creating Index fixed — Suyang Zhong
2023-12-13 Panic when Using BETWEEN and CASE WHEN fixed — Suyang Zhong
2023-12-12 Unexpected Results of In expressions fixed — Suyang Zhong
2023-11-30 Unexpected Results when Querying with COT fixed — Suyang Zhong
2023-11-30 Potential Issue Using ROUND fixed — suyZhong
2023-11-29 Crash by SQRT fixed — suyZhong
2023-11-28 Crash by Time Functions fixed — suyZhong
2023-11-23 Crash by ACOS fixed — suyZhong
2023-11-22 Unexpected Results about Decimal-Boolean Casting in Filters fixed — Suyang Zhong
2023-11-22 Crash by Function DAYNAME fixed — Suyang Zhong
2023-11-19 Unexpected Results when Querying with NULL values fixed — Suyang Zhong
2023-11-19 Crashing by Division Operators fixed — Suyang Zhong
2023-11-17 Unexpected Results about Floating-point Type Casting fixed — Suyang Zhong
2023-11-16 Unexpected Results when Using '%' operator fixed — Suyang Zhong
2023-07-12 Unexpected Results when Using IN for Floating-Point 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.