← All database systems

CockroachDB is supported by SQLancer — the main repository ships a testing implementation for it. SQLancer is credited with 202 bugs in it, reported between 2020-01-01 and 2026-09-13. Its source is at cockroachdb/cockroach.

A further 11 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.

SQLancer and this project

Adoption proposed, not yet shown

The project's developers have proposed adopting SQLancer without anything yet showing the project running it. An intention is not use, so this counts towards no figure on the impact page.

srosenberg, contributor of the CockroachDB project, proposed adopting SQLancer; the issue is open.

running `sqlancer
Issue in the CockroachDB tracker proposing SQLancer, opened by srosenberg (contributor).
cockroachdb/cockroach/issues/110322
add a _long-running_ workload utilizing `sqlancer
Issue in the CockroachDB tracker proposing SQLancer, opened by srosenberg (contributor).
cockroachdb/cockroach/issues/110528
running `sqlancer
Issue in the CockroachDB tracker proposing SQLancer, opened by srosenberg (contributor).
cockroachdb/cockroach/issues/110321
running sqlancer
Issue in the CockroachDB tracker proposing SQLancer, opened by rharding6373 (collaborator).
cockroachdb/cockroach/issues/101964
Add additional features to SQLancer
Issue in the CockroachDB tracker proposing SQLancer, opened by mgartner (contributor).
cockroachdb/cockroach/issues/62902

How the bugs break down

By year reported

2020
71
2021
10
2022
34
2023
12
2024
6
2025
37
2026
12
Year not recorded
20

Who found them

Found by the SQLancer project
127
Found by someone outside the project
56
Reporter not recorded
19

By status

Fixed
161
Confirmed
16
Open
25

By symptom

Logic bug
15
Unexpected error
46
Crash
5
Hang
1
Unclassified
135

By technique

Technique not recorded
141
Ternary Logic Partitioning (TLP)
53
Non-optimizing Reference Engine Construction (NoREC)
7
Pivoted Query Synthesis (PQS)
1

Why each bug counts

Listed in the project's own bug repository
71
The report names a SQLancer oracle
61
The reproducer carries SQLancer's generated schema
53
Filed by someone who runs SQLancer campaigns
13
The report names SQLancer
4

Who reported them (8)

Manuel Rigger
67
cockroach-teamcity
40
DerZc
32
bajinsheng
19
mgartner
7
mrigger
3
srosenberg
3
TheoristCoder
2

Every bug on record (213)

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-13 sql: ST_DWithin inverted join fails for POINT EMPTY geography input open — DerZc
2026-08-01 sql: Internal error "expected inverted index scan to have a constraint" for TIMETZ[] inverted index with NU... fixed — Annie191
2026-07-02 sql/flowinfra: row stream can emit unset EncDatum row after INTERVAL encode overflow open — srosenberg
2026-04-12 roachtest: tlp failed fixed TLP cockroach-teamcity
2026-03-05 Unexpected Fault error fixed — DerZc
2026-03-04 Index makes the normal SELECT query slow down fixed — DerZc
2026-02-05 redundant join operation in the query plan of a normal SELECT open — DerZc
2026-02-05 Inefficient query plan of a normal SELECT with merge join open — DerZc
2026-02-04 redundant filter and render in the query plan of a normal SELECT with empty table fixed — DerZc
2026-02-04 Less efficient query plan generated by normal SELECT than the equivalent prepared SELECT related to group a... closed not a bug — DerZc
2026-02-03 Less efficient query plan generated by normal SELECT than the equivalent prepared SELECT fixed — DerZc
2026-01-19 ERROR: internal error: could not find format code for column 1 in [FormatText] fixed — DerZc
2026-01-09 BYTEA to text to BYTEA generate inconsystent value from the original one fixed — DerZc
2025-12-10 roachtest: tlp failed [flake due to lack of `ORDER BY` with `LIMIT` clause] open TLP cockroach-teamcity
2025-12-10 internal error: non-const expression: function: current_user [type=string] fixed — DerZc
2025-12-10 Unexpected result of BIT_AND in prepared statement fixed — DerZc
2025-12-09 sql: type annotation does not work correctly in prepared statement open — DerZc
2025-12-09 Unexpected result of prepared statement with JOINing subquery fixed — DerZc
2025-10-26 roachtest: tlp failed fixed TLP cockroach-teamcity
2025-10-15 Malformed SPLIT_PART error is silently ignored when used in ORDER BY fixed — EmilyOng
2025-10-09 Unexpected error "ERROR: overflow during Encode" fixed — DerZc
2025-09-30 roachtest: tlp failed due to unordered limit fixed TLP cockroach-teamcity
2025-09-18 Unexpected error `ERROR: internal error: non-int start argument type unknown` fixed — DerZc
2025-09-17 Unexpected error when bind a value in GROUP BY fixed — DerZc
2025-09-17 Unexpected error of MAX(NULL) in prepared statement `ERROR: no builtin aggregate for MAX on [unknown]` open — DerZc
2025-09-17 EXECUTE a select statement triggers unexpected error `No results were returned by the query` fixed — DerZc
2025-09-15 EXPLAIN statement triggers unexpected error with JDBC: `A result was returned when none was expected.` fixed — DerZc
2025-09-15 EXECUTE statement triggers unexpected error with JDBC: `Received resultset tuples, but no field structure f... fixed — DerZc
2025-09-04 Incorrect plan time of prepared statement fixed — DerZc
2025-09-03 Unexpected internal error triggered by prepared statement:`trying to add a column of UNKNOWN type at index ... fixed — DerZc
2025-08-30 Unexpected syntex error when use COLLATE in the definition of the default value of a column open — DerZc
2025-08-30 Unexpected error in prepared statement fixed — DerZc
2025-08-28 Unexpected error when insert a collatedstring{es}[] value into column with type string[] open — DerZc
2025-08-28 Integer overflow with prepared statement open — DerZc
2025-08-28 IF operator has wrong result in prepared statement fixed — DerZc
2025-08-21 remote wall time is too far ahead to be trustworthy fixed — DerZc
2025-08-06 sql: secondary index corruption for `0::REGCLASS::STRING` when handling Oid column open TLP cockroach-teamcity
2025-07-07 a single float8 constant was parsered to different float value in a single query open — DerZc
2025-06-13 Unexpected Result of a complex expression open — bajinsheng
2025-06-02 Join with internal error: unexpected error from the vectorized engine: runtime error fixed — TheoristCoder
2025-06-02 Join panic with connection lost: ERROR: a panic has occurred invalid datum type given: DECIMAL, expected INT4 fixed — TheoristCoder
2025-05-25 roachtest: tlp failed fixed TLP cockroach-teamcity
2025-05-17 Unexpected Result of to_regclass() fixed — bajinsheng
2025-05-05 Crash of Truncate fixed — bajinsheng
2025-05-01 runtime error: index out of range in SPLIT_PART() fixed — bajinsheng
2025-04-24 Unexpected -0.0 open — bajinsheng
2025-03-15 roachtest: tlp failed fixed TLP cockroach-teamcity
2025-02-06 Join Crash with ERROR: internal error: invalid datum type given fixed — Zhaokun Xiang
2025-02-04 roachtest: tlp failed fixed TLP cockroach-teamcity
2025-01-12 ERROR: internal error: inconsistent Case return types bool unknown closed not a bug — DerZc
2025-01-05 roachtest: tlp failed fixed TLP cockroach-teamcity
2024-11-29 roachtest: incorrect geo results with tlp fixed TLP cockroach-teamcity
2024-11-28 Performance of Query 63 in TPC-DS Benchmark open — bajinsheng
2024-11-12 Performance of Query 7 on TPC-H Benchmark open — bajinsheng
2024-09-15 roachtest: tlp failed fixed TLP cockroach-teamcity
2024-09-13 Unexpected result when using a record in WHERE filter fixed — suyZhong
2024-07-28 roachtest: tlp failure: false vs NULL fixed TLP cockroach-teamcity
2023-09-29 Unexpected Error: overflow during Encode fixed — bajinsheng
2023-09-29 Unexpected Error for timestamp overflow fixed — bajinsheng
2023-09-29 Unexpected Error for ascii() fixed — bajinsheng
2023-09-12 Integer Overflow with Index Hints fixed — bajinsheng
2023-09-10 upgrades: auto-repair of catalog corruptions during upgrade may extend cluster finalization indefinitely fixed — srosenberg
2023-09-10 sql: data race in NewDCollatedString open — srosenberg
2023-06-07 sql: unexpected internal error message from new schema changer during CREATE INDEX fixed — DerZc
2023-05-30 roachtest/tlp: 'expected unpartitioned and partitioned results to be equal' assertion fixed TLP irfansharif
2023-04-29 sql: inconsistent ASC/DESC ordering of BOX2D fixed TLP cockroach-teamcity
2023-04-20 sql: create unique index error: failed to construct index entries during backfill: overflow during Encode fixed — rharding6373
2023-04-15 `SQRDIFF` has different results when the order of arguments changed open — DerZc
2023-04-05 internal error about index fixed — DerZc
2022-12-24 ERROR: internal error: expected *DInt, found tree.dNull unknown — bajinsheng
2022-10-18 Suspicious Estimated Rows by `OR` unknown — bajinsheng
2022-10-18 Suspicious Estimated Rows by `DISTINCT` open — bajinsheng
2022-10-11 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-10-10 opt: internal error in FoldBinaryCheckOverflow fixed — mgartner
2022-10-06 Unexpected Estimated Rows in `HAVING` clause open — bajinsheng
2022-10-02 An Issue of Estimated Rows unknown — bajinsheng
2022-09-30 roachtest.tlp failed: incorrect cardinality of EXCEPT produces incorrect results fixed TLP rytaft
2022-09-30 Estimated Rows of `RIGHT JOIN` and `FULL OUTER JOIN` fixed — bajinsheng
2022-09-29 roachtest: tlp failed: SplitLimitedSelectIntoUnionSelects makes incorrect transformation fixed TLP cockroach-teamcity
2022-09-29 Suspicious Estimated Rows of `HAVING` Clause fixed — bajinsheng
2022-09-28 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-09-22 Potential Issue for Estimated Rows unknown — bajinsheng
2022-09-21 internal error: index found in depended-on-by references, no such index in this relation fixed — bajinsheng
2022-09-19 An unexpected error in `LEFT LOOKUP JOIN` fixed — bajinsheng
2022-09-18 tlp: row with null regproc missing from partitioned query fixed TLP cockroach-teamcity
2022-09-18 An Unexpected Error in `CROSS MERGE JOIN` unknown — bajinsheng
2022-08-03 Unexpected Result by UNION unknown — bajinsheng
2022-08-01 sql: No Result Returned by SHOW COLUMN on a temporary table open — bajinsheng
2022-07-23 roachtest: tlp failed on complex join condition involving geometry fixed TLP cockroach-teamcity
2022-07-08 Crash: panic: RecordingStructured has 30 recordings; expected 1 unknown — bajinsheng
2022-07-07 Crashing by EXPLAIN Statement unknown — bajinsheng
2022-07-04 sql: support SCRUB on temp tables open — bajinsheng
2022-07-03 sql: Duration.Encode overflows causing incorrect results fixed TLP cockroach-teamcity
2022-06-29 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-06-23 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-05-26 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-05-20 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-04-22 geoindex: false negatives producing incorrect results for geography intersection open TLP cockroach-teamcity
2022-04-16 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-04-15 sql: v21.2, v22.1 incorrect results for st_intersects filter fixed TLP cockroach-teamcity
2022-04-14 sql: v22.1: spurious tlp failure due to string comparison fixed TLP cockroach-teamcity
2022-04-10 tlp: do not generate mutations in partitioned/unpartitioned queries fixed TLP cockroach-teamcity
2022-04-03 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-03-30 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-03-25 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-03-23 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-03-19 roachtest: tlp failed fixed TLP cockroach-teamcity
2022-03-02 roachtest: -0 is not converted to 0, causing spurious tlp failure fixed TLP cockroach-teamcity
2022-02-21 opt: cascading deletes do not correctly remove KVs of indexes on virtual columns fixed TLP cockroach-teamcity
2022-02-09 sql: incorrect splitting lookup span into family spans fixed TLP cockroach-teamcity
2022-01-11 roachtest: tlp failed fixed TLP cockroach-teamcity
2021-12-28 roachtest: tlp failed fixed TLP cockroach-teamcity
2021-12-22 sql: corruption of unique index with virtual computed column (or expression column) fixed TLP mgartner
2021-09-22 TLP Failure with COUNT fixed TLP nehageorge
2021-08-31 sql: computed column expressions incorrectly evaluated when dependent on certain types fixed TLP mgartner
2021-08-24 sql: computed column expressions incorrectly evaluated when dependent on "char" type fixed TLP mgartner
2021-08-16 sql: vectorized IN evaluation incorrectly assumes the RHS tuple contents are sorted fixed TLP cockroach-teamcity
2021-07-01 table with a `CHECK (false)` constraint allows inserts fixed — mgartner
2021-07-01 potential correctness bug in 21.1 found by SQLancer fixed — mgartner
2021-06-22 colfetcher: incorrect decoding of unique secondary indexes with multiple column families fixed TLP cockroach-teamcity
2021-03-19 release-20.2: DROP DATABASE causes ERROR: descriptor not found fixed — mgartner
2020-12-15 opt: internal error for comparison overload not found fixed — jordanlewis
2020-04-10 BETWEEN expression with an INTERVAL and DECIMAL cast results in an incorrect result fixed TLP Manuel Rigger
2020-04-09 Arithmetic expression results in "internal error: could not find type for binary expression mult" fixed — mrigger
2020-04-07 SCRUB on a table with FLOAT PRIMARY KEY and INTERLEAVE IN PARENT index causes server to exit verified — Manuel Rigger
2020-04-07 ORDER BY unexpectedly causes a value to be represented in E notation when VECTORIZE=on fixed TLP Manuel Rigger
2020-04-07 Disconnecting from server results in crash with "unexpected leftover bytes" verified — Manuel Rigger
2020-04-07 Column that is used both as an INT2 and INT4 results in an internal error fixed — Manuel Rigger
2020-04-07 CREATE INDEX results in "invalid interleave backreference" and prevents database from being dropped verified — Manuel Rigger
2020-04-04 TRUNCATE on temporary table results in "unexpected value: " fixed — Manuel Rigger
2020-04-04 SELECT statement on table with a hash-sharded index results in an internal error fixed — Manuel Rigger
2020-04-04 SCRUB on a temporary table that has a hash-sharded index results in an error verified — Manuel Rigger
2020-04-04 Internal error for an invalid CREATE INDEX statement fixed — Manuel Rigger
2020-04-04 Incorrect result for query on interleaved index when vectorize=on fixed TLP Manuel Rigger
2020-04-04 COLLATE in array causes an internal error "ARRAY[]:::STRING[] COLLATE en: incompatible type for COLLATE: st... fixed — mrigger
2020-04-03 Query with an invalid regular expression unexpectedly does not fail fixed TLP Manuel Rigger
2020-04-03 Comparison with (-9223372036854775808)::TIMESTAMP results in an unexpected error fixed — Manuel Rigger
2020-04-03 CREATE STATISTICS on table with ARRAY column fixed — Manuel Rigger
2020-04-03 CAST to INT2 yields an incorrect/inconsistent result verified TLP Manuel Rigger
2020-04-02 Unexpected syntax error for expression involving ARRAY[NULL] verified — Manuel Rigger
2020-04-02 Internal error: lookup for ComparisonExpr ((@2)[float] != ('NaN')[string])[bool]'s CmpOp failed fixed — Manuel Rigger
2020-03-29 Internal error for vectorize=on and multiplication of INT4 values fixed — Manuel Rigger
2020-03-24 Query with HAVING clause, DISTSQL=off, and vectorize=on results in an internal error verified — Manuel Rigger
2020-03-22 HAVING clause incorrectly evaluates to TRUE for VARIANCE(0) IS NOT NULL predicate fixed TLP Manuel Rigger
2020-03-21 UPSERT on table with FOREIGN KEY constraint results in an internal error "cannot convert int to type bool" fixed — Manuel Rigger
2020-03-21 UPSERT causes a decoding error in collated string column fixed — Manuel Rigger
2020-03-21 SCRUB fails for table that has a FOREIGN KEY constraint on a rowid column verified — Manuel Rigger
2020-03-21 NATURAL JOIN fails with "duplicate column name" on view fixed — Manuel Rigger
2020-03-21 INSERT ... DO NOTHING results in an error "UPSERT or INSERT...ON CONFLICT command cannot affect row a secon... fixed — Manuel Rigger
2020-03-21 EXPLAIN (VEC) results in an internal error "input to aggregatorBase is not an execinfra.OpNode" fixed — Manuel Rigger
2020-03-21 DROP DATABASE issue with TEMP tables fixed — Manuel Rigger
2020-03-17 VALUES table expression malfunctions with MAX fixed — mrigger
2020-03-17 Query with negative LIMIT results in an internal error "node lookup-join with MaxCost added to the memo" fixed — Manuel Rigger
2020-03-16 Incorrect result for MAX, INTERLEAVE IN PARENT, and vectorize=experimental_on fixed TLP Manuel Rigger
2020-03-14 EXPLAIN (VEC) SELECT results in an internal error "zero length schema unsupported" fixed — Manuel Rigger
2020-03-14 EXPLAIN (VEC) SELECT results in an internal error "input to aggregatorBase is not an execinfra.OpNode" fixed — Manuel Rigger
2020-02-26 COUNT_ROWS() malfunctions for GROUP BY fixed PQS Manuel Rigger
2020-02-17 Syntax error for multi-valued comparison and COLLATE verified — Manuel Rigger
2020-02-12 Internal error for VECTORIZE=experimental_on, DEFAULT_INT_SIZE=4, and aggregate query fixed — Manuel Rigger
2020-02-12 EXPERIMENTAL SCRUB TABLE crashes server for table with TIMESTAMP column fixed — Manuel Rigger
2020-02-11 Internal error for NATURAL JOIN on INT and INT4 column for VECTORIZE=experimental_on closed duplicate — Manuel Rigger
2020-02-09 Internal error when setting VECTORIZE = experimental_on and DEFAULT_INT_SIZE = 4 fixed — Manuel Rigger
2020-02-08 EXPERIMENTAL SCRUB TABLE results in an "overflow during Encode" error verified — Manuel Rigger
2020-02-07 Internal error for SUBSTRING, INT4 cast, and VECTORIZE=experimental_on fixed — Manuel Rigger
2020-02-06 NOT BETWEEN query on VIEW results in an internal error with VECTORIZE=experimental_on fixed — Manuel Rigger
2020-02-05 Unexpected error for aggregate functions verified — Manuel Rigger
2020-01-30 Server exits on query with LEFT JOIN fixed — Manuel Rigger
2020-01-30 Internal error for NATURAL JOIN and VECTORIZE='experimental_on' fixed — Manuel Rigger
2020-01-29 Multi-record UPSERT inserts duplicate values in PRIMARY KEY, resulting in inconsistent results fixed NOREC Manuel Rigger
2020-01-27 Internal error "estimated distinct count must be non-zero" fixed — Manuel Rigger
2020-01-26 Deadlock in SHOW TABLES fixed — Manuel Rigger
2020-01-23 Internal error setting tracing=true fixed — Manuel Rigger
2020-01-23 Internal error for CASE expression and VECTORIZE=experimental_on fixed — Manuel Rigger
2020-01-23 Incorrect result for IS NULL query on VIEW using SELECT DISTINCT verified NOREC Manuel Rigger
2020-01-22 SHOW EXPERIMENTAL_FINGERPRINTS error for STRING columns and character escapes verified — Manuel Rigger
2020-01-22 Query on VIEW with OFFSET NULL and WHERE condition involving CURRENT_USER() unexpectedly fetches a row fixed NOREC Manuel Rigger
2020-01-22 Incorrect result for query with IS NULL condition on UNIQUE column and VECTORIZE=experimental_on fixed NOREC Manuel Rigger
2020-01-21 TO_ENGLISH(-9223372036854775808) results in an internal error fixed — Manuel Rigger
2020-01-21 Internal error for BETWEEN operator and CAST to BYTES fixed — Manuel Rigger
2020-01-21 Incorrect result for BETWEEN SYMMETRIC query fixed NOREC Manuel Rigger
2020-01-20 Unexpected error when using EXPERIMENTAL SCRUB fixed — Manuel Rigger
2020-01-20 Internal error in expression that uses a CAST and COLLATE verified — Manuel Rigger
2020-01-20 DEFAULT value causes unexpected syntax error when executing INSERT fixed — Manuel Rigger
2020-01-19 Generated column causes query to omit a record in the result set fixed NOREC Manuel Rigger
2020-01-19 Crash when using VECTORIZE=experimental_on fixed — Manuel Rigger
2020-01-18 Incorrect result for LIKE query verified NOREC Manuel Rigger
2020-01-05 FULL JOIN with an SUBSTRING ON clause results in an internal error fixed — Manuel Rigger
2020-01-04 Internal error for query with negative LIMIT on view with negative LIMIT fixed — Manuel Rigger
2020-01-04 Internal error for case expression involving NULLIF and VECTORIZE=experimental_on fixed — Manuel Rigger
2020-01-03 Internal error for arithmetic operators and NULLIF fixed — Manuel Rigger
2020-01-02 Internal error for SUBSTRING with negative length and VECTORIZE=experimental_on fixed — Manuel Rigger
2020-01-01 Internal error for ILIKE_ESCAPE and special characters fixed — Manuel Rigger
2020-01-01 Complex ORDER BY clause results in internal error with VECTORIZE=experimental_on fixed — Manuel Rigger
— sql: truncate fails when an index is referenced by a view open — —
— sql: internal error on collated string array fixed — —
— sql: inconsistent estimated rows with JOINs fixed — —
— sql: Unexpected Error in SHOW COLUMNS with collated string open — —
— sql: Inconsistent estimated rows from WHERE clause fixed — —
— opt: internal error: no volatility for cast decimal::timestamp fixed — —
— opt: internal error: no output column equivalent to 2 fixed — —
— opt: internal error: lookup for ComparisonExpr fixed — —
— opt: internal error: estimated row count must be non-zero fixed — —
— opt: Internal Error: Comparison Overload not Found fixed — —
— opt: Inconsistent Case Return Types Decimal Int fixed — —
— internal error: comparison overload not found (ge, unknown, unknown) verified — Suyang Zhong
— estimated rows from `EXPLAIN SELECT` incorrectly reduced by DISTINCT fixed — —
— costfuzz: expected required columns to be a subset of output columns in projectBuildProvided fixed — —
— cannot cast jsonb numeric to type bool fixed — —
— Unexpected Overflow Error by Huge Interval Value fixed — —
— Unexpected Error of Unique Index fixed — —
— Unexpected Crash in Multiple Table Join fixed — —
— Invalid Memory Address Error of Specific SQL Query fixed — —
— ERROR: no builtin aggregate for SUM_INT on [unknown] fixed — —

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.