← Bugs over time

SQLancer is credited with 22 bugs reported in 2021, across 6 database systems, between 2021-01-20 and 2021-12-28. A further 2 reports were filed that year and rejected by the developers as invalid or duplicate; those are kept in the dataset and counted nowhere.

Which systems (6)

CockroachDB
10
ClickHouse
4
StarRocks
3
YugabyteDB
3
DuckDB
1
Hazelcast
1

Each system's own page carries its whole history rather than this year's share: CockroachDB, ClickHouse, StarRocks, YugabyteDB, DuckDB, Hazelcast.

How they break down

Who found them

Found by someone outside the project
22

By status

Fixed
21
Open
1

By symptom

Unclassified
22

By technique

Ternary Logic Partitioning (TLP)
11
Technique not recorded
11

Why each bug counts

The report names SQLancer
9
The report names a SQLancer oracle
8
The reproducer carries SQLancer's generated schema
5

Who reported them

mgartner
6
cockroach-teamcity
3
qoega
3
qvad
3
wanpengfei-git
2
Fly-Style
1
dirtysalt
1
hannes
1

Every bug reported in 2021 (24)

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 System Status Reporter
2021-12-28 roachtest: tlp failed CockroachDB fixed cockroach-teamcity
2021-12-22 Query return error: No equal on predicate in LEFT SEMI JOIN is not supported StarRocks fixed wanpengfei-git
2021-12-22 sql: corruption of unique index with virtual computed column (or expression column) CockroachDB fixed mgartner
2021-11-29 Constant-cmp-Column not supported here, should be deal earlier StarRocks fixed wanpengfei-git
2021-10-29 SQL: Various wrong query results with string functions [HZ-1229] Hazelcast fixed Fly-Style
2021-10-28 [YSQL] [SQLancer] A lot of catalog consistency related exceptions during evaluating test in parallel YugabyteDB closed not a bug qvad
2021-10-16 Sqlancer crashes in ASAN Mode StarRocks fixed dirtysalt
2021-10-08 SQLancer: IOException occurs on UDPATE statement (local and cluster modes are affected) YugabyteDB fixed qvad
2021-10-01 SQLancer: Wrong result in non-optimised query if current_query() function call used YugabyteDB fixed qvad
2021-10-01 SQLancer: Server restarts during evaluating workload YugabyteDB closed not a bug qvad
2021-09-29 sqlancer: Hitting issue when creating temporary table with PK and ON COMMIT DELETE in parallel wo... YugabyteDB open qvad
2021-09-22 TLP Failure with COUNT CockroachDB fixed nehageorge
2021-08-31 sql: computed column expressions incorrectly evaluated when dependent on certain types CockroachDB fixed mgartner
2021-08-24 sql: computed column expressions incorrectly evaluated when dependent on "char" type CockroachDB fixed mgartner
2021-08-16 sql: vectorized IN evaluation incorrectly assumes the RHS tuple contents are sorted CockroachDB fixed cockroach-teamcity
2021-07-01 table with a `CHECK (false)` constraint allows inserts CockroachDB fixed mgartner
2021-07-01 potential correctness bug in 21.1 found by SQLancer CockroachDB fixed mgartner
2021-06-22 colfetcher: incorrect decoding of unique secondary indexes with multiple column families CockroachDB fixed cockroach-teamcity
2021-05-11 Cannot convert column `less(c0, c1)` because it is non constant in source stream but must be cons... ClickHouse fixed qoega
2021-04-13 Logical error: Block structure mismatch in QueryPipeline::unitePipelines stream: different columns ClickHouse fixed songenjie
2021-03-19 release-20.2: DROP DATABASE causes ERROR: descriptor not found CockroachDB fixed mgartner
2021-01-27 Filter issue with `IN` and `NULL` DuckDB fixed hannes
2021-01-20 UndefinedBehaviorSanitizer AggregateFunctionAvg.h:153: runtime error: signed integer overflow: ..... ClickHouse fixed qoega
2021-01-20 Logical error: 'Constraint `x0` does not return a value of type UInt8 ClickHouse fixed qoega

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.