Found Bugs
Found bugs in DBMS systems.
Database Management Systems (241 bugs)
MonetDB (47 bugs)
Unexpected result for INNER JOIN with IS NOT NULL
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7426
Unexpected result when using AND and IS NOT NULL
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7430
Unexpected result when using CASE WHEN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7429
Unexpected result when using BETWEEN operator
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7428
Unexpected result when using AND/OR chain
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7448
Unexpected result when using BETWEEN in INNER JOIN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7447
Unexpected result when using BETWEEN and CAST
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7451
Unexpected result when CREATE VIEW with WHERE NULL
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7450
Unexpected result when using BETWEEN with BOOLEAN values
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7455
Unexpected result when using AND with INTEGER
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7457
Unexpected result when using SIGN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7458
Crash when using CONTAINS in ORDER BY clause
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7459
Crash when using CAST and BETWEEN AND
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7460
Crash by potentially use of bad escape characters
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7461
Unexpected result when using CONTAINS and type casting
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7463
Crash when INNER JOIN with CONTAINS
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7466
Unexpected result when using NULL in BETWEEN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7465
Unexpected result when using IFNULL with large numbers
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7468
Unexpected result when using IS DISTINCT FROM
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7521
Assertion failure when using CONTAINS
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7523
Crash when creating view with HAVING
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7522
Unexpected error when using NATURAL RIGHT JOIN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7524
Unexpected result when using IS DISTINCT FROM with RIGHT JOIN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7527
Assertion failure when using JAROWINKLER in ORDER BY clause
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7528
Assertion failure when using JAROWINKLER with empty string
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7530
Unexpected result when using IS DISTINCT FROM with AND
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7534
Assertion failure when using GROUP BY when CREATE VIEW
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7535
Crash when using IS DISTINCT FROM with SIN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7539
Assertion failure when using STARTSWITH
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7540
Unexpected result when using LEVENSHTEIN
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7541
Unexpected result when using IS DISTINCT FROM with constants
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7543
Unexpected result when using STARTSWITH
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7544
Crash when creating view with GROUP BY
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7545
Assertion failure when using INNER JOIN on STARTSWITH
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7553
Unexpected result when using NULL constant in comparison
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7552
Unexpected result when using range comparison with NULL
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7554
Unexpected result when casting integer to boolean in comparison
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7555
Assertion failure when using STARTSWITH with view
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7556
Assertion failure when comparing INTERVAL value
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7562
Unexpected result when using IS DISTINCT FROM in VIEW
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7563
Crash when integer overflow in ORDER BY
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7571
Assertion failure at rel2bin_select when using STARTSWITH
Status: confirmedLink: https://github.com/MonetDB/MonetDB/issues/7574
Crash when using CHECK constraint
Status: fixedLink: https://github.com/MonetDB/MonetDB/issues/7577
Umbra (46 bugs)
cratedb (45 bugs)
Unexpected result when using CASE statement
Status: fixedLink: https://github.com/crate/crate/issues/15029
Unexpected Results when Using AND Operator
Status: fixedLink: https://github.com/crate/crate/issues/15050
Unexpected Results when Using Concat Operator
Status: fixedLink: https://github.com/crate/crate/issues/15083
Unexpected result when using BETWEEN AND
Status: fixedLink: https://github.com/crate/crate/issues/15201
Unexpected result when Concatenating NULL
Status: fixedLink: https://github.com/crate/crate/issues/15202
Unexpected Result when using IS NOT NULL
Status: fixedLink: https://github.com/crate/crate/issues/15265
Unexpected Result when using LEFT JOIN
Status: fixedLink: https://github.com/crate/crate/issues/15324
Unexpected Results Using NULLIF with VARCHAR
Status: fixedLink: https://github.com/crate/crate/issues/15325
Unexpected result when using string comparison AND IS NULL
Status: fixedLink: https://github.com/crate/crate/issues/15395
Unexpected result when using CONCAT_WS containing NULL
Status: fixedLink: https://github.com/crate/crate/issues/15459
Unexpected result when using % with NULL
Status: fixedLink: https://github.com/crate/crate/issues/15500
Unexpected result when using LTRIM with NULL as second argument
Status: fixedLink: https://github.com/crate/crate/issues/15527
Unexpected result when casting integer as boolean
Status: fixedLink: https://github.com/crate/crate/issues/15537
Weird string substitution when using JDBC
Status: fixedLink: https://github.com/crate/crate/issues/15566
Unexpected result when using INNER JOIN and CASE in filter
Status: fixedLink: https://github.com/crate/crate/issues/15613
Unexpected results when using system information functions
Status: fixedLink: https://github.com/crate/crate/issues/16026
Unexpected result when using CURRENT_SETTING
Status: fixedLink: https://github.com/crate/crate/issues/16062
Unexpected result when using PG_GET_PARTKEYDEF
Status: fixedLink: https://github.com/crate/crate/issues/16172
Unexpected result when using DEFAULT during creating table
Status: fixedLink: https://github.com/crate/crate/issues/16173
Unexpected result when querying with boolean comparisons
Status: fixedLink: https://github.com/crate/crate/issues/16227
Unexpected result when using FORMAT_TYPE
Status: fixedLink: https://github.com/crate/crate/issues/16225
Unexpected result when using escape character in LIKE
Status: fixedLink: https://github.com/crate/crate/issues/16350
Unexpected result when using empty OBJECT literal
Status: fixedLink: https://github.com/crate/crate/issues/16476
Unexpected results when using OBJECT nulls
Status: fixedLink: https://github.com/crate/crate/issues/16556
Unexpected results when matching empty string with indexing disabled
Status: fixedLink: https://github.com/crate/crate/issues/16567
Unexpected result when querying partitioned table with null values
Status: fixedLink: https://github.com/crate/crate/issues/16577
Unexpected result when using bigint in ORDER BY
Status: fixedLink: https://github.com/crate/crate/issues/16615
Unexpected result when querying partitioned table with CASE WHEN
Status: fixedLink: https://github.com/crate/crate/issues/16614
Unexpected result when using ARRAY(TEXT) in IN
Status: fixedLink: https://github.com/crate/crate/issues/16652
OutOfMemory when creating table with large replicas
Status: fixedLink: https://github.com/crate/crate/issues/16668
Unexpected result when comparing CHAR with ''
Status: confirmedLink: https://github.com/crate/crate/issues/16689
Unexpected result when RIGHT JOIN a subquery
Status: fixedLink: https://github.com/crate/crate/issues/16951
Potential hang when LEFT JOIN a subquery with EXP
Status: fixedLink: https://github.com/crate/crate/issues/16952
Unexpected result when using multiple RIGHT JOIN
Status: confirmedLink: https://github.com/crate/crate/issues/17089
Potential hang when LEFT JOIN a subquery with EXP
Status: fixedLink: https://github.com/crate/crate/issues/16952
Unexpected results when using LEFT JOIN with a subquery
Status: confirmedLink: https://github.com/crate/crate/issues/17380
Unexpected results when querying BOOLEAN values
Status: confirmedLink: https://github.com/crate/crate/issues/17379
Unexpected results when using ARRAY_POSITION
Status: confirmedLink: https://github.com/crate/crate/issues/17378
Dolt (28 bugs)
Unexpected Results when Using '%' operator
Status: fixedLink: https://github.com/dolthub/dolt/issues/7006
Unexpected Results about Floating-point Type Casting
Status: fixedLink: https://github.com/dolthub/dolt/issues/7018
Unexpected Results when Querying with NULL values
Status: fixedLink: https://github.com/dolthub/dolt/issues/7025
Unexpected Results about Decimal-Boolean Casting in Filters
Status: fixedLink: https://github.com/dolthub/dolt/issues/7038
Unexpected Results when Querying with COT
Status: fixedLink: https://github.com/dolthub/dolt/issues/7072
Unexpected Results when Using IN for Floating-Point
Status: fixedLink: https://github.com/dolthub/dolt/issues/7120
Unexpected Results of In expressions
Status: fixedLink: https://github.com/dolthub/dolt/issues/7147
Panic when Using BETWEEN and CASE WHEN
Status: fixedLink: https://github.com/dolthub/dolt/issues/7154
Unexpected Results when Using IN after Creating Index
Status: fixedLink: https://github.com/dolthub/dolt/issues/7155
Unexpected Results when Using ROUND()
Status: fixedLink: https://github.com/dolthub/dolt/issues/7222
Unexpected Results when Using BETWEEN and LEFT JOIN
Status: fixedLink: https://github.com/dolthub/dolt/issues/7229
Unexpected Results when Using BETWEEN AND after CREATE INDEX
Status: fixedLink: https://github.com/dolthub/dolt/issues/7260
Unexpected Result when Querying with CONCAT
Status: fixedLink: https://github.com/dolthub/dolt/issues/7261
Panic when Using INNER JOIN with String in IN
Status: fixedLink: https://github.com/dolthub/dolt/issues/7262
Unexpected results when comparing with empty string
Status: fixedLink: https://github.com/dolthub/dolt/issues/7323
Unexpected result when using Boolean in IN
Status: fixedLink: https://github.com/dolthub/dolt/issues/7338
Unexpected results when comparing string with type conversion
Status: confirmedLink: https://github.com/dolthub/dolt/issues/7372
DuckDB (23 bugs)
Unexpected Results when using IS NOT NULL
Status: fixedLink: https://github.com/duckdb/duckdb/issues/9806
Missing Results when using Floating-point in BETWEEN
Status: fixedLink: https://github.com/duckdb/duckdb/issues/9825
Internal Error: Calling StringValue::Get on a NULL value
Status: fixedLink: https://github.com/duckdb/duckdb/issues/9870
INTERNAL Error: Failed to bind column reference "" [1.2] (bindings: [1.1])
Status: fixedLink: https://github.com/duckdb/duckdb/issues/10087
Unexpected Result When Using `IS DISTINCT FROM` and `CASE WHEN` in a JOIN clause
Status: fixedLink: https://github.com/duckdb/duckdb/issues/12181
Unexpected result when using IN with DATE values
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13380
Unexpected result when casting negative integer to BIT
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13506
Unexpected result after creating index on varchar column
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13785
Unexpected result when using IN with TIME values
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13813
Unexpected result after creating index on DATE column
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13842
Inconsistent results when casting BIT and VARBINARY
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13905
Unexpected result when comparing STRUCT with INET
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13924
INTERNAL Error: Attempted to dereference unique_ptr that is NULL
Status: fixedLink: https://github.com/duckdb/duckdb/issues/13938
Unexpected result when casting TIMESTAMP_S to TIME
Status: fixedLink: https://github.com/duckdb/duckdb/issues/14026
Unexpected result when comparing BLOB
Status: fixedLink: https://github.com/duckdb/duckdb/issues/14567
Unexpected result when using INTERVAL and INNER JOIN subquery
Status: fixedLink: https://github.com/duckdb/duckdb/issues/14834
INTERNAL Error: Attempted to access index 0 within vector of size 0
Status: fixedLink: https://github.com/duckdb/duckdb/issues/15005
INTERNAL Error: ConstantFilter constant cannot be NULL - use IsNullFilter instead
Status: fixedLink: https://github.com/duckdb/duckdb/issues/15479
INTERNAL Error: Failed to bind column reference
Status: confirmedLink: https://github.com/duckdb/duckdb/issues/15586
INTERNAL Error: Vector::Reference used on vector of different type
Status: fixedLink: https://github.com/duckdb/duckdb/issues/15584
Unexpected result when using BETWEEN and CASE WHEN
Status: fixedLink: https://github.com/duckdb/duckdb/issues/15602
Unexpected results after indexing a column with multiple rows
Status: confirmedLink: https://github.com/duckdb/duckdb/issues/16074
Virtuoso (10 bugs)
Unexpected results when Using Trigonometric functions
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1213
Unexpected results when Using RIGHT JOIN
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1214
Unexpected results when using trigonometric functions
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1213
Unexpected Results when using LEFT JOIN with NULL
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1236
Unexpected results when using LEFT JOIN with NULL as predicate
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1238
Crash by CASE WHEN and unknown identifier
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1239
Unexpected results when using ORDER BY
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1241
Unexpected results when using LEFT JOIN and UNION
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1250
Unexpected results when using INNER JOIN and UNION
Status: fixedLink: https://github.com/openlink/virtuoso-opensource/issues/1251
TiDB (9 bugs)
Unexpected Results of IN expression With NATURAL RIGHT JOIN
Status: fixedLink: https://github.com/pingcap/tidb/issues/49476
Runtime error when using overflow integers
Status: confirmedLink: https://github.com/pingcap/tidb/issues/50489
Unexpected Result with NATURAL RIGHT JOIN and Bitwise NOT
Status: confirmedLink: https://github.com/pingcap/tidb/issues/53506
runtime error: index out of range [0] with length 0 by RAND()
Status: fixedLink: https://github.com/pingcap/tidb/issues/56270
Unexpected result when using JSON_VALID
Status: fixedLink: https://github.com/pingcap/tidb/issues/56293
Unexpected result when comparing TIMESTAMP null values
Status: confirmedLink: https://github.com/pingcap/tidb/issues/56294
runtime error: invalid memory address or nil pointer dereference with JSON_EXTRACT
Status: confirmedLink: https://github.com/pingcap/tidb/issues/56300
Unexpected result when using BIT_OR in RIGHT JOIN
Status: confirmedLink: https://github.com/pingcap/tidb/issues/57284
Unexpected result when using BIT_OR in RIGHT JOIN
Status: confirmedLink: https://github.com/pingcap/tidb/issues/57284
Firebird (9 bugs)
Crash potentially caused by BETWEEN Operator
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7860
Unexpected Results when Using Natural Right Join
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7879
Unexpected Results when Using CASE-WHEN with LEFT JOIN
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7903
Unexpected results when the join condition contains the OR predicate
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7908
Unexpected results when using CASE WHEN with RIGHT JOIN
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7993
Unexpected results after creating partial index
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7995
Unexpected results when using string concatenation for INTEGER
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7997
Unexpected error and crash after creating a partial index
Status: fixedLink: https://github.com/FirebirdSQL/firebird/issues/7998
Unexpected results when using LIKE with boolean values
Status: confirmedLink: https://github.com/FirebirdSQL/firebird/issues/8132
CedarDB (5 bugs)
risingwave (4 bugs)
Unexpected Results when Inserting NULL to PK column
Status: fixedLink: https://github.com/risingwavelabs/risingwave/issues/13497
Unexpected Results when Using NATURAL LEFT JOIN
Status: fixedLink: https://github.com/risingwavelabs/risingwave/issues/13572
Unexpected Results when Comparing with Bigint
Status: fixedLink: https://github.com/risingwavelabs/risingwave/issues/13601
Panicked: byte index 1024 is not a char boundary
Status: fixedLink: https://github.com/risingwavelabs/risingwave/issues/14283
Vitess (3 bugs)
Bug Report: Unexpected result when using bit-wise inversion and logical OR
Status: fixedLink: https://github.com/vitessio/vitess/issues/16590
Bug Report: Unexpected result when comparing BIT with VARCHAR
Status: confirmedLink: https://github.com/vitessio/vitess/issues/16832
Bug Report: Unexpected result when using LIKE operator
Status: fixedLink: https://github.com/vitessio/vitess/issues/16831
SQLite (3 bugs)
Unexpected results when using `REPLACE` function
Status: fixedLink: https://sqlite.org/forum/forumpost/3776b48e71
Unexpected result when using multiple joins with view
Status: fixedLink: https://sqlite.org/forum/forumpost/3f676b1196
Unexpected result when using multiple joins and subqueries
Status: fixedLink: https://sqlite.org/forum/forumpost/5c8a069d233fdc4dd4aa813d38af3dafd06795fb018c1427c5073ee312b3cacb
MySQL (2 bugs)
Unexpected Results when Using Math Function SIN
Status: confirmedLink: https://bugs.mysql.com/bug.php?id=113180
Unexpected Results when Using IN for Floating-Point
Status: confirmedLink: http://bugs.mysql.com/113298
MariaDB (2 bugs)
Unexpected result when casting decimal in WHERE clause
Status: confirmedLink: https://jira.mariadb.org/browse/MDEV-33999
Unexpected result for query with RIGHT JOIN and IS TRUE in where clause
Status: confirmedLink: https://jira.mariadb.org/browse/MDEV-33998
H2 (2 bugs)
Potential issue when using ROUND
Status: confirmedLink: https://github.com/h2database/h2database/issues/3982
Unexpected result when using trigonomeric functions
Status: fixedLink: https://github.com/h2database/h2database/issues/3981
CockroachDB (2 bugs)
internal error: comparison overload not found (ge, unknown, unknown)
Status: confirmedLink: https://github.com/cockroachdb/cockroach/issues/128889
Unexpected result when using a record in WHERE filter
Status: fixedLink: https://github.com/cockroachdb/cockroach/issues/130649
ClickHouse (1 bugs)
Unexpected result when comparing IN expression and integer
Status: confirmedLink: https://github.com/ClickHouse/ClickHouse/issues/65316