← Bugs over time

SQLancer is credited with 302 bugs reported in 2020, across 10 database systems, between 2020-01-01 and 2020-12-15. A further 7 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 (10)

DuckDB
85
CockroachDB
71
TiDB
61
MonetDB
41
H2
18
SQLite
11
MySQL
7
ClickHouse
5
Citus
2
Apache Doris
1

Each system's own page carries its whole history rather than this year's share: DuckDB, CockroachDB, TiDB, MonetDB, H2, SQLite, and 4 more.

How they break down

Who found them

Found by the SQLancer project
251
Found by someone outside the project
51

By status

Fixed
241
Fixed in documentation
2
Confirmed
56
Open
3

By symptom

Logic bug
94
Unexpected error
102
Crash
42
Hang
1
Unclassified
63

By technique

Technique not recorded
203
Ternary Logic Partitioning (TLP)
85
Non-optimizing Reference Engine Construction (NoREC)
11
Pivoted Query Synthesis (PQS)
3

Why each bug counts

Listed in the project's own bug repository
145
The report names a SQLancer oracle
94
The reproducer carries SQLancer's generated schema
48
The report names SQLancer
8
Filed by someone who runs SQLancer campaigns
7

Who reported them

Manuel Rigger
239
monetdb-team
41
mrigger
12
qoega
5
hannes
1
jordanlewis
1
nukoyluoglu
1
onderkalaci
1

Every bug reported in 2020 (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 System Status Reporter
2020-12-15 opt: internal error for comparison overload not found CockroachDB fixed jordanlewis
2020-12-13 Comparison with boolean unexpectedly evaluates to false DuckDB fixed mrigger
2020-11-30 Wrong result when dividing interval by literal float MonetDB fixed monetdb-team
2020-11-30 Some MAL function are mapped incorrectly MonetDB fixed monetdb-team
2020-11-30 Segfault on large chain of constant decimal multiplication MonetDB fixed monetdb-team
2020-11-30 SQLancer query: batcalc.between undefined MonetDB fixed monetdb-team
2020-11-30 SQLancer query: 'calc.bit' undefined MonetDB fixed monetdb-team
2020-11-30 SQLancer query: 'bat.append' undefined MonetDB fixed monetdb-team
2020-11-30 SQLancer query with wrong results MonetDB fixed monetdb-team
2020-11-30 SQLancer query with wrong results MonetDB fixed monetdb-team
2020-11-30 SQLancer query with wrong results MonetDB fixed monetdb-team
2020-11-30 SQLancer query copy on unique pair of columns fails and complex query with GDK error MonetDB fixed monetdb-team
2020-11-30 SQLancer query compilation error MonetDB fixed monetdb-team
2020-11-30 SQLancer project_bte: does not match always MonetDB fixed monetdb-team
2020-11-30 SQLancer insert function doesn't handle utf-8 strings MonetDB fixed monetdb-team
2020-11-30 SQLancer inputs not the same size MonetDB fixed monetdb-team
2020-11-30 SQLancer inputs not the same size MonetDB fixed monetdb-team
2020-11-30 SQLancer inner join reporting GDK error MonetDB fixed monetdb-team
2020-11-30 SQLancer generates query with unclear error message MonetDB fixed monetdb-team
2020-11-30 SQLancer generated SIGFPE MonetDB fixed monetdb-team
2020-11-30 SQLancer distinct aggregate with error on group by constant MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on rtrim function MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on query with HAVING MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on long query MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on join with coalesce MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on join query MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on delete query MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on cross join on view MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on complex query MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on complex join MonetDB fixed monetdb-team
2020-11-30 SQLancer crash on coalesce MonetDB fixed monetdb-team
2020-11-30 SQLancer causing 'algebra.select' undefined error MonetDB fixed monetdb-team
2020-11-30 SQLancer causes assertion error on UTF8_strlen MonetDB fixed monetdb-team
2020-11-30 SQLancer calc.date undefined MonetDB fixed monetdb-team
2020-11-30 SQLancer calc.abs undefined MonetDB fixed monetdb-team
2020-11-30 SQLancer alter table add unique gives strange error message MonetDB fixed monetdb-team
2020-11-30 SQLancer algebra.select' undefined 2 MonetDB fixed monetdb-team
2020-11-30 SQLancer algebra.select undefined MonetDB fixed monetdb-team
2020-11-30 SQLancer aggr.subavg undefined MonetDB fixed monetdb-team
2020-11-30 SQLancer TLP query with wrong results 3 MonetDB fixed monetdb-team
2020-11-30 SQLancer TLP query with wrong results 2 MonetDB fixed monetdb-team
2020-11-30 SQLancer TLP query with wrong results MonetDB fixed monetdb-team
2020-11-30 Query randomly failing with Object not found MonetDB fixed monetdb-team
2020-09-28 Typeof does not work when using JDBC DuckDB fixed mrigger
2020-09-24 Getting a query plan using JDBC DuckDB fixed mrigger
2020-09-24 Buffer overflow in duckdb::ART::IteratorNext DuckDB fixed Manuel Rigger
2020-08-27 Unexpected result for % and '1E1' SQLite fixed in documentation Manuel Rigger
2020-08-25 CREATE TABLE with a BINARY column and large size specification results in a NegativeArraySizeExce... H2 fixed Manuel Rigger
2020-08-24 Incorrect result for IN expression with right-hand IS TRUE sub-expression SQLite fixed Manuel Rigger
2020-08-20 Querying view that uses LTRIM/RTRIM results in a syntax error H2 fixed Manuel Rigger
2020-08-20 Call to STRINGDECODE results in StringIndexOutOfBoundsException H2 fixed Manuel Rigger
2020-08-19 Restore YEAR data type for MySQL compatibility mode H2 fixed Manuel Rigger
2020-08-19 ROUND() function runs very long H2 fixed Manuel Rigger
2020-08-19 Querying a view that uses the POSITION() function results in an unexpected syntax error H2 fixed Manuel Rigger
2020-08-19 MERGE INTO fails with an error "Timeout trying to lock table" H2 open Manuel Rigger
2020-08-19 MERGE INTO causes an unexpected syntax error H2 fixed Manuel Rigger
2020-08-19 INSERT() with NULL arguments for the original string and string to be added results in NPE H2 fixed Manuel Rigger
2020-08-19 Calling math functions with a string argument results in a NullPointerException H2 fixed Manuel Rigger
2020-08-19 MAX over empty set should return NULL according to standard SQL ClickHouse fixed qoega
2020-08-18 Table with a generated column cycle results in a NullPointerException H2 fixed Manuel Rigger
2020-08-18 Query with % operator results in a ClassCastException H2 fixed Manuel Rigger
2020-08-18 Query on view with BINARY column results in an unexpected syntax error H2 fixed Manuel Rigger
2020-08-18 DuckDB JDBC driver issue in the presence of other JDBC drivers DuckDB fixed mrigger
2020-08-15 Query on view that uses the BETWEEN operator results in an unexpected syntax error H2 fixed Manuel Rigger
2020-08-14 Unexpected result for query that compares an integer with a string H2 open Manuel Rigger
2020-08-14 Query with CASE operator unexpectedly results in "Column must be in the GROUP BY list" error H2 fixed Manuel Rigger
2020-08-12 Query with an expression "NOT NOT - C0" causes a NullPointerException H2 fixed Manuel Rigger
2020-08-12 Incorrect result for query and NOT (c0 != -1 AND c0) predicate H2 fixed Manuel Rigger
2020-08-12 Expression NOT(c0 AND c0) unexpectedly evaluates to FALSE H2 closed duplicate Manuel Rigger
2020-07-10 Invalid number of rows in Chunk column Int32: expected 99, got 5: While executing TinyLog ClickHouse fixed qoega
2020-07-07 HAVING clause can change result of aggregation ClickHouse fixed qoega
2020-07-06 Some check constraints on distributed tables fails Citus fixed onderkalaci
2020-06-30 ERROR: unrecognized node type: 127 with queries involving COLLATE Citus fixed nukoyluoglu
2020-06-24 Column ID mismatch in adaptive filters DuckDB fixed hannes
2020-06-24 Not obvious error message [Attempt to read after eof: while converting '' to Int32] ClickHouse open qoega
2020-06-24 Non-trivial error if Int is used in WHERE expression[DB::Exception: Bad get: has Int64, requested... ClickHouse fixed qoega
2020-06-15 BE crashed Apache Doris fixed sduzh
2020-05-26 Maven artifact & JDBC driver fat JAR DuckDB fixed mrigger
2020-05-07 SELECT with RIGHT JOIN causes an assertion failure "Assertion `!finalized' failed" DuckDB fixed Manuel Rigger
2020-05-06 Query using LEFT() results in a segmentation fault DuckDB fixed Manuel Rigger
2020-05-05 UPDATE on altered table results in an error "Could not find node in column segment tree" DuckDB fixed Manuel Rigger
2020-05-05 DROP column results in an assertion failure unique.index < base.columns.size(). DuckDB fixed Manuel Rigger
2020-05-05 DROP column results in an assertion failure unique.index < base.columns.size() 2 DuckDB fixed Manuel Rigger
2020-05-05 ALTER TYPE with USING results in an assertion failure "types.size() > 0" DuckDB fixed Manuel Rigger
2020-05-05 ALTER TABLE results in an assertion failure "Assertion `expr.return_type == vector.type' failed" DuckDB fixed Manuel Rigger
2020-05-04 Query on altered table results in a segmentation fault DuckDB fixed Manuel Rigger
2020-05-04 Failed ALTER COLUMN results in a "Transaction conflict" error that cannot be aborted DuckDB fixed Manuel Rigger
2020-05-02 Building duckdb_java.cpp fails with an include error DuckDB fixed mrigger
2020-05-01 Large argument to RPAD results in std::bad_alloc DuckDB fixed Manuel Rigger
2020-05-01 Incorrect result for MIN() on expression involving rowid DuckDB fixed Manuel Rigger
2020-04-29 GROUP BY does not take COLLATE into account DuckDB fixed Manuel Rigger
2020-04-29 BETWEEN with COLLATE NOACCENT.NOCASE expression results in a segfault/ASan failure DuckDB fixed Manuel Rigger
2020-04-28 UPDATE results in crash or assertion failure DuckDB fixed Manuel Rigger
2020-04-27 STDDEV_POP unexpectedly does not fetch any rows DuckDB fixed Manuel Rigger
2020-04-26 Expression with LIKE and comparison causes an assertion failure DuckDB fixed Manuel Rigger
2020-04-25 UNION operator malfunctions in LEFT JOIN on view SQLite fixed Manuel Rigger
2020-04-25 Subtracting a large integer from a DATE results in a "double free or corruption" DuckDB fixed Manuel Rigger
2020-04-25 Query with complex ORDER BY causes an incorrect rowid value DuckDB fixed Manuel Rigger
2020-04-25 Predicate checking for an empty string yields an incorrect result DuckDB fixed Manuel Rigger
2020-04-25 NOACCENT.NOCASE comparison with a special character results in a segmentation fault DuckDB fixed Manuel Rigger
2020-04-25 Creating an index on rowid results in an internal error "Failed to bind column reference" DuckDB fixed Manuel Rigger
2020-04-25 Comparison with a DATE yields an incorrect result DuckDB fixed Manuel Rigger
2020-04-25 Comparing a string with a boolean yields an incorrect result after UPDATE DuckDB fixed Manuel Rigger
2020-04-25 A select with BETWEEN and VARCHAR cast results in an incorrect result DuckDB fixed Manuel Rigger
2020-04-25 A negative DATE results in a "double free or corruption" crash DuckDB fixed Manuel Rigger
2020-04-24 Updated value in column is not visible in a SELECT DuckDB fixed Manuel Rigger
2020-04-24 SUBSTRING with an invalid start position causes a segmentation fault DuckDB fixed Manuel Rigger
2020-04-24 DISTINCT malfunctions for BOOLEAN DuckDB fixed Manuel Rigger
2020-04-23 Value in generated column depends on a WHERE clause TiDB verified Manuel Rigger
2020-04-23 Fetching from a view with an escaped backslash results in an unexpected syntax error TiDB verified Manuel Rigger
2020-04-23 A predicate with COLLATE 'binary' results in a server panic "invalid memory address or nil pointe... TiDB fixed Manuel Rigger
2020-04-22 Using an index twice in an index hint results in an incorrect result TiDB verified Manuel Rigger
2020-04-22 UNIQUE constraint on boolean column results in an incorrect result in a comparison TiDB verified Manuel Rigger
2020-04-22 UNIQUE constraint on DECIMAL/floating-point columns causes incorrect result for NULL in AND TiDB verified Manuel Rigger
2020-04-22 SELECT with ORDER BY results in an "inconsistent index" error TiDB verified Manuel Rigger
2020-04-22 Inf value in FLOAT column causes JDBC driver error TiDB verified Manuel Rigger
2020-04-22 INSERT INTO with ON DUPLICATE clause results in an unexpected "key not exist" error TiDB verified Manuel Rigger
2020-04-22 INSERT INTO with ON DUPLICATE clause results in an unexpected "Miss column" error TiDB verified Manuel Rigger
2020-04-22 INSERT IGNORE allows NULL value in a NOT NULL generated column TiDB verified Manuel Rigger
2020-04-22 INL_HASH_JOIN hint causes an incorrect result for a table with a generated column TiDB verified Manuel Rigger
2020-04-22 CREATE TABLE with generated column unexpectedly causes a syntax error TiDB verified Manuel Rigger
2020-04-22 CREATE TABLE with generated column and escaped backslash causes a syntax error TiDB verified Manuel Rigger
2020-04-20 Incorrect result for LEFT JOIN AND NULLIF TiDB verified Manuel Rigger
2020-04-19 Unexpected error "Data Too Long" when using a WHERE clause in an UPDATE TiDB verified Manuel Rigger
2020-04-19 Query using PREFIX() results in an error std::bad_alloc DuckDB fixed Manuel Rigger
2020-04-19 Incorrect result for BETWEEN query that casts column to boolean DuckDB fixed Manuel Rigger
2020-04-16 REVERSE() on special character results in "Assertion `strcmp(dataptr, normalized) == 0' failed." DuckDB fixed Manuel Rigger
2020-04-15 Using the DEFAULT() function results in an ambiguous column error TiDB verified Manuel Rigger
2020-04-15 Server panic for predicate t0.c0=9223372036854775808 when using partitions TiDB verified Manuel Rigger
2020-04-15 Server panic for NATURAL LEFT JOIN on partitioned table TiDB verified Manuel Rigger
2020-04-15 RIGHT JOIN with ELT() predicate returns an incorrect result TiDB verified Manuel Rigger
2020-04-15 NATURAL LEFT JOIN with a NOT predicate results in a server panic TiDB fixed Manuel Rigger
2020-04-15 NATURAL LEFT JOIN results in incorrect result for <=> operator TiDB verified Manuel Rigger
2020-04-15 Internal error message when using CASE in partitioned table TiDB verified Manuel Rigger
2020-04-15 Inserting into a partitioned table results in an "Missing session variable when eval builtin" error TiDB verified Manuel Rigger
2020-04-15 Incorrect result when using the empty string as a predicate in a RIGHT JOIN TiDB verified Manuel Rigger
2020-04-15 Incorrect result when using SPACE() in a predicate TiDB verified Manuel Rigger
2020-04-15 Incorrect result when fetching from a view TiDB verified Manuel Rigger
2020-04-15 Incorrect result or run-time error after changing column type TiDB verified Manuel Rigger
2020-04-15 Incorrect result for LEFT JOIN and CASE operator TiDB verified Manuel Rigger
2020-04-15 Incorrect result for CAST to DATETIME TiDB verified Manuel Rigger
2020-04-15 A NOT NULL predicate unexpectedly evaluates to TRUE TiDB closed duplicate Manuel Rigger
2020-04-15 SELECT with CASE expression causes an assertion failure "Assertion `!entry.first->Equals(&expr)' ... DuckDB fixed Manuel Rigger
2020-04-15 Incorrect result for SUM() and negative number DuckDB fixed Manuel Rigger
2020-04-14 RIGHT JOIN results in Assertion `filter->expressions.size() == 1' failed DuckDB fixed Manuel Rigger
2020-04-13 [JDBC] Special character causes the JVM to terminate with "basic_string::_M_construct null not va... DuckDB fixed Manuel Rigger
2020-04-13 Unexpected result for SUM() upon overflow DuckDB fixed Manuel Rigger
2020-04-13 SELECT on view with text constant in ORDER BY crashes DuckDB fixed Manuel Rigger
2020-04-13 Query with SIMILAR TO results in "Assertion `strlen(dataptr) == length' failed" DuckDB fixed Manuel Rigger
2020-04-13 Nested MAX() results in nondeterministic result or double free DuckDB fixed Manuel Rigger
2020-04-13 Nested CASE expression results in Assertion `other.auxiliary->type == VectorBufferType::STRING_BU... DuckDB fixed Manuel Rigger
2020-04-13 Assertions in the JDBC build of DuckDB? DuckDB fixed mrigger
2020-04-12 UPDATE causes subsequent query to segfault DuckDB fixed Manuel Rigger
2020-04-12 SELECT on DATE column with a large negative value results in a "double free or corruption" DuckDB fixed Manuel Rigger
2020-04-12 Query with JOIN and WHERE condition unexpectedly fetches a value not present in the table DuckDB fixed Manuel Rigger
2020-04-12 Query that uses the CONCAT() function and OR expression crashes DuckDB fixed Manuel Rigger
2020-04-12 Overflow when casting from REAL to INT results in "Invalid TypeId -1" DuckDB fixed Manuel Rigger
2020-04-12 Nondeterministic clause when using an UNION query and HAVING clause DuckDB fixed Manuel Rigger
2020-04-12 Incorrect result for query that uses REGEXP_MATCHES() DuckDB fixed Manuel Rigger
2020-04-12 Incorrect result for predicate with shift on a BIGINT column DuckDB fixed Manuel Rigger
2020-04-12 Incorrect result for a JOIN predicate t1.c0 IN (t0.c0) and WHERE predicate t1.c0<=t0.c0 DuckDB fixed Manuel Rigger
2020-04-12 GROUP BY clause results in non-deterministic result DuckDB fixed Manuel Rigger
2020-04-12 Fetching from table and view results in a crash DuckDB fixed Manuel Rigger
2020-04-12 Fetching a TIMESTAMP column results in an error DuckDB fixed mrigger
2020-04-11 The trigonometric functions can result in -nan DuckDB fixed Manuel Rigger
2020-04-11 ROUND() evaluates to -nan DuckDB fixed Manuel Rigger
2020-04-11 Query with comparison on boolean column results in "Invalid type: Invalid Type [BOOL]: Invalid ty... DuckDB fixed Manuel Rigger
2020-04-11 Query with an AND predicate, NOT and comparison yields an incorrect result DuckDB fixed Manuel Rigger
2020-04-11 Query with a negative shift predicate yields an incorrect result DuckDB fixed Manuel Rigger
2020-04-11 Query using the LN() function does not terminate DuckDB fixed Manuel Rigger
2020-04-11 LEFT JOIN with comparison on integer columns results in "Not implemented: Unimplemented type for ... DuckDB fixed Manuel Rigger
2020-04-11 Incorrect result after an INSERT violates a UNIQUE constraint DuckDB fixed Manuel Rigger
2020-04-11 Casting a large number to REAL and multiplying it with zero results in -nan DuckDB fixed Manuel Rigger
2020-04-10 SIMILAR TO results in an incorrect result DuckDB fixed Manuel Rigger
2020-04-10 RIGHT JOIN with a predicate that compares two integer columns results in an "Unhandled type" error DuckDB fixed Manuel Rigger
2020-04-10 Query results in an error "INTERNAL: Failed to bind column reference "c0" [5.0] (bindings: [6.0])" DuckDB fixed Manuel Rigger
2020-04-10 LEFT JOIN on column with NULL value results in a segmentation fault DuckDB fixed Manuel Rigger
2020-04-10 INSERT results in an error "Not implemented: Cannot create data from this type" DuckDB fixed Manuel Rigger
2020-04-10 Creating an empty table results in a crash DuckDB fixed Manuel Rigger
2020-04-10 A RIGHT JOIN unexpectedly fetches rows DuckDB fixed Manuel Rigger
2020-04-10 BETWEEN expression with an INTERVAL and DECIMAL cast results in an incorrect result CockroachDB fixed Manuel Rigger
2020-04-09 SELECT causes JDBC driver to crash DuckDB fixed Manuel Rigger
2020-04-09 Arithmetic expression results in "internal error: could not find type for binary expression mult" CockroachDB fixed mrigger
2020-04-08 SIMILAR TO results in an "Unknown error -1" DuckDB fixed Manuel Rigger
2020-04-08 INSERT causes an abort with "terminate called after throwing an instance of 'duckdb::InvalidTypeE... DuckDB fixed Manuel Rigger
2020-04-08 Comparison on UNIQUE NUMERIC column causes a query to omit a row in the result set DuckDB fixed Manuel Rigger
2020-04-08 Comparison of two boolean columns in different tables results in an error "Not implemented: Unimp... DuckDB fixed Manuel Rigger
2020-04-07 PRAGMA table_info provides no output DuckDB fixed mrigger
2020-04-07 A predicate NOT(NULL OR TRUE) unexpectedly evaluates to TRUE DuckDB fixed Manuel Rigger
2020-04-07 A comparison column=column unexpectedly evaluates to TRUE for column=NULL DuckDB fixed Manuel Rigger
2020-04-07 SCRUB on a table with FLOAT PRIMARY KEY and INTERLEAVE IN PARENT index causes server to exit CockroachDB verified Manuel Rigger
2020-04-07 ORDER BY unexpectedly causes a value to be represented in E notation when VECTORIZE=on CockroachDB fixed Manuel Rigger
2020-04-07 Disconnecting from server results in crash with "unexpected leftover bytes" CockroachDB verified Manuel Rigger
2020-04-07 Column that is used both as an INT2 and INT4 results in an internal error CockroachDB fixed Manuel Rigger
2020-04-07 CREATE INDEX results in "invalid interleave backreference" and prevents database from being dropped CockroachDB verified Manuel Rigger
2020-04-04 BETWEEN computes incorrect result when comparing DECIMAL with a string MySQL closed not a bug Manuel Rigger
2020-04-04 TRUNCATE on temporary table results in "unexpected value: " CockroachDB fixed Manuel Rigger
2020-04-04 SELECT statement on table with a hash-sharded index results in an internal error CockroachDB fixed Manuel Rigger
2020-04-04 SCRUB on a temporary table that has a hash-sharded index results in an error CockroachDB verified Manuel Rigger
2020-04-04 Internal error for an invalid CREATE INDEX statement CockroachDB fixed Manuel Rigger
2020-04-04 Incorrect result for query on interleaved index when vectorize=on CockroachDB fixed Manuel Rigger
2020-04-04 COLLATE in array causes an internal error "ARRAY[]:::STRING[] COLLATE en: incompatible type for C... CockroachDB fixed mrigger
2020-04-03 Query with an invalid regular expression unexpectedly does not fail CockroachDB fixed Manuel Rigger
2020-04-03 Comparison with (-9223372036854775808)::TIMESTAMP results in an unexpected error CockroachDB fixed Manuel Rigger
2020-04-03 CREATE STATISTICS on table with ARRAY column CockroachDB fixed Manuel Rigger
2020-04-03 CAST to INT2 yields an incorrect/inconsistent result CockroachDB verified Manuel Rigger
2020-04-02 SELECT on table with generated column causes a server panic TiDB fixed Manuel Rigger
2020-04-02 RIGHT JOIN with CONCAT_WS fails to fetch a row TiDB fixed Manuel Rigger
2020-04-02 REGEXP predicate unexpectedly results in an error "No valid regexp pattern found" TiDB fixed Manuel Rigger
2020-04-02 LEFT JOIN on a view results in "runtime error: slice bounds out of range [:264] with capacity 256" TiDB verified Manuel Rigger
2020-04-02 Incorrect result when comparing a FLOAT/DOUBLE UNSIGNED with a negative number TiDB verified Manuel Rigger
2020-04-02 INSERT IGNORE causes an incorrect result for a query on a DECIMAL column TiDB fixed Manuel Rigger
2020-04-02 INL_MERGE_JOIN hint results in an error "Internal : Can't find a proper physical plan for this qu... TiDB verified Manuel Rigger
2020-04-02 Unexpected syntax error for expression involving ARRAY[NULL] CockroachDB verified Manuel Rigger
2020-04-02 Internal error: lookup for ComparisonExpr ((@2)[float] != ('NaN')[string])[bool]'s CmpOp failed CockroachDB fixed Manuel Rigger
2020-04-01 fast ANALYZE TABLE on INDEX PRIMARY causes an error "analyze worker panic" TiDB fixed Manuel Rigger
2020-04-01 Using a column both in a string comparison and as a boolean yields an incorrect result TiDB fixed Manuel Rigger
2020-04-01 USE_INDEX_MERGE results in an incorrect result for a generated column TiDB fixed Manuel Rigger
2020-04-01 USE_INDEX_MERGE on table with generated column causes a server crash TiDB fixed Manuel Rigger
2020-04-01 OR clause on FLOAT/DOUBLE column unexpectedly evaluates to TRUE TiDB verified Manuel Rigger
2020-04-01 LIKE operator malfunctions for COLLATE 'latin1_bin' TiDB fixed Manuel Rigger
2020-04-01 Incorrect result for a predicate that uses the CHAR() function TiDB fixed Manuel Rigger
2020-04-01 A USE_INDEX_MERGE hint causes a server panic TiDB fixed Manuel Rigger
2020-04-01 The IN operator malfunctions for floating-poing numbers MySQL closed not a bug Manuel Rigger
2020-04-01 Incorrect result when comparing a floating-point number with an integer MySQL verified Manuel Rigger
2020-04-01 Comparison on FLOAT column and large value malfunctions MySQL verified Manuel Rigger
2020-04-01 BETWEEN query malfunctions for special character and TEXT index MySQL verified Manuel Rigger
2020-03-31 Incorrect result when comparing an UNSIGNED INT with a floating-point number MySQL verified Manuel Rigger
2020-03-31 Incorrect result for query that uses an AND operator on floats MySQL closed not a bug Manuel Rigger
2020-03-31 BETWEEN malfunctions when comparing large numbers MySQL verified Manuel Rigger
2020-03-31 BETWEEN malfunctions when comparing a string containing a newline MySQL verified Manuel Rigger
2020-03-31 A predicate that compares 0 with -0 yields an incorrect result MySQL fixed Manuel Rigger
2020-03-30 Query with a NATURAL LEFT JOIN unexpectedly results in an error TiDB fixed Manuel Rigger
2020-03-30 Query with RIGHT JOIN causes a server panic TiDB fixed Manuel Rigger
2020-03-30 Query results in "baseBuiltinFunc.vecEvalString() should never be called" error TiDB verified Manuel Rigger
2020-03-30 NATURAL RIGHT JOIN results in an unexpected "Unknown column" error TiDB verified Manuel Rigger
2020-03-30 Incorrect result for LEFT JOIN and NULL values TiDB fixed Manuel Rigger
2020-03-29 Join on tables with redundant indexes causes a server panic TiDB fixed Manuel Rigger
2020-03-29 GROUP BY clause nondeterministically results in an incorrect result or error TiDB fixed Manuel Rigger
2020-03-29 A predicate column1 = -column2 incorrectly evaluates to false for 0 values TiDB fixed Manuel Rigger
2020-03-29 Internal error for vectorize=on and multiplication of INT4 values CockroachDB fixed Manuel Rigger
2020-03-27 Unexpected "Data truncation: %s value is out of range in '%s'" error in UNION query TiDB fixed Manuel Rigger
2020-03-27 COLLATE causes an incorrect result in the presence of an index TiDB fixed Manuel Rigger
2020-03-26 Incorrect result for query that uses an AND operator on floats TiDB verified Manuel Rigger
2020-03-26 Incorrect result for an UNION query and a generated column TiDB fixed Manuel Rigger
2020-03-26 Double negation causes incorrect result TiDB fixed Manuel Rigger
2020-03-26 ANALYZE TABLE results in "invalid encoded key" with tidb_enable_fast_analyze=1 TiDB fixed Manuel Rigger
2020-03-26 ANALYZE TABLE results in "analyze worker panic" with tidb_enable_fast_analyze=1 TiDB fixed Manuel Rigger
2020-03-26 ANALYZE TABLE causes SIGSEGV on latest trunk TiDB fixed Manuel Rigger
2020-03-24 Query with HAVING clause, DISTSQL=off, and vectorize=on results in an internal error CockroachDB verified Manuel Rigger
2020-03-22 HAVING clause incorrectly evaluates to TRUE for VARIANCE(0) IS NOT NULL predicate CockroachDB fixed Manuel Rigger
2020-03-21 UPSERT on table with FOREIGN KEY constraint results in an internal error "cannot convert int to t... CockroachDB fixed Manuel Rigger
2020-03-21 UPSERT causes a decoding error in collated string column CockroachDB fixed Manuel Rigger
2020-03-21 SCRUB fails for table that has a FOREIGN KEY constraint on a rowid column CockroachDB verified Manuel Rigger
2020-03-21 NATURAL JOIN fails with "duplicate column name" on view CockroachDB fixed Manuel Rigger
2020-03-21 INSERT ... DO NOTHING results in an error "UPSERT or INSERT...ON CONFLICT command cannot affect r... CockroachDB fixed Manuel Rigger
2020-03-21 EXPLAIN (VEC) results in an internal error "input to aggregatorBase is not an execinfra.OpNode" CockroachDB fixed Manuel Rigger
2020-03-21 DROP DATABASE issue with TEMP tables CockroachDB fixed Manuel Rigger
2020-03-17 VALUES table expression malfunctions with MAX CockroachDB fixed mrigger
2020-03-17 Query with negative LIMIT results in an internal error "node lookup-join with MaxCost added to th... CockroachDB fixed Manuel Rigger
2020-03-16 Incorrect result for MAX, INTERLEAVE IN PARENT, and vectorize=experimental_on CockroachDB fixed Manuel Rigger
2020-03-14 EXPLAIN (VEC) SELECT results in an internal error "zero length schema unsupported" CockroachDB fixed Manuel Rigger
2020-03-14 EXPLAIN (VEC) SELECT results in an internal error "input to aggregatorBase is not an execinfra.Op... CockroachDB fixed Manuel Rigger
2020-03-10 GROUP BY causes unexpected conversion SQLite fixed Manuel Rigger
2020-03-05 Unexpected result for MIN on string that contains a null character SQLite fixed in documentation Manuel Rigger
2020-03-04 MAX yields unexpected result for UTF-16 SQLite fixed Manuel Rigger
2020-02-26 COUNT_ROWS() malfunctions for GROUP BY CockroachDB fixed Manuel Rigger
2020-02-17 Syntax error for multi-valued comparison and COLLATE CockroachDB verified Manuel Rigger
2020-02-12 Internal error for VECTORIZE=experimental_on, DEFAULT_INT_SIZE=4, and aggregate query CockroachDB fixed Manuel Rigger
2020-02-12 EXPERIMENTAL SCRUB TABLE crashes server for table with TIMESTAMP column CockroachDB fixed Manuel Rigger
2020-02-11 Internal error for NATURAL JOIN on INT and INT4 column for VECTORIZE=experimental_on CockroachDB closed duplicate Manuel Rigger
2020-02-09 Internal error when setting VECTORIZE = experimental_on and DEFAULT_INT_SIZE = 4 CockroachDB fixed Manuel Rigger
2020-02-08 EXPERIMENTAL SCRUB TABLE results in an "overflow during Encode" error CockroachDB verified Manuel Rigger
2020-02-07 Internal error for SUBSTRING, INT4 cast, and VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger
2020-02-06 NOT BETWEEN query on VIEW results in an internal error with VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger
2020-02-05 Unexpected error for aggregate functions CockroachDB verified Manuel Rigger
2020-01-30 Server exits on query with LEFT JOIN CockroachDB fixed Manuel Rigger
2020-01-30 Internal error for NATURAL JOIN and VECTORIZE='experimental_on' CockroachDB fixed Manuel Rigger
2020-01-29 Multi-record UPSERT inserts duplicate values in PRIMARY KEY, resulting in inconsistent results CockroachDB fixed Manuel Rigger
2020-01-27 Internal error "estimated distinct count must be non-zero" CockroachDB fixed Manuel Rigger
2020-01-26 Deadlock in SHOW TABLES CockroachDB fixed Manuel Rigger
2020-01-23 Internal error setting tracing=true CockroachDB fixed Manuel Rigger
2020-01-23 Internal error for CASE expression and VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger
2020-01-23 Incorrect result for IS NULL query on VIEW using SELECT DISTINCT CockroachDB verified Manuel Rigger
2020-01-22 SHOW EXPERIMENTAL_FINGERPRINTS error for STRING columns and character escapes CockroachDB verified Manuel Rigger
2020-01-22 Query on VIEW with OFFSET NULL and WHERE condition involving CURRENT_USER() unexpectedly fetches ... CockroachDB fixed Manuel Rigger
2020-01-22 Incorrect result for query with IS NULL condition on UNIQUE column and VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger
2020-01-21 TO_ENGLISH(-9223372036854775808) results in an internal error CockroachDB fixed Manuel Rigger
2020-01-21 Internal error for BETWEEN operator and CAST to BYTES CockroachDB fixed Manuel Rigger
2020-01-21 Incorrect result for BETWEEN SYMMETRIC query CockroachDB fixed Manuel Rigger
2020-01-20 Unexpected error when using EXPERIMENTAL SCRUB CockroachDB fixed Manuel Rigger
2020-01-20 Internal error in expression that uses a CAST and COLLATE CockroachDB verified Manuel Rigger
2020-01-20 DEFAULT value causes unexpected syntax error when executing INSERT CockroachDB fixed Manuel Rigger
2020-01-19 Generated column causes query to omit a record in the result set CockroachDB fixed Manuel Rigger
2020-01-19 Crash when using VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger
2020-01-18 Incorrect result for LIKE query CockroachDB verified Manuel Rigger
2020-01-08 Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition SQLite fixed Manuel Rigger
2020-01-08 Incorrect result for COUNT(), UTF16be encoding and SUBSTR SQLite fixed Manuel Rigger
2020-01-05 FULL JOIN with an SUBSTRING ON clause results in an internal error CockroachDB fixed Manuel Rigger
2020-01-04 DBSTAT query computes incorrect result for stat.aggregate = 1 condition SQLite closed not a bug Manuel Rigger
2020-01-04 DBSTAT query computes incorrect result for name column SQLite fixed Manuel Rigger
2020-01-04 DBSTAT query computes incorrect result for aggregate column SQLite fixed Manuel Rigger
2020-01-04 Internal error for query with negative LIMIT on view with negative LIMIT CockroachDB fixed Manuel Rigger
2020-01-04 Internal error for case expression involving NULLIF and VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger
2020-01-03 Internal error for arithmetic operators and NULLIF CockroachDB fixed Manuel Rigger
2020-01-02 FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR SQLite fixed Manuel Rigger
2020-01-02 Internal error for SUBSTRING with negative length and VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger
2020-01-01 Internal error for ILIKE_ESCAPE and special characters CockroachDB fixed Manuel Rigger
2020-01-01 Complex ORDER BY clause results in internal error with VECTORIZE=experimental_on CockroachDB fixed Manuel Rigger

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.