Bugs reported in 2019

← Bugs over time

SQLancer is credited with 221 bugs reported in 2019, across 5 database systems, between 2019-05-01 and 2019-12-31. A further 36 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 (5)

SQLite

167

MySQL

25

PostgreSQL

18

MariaDB

6

TDengine

5

Each system's own page carries its whole history rather than this year's share: SQLite, MySQL, PostgreSQL, MariaDB, TDengine.

How they break down

Who found them

Found by the SQLancer project

221

By status

Fixed

190

Fixed in documentation

11

Confirmed

17

Open

3

By symptom

Logic bug

101

Unexpected error

66

Crash

49

Hang

2

Unclassified

3

By technique

Technique not recorded

120

Pivoted Query Synthesis (PQS)

62

Non-optimizing Reference Engine Construction (NoREC)

39

Why each bug counts

Listed in the project's own bug repository

119

The report names a SQLancer oracle

101

Filed by someone who runs SQLancer campaigns

1

Who reported them

Manuel Rigger

218

mrigger

3

Every bug reported in 2019 (257)

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
2019-12-31	Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u....	SQLite	fixed	Manuel Rigger
2019-12-30	NATURAL JOIN on virtual table results in "parse error in rank function"	SQLite	fixed	Manuel Rigger
2019-12-30	Inconsistent handling of subqueries in index expressions	SQLite	closed not a bug	Manuel Rigger
2019-12-30	Debug assertion codeVectorCompare: Assertion `0' failed	SQLite	fixed	Manuel Rigger
2019-12-29	Trigger on normal table causes the database disk image to become malformed	SQLite	fixed	Manuel Rigger
2019-12-28	Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u....	SQLite	fixed	Manuel Rigger
2019-12-28	Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed	SQLite	fixed	Manuel Rigger
2019-12-28	Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMem[pOp->p1])' failed.	SQLite	fixed	Manuel Rigger
2019-12-28	Debug assertion exprSrcCount: Assertion `0' failed	SQLite	fixed	Manuel Rigger
2019-12-27	FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding	SQLite	fixed in documentation	Manuel Rigger
2019-12-27	Debug assertion assert_pager_state: Assertion `pPager->changeCountDone==0 || pPager->eLock>=RESER...	SQLite	fixed	Manuel Rigger
2019-12-26	Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbor...	SQLite	fixed	Manuel Rigger
2019-12-26	Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed	SQLite	fixed	Manuel Rigger
2019-12-25	Debug assertion sqlite3TableColumnAffinity: Assertion `iColnCol' failed.	SQLite	fixed	Manuel Rigger
2019-12-25	Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed	SQLite	fixed	Manuel Rigger
2019-12-24	FTS database disk image is malformed for UTF-16 encoding and integrity check	SQLite	fixed	Manuel Rigger
2019-12-24	Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed	SQLite	fixed	Manuel Rigger
2019-12-23	UPDATE with complex WHERE condition on rtree results in "database table is locked" error	SQLite	fixed in documentation	Manuel Rigger
2019-12-23	FTS database disk image is malformed for special characters in table	SQLite	fixed	Manuel Rigger
2019-12-23	Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n &&...	SQLite	fixed	Manuel Rigger
2019-12-23	Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2)	SQLite	fixed	Manuel Rigger
2019-12-23	Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed	SQLite	fixed	Manuel Rigger
2019-12-23	Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed (2)	SQLite	fixed	Manuel Rigger
2019-12-23	Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' ...	SQLite	fixed	Manuel Rigger
2019-12-23	Debug assertion rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed	SQLite	fixed	Manuel Rigger
2019-12-23	Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed	SQLite	fixed	Manuel Rigger
2019-12-22	SELECT on window function causes a segfault	SQLite	fixed	Manuel Rigger
2019-12-22	Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n &&...	SQLite	fixed	Manuel Rigger
2019-12-22	Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed	SQLite	fixed	Manuel Rigger
2019-12-22	Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed	SQLite	fixed	Manuel Rigger
2019-12-22	Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed	SQLite	fixed	Manuel Rigger
2019-12-22	Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed	SQLite	fixed	Manuel Rigger
2019-12-22	Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed	SQLite	fixed	Manuel Rigger
2019-12-22	Debug assertion constructAutomaticIndex: Assertion `!ExprHasProperty(pExpr, EP_FromJoin) || pExpr...	SQLite	fixed	Manuel Rigger
2019-12-21	FTS database disk image is malformed for update on languageid	SQLite	fixed	Manuel Rigger
2019-12-20	Incorrect result for BETWEEN and generated column	SQLite	fixed	Manuel Rigger
2019-12-20	FTS database disk image is malformed for UTF-16 encoding	SQLite	fixed	Manuel Rigger
2019-12-20	FILTER clause in window function causes a segfault	SQLite	fixed	Manuel Rigger
2019-12-19	UPDATE causes "database table is locked" for rtree table	SQLite	fixed	Manuel Rigger
2019-12-16	LEFT JOIN malfunctions with generated column	SQLite	fixed	Manuel Rigger
2019-12-14	REINDEX segfaults on table with generated columns	SQLite	fixed	Manuel Rigger
2019-12-11	LEFT JOIN segfault on rtree table	SQLite	fixed	Manuel Rigger
2019-12-11	FTS database disk image is malformed for UTF-16 encoding after update	SQLite	fixed	Manuel Rigger
2019-12-10	REINDEX results in "UNIQUE constraint failed" for generated column	SQLite	fixed	Manuel Rigger
2019-12-09	PRAGMA integrity_check does not terminate on table with generated column	SQLite	fixed	Manuel Rigger
2019-12-08	Query on table without rows and generated column results in "out of memory" error	SQLite	fixed	Manuel Rigger
2019-12-06	NOT NULL auxiliary column in rtree table malfunctions	SQLite	fixed in documentation	Manuel Rigger
2019-12-06	Incorrect result for predicate on rtree table	SQLite	fixed	Manuel Rigger
2019-12-06	Generated column and foreign key causes a segfault	SQLite	fixed	Manuel Rigger
2019-12-06	Comparison on INT column in rtree table malfunctions	SQLite	fixed	Manuel Rigger
2019-12-06	CREATE VIRTUAL TABLE causes segfault	SQLite	fixed	Manuel Rigger
2019-12-05	column = NULL predicate evaluates to TRUE for rtree table	SQLite	fixed	Manuel Rigger
2019-12-05	Row value comparison malfunctions with rtree table	SQLite	fixed	Manuel Rigger
2019-12-05	Join on two rtree tables malfunctions	SQLite	fixed	Manuel Rigger
2019-12-04	Incorrect result for TEXT comparison on rtree table	SQLite	fixed	Manuel Rigger
2019-12-02	FailedAssertion("!OidIsValid(def->collOid)", File: "view.c", Line: 89)	PostgreSQL	verified	Manuel Rigger
2019-11-30	LEFT JOIN malfunctions with partial ISNULL index	SQLite	fixed	Manuel Rigger
2019-11-22	Segfault when creating constant bit_length() index on TEMP table	PostgreSQL	fixed	Manuel Rigger
2019-11-20	Fetching from information_schema.tables results in segfault	PostgreSQL	fixed	Manuel Rigger
2019-11-20	ALTER TABLE fails when changing column type due to index with bit_ops opclass	PostgreSQL	closed not a bug	Manuel Rigger
2019-11-19	No = operator for opfamily 426	PostgreSQL	fixed	Manuel Rigger
2019-11-19	Failed assertion clauses != NIL	PostgreSQL	fixed	Manuel Rigger
2019-11-18	NOT NULL and UNIQUE constraints cause SUM() to yield an incorrect result	MariaDB	verified	Manuel Rigger
2019-11-16	ALTER TABLE results in "could not find cast from 3904 to 3831"	PostgreSQL	open	Manuel Rigger
2019-11-15	UNIQUE constraint causes a query with string comparison to omit a row in the result set	MariaDB	fixed	Manuel Rigger
2019-11-14	CREATE UNIQUE INDEX USING HASH malfunctions for engine=Aria table	MariaDB	closed duplicate	Manuel Rigger
2019-11-14	CREATE TABLE with generated column and RLIKE results in segfault	MariaDB	verified	Manuel Rigger
2019-11-13	Unexpected "cache lookup failed for collation 0" failure	PostgreSQL	fixed	Manuel Rigger
2019-11-13	REINDEX CONCURRENTLY unexpectedly fails	PostgreSQL	verified	Manuel Rigger
2019-11-11	Index causes incorrect result when comparing float-point number with INT	MariaDB	verified	Manuel Rigger
2019-11-11	Incorrect result for expression with the <=> operator and IS NULL	MariaDB	verified	Manuel Rigger
2019-11-11	GREATEST() and LEAST() malfunction for NULL	MariaDB	verified	Manuel Rigger
2019-11-07	VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column	SQLite	fixed	Manuel Rigger
2019-11-07	UPDATE on table with two generated columns and CHECK clause results in segfault	SQLite	fixed	Manuel Rigger
2019-11-07	DISTINCT malfunctions for VIEW with virtual table	SQLite	fixed	Manuel Rigger
2019-11-06	Segfault when inserting into table with generated columns	SQLite	fixed	Manuel Rigger
2019-11-06	REPLACE on table with generated NOT NULL column results in segfault	SQLite	fixed	Manuel Rigger
2019-11-06	NULL WHERE condition unexpectedly results in row being fetched	SQLite	fixed	Manuel Rigger
2019-11-05	UNLIKELY in query causes row to not be fetched	SQLite	closed not a bug	Manuel Rigger
2019-11-04	Row value comparison malfunctions on view with left join	SQLite	fixed	Manuel Rigger
2019-11-03	PRAGMA integrity_check fails due to CHECK constraint even without records	SQLite	fixed	Manuel Rigger
2019-11-03	LEFT JOIN in view malfunctions with partial index on table	SQLite	fixed	Manuel Rigger
2019-11-02	Incorrect result for GLOB operator	SQLite	fixed	Manuel Rigger
2019-11-01	REPLACE causes segfault in table with generated column and foreign key	SQLite	fixed	Manuel Rigger
2019-10-31	VACUUM on table with generated column that uses TYPEOF results in an error	SQLite	fixed	Manuel Rigger
2019-10-31	Segfault in table with generated column and foreign key	SQLite	fixed	Manuel Rigger
2019-10-29	VACUUM on table with generated column results in an error	SQLite	fixed	Manuel Rigger
2019-10-29	VACUUM issue on table with generated column	SQLite	fixed	Manuel Rigger
2019-10-29	Segfault when updating table with generated columns	SQLite	fixed	Manuel Rigger
2019-10-27	Segfault in table with generated columns	SQLite	fixed	Manuel Rigger
2019-10-26	REINDEX causes "UNIQUE constraint failed" error for generated column	SQLite	fixed	Manuel Rigger
2019-10-25	Trigger causes query to compute incorrect result	SQLite	fixed	Manuel Rigger
2019-10-24	FTS integrity-check malfunctions nondeterministically with tokenize="ascii"	SQLite	fixed	Manuel Rigger
2019-10-24	Crash on REPLACE INTO of a table with an AFTER DELETE trigger	SQLite	fixed	Manuel Rigger
2019-10-23	Comparison of row values with COLLATE NOCASE yields incorrect result	SQLite	fixed	Manuel Rigger
2019-10-22	Row value comparison yields incorrect result	SQLite	fixed	Manuel Rigger
2019-10-22	Comparison of row values results in incorrect result	SQLite	fixed	Manuel Rigger
2019-10-21	INSERT into table with two triggers does not terminate	SQLite	closed not a bug	Manuel Rigger
2019-10-17	FTS merge does not terminate	SQLite	fixed	Manuel Rigger
2019-10-16	Trigger inserts duplicate value in UNIQUE column	SQLite	fixed	Manuel Rigger
2019-10-11	FTS order=DESC results into integrity-check failing	SQLite	fixed	Manuel Rigger
2019-10-11	FTS integrity_check fails when inserting x'00'	SQLite	fixed	Manuel Rigger
2019-10-11	FTS integrity-check malfunctions for transaction and the prefix option	SQLite	fixed	Manuel Rigger
2019-10-10	LEFT JOIN in view malfunctions with NOTNULL	SQLite	fixed	Manuel Rigger
2019-10-09	LEFT JOIN in view malfunctions	SQLite	fixed	Manuel Rigger
2019-10-09	FTS rebuild in combination with crisismerge results in error "database or disk is full"	SQLite	fixed	Manuel Rigger
2019-10-09	FTS integrity-check indicates that the database disk image is malformed	SQLite	fixed	Manuel Rigger
2019-10-07	FTS rebuild in transaction causes integrity-check to fail	SQLite	fixed	Manuel Rigger
2019-10-07	FTS pgsz option results in "database disk image is malformed" error	SQLite	fixed	Manuel Rigger
2019-10-07	FTS integrity-check malfunctions	SQLite	fixed	Manuel Rigger
2019-10-07	Comparison on view malfunctions	SQLite	fixed	Manuel Rigger
2019-10-03	Unexpected result when using arithmetic expressions in WHERE clause	TDengine	open	Manuel Rigger
2019-10-03	The "<>" and "=" operators do not work for NCHAR columns	TDengine	open	Manuel Rigger
2019-10-02	Inserting the "+" and "-" strings fails	TDengine	fixed	Manuel Rigger
2019-10-01	Likely typo in configuration option "abloks"	TDengine	fixed	mrigger
2019-10-01	DROP DATABASE seems to leave behind a table when using the "tables" configuration option	TDengine	fixed	Manuel Rigger
2019-09-24	INSERT INTO causes segfault on trunk	PostgreSQL	fixed	Manuel Rigger
2019-09-24	INSERT INTO causes segfault on trunk	PostgreSQL	fixed	mrigger
2019-09-17	Row is not fetched when using WHERE clause with INSTR()	SQLite	fixed	Manuel Rigger
2019-09-16	GLOB unexpectedly does not match	SQLite	fixed	Manuel Rigger
2019-09-11	COLLATE issue in view	SQLite	fixed	Manuel Rigger
2019-09-10	DISTINCT malfunctions for VIEW	SQLite	closed not a bug	Manuel Rigger
2019-09-09	BETWEEN issue in view	SQLite	fixed	Manuel Rigger
2019-09-03	IS NULL unexpectedly evaluates to TRUE	SQLite	fixed	Manuel Rigger
2019-09-03	COLLATE NOCASE string comparison yields incorrect result	SQLite	fixed	Manuel Rigger
2019-09-02	Expression computed on row yields incorrect result	SQLite	fixed	Manuel Rigger
2019-09-02	Different rounding when converting TEXT to REAL	SQLite	fixed	Manuel Rigger
2019-08-30	REINDEX causes "UNIQUE constraint failed" error	SQLite	fixed	Manuel Rigger
2019-08-30	Partial index causes row to not be fetched in BETWEEN expression	SQLite	fixed	Manuel Rigger
2019-08-30	Partial index causes row to not be fetched	SQLite	fixed	Manuel Rigger
2019-08-30	Partial index and BETWEEN issue	SQLite	fixed	Manuel Rigger
2019-08-28	Short-circuit evaluation issue	SQLite	closed not a bug	Manuel Rigger
2019-08-27	Unexpected affinity conversion is performed for the IN operator	SQLite	fixed	Manuel Rigger
2019-08-22	Row with comparison on TEXT UNIQUE column is not fetched	SQLite	fixed	Manuel Rigger
2019-08-22	Row is not fetched in table with INTEGER PRIMARY KEY	SQLite	fixed	Manuel Rigger
2019-08-22	LIKELY() seems to cause unexpected affinity conversion for rowid	SQLite	fixed	Manuel Rigger
2019-08-21	DISTINCT malfunctions for IS NULL	SQLite	fixed	Manuel Rigger
2019-08-20	INDEXED BY results in row not being fetched	SQLite	fixed	Manuel Rigger
2019-08-17	WHERE clause erroneously influences value of fetched column from view	SQLite	fixed	Manuel Rigger
2019-08-17	LEFT JOIN fails to fetch row	SQLite	fixed	Manuel Rigger
2019-08-15	Null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)	SQLite	fixed	Manuel Rigger
2019-08-14	Unexpected error in DELETE with existing trigger	SQLite	closed not a bug	Manuel Rigger
2019-08-10	Constant expression in partial index results in row not being fetched	SQLite	fixed	Manuel Rigger
2019-08-07	Incorrect result for query that uses MIN() and a CAST on rowid	SQLite	fixed	Manuel Rigger
2019-08-06	Unexpected affinity conversion for view column in IN operator	SQLite	fixed	Manuel Rigger
2019-08-05	Unexpected affinity conversion in view	SQLite	fixed	Manuel Rigger
2019-08-05	Row is not fetched in SELECT from VIEW	SQLite	fixed	Manuel Rigger
2019-08-03	MIN() malfunctions for a query with ISNULL condition	SQLite	fixed	Manuel Rigger
2019-07-30	Query with DISTINCT does not fetch all distinct rows	SQLite	fixed	Manuel Rigger
2019-07-29	Query with ORDER BY results in "database disk image is malformed" error	SQLite	fixed	Manuel Rigger
2019-07-29	Issue with DISTINCT and COLLATE	SQLite	closed not a bug	Manuel Rigger
2019-07-29	ANALYZE causes DISTINCT to malfunction in CROSS JOIN	SQLite	fixed	Manuel Rigger
2019-07-27	Multiple inheritance and ALTER TABLE issue	PostgreSQL	verified	Manuel Rigger
2019-07-24	Attribute has wrong type in ALTER TABLE	PostgreSQL	closed duplicate	Manuel Rigger
2019-07-24	ANALYZE on parent table results in an error "tuple already updated by self"	PostgreSQL	closed duplicate	Manuel Rigger
2019-07-24	ADD CHECK fails for parent table if column used in CHECK is fully-qualified	PostgreSQL	closed not a bug	Manuel Rigger
2019-07-23	DISABLE KEYS, DELAY_KEY_WRITE results in "Data truncated for functional index"	MySQL	closed duplicate	Manuel Rigger
2019-07-23	CAST of STRING with newlines to SIGNED/UNSIGNED returns unexpected result	MySQL	closed duplicate	Manuel Rigger
2019-07-17	REINDEX CONCURRENTLY causes ALTER TABLE to fail	PostgreSQL	fixed	Manuel Rigger
2019-07-16	BETWEEN SYMMETRIC condition results in "row is too big: ..., maximum size 8160"	PostgreSQL	closed not a bug	Manuel Rigger
2019-07-15	UPDATE causes segfault on trunk	PostgreSQL	closed duplicate	Manuel Rigger
2019-07-14	SELECT with COLLATE results in segfault on trunk and 12 Beta 2	PostgreSQL	closed duplicate	Manuel Rigger
2019-07-11	Stack buffer overflow in 12beta2 release	PostgreSQL	closed not a bug	mrigger
2019-07-11	Stack buffer overflow in 12beta2 release	PostgreSQL	closed duplicate	Manuel Rigger
2019-07-10	SEGFAULT in 12beta2 release	PostgreSQL	closed duplicate	Manuel Rigger
2019-07-10	SEGFAULT in 12beta2 release	PostgreSQL	closed not a bug	mrigger
2019-07-10	Generated column and string concatenation issue	PostgreSQL	closed not a bug	Manuel Rigger
2019-07-10	ERROR: negative bitmapset member not allowed in SELECT	PostgreSQL	fixed	Manuel Rigger
2019-07-10	ERROR: found unexpected null value in index	PostgreSQL	fixed	Manuel Rigger
2019-07-07	VACUUM FULL results in ERROR: integer out of range	PostgreSQL	closed not a bug	Manuel Rigger
2019-07-07	Issue with CHAR column and "column LIKE column" condition	PostgreSQL	closed not a bug	Manuel Rigger
2019-07-04	DISCARD TEMP results in "ERROR: cache lookup failed for type 0"	PostgreSQL	fixed	Manuel Rigger
2019-07-04	ALTER TABLE results in "ERROR: could not open relation with OID 43707388"	PostgreSQL	verified	Manuel Rigger
2019-07-02	MIN() malfunctions for UNIQUE column	SQLite	fixed	Manuel Rigger
2019-07-02	SELECT results in "ERROR: index key does not match expected index column"	PostgreSQL	verified	Manuel Rigger
2019-07-02	GROUP BY and inheritance issue	PostgreSQL	fixed	Manuel Rigger
2019-06-29	VACUUM FULL results in deadlock	PostgreSQL	closed not a bug	Manuel Rigger
2019-06-26	SET key_cache_* and key_buffer_* variables fails nondeterministically	MySQL	verified	Manuel Rigger
2019-06-26	Query with GREATEST function malfunctions	MySQL	fixed	Manuel Rigger
2019-06-26	Non-unique functional index prevents PRIMARY KEY from being dropped	MySQL	closed duplicate	Manuel Rigger
2019-06-26	Index makes DELETE fail with "Truncated incorrect DOUBLE value"	MySQL	closed not a bug	Manuel Rigger
2019-06-25	Unexpected result for IN operator and constants	MySQL	fixed in documentation	Manuel Rigger
2019-06-25	Setting sort_buffer_size to a large value causes query to go out of memory	MySQL	fixed	Manuel Rigger
2019-06-25	SET GLOBAL on rbr_exec_mode fails	MySQL	verified	Manuel Rigger
2019-06-25	Query involving &, <, and AND operators computes incorrect result	MySQL	fixed	Manuel Rigger
2019-06-25	Compare that uses UNSIGNED cast and function malfunctions in the MEMORY engine	MySQL	fixed	Manuel Rigger
2019-06-24	The logical operators &, |, and ^ do not ignore newlines in TEXT	MySQL	fixed	Manuel Rigger
2019-06-24	TEXT column used as boolean incorrectly evaluates to false	MySQL	fixed	Manuel Rigger
2019-06-24	IN operator issue when comparing signed column and the column cast to unsigned	MySQL	verified	Manuel Rigger
2019-06-24	Function return value with newline yields wrong result when used as a boolean	MySQL	fixed	Manuel Rigger
2019-06-24	CAST of negative function return value to UNSIGNED malfunctions with BIGINT	MySQL	fixed	Manuel Rigger
2019-06-24	BENCHMARK() returns NULL in some cases but is documented to always return 0	MySQL	fixed in documentation	Manuel Rigger
2019-06-24	AND/OR/XOR compute wrong result for small floating-point numbers in TEXT columns	MySQL	fixed	Manuel Rigger
2019-06-23	CHECK TABLE FOR UPGRADE crashes server (segfault)	MySQL	fixed	Manuel Rigger
2019-06-23	CHECK TABLE FOR UPGRADE crashes server (segfault)	MySQL	fixed	mrigger
2019-06-22	XOR operator returns incorrect result for strings with a floating-point number	MySQL	fixed	Manuel Rigger
2019-06-22	Row is not fetched when using a function expression that should yield TRUE	MySQL	fixed	Manuel Rigger
2019-06-22	Duplicate entry for key 'PRIMARY' when querying information_schema.TABLES	MySQL	fixed	Manuel Rigger
2019-06-21	The negation of a "<=>" comparison malfunctions depending on the column's type	MySQL	fixed	Manuel Rigger
2019-06-20	Functional index seems to malfunction with UNSIGNED column	MySQL	fixed	Manuel Rigger
2019-06-20	DROP PRIMARY KEY on UNIQUE PRIMARY KEY does not update information_schema.column	MySQL	verified	Manuel Rigger
2019-06-20	DROP COLUMN error on INVISIBLE UNIQUE INDEX that refers to constant expression	MySQL	closed not a bug	Manuel Rigger
2019-06-20	Applying NOT twice on an integer results in wrong result in WHERE condition	MySQL	closed duplicate	Manuel Rigger
2019-06-18	"Can't find record" error in SELECT statement 2 (HEAP engine)	MySQL	verified	Manuel Rigger
2019-06-18	"Can't find record" error in SELECT statement 1 (MyISAM engine)	MySQL	verified	Manuel Rigger
2019-06-16	COLLATE in BETWEEN expression is ignored	SQLite	fixed	Manuel Rigger
2019-06-15	REPAIR TABLE on a functional table marks it as crashed	MySQL	verified	Manuel Rigger
2019-06-14	LIKE malfunctions for UNIQUE COLLATE NOCASE column	SQLite	fixed	Manuel Rigger
2019-06-14	Built-in RTRIM collating sequence yields incorrect comparisons	SQLite	fixed	Manuel Rigger
2019-06-12	IS TRUE operator malfunctions with COLLATE and REAL value	SQLite	fixed	Manuel Rigger
2019-06-12	CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0	SQLite	fixed	Manuel Rigger
2019-06-12	CAST takes implicit COLLATE of its operand	SQLite	fixed in documentation	Manuel Rigger
2019-06-11	Lossless conversion when casting a large TEXT number to NUMERIC is not performed	SQLite	fixed in documentation	Manuel Rigger
2019-06-11	LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities	SQLite	fixed	Manuel Rigger
2019-06-11	COLLATE expression in the right side of an IN operator results in an affinity conversion	SQLite	fixed	Manuel Rigger
2019-06-11	-'1.0' computes -1.0 rather than -1	SQLite	fixed in documentation	Manuel Rigger
2019-06-10	TEXT value interpreted as column name in an index with empty list in an IN expression	SQLite	fixed	Manuel Rigger
2019-06-10	LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column	SQLite	fixed	Manuel Rigger
2019-06-10	Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()"	SQLite	fixed	Manuel Rigger
2019-06-10	COLLATE expression has an affinity	SQLite	fixed in documentation	Manuel Rigger
2019-06-10	CAST('.' AS NUMERIC) computes 0.0 rather than 0	SQLite	fixed	Manuel Rigger
2019-06-10	Another case of Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()"	SQLite	fixed	Manuel Rigger
2019-06-08	CAST to NUMERIC no longer converts to INTEGER	SQLite	fixed	Manuel Rigger
2019-06-02	ALTER TABLE SET WITH OIDS fails after failed CONCURRENTLY index creation	PostgreSQL	closed not a bug	Manuel Rigger
2019-05-30	Unique index that uses GLOB does not detect duplicate due to REAL conversion	SQLite	fixed	Manuel Rigger
2019-05-28	String interpreted as a column name when creating an index	SQLite	closed not a bug	Manuel Rigger
2019-05-28	PRAGMA case_sensitive_like conflicts with LIKE operator when creating an index	SQLite	closed duplicate	Manuel Rigger
2019-05-28	PRAGMA case_sensitive_like can corrupt some databases	SQLite	fixed	Manuel Rigger
2019-05-28	COLLATE nocase index on a WITHOUT ROWID table malfunctions	SQLite	fixed	Manuel Rigger
2019-05-25	Incorrect result when subtracting a large integer number from a TEXT value	SQLite	fixed	Manuel Rigger
2019-05-25	CAST('-' AS NUMERIC) computes 0.0	SQLite	fixed	Manuel Rigger
2019-05-21	"Malformed database schema" when creating a failing index within a transaction	SQLite	fixed	Manuel Rigger
2019-05-19	Nested boolean formula with IN operator computes an incorrect result	SQLite	fixed	Manuel Rigger
2019-05-19	Index on non-existing column results in a fabricated value being fetched	SQLite	fixed	Manuel Rigger
2019-05-18	Query results in a SEGFAULT	SQLite	fixed	Manuel Rigger
2019-05-16	REAL rounding seems to depend on FROM clause	SQLite	fixed	Manuel Rigger
2019-05-16	Malformed image when using no journal mode, zero cache size, and failing when creating an index	SQLite	fixed in documentation	Manuel Rigger
2019-05-14	PRAGMA reverse_unordered_selects=true results in row not being fetched	SQLite	fixed	Manuel Rigger
2019-05-13	REINDEX causes rows not to be fetched in a WITHOUT ROWIDs table and PRIMARY KEY DESC	SQLite	fixed	Manuel Rigger
2019-05-13	Mixing main and temp databases in foreign keys is not supported	SQLite	closed not a bug	Manuel Rigger
2019-05-11	Partial NOT NULL index malfunctions with IS NOT/!=	SQLite	fixed	Manuel Rigger
2019-05-10	Incorrect handling of Infinity by the ROUND function	SQLite	fixed	Manuel Rigger
2019-05-09	Row is not fetched with PRAGMA reverse_unordered_selects=true	SQLite	fixed	Manuel Rigger
2019-05-09	Malformed database image when using a REAL PRIMARY KEY	SQLite	fixed	Manuel Rigger
2019-05-08	'./' LIKE './' does not match	SQLite	fixed	Manuel Rigger
2019-05-07	Incorrect result for "<" and "<=" comparison of rowid and non-numeric text value	SQLite	fixed	Manuel Rigger
2019-05-07	INSERT OR FAIL inserts row although it violates a table constraint	SQLite	fixed	Manuel Rigger
2019-05-06	ALTER TABLE fails when renaming an INTEGER PRIMARY KEY column in a WITHOUT ROWID table	SQLite	fixed	Manuel Rigger
2019-05-05	REAL PRIMARY KEY and floating point comparison does not work	SQLite	closed duplicate	Manuel Rigger
2019-05-04	Incorrect result on a table scan of a partial index	SQLite	fixed	Manuel Rigger
2019-05-03	Problem with REAL values and string functions used in indexes or on expressions	SQLite	fixed	Manuel Rigger
2019-05-03	GLOB and minus in index and real column	SQLite	closed duplicate	Manuel Rigger
2019-05-02	UPSERT documentation issue	SQLite	fixed in documentation	Manuel Rigger
2019-05-02	TYPEOF index on REAL column malfunctions	SQLite	fixed	Manuel Rigger
2019-05-02	Index on REAL column malfunctions when multiplying with a string	SQLite	closed duplicate	Manuel Rigger
2019-05-01	Multi-row insert circumvents index check	SQLite	fixed	Manuel Rigger
2019-05-01	COLLATE NOCASE index on REAL column malfunctions	SQLite	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.