← All database systems

H2 is supported by SQLancer — the main repository ships a testing implementation for it. SQLancer is credited with 20 bugs in it, reported between 2020-08-12 and 2024-01-25. Its source is at h2database/h2database.

A further 1 report was 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

2020
18
2024
2

Who found them

Found by the SQLancer project
20

By status

Fixed
18
Open
2

By symptom

Logic bug
2
Unexpected error
15
Crash
1
Unclassified
2

By technique

Technique not recorded
18
Ternary Logic Partitioning (TLP)
2

Why each bug counts

Listed in the project's own bug repository
16
The report names a SQLancer oracle
2
The reproducer carries SQLancer's generated schema
1
Filed by someone who runs SQLancer campaigns
1

Who reported them (3)

Manuel Rigger
18
Suyang Zhong
1
suyZhong
1

Every bug on record (21)

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
2024-01-25 Unexpected result when using trigonomeric functions fixed — Suyang Zhong
2024-01-25 Potential issue when using `ROUND` fixed — suyZhong
2020-08-25 CREATE TABLE with a BINARY column and large size specification results in a NegativeArraySizeException fixed — Manuel Rigger
2020-08-20 Querying view that uses LTRIM/RTRIM results in a syntax error fixed — Manuel Rigger
2020-08-20 Call to STRINGDECODE results in StringIndexOutOfBoundsException fixed — Manuel Rigger
2020-08-19 Restore YEAR data type for MySQL compatibility mode fixed — Manuel Rigger
2020-08-19 ROUND() function runs very long fixed — Manuel Rigger
2020-08-19 Querying a view that uses the POSITION() function results in an unexpected syntax error fixed — Manuel Rigger
2020-08-19 MERGE INTO fails with an error "Timeout trying to lock table" open — Manuel Rigger
2020-08-19 MERGE INTO causes an unexpected syntax error fixed — Manuel Rigger
2020-08-19 INSERT() with NULL arguments for the original string and string to be added results in NPE fixed — Manuel Rigger
2020-08-19 Calling math functions with a string argument results in a NullPointerException fixed — Manuel Rigger
2020-08-18 Table with a generated column cycle results in a NullPointerException fixed — Manuel Rigger
2020-08-18 Query with % operator results in a ClassCastException fixed — Manuel Rigger
2020-08-18 Query on view with BINARY column results in an unexpected syntax error fixed — Manuel Rigger
2020-08-15 Query on view that uses the BETWEEN operator results in an unexpected syntax error fixed — Manuel Rigger
2020-08-14 Unexpected result for query that compares an integer with a string open TLP Manuel Rigger
2020-08-14 Query with CASE operator unexpectedly results in "Column must be in the GROUP BY list" error fixed — Manuel Rigger
2020-08-12 Query with an expression "NOT NOT - C0" causes a NullPointerException fixed — Manuel Rigger
2020-08-12 Incorrect result for query and NOT (c0 != -1 AND c0) predicate fixed TLP Manuel Rigger
2020-08-12 Expression NOT(c0 AND c0) unexpectedly evaluates to FALSE closed duplicate TLP 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.