← All database systems

PostgreSQL is supported by SQLancer — the main repository ships a testing implementation for it. SQLancer is credited with 18 bugs in it, reported between 2019-07-02 and 2019-12-02. Its source is at postgres/postgres.

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

How the bugs break down

By year reported

2019
18

Who found them

Found by the SQLancer project
18

By status

Fixed
12
Confirmed
5
Open
1

By symptom

Logic bug
1
Unexpected error
11
Crash
5
Unclassified
1

By technique

Technique not recorded
17
Pivoted Query Synthesis (PQS)
1

Why each bug counts

Listed in the project's own bug repository
17
The report names a SQLancer oracle
1

Who reported them (2)

Manuel Rigger
17
mrigger
1

Every bug on record (34)

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
2019-12-02 FailedAssertion("!OidIsValid(def->collOid)", File: "view.c", Line: 89) verified — Manuel Rigger
2019-11-22 Segfault when creating constant bit_length() index on TEMP table fixed — Manuel Rigger
2019-11-20 Fetching from information_schema.tables results in segfault fixed — Manuel Rigger
2019-11-20 ALTER TABLE fails when changing column type due to index with bit_ops opclass closed not a bug — Manuel Rigger
2019-11-19 No = operator for opfamily 426 fixed — Manuel Rigger
2019-11-19 Failed assertion clauses != NIL fixed — Manuel Rigger
2019-11-16 ALTER TABLE results in "could not find cast from 3904 to 3831" open — Manuel Rigger
2019-11-13 Unexpected "cache lookup failed for collation 0" failure fixed — Manuel Rigger
2019-11-13 REINDEX CONCURRENTLY unexpectedly fails verified — Manuel Rigger
2019-09-24 INSERT INTO causes segfault on trunk fixed — Manuel Rigger
2019-09-24 INSERT INTO causes segfault on trunk fixed — mrigger
2019-07-27 Multiple inheritance and ALTER TABLE issue verified — Manuel Rigger
2019-07-24 Attribute has wrong type in ALTER TABLE closed duplicate — Manuel Rigger
2019-07-24 ANALYZE on parent table results in an error "tuple already updated by self" closed duplicate — Manuel Rigger
2019-07-24 ADD CHECK fails for parent table if column used in CHECK is fully-qualified closed not a bug — Manuel Rigger
2019-07-17 REINDEX CONCURRENTLY causes ALTER TABLE to fail fixed — Manuel Rigger
2019-07-16 BETWEEN SYMMETRIC condition results in "row is too big: ..., maximum size 8160" closed not a bug — Manuel Rigger
2019-07-15 UPDATE causes segfault on trunk closed duplicate — Manuel Rigger
2019-07-14 SELECT with COLLATE results in segfault on trunk and 12 Beta 2 closed duplicate — Manuel Rigger
2019-07-11 Stack buffer overflow in 12beta2 release closed not a bug — mrigger
2019-07-11 Stack buffer overflow in 12beta2 release closed duplicate — Manuel Rigger
2019-07-10 SEGFAULT in 12beta2 release closed duplicate — Manuel Rigger
2019-07-10 SEGFAULT in 12beta2 release closed not a bug — mrigger
2019-07-10 Generated column and string concatenation issue closed not a bug — Manuel Rigger
2019-07-10 ERROR: negative bitmapset member not allowed in SELECT fixed — Manuel Rigger
2019-07-10 ERROR: found unexpected null value in index fixed — Manuel Rigger
2019-07-07 VACUUM FULL results in ERROR: integer out of range closed not a bug — Manuel Rigger
2019-07-07 Issue with CHAR column and "column LIKE column" condition closed not a bug PQS Manuel Rigger
2019-07-04 DISCARD TEMP results in "ERROR: cache lookup failed for type 0" fixed — Manuel Rigger
2019-07-04 ALTER TABLE results in "ERROR: could not open relation with OID 43707388" verified — Manuel Rigger
2019-07-02 SELECT results in "ERROR: index key does not match expected index column" verified — Manuel Rigger
2019-07-02 GROUP BY and inheritance issue fixed PQS Manuel Rigger
2019-06-29 VACUUM FULL results in deadlock closed not a bug — Manuel Rigger
2019-06-02 ALTER TABLE SET WITH OIDS fails after failed CONCURRENTLY index creation closed not a bug — 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.