Database Management Systems (338 bugs)

TiDB (47 bugs)

incorrect unresolved column when using natural join

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/35522
Found by: bajinsheng

unexpected unresolved column error when the view refers to dual table

Status: fixed
Link: https://github.com/pingcap/tidb/issues/35527
Found by: bajinsheng

Runtime error: invalid memory address

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/35623
Found by: bajinsheng

Unexpected Result with a FALSE Expression in WHERE

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/35645
Found by: bajinsheng

Unexpected Error by CAST and CHAR functions

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/35652
Found by: bajinsheng

Unexpected Error for Function INET_ATON

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/35677
Found by: bajinsheng

Unexpected Connection Lost

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/35678
Found by: bajinsheng

Inconsistent Results in SELECT

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/36853
Found by: bajinsheng

Unexpected Result by CONCAT_WS

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/36888
Found by: bajinsheng

ERROR 8141 (HY000): assertion failed

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38295
Found by: bajinsheng

Incorrect Results by `REGEXP`

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38303
Found by: bajinsheng

Incorrect Result by `LEFT JOIN`

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38304
Found by: bajinsheng

runtime error: invalid memory address or nil pointer dereference

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38305
Found by: bajinsheng

Unexpected Results

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38310
Found by: bajinsheng

Error [types:1690]%s value is out of range in '%s'

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38352
Found by: bajinsheng

Unexpected Error: Failed to read auto-increment value from storage engine

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38483
Found by: bajinsheng

Unexpected Results by RIGHT JOIN

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38654
Found by: bajinsheng

rule PredicatePushDown pushes wrong filter across projection

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38736
Found by: bajinsheng

ERROR 8141 (HY000): assertion failed

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38295
Found by: bajinsheng

Incorrect Results by `REGEXP`

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38303
Found by: bajinsheng

Incorrect Result by `LEFT JOIN`

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38304
Found by: bajinsheng

runtime error: invalid memory address or nil pointer dereference

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38305
Found by: bajinsheng

Unexpected Results

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38310
Found by: bajinsheng

Unexpected Estimated Rows of `OR`

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38319
Found by: bajinsheng

Error [types:1690]%s value is out of range in '%s'

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38352
Found by: bajinsheng

Question About the Estimated Rows in `GROUP BY`

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38474
Found by: bajinsheng

Suspicious Estimated Rows by `JOIN`

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38479
Found by: bajinsheng

Suspicious Estimated Rows by HAVING

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38482
Found by: bajinsheng

Unexpected Error: Failed to read auto-increment value from storage engine

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38483
Found by: bajinsheng

Unexpected Results by RIGHT JOIN

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38654
Found by: bajinsheng

Unexpected Estimated Rows by INNER JOIN

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38665
Found by: bajinsheng

Unexpected Estimated Rows by WHERE clause

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38721
Found by: bajinsheng

rule PredicatePushDown pushes wrong filter across projection

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/38736
Found by: bajinsheng

runtime error: index out of range [7] with length 4

Status: unconfirmed
Link: https://github.com/pingcap/tidb/issues/44747
Found by: bajinsheng

Unexpected result of subquery

Status: fixed
Link: https://github.com/pingcap/tidb/issues/42912
Found by: Chi Zhang

Unexpected error in `ORDER BY`

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/42941
Found by: Chi Zhang

Unexpected error message on constant

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/42942
Found by: Chi Zhang

An expression has two different value in two queries

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/43026
Found by: Chi Zhang

`runtime error: index out of range [1] with length 1` on `SELECT`

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/43256
Found by: Chi Zhang

Unexpected results of subquery in `INSERT`

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/43373
Found by: Chi Zhang

Unexpected error `Unknown column 't1.c0' in 'where clause'`

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/43569
Found by: Chi Zhang

Unexpected results when `CASE` and `IN` use together

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/43624
Found by: Chi Zhang

Unexpected error `Unknown table ''` on CTE

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/44673
Found by: Chi Zhang

Unexpected error when `CHECK` a predicate that is always true.

Status: fixed
Link: https://github.com/pingcap/tidb/issues/44689
Found by: Chi Zhang

Unexpected results of `ANY` operator

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/44706
Found by: Chi Zhang

Unexpected Results of IN expression With NATURAL RIGHT JOIN

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/49476
Found by: Suyang Zhong

Runtime error when using overflow integers

Status: confirmed
Link: https://github.com/pingcap/tidb/issues/50489
Found by: Suyang Zhong

Umbra (46 bugs)

Unexpected Results when Comparing Boolean Values

Status: fixed
Link: None
Found by: Suyang Zhong

Potential Issue in BETWEEN operator

Status: fixed
Link: None
Found by: Suyang Zhong

Potential Issue in NULLIF function

Status: fixed
Link: None
Found by: Suyang Zhong

Potential Issue about boolean pruning in filter

Status: fixed
Link: None
Found by: Suyang Zhong

Potential Issue about UNIQUE INDEX

Status: fixed
Link: None
Found by: Suyang Zhong

Potential Issue when Dropping table

Status: fixed
Link: None
Found by: Suyang Zhong

Segmentation fault when Using NATURAL LEFT JOIN

Status: fixed
Link: None
Found by: Suyang Zhong

Potential issue when Using Boolean values and BETWEEN Operator

Status: fixed
Link: None
Found by: Suyang Zhong

Potential issue handling Boolean values after INDEX

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results after triggering an index scan

Status: fixed
Link: None
Found by: Suyang Zhong

Potential Issue when Using CONCAT with overflow integers

Status: fixed
Link: None
Found by: Suyang Zhong

Segmentation fault when Using Between Operator

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results When Using Between Operator and String Concatenation

Status: fixed
Link: None
Found by: Suyang Zhong

Segmentation fault when Using Between Operator and integer

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when Using BETWEEN Operator and Comparison

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when LEFT JOIN a view

Status: fixed
Link: None
Found by: Suyang Zhong

None

Status: fixed
Link: None
Found by: Suyang Zhong

None

Status: fixed
Link: None
Found by: Suyang Zhong

Segmentation fault when Using NATURAL FULL JOIN

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when Using IN expression With INDEX

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when Using BETWEEN With VIEW

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using NOT IN expression

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using IS NULL with empty VIEW

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using CAST

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using IN and BETWEEN AND for VIEW

Status: fixed
Link: None
Found by: Suyang Zhong

FATAL ERROR when Using NATURAL FULL JOIN

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using IN and BETWEEN AND for VIEW

Status: fixed
Link: None
Found by: Suyang Zhong

Segmentation fault when Using NATURAL FULL JOIN

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using Multiple Comparison

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using LEFT JOIN with VIEW on IS NOT NULL

Status: fixed
Link: None
Found by: Suyang Zhong

Assertion failure when using UNION ALL

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Abort

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when Using COS and IN expression

Status: fixed
Link: None
Found by: Suyang Zhong

Assertion failure when using NATURAL JOIN

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when Casting to VARCHAR

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when using NATURAL RIGHT JOIN with INDEX

Status: fixed
Link: None
Found by: Suyang Zhong

ERROR: AddressSanitizer: stack-buffer-overflow

Status: fixed
Link: None
Found by: Suyang Zhong

Assertion failure when using COT and BETWEEN AND

Status: fixed
Link: None
Found by: Suyang Zhong

Crash when using BETWEEN operator and large integer

Status: fixed
Link: None
Found by: Suyang Zhong

ERROR: AddressSanitizer: use-after-poison

Status: fixed
Link: None
Found by: Suyang Zhong

Assertion failure when using COALESCE and CASE WHEN

Status: fixed
Link: None
Found by: Suyang Zhong

Crash when using INNER JOIN

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected result when using LEFT JOIN and VIEW

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected result when using NULLIF and CAST in VIEW

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected result when using LEFT JOIN and NULL values

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected results when using logical operator in VIEW

Status: fixed
Link: None
Found by: Suyang Zhong

questdb (39 bugs)

Unexpected Internal Error: Index -1 out of bounds for length 16

Status: fixed
Link: https://github.com/questdb/questdb/issues/3322
Found by: Yuancheng Jiang

Unexpected Internal Error: UnsupportedOperationException

Status: fixed
Link: https://github.com/questdb/questdb/issues/3323
Found by: Yuancheng Jiang

Unexpected Internal Error: NullPointerException

Status: fixed
Link: https://github.com/questdb/questdb/issues/3324
Found by: Yuancheng Jiang

Unexpected NullPointerException with null query

Status: fixed
Link: https://github.com/questdb/questdb/issues/3356
Found by: Yuancheng Jiang

Unexpected ClassCastException with null query

Status: fixed
Link: https://github.com/questdb/questdb/issues/3357
Found by: Yuancheng Jiang

Consuming input failed: server closed the connection unexpectedly

Status: fixed
Link: https://github.com/questdb/questdb/issues/3376
Found by: Yuancheng Jiang

Unexpected UnsupportedOperationException with join query on non-boolean expression

Status: fixed
Link: https://github.com/questdb/questdb/issues/3386
Found by: Yuancheng Jiang

Unexpected StringIndexOutOfBoundsException with empty string

Status: fixed
Link: https://github.com/questdb/questdb/issues/3418
Found by: Yuancheng Jiang

NullPointerException Cannot invoke '.getAst()' because 'queryColumn' is null with order by clause

Status: fixed
Link: https://github.com/questdb/questdb/issues/3419
Found by: Yuancheng Jiang

NullPointerException: Cannot read field 'type' because 'node' is null with constant expression

Status: fixed
Link: https://github.com/questdb/questdb/issues/3420
Found by: Yuancheng Jiang

ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 16

Status: fixed
Link: https://github.com/questdb/questdb/issues/3433
Found by: Yuancheng Jiang

NullPointerException Cannot invoke '.isUndefined()' because the return value of '.getQuick(int)' is null

Status: fixed
Link: https://github.com/questdb/questdb/issues/3445
Found by: Yuancheng Jiang

ImplicitCastException and stuck when comparing STRING with NULL

Status: fixed
Link: https://github.com/questdb/questdb/issues/3454
Found by: Yuancheng Jiang

ClassCastException: NullConstant cannot be cast to class SymbolFunction

Status: fixed
Link: https://github.com/questdb/questdb/issues/3455
Found by: Yuancheng Jiang

StringIndexOutOfBoundsException: String index out of range: 0

Status: fixed
Link: https://github.com/questdb/questdb/issues/3467
Found by: Yuancheng Jiang

NullPointerException: Cannot read field 'type' because 'column' is null

Status: fixed
Link: https://github.com/questdb/questdb/issues/3468
Found by: Yuancheng Jiang

ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 0 at io.questdb.std.LongList.extendAndSet

Status: fixed
Link: https://github.com/questdb/questdb/issues/3469
Found by: Yuancheng Jiang

CairoException when casting string to timestamp

Status: fixed
Link: https://github.com/questdb/questdb/issues/3470
Found by: Yuancheng Jiang

java.lang.NullPointerException: Cannot read field 'type' because 'op' is null in rewriteAggregate(SqlOptimiser.java:3300)

Status: fixed
Link: https://github.com/questdb/questdb/issues/3526
Found by: Yuancheng Jiang

Unrobust comparison between string and char

Status: fixed
Link: https://github.com/questdb/questdb/issues/3576
Found by: Yuancheng Jiang

Inaccurate results with EXCEPT/INTERSECT

Status: fixed
Link: https://github.com/questdb/questdb/issues/3580
Found by: Yuancheng Jiang

Incorrect result returned by INTERSECT

Status: fixed
Link: https://github.com/questdb/questdb/issues/3581
Found by: Yuancheng Jiang

ClassCastException: GenericRecordMetadata cannot be cast to JoinRecordMetadata in generateJoins()

Status: fixed
Link: https://github.com/questdb/questdb/issues/3590
Found by: Yuancheng Jiang

Unexpected Error Invalid Column with multiple JOIN

Status: fixed
Link: https://github.com/questdb/questdb/issues/3595
Found by: Yuancheng Jiang

Invalid Column error with multiple JOIN

Status: fixed
Link: https://github.com/questdb/questdb/issues/3619
Found by: Yuancheng Jiang

UnsupportedOperationException in IntFunction.getStr(IntFunction.java:145)

Status: fixed
Link: https://github.com/questdb/questdb/issues/3622
Found by: Yuancheng Jiang

StringIndexOutOfBoundsException: String index out of range: 0 with ORDER BY empty string

Status: fixed
Link: https://github.com/questdb/questdb/issues/3623
Found by: Yuancheng Jiang

Incorrect results returned from UNION

Status: fixed
Link: https://github.com/questdb/questdb/issues/3669
Found by: Yuancheng Jiang

Invalid column error with LEFT OUTER JOIN

Status: fixed
Link: https://github.com/questdb/questdb/issues/3670
Found by: Yuancheng Jiang

Invalid column error not completely fixed

Status: fixed
Link: https://github.com/questdb/questdb/issues/3733
Found by: Yuancheng Jiang

Incorrect results with symbol comparison

Status: fixed
Link: https://github.com/questdb/questdb/issues/3828
Found by: Yuancheng Jiang

ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 16

Status: fixed
Link: https://github.com/questdb/questdb/issues/3833
Found by: Yuancheng Jiang

Unexpected invalid column not completely fixed

Status: fixed
Link: https://github.com/questdb/questdb/issues/3933
Found by: Yuancheng Jiang

Unexpected DatabaseError: queries have different number of columns in window function with union

Status: fixed
Link: https://github.com/questdb/questdb/issues/3934
Found by: Yuancheng Jiang

NullPointerException: Cannot invoke 'io.questdb.cairo.sql.SymbolTable.valueOf(int)' because 'this.symbolTable' is null

Status: fixed
Link: https://github.com/questdb/questdb/issues/3935
Found by: Yuancheng Jiang

Incorrect result with window function

Status: fixed
Link: https://github.com/questdb/questdb/issues/3936
Found by: Yuancheng Jiang

Unexpected results when having brackets with window query

Status: fixed
Link: https://github.com/questdb/questdb/issues/3938
Found by: Yuancheng Jiang

NullPointerException: Cannot read field 'token' because 'first' is null

Status: fixed
Link: https://github.com/questdb/questdb/issues/3949
Found by: Yuancheng Jiang

Incorrect results with nested joins

Status: fixed
Link: https://github.com/questdb/questdb/issues/4010
Found by: Yuancheng Jiang

SQLite (36 bugs)

An Inconsistent Result Depending on Parenthesization

Status: fixed
Link: https://sqlite.org/forum/forumpost/af3d07f908
Found by: bajinsheng

An Unexpected NULL Column Caused by Where Clause in RIGHT JOIN

Status: fixed
Link: https://sqlite.org/forum/forumpost/41cc3851d8
Found by: bajinsheng

Rows are Unexpectedly Filtered Out by DISTINCT in RIGHT JOIN

Status: fixed
Link: https://sqlite.org/forum/forumpost/c06b10ad7e
Found by: bajinsheng

Expression or Constant in GroupBy Clause

Status: fixed
Link: https://sqlite.org/forum/forumpost/2458c5dea2
Found by: bajinsheng

Ambiguous Reference Error for Right Join

Status: confirmed
Link: https://sqlite.org/forum/forumpost/e90a8e6e6f
Found by: bajinsheng

Unexpected Result by WHERE when Joining Tables

Status: fixed
Link: https://sqlite.org/forum/forumpost/687b0bf563
Found by: bajinsheng

Unexpected Result by WHERE/RIGHT JOIN

Status: fixed
Link: https://sqlite.org/forum/forumpost/5cfe08eed6
Found by: bajinsheng

Unexpected Result in Joining Virtual Tables

Status: fixed
Link: https://sqlite.org/forum/forumpost/3902c7b833
Found by: bajinsheng

Unexpected Result by Joining

Status: fixed
Link: https://sqlite.org/forum/forumpost/c2554d560b
Found by: bajinsheng

Unexpected Result by RIGHT JOIN on RTree Tables

Status: fixed
Link: https://sqlite.org/forum/forumpost/087de2d9ec
Found by: bajinsheng

Unexpected Result by WHERE Again

Status: fixed
Link: https://sqlite.org/forum/forumpost/de16c4abe2
Found by: bajinsheng

Unexpected Result by RIGHT JOIN

Status: fixed
Link: https://sqlite.org/forum/forumpost/206d99a16d
Found by: bajinsheng

Unexpected Assertion Error in SQLite3MemCompare

Status: fixed
Link: https://sqlite.org/forum/forumpost/800eecf5e6
Found by: bajinsheng

Unexpected Result by ORDER BY

Status: fixed
Link: https://sqlite.org/forum/forumpost/323f86cc30
Found by: bajinsheng

Unexpected Result by RIGHT JOIN with INDEX

Status: fixed
Link: https://sqlite.org/forum/forumpost/c4676c4956
Found by: bajinsheng

Unexpected Result by JSON

Status: fixed
Link: https://sqlite.org/forum/forumpost/3d9caa45cb
Found by: bajinsheng

Unexpected Result by Complicated JOINING

Status: unconfirmed
Link: https://sqlite.org/forum/forumpost/eeb8173cf8
Found by: bajinsheng

Assertion `pCur->eCurType==CURTYPE_VTAB' failed

Status: fixed
Link: https://sqlite.org/forum/forumpost/dafe0500b0
Found by: bajinsheng

Unexpected Result by RIGHT JOIN Again

Status: fixed
Link: https://sqlite.org/forum/forumpost/51e6959f61
Found by: bajinsheng

Unexpected Result by Complicated JOINING Again

Status: fixed
Link: https://sqlite.org/forum/forumpost/b40696f501
Found by: bajinsheng

Unexpected Assertion Error in valueFromFunction

Status: unconfirmed
Link: https://sqlite.org/forum/forumpost/e3243e07e8
Found by: bajinsheng

Unexpected Result by FULL OUTER JOIN

Status: fixed
Link: https://sqlite.org/forum/forumpost/5610c17c3d
Found by: bajinsheng

Unexpected Expression on ON clause

Status: fixed
Link: https://sqlite.org/forum/forumpost/57bdf2217d
Found by: bajinsheng

Unexpected Expression Result by FULL OUTER JOIN

Status: fixed
Link: https://sqlite.org/forum/forumpost/6650cd40b5
Found by: bajinsheng

Unexpected Parse Error

Status: fixed
Link: https://sqlite.org/forum/forumpost/1a7fea4651
Found by: bajinsheng

Unexpected Assertion Error in whereRangeScanEst

Status: fixed
Link: https://sqlite.org/forum/forumpost/c3496cf6b1
Found by: bajinsheng

Unexpected Result by Union

Status: unconfirmed
Link: https://sqlite.org/forum/forumpost/174afeae57
Found by: bajinsheng

Assertion `pRec->nField>0 && pRec->nField<=pIdx->nSampleCol' failed.

Status: unconfirmed
Link: https://sqlite.org/forum/forumpost/3607259d3c
Found by: bajinsheng

Incorrect results with the latest trunk version

Status: fixed
Link: https://sqlite.org/forum/info/0846211821513f50
Found by: Chi Zhang

Incorrect result that might be caused by json function

Status: fixed
Link: https://sqlite.org/forum/info/37dd14a538ea84e0
Found by: Chi Zhang

Incorrect result for COUNT on view with window function

Status: fixed
Link: https://sqlite.org/forum/info/2cd11c2d37696553
Found by: Chi Zhang

Incorrect result might caused by INDEX

Status: fixed
Link: https://sqlite.org/forum/info/a68313d0545273c8
Found by: Chi Zhang

An assertion failure only triggers in JDBC driver with -DSQLITE_DEBUG=1 compile option

Status: fixed
Link: https://sqlite.org/forum/info/dc4854437bda462c
Found by: Chi Zhang

Unexpected results of `JOIN`

Status: fixed
Link: https://sqlite.org/forum/forumpost/8f48e29d67
Found by: Chi Zhang

Unexpected result of `JOIN`

Status: fixed
Link: https://sqlite.org/forum/forumpost/96cd4a7e9e
Found by: Chi Zhang

Unexpected results when using `REPLACE` function

Status: fixed
Link: https://sqlite.org/forum/forumpost/3776b48e71
Found by: Suyang Zhong

DuckDB (32 bugs)

BETWEEN with subquery and column results in unexpected error

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/3588
Found by: kokrui

Unexpected Error for RTRIM Function in Where Clause

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/3616
Found by: kokrui

Crash When Creating Index

Status: unconfirmed
Link: https://github.com/duckdb/duckdb/issues/4976
Found by: bajinsheng

Segmentation fault on `BETWEEN`

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/6861
Found by: Chi Zhang

Unexpected result when take subquery as operand

Status: confirmed
Link: https://github.com/duckdb/duckdb/issues/7044
Found by: Chi Zhang

Different returned datatype of a `CASE` statement in different query.

Status: confirmed
Link: https://github.com/duckdb/duckdb/issues/7064
Found by: Chi Zhang

Unexpected results when integer overflow

Status: unconfirmed
Link: https://github.com/duckdb/duckdb/issues/7094
Found by: Chi Zhang

Unexpected results on specific values

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7142
Found by: Chi Zhang

Hang on `SELECT` query

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7143
Found by: Chi Zhang

`INTERNAL Error: Logical column index 1 out of range`

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7250
Found by: Chi Zhang

DuckDB hang on `DELETE`

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7530
Found by: Chi Zhang

Segmentation fault on `SELECT`

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7551
Found by: Chi Zhang

Inconsistent results of subquery in `INSERT` and `SELECT`, and an unexpected error

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7601
Found by: Chi Zhang

DuckDB hang on `DELETE`

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7610
Found by: Chi Zhang

Unexpected results on common table expressions

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/7960
Found by: Chi Zhang

Incorrect result by subquery and join

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/100561
Found by: Chi Zhang

internal error: null rejection requested on non-null column

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/100559
Found by: Chi Zhang

kvcoord: setting `kv.range_descriptor_cache.size=0` results in range iterator to retry endlessly

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/101011
Found by: Chi Zhang

internal error: failed to parse locale "": language: tag is not well-formed

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/101418
Found by: Chi Zhang

Unexpected results of `TIME` value under JDBC

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/101591
Found by: Chi Zhang

`internal error: expected subquery to be lazily planned as a routine`

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/101980
Found by: Chi Zhang

Unexpected results of `CASE` and `BETWEEN`

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/102110
Found by: Chi Zhang

Unexpected results might be related to `BIT` and `INDEX`

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/102412
Found by: Chi Zhang

Unexpected error `unknown signature: bit_length(string) (desired )`

Status: confirmed
Link: https://github.com/cockroachdb/cockroach/issues/102716
Found by: Chi Zhang

Unexpected results of `IN` with redundant values list

Status: confirmed
Link: https://github.com/cockroachdb/cockroach/issues/102864
Found by: Chi Zhang

Unexpected results related to `INDEX`

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/103755
Found by: Chi Zhang

Inconsistent result of `AVG` on big float number

Status: confirmed
Link: https://github.com/cockroachdb/cockroach/issues/104319
Found by: Chi Zhang

Unexpected hang on subquery

Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/105882
Found by: Chi Zhang

Unexpected Results when using IS NOT NULL

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/9806
Found by: Suyang Zhong

Missing Results when using Floating-point in BETWEEN

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/9825
Found by: Suyang Zhong

Internal Error: Calling StringValue::Get on a NULL value

Status: fixed
Link: https://github.com/duckdb/duckdb/issues/9870
Found by: Suyang Zhong

INTERNAL Error: Failed to bind column reference "" [1.2] (bindings: [1.1])

Status: confirmed
Link: https://github.com/duckdb/duckdb/issues/10087
Found by: Suyang Zhong

Dolt (27 bugs)

Unexpected Results when Using '%' operator

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7006
Found by: Suyang Zhong

Unexpected Results about Floating-point Type Casting

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7018
Found by: Suyang Zhong

Unexpected Results when Querying with NULL values

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7025
Found by: Suyang Zhong

Crashing by Division Operators

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7026
Found by: Suyang Zhong

Unexpected Results about Decimal-Boolean Casting in Filters

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7038
Found by: Suyang Zhong

Crash by Function DAYNAME

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7039
Found by: Suyang Zhong

Crash by ACOS

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7046
Found by: Suyang Zhong

Crash by Time Functions

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7056
Found by: Suyang Zhong

Crash by SQRT

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7060
Found by: Suyang Zhong

Unexpected Results when Querying with COT

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7072
Found by: Suyang Zhong

Potential Issue Using ROUND

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7073
Found by: Suyang Zhong

Unexpected Results when Using IN for Floating-Point

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7120
Found by: Suyang Zhong

Unexpected Results of In expressions

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7147
Found by: Suyang Zhong

Panic when Using BETWEEN and CASE WHEN

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7154
Found by: Suyang Zhong

Unexpected Results when Using IN after Creating Index

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7155
Found by: Suyang Zhong

Panic when Using BETWEEN AND

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7216
Found by: Suyang Zhong

Unexpected Results when Using ROUND()

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7222
Found by: Suyang Zhong

Unexpected Results when Using BETWEEN and LEFT JOIN

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7229
Found by: Suyang Zhong

Panic when Using INNER JOIN

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7235
Found by: Suyang Zhong

Unexpected Result when Using -'' in IN

Status: fixed
Link: None
Found by: Suyang Zhong

Unexpected Results when Using BETWEEN AND after CREATE INDEX

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7260
Found by: Suyang Zhong

Unexpected Result when Querying with CONCAT

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7261
Found by: Suyang Zhong

Panic when Using INNER JOIN with String in IN

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7262
Found by: Suyang Zhong

Unexpected results when comparing with empty string

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7323
Found by: Suyang Zhong

Unexpected result when using Boolean in IN

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7338
Found by: Suyang Zhong

Crash by INNER JOIN

Status: fixed
Link: https://github.com/dolthub/dolt/issues/7371
Found by: Suyang Zhong

Unexpected results when comparing string with type conversion

Status: confirmed
Link: https://github.com/dolthub/dolt/issues/7372
Found by: Suyang Zhong

CockroachDB (25 bugs)

sql: support SCRUB on temp tables

Status: confirmed
Link: https://github.com/cockroachdb/cockroach/issues/83770
Found by: bajinsheng

Internal Error: Comparison Overload not Found

Status: confirmed
Link: https://github.com/cockroachdb/cockroach/issues/83792
Found by: bajinsheng

ERROR: no builtin aggregate for SUM_INT on [unknown]

Status: confirmed
Link: https://github.com/cockroachdb/cockroach/issues/83874
Found by: bajinsheng

Crashing by EXPLAIN Statement

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/83965
Found by: bajinsheng

Invalid Memory Address Error of Specific SQL Query

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/83973
Found by: bajinsheng

Unexpected Error of Unique Index

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/83976
Found by: bajinsheng

Crash: panic: RecordingStructured has 30 recordings; expected 1

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/84056
Found by: bajinsheng

Unexpected Overflow Error by Huge Interval Value

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/84154
Found by: bajinsheng

Inconsistent Case Return Types Decimal Int

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85356
Found by: bajinsheng

No Result Returned by SHOW COLUMN

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85388
Found by: bajinsheng

internal error: no volatility for cast decimal::timestamp

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85389
Found by: bajinsheng

opt: internal error: lookup for ComparisonExpr

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85390
Found by: bajinsheng

opt: internal error: no output column equivalent to 2

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85393
Found by: bajinsheng

Unexpected Error in SHOW COLUMNS

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85394
Found by: bajinsheng

opt: internal error: estimated row count must be non-zero

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85499
Found by: bajinsheng

Unexpected Result by UNION

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/85502
Found by: bajinsheng

An Unexpected Error in `CROSS MERGE JOIN`

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/88104
Found by: bajinsheng

ERROR: internal error: expected *DInt, found tree.dNull

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/94264
Found by: bajinsheng

An Unexpected Error in `CROSS MERGE JOIN`

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/88104
Found by: bajinsheng

Potential Issue for Estimated Rows

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/88455
Found by: bajinsheng

An Issue of Estimated Rows

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/89161
Found by: bajinsheng

Unexpected Estimated Rows in `HAVING` clause

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/89462
Found by: bajinsheng

Suspicious Estimated Rows by `OR`

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/90112
Found by: bajinsheng

Suspicious Estimated Rows by `DISTINCT`

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/90113
Found by: bajinsheng

ERROR: internal error: expected *DInt, found tree.dNull

Status: unconfirmed
Link: https://github.com/cockroachdb/cockroach/issues/94264
Found by: bajinsheng

cratedb (20 bugs)

Couldn't create execution plan from logical plan because of: Index 2 out of bounds for length 2

Status: fixed
Link: https://github.com/crate/crate/issues/14805
Found by: Yuancheng Jiang

Incorrect result returned by UNION

Status: fixed
Link: https://github.com/crate/crate/issues/14807
Found by: Yuancheng Jiang

Unexpected Exception with ORDER BY clause with UNION

Status: fixed
Link: https://github.com/crate/crate/issues/14815
Found by: Yuancheng Jiang

Unexpected result when using CASE statement

Status: fixed
Link: https://github.com/crate/crate/issues/15029
Found by: Suyang Zhong

Unexpected Results when Using AND Operator

Status: fixed
Link: https://github.com/crate/crate/issues/15050
Found by: Suyang Zhong

Unexpected Results when Using Concat Operator

Status: fixed
Link: https://github.com/crate/crate/issues/15083
Found by: Suyang Zhong

Unexpected Results Using Boolean

Status: fixed
Link: https://github.com/crate/crate/issues/15120
Found by: Suyang Zhong

Unexpected Results Using NULLIF

Status: fixed
Link: https://github.com/crate/crate/issues/15121
Found by: Suyang Zhong

Unexpected result when using BETWEEN AND

Status: fixed
Link: https://github.com/crate/crate/issues/15201
Found by: Suyang Zhong

Unexpected result when Concatenating NULL

Status: fixed
Link: https://github.com/crate/crate/issues/15202
Found by: Suyang Zhong

Unexpected Result when using IS NOT NULL

Status: fixed
Link: https://github.com/crate/crate/issues/15265
Found by: Suyang Zhong

Unexpected Result when using LEFT JOIN

Status: fixed
Link: https://github.com/crate/crate/issues/15324
Found by: Suyang Zhong

Unexpected Results Using NULLIF with VARCHAR

Status: fixed
Link: https://github.com/crate/crate/issues/15325
Found by: Suyang Zhong

Unexpected Result when using IN

Status: fixed
Link: https://github.com/crate/crate/issues/15326
Found by: Suyang Zhong

Unexpected result when using string comparison AND IS NULL

Status: fixed
Link: https://github.com/crate/crate/issues/15395
Found by: Suyang Zhong

Unexpected results when using AND

Status: fixed
Link: https://github.com/crate/crate/issues/15458
Found by: Suyang Zhong

Unexpected result when using CONCAT_WS containing NULL

Status: fixed
Link: https://github.com/crate/crate/issues/15459
Found by: Suyang Zhong

Unexpected result when using % with NULL

Status: fixed
Link: https://github.com/crate/crate/issues/15500
Found by: Suyang Zhong

Unexpected result when using LTRIM with NULL as second argument

Status: fixed
Link: https://github.com/crate/crate/issues/15527
Found by: Suyang Zhong

Unexpected result when casting integer as boolean

Status: confirmed
Link: https://github.com/crate/crate/issues/15537
Found by: Suyang Zhong

neo4j (11 bugs)

A potential performance bug (missing optimization)

Status: confirmed
Link: https://github.com/neo4j/neo4j/issues/12957
Found by: Yuancheng Jiang

Unexpected DatabaseException: Exception closing multiple resources

Status: fixed
Link: https://github.com/neo4j/neo4j/issues/12968
Found by: Yuancheng Jiang

One equivalent query can help improve performance hundred of times

Status: fixed
Link: https://github.com/neo4j/neo4j/issues/12973
Found by: Yuancheng Jiang

Using OPTIONAL and DISTINCT together with shortestPath() outputs an error

Status: fixed
Link: https://github.com/neo4j/neo4j/issues/12988
Found by: Yuancheng Jiang

Inconsistent results

Status: fixed
Link: https://github.com/neo4j/neo4j/issues/12991
Found by: Yuancheng Jiang

Unexpected Result with SKIP 1

Status: fixed
Link: https://github.com/neo4j/neo4j/issues/12996
Found by: Yuancheng Jiang

Some queries are running unexpectedly slow

Status: confirmed
Link: https://github.com/neo4j/neo4j/issues/13003
Found by: Yuancheng Jiang

Adding index incurs performance regression in some cases

Status: confirmed
Link: https://github.com/neo4j/neo4j/issues/13010
Found by: Yuancheng Jiang

OPTIONAL MATCH is much faster than MATCH in some cases

Status: confirmed
Link: https://github.com/neo4j/neo4j/issues/13033
Found by: Yuancheng Jiang

Inconsistent performance

Status: fixed
Link: https://github.com/neo4j/neo4j/issues/13034
Found by: Yuancheng Jiang

Unexpected error: out of bounds for object

Status: fixed
Link: https://github.com/neo4j/neo4j/issues/13041
Found by: Yuancheng Jiang

MonetDB (9 bugs)

Unexpected result for INNER JOIN with IS NOT NULL

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7426
Found by: Suyang Zhong

Unexpected result when using AND and IS NOT NULL

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7430
Found by: Suyang Zhong

Unexpected result when using CASE WHEN

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7429
Found by: Suyang Zhong

Unexpected result when using BETWEEN operator

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7428
Found by: Suyang Zhong

Unexpected result when using AND/OR chain

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7448
Found by: Suyang Zhong

Unexpected result when using BETWEEN in INNER JOIN

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7447
Found by: Suyang Zhong

Unexpected result when using BETWEEN and CAST

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7451
Found by: Suyang Zhong

Unexpected result when CREATE VIEW with WHERE NULL

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7450
Found by: Suyang Zhong

Unexpected result when using BETWEEN with BOOLEAN values

Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7455
Found by: Suyang Zhong

Firebird (9 bugs)

Potential bug in BETWEEN Operator

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7839
Found by: Manuel Rigger

Crash potentially caused by BETWEEN Operator

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7860
Found by: Suyang Zhong

Unexpected Results when Using Natural Right Join

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7879
Found by: Suyang Zhong

Unexpected Results when Using CASE-WHEN with LEFT JOIN

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7903
Found by: Suyang Zhong

Unexpected results when the join condition contains the OR predicate

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7908
Found by: Suyang Zhong

Unexpected results when using CASE WHEN with RIGHT JOIN

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7993
Found by: Suyang Zhong

Unexpected results after creating partial index

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7995
Found by: Suyang Zhong

Unexpected results when using string concatenation for INTEGER

Status: confirmed
Link: https://github.com/FirebirdSQL/firebird/issues/7997
Found by: Suyang Zhong

Unexpected error and crash after creating a partial index

Status: fixed
Link: https://github.com/FirebirdSQL/firebird/issues/7998
Found by: Suyang Zhong

MySQL (8 bugs)

Suspicious Estimated Rows

Status: unconfirmed
Link: https://bugs.mysql.com/bug.php?id=108833
Found by: bajinsheng

Suspicious Estimated Rows by JOIN

Status: unconfirmed
Link: https://bugs.mysql.com/bug.php?id=108851
Found by: bajinsheng

Suspicious Estimated Rows by DISTINCTROW

Status: unconfirmed
Link: https://bugs.mysql.com/bug.php?id=108852
Found by: bajinsheng

Unexpected Error: Memory capacity exceeded

Status: unconfirmed
Link: https://bugs.mysql.com/bug.php?id=111471
Found by: bajinsheng

Wrong result of `IN` clause

Status: confirmed
Link: https://bugs.mysql.com/bug.php?id=111241
Found by: Chi Zhang

Unexpected error when `CHECK` a predicate that is always true

Status: confirmed
Link: https://bugs.mysql.com/bug.php?id=111421
Found by: Chi Zhang

Unexpected Results when Using Math Function SIN

Status: confirmed
Link: https://bugs.mysql.com/bug.php?id=113180
Found by: Suyang Zhong

Unexpected Results when Using IN for Floating-Point

Status: confirmed
Link: http://bugs.mysql.com/113298
Found by: Suyang Zhong

risingwave (7 bugs)

Panicked when processing: assertion failed: (left == right)

Status: fixed
Link: https://github.com/risingwavelabs/risingwave/issues/12818
Found by: Yuancheng Jiang

Incorrect result with ORDER BY in OVER(PARTITION BY ...)

Status: confirmed
Link: https://github.com/risingwavelabs/risingwave/issues/12822
Found by: Yuancheng Jiang

InternalError_: Panicked when processing: internal error: entered unreachable code: Subquery Subquery

Status: fixed
Link: https://github.com/risingwavelabs/risingwave/issues/12847
Found by: Yuancheng Jiang

Unexpected Results when Inserting NULL to PK column

Status: fixed
Link: https://github.com/risingwavelabs/risingwave/issues/13497
Found by: Suyang Zhong

Unexpected Results when Using NATURAL LEFT JOIN

Status: fixed
Link: https://github.com/risingwavelabs/risingwave/issues/13572
Found by: Suyang Zhong

Unexpected Results when Comparing with Bigint

Status: fixed
Link: https://github.com/risingwavelabs/risingwave/issues/13601
Found by: Suyang Zhong

Panicked: byte index 1024 is not a char boundary

Status: fixed
Link: https://github.com/risingwavelabs/risingwave/issues/14283
Found by: Suyang Zhong

Virtuoso (6 bugs)

Unexpected results when Using Trigonometric functions

Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1213
Found by: Suyang Zhong

Unexpected results when Using RIGHT JOIN

Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1214
Found by: Suyang Zhong

Unexpected results when using trigonometric functions

Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1213
Found by: Suyang Zhong

Unexpected Results when using LEFT JOIN with NULL

Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1236
Found by: Suyang Zhong

Unexpected results when using LEFT JOIN with NULL as predicate

Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1238
Found by: Suyang Zhong

Crash by CASE WHEN and unknown identifier

Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1239
Found by: Suyang Zhong

tdengine (4 bugs)

Segmentation fault with certain queries

Status: fixed
Link: https://github.com/taosdata/TDengine/issues/21323
Found by: Yuancheng Jiang

Unexpected generic error with LIKE query

Status: open
Link: https://github.com/taosdata/TDengine/issues/21368
Found by: Yuancheng Jiang

Unexpected Syntax Error with Null

Status: open
Link: https://github.com/taosdata/TDengine/issues/21520
Found by: Yuancheng Jiang

Segmentation fault when having IS NULL in JOIN condition

Status: confirmed
Link: https://github.com/taosdata/TDengine/issues/22857
Found by: Yuancheng Jiang

redisgraph (4 bugs)

Unexpected results

Status: confirmed
Link: https://github.com/RedisGraph/RedisGraph/issues/2744
Found by: Yuancheng Jiang

Buggy result

Status: confirmed
Link: https://github.com/RedisGraph/RedisGraph/issues/2858
Found by: Yuancheng Jiang

Inconsistent results

Status: confirmed
Link: https://github.com/RedisGraph/RedisGraph/issues/2859
Found by: Yuancheng Jiang

Inconsistent results when querying a symmetric path

Status: confirmed
Link: https://github.com/RedisGraph/RedisGraph/issues/2865
Found by: Yuancheng Jiang

agensgraph (3 bugs)

Query gives inconsistent result

Status: fixed
Link: https://github.com/bitnine-oss/agensgraph/issues/595
Found by: Yuancheng Jiang

Seems to be an unexpected error

Status: fixed
Link: https://github.com/bitnine-oss/agensgraph/issues/609
Found by: Yuancheng Jiang

Inconsistent results when executing equivalent queries

Status: fixed
Link: https://github.com/bitnine-oss/agensgraph/issues/617
Found by: Yuancheng Jiang

Percona (2 bugs)

Unexpected result related to CREATE INDEX and RADIANS

Status: confirmed
Link: https://perconadev.atlassian.net/browse/PS-9049
Found by: Albert Zhang

Unexpected results when using ASIN function with NULLIF

Status: confirmed
Link: https://perconadev.atlassian.net/jira/software/c/projects/PS/issues/PS-9085
Found by: Albert Zhang

H2 (2 bugs)

Potential issue when using ROUND

Status: confirmed
Link: https://github.com/h2database/h2database/issues/3982
Found by: Suyang Zhong

Unexpected result when using trigonomeric functions

Status: fixed
Link: https://github.com/h2database/h2database/issues/3981
Found by: Suyang Zhong

CUBRID (1 bugs)

ORDER BY causes row to be omitted with index and case expression

Status: fixed
Link: http://jira.cubrid.org/browse/CBRD-25067
Found by: Manuel Rigger

Datalog Engines (30 bugs)

Soufflé (23 bugs)

Negative zero causes different results for interpreter mode and compiler mode

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2311
Found by: Chi Zhang

A problem about ungrounded variable

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2318
Found by: Chi Zhang

Souffle crashed on aggregates

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2320
Found by: Chi Zhang

Assertion failure "relation not found" on provenance

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2321
Found by: Chi Zhang

A problem about subsumption

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2322
Found by: Chi Zhang

A problem that the result of subsumption is correct, but the final result is wrong

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2323
Found by: Chi Zhang

The subsumption causes the execution of program been killed

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2324
Found by: Chi Zhang

"inline" causes assertion failure "functor type not set"

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2326
Found by: Chi Zhang

Wrong result caused by "eqrel"

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2327
Found by: Chi Zhang

Wrong result with `inline` and `no_magic`

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2337
Found by: Chi Zhang

`inline` cause `Ungrounded variable` not assertion failure

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2338
Found by: Chi Zhang

`inline` cause `Floating-point arithmetic exception` without divide-by-zero

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2339
Found by: Chi Zhang

`inline` and `magic` used together cause `Segmentation violation`

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2340
Found by: Chi Zhang

different result under interpreter and compiler mode

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2343
Found by: Chi Zhang

Assertion failure on auto-tuning

Status: fixed
Link: https://github.com/souffle-lang/souffle/issues/2346
Found by: Chi Zhang

Insufficient grammar check for query plan

Status: fixed
Link: https://github.com/souffle-lang/souffle/issues/2351
Found by: Chi Zhang

`inline` causes assertion failure `numeric constant type not set`

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2355
Found by: Chi Zhang

`inline` in recursive query trigger an error with query plan

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2369
Found by: Chi Zhang

`magic` causes different result

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2375
Found by: Chi Zhang

Insufficient checking on unground variable

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2379
Found by: Chi Zhang

A problem about subsumption.

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2382
Found by: Chi Zhang

`eqrel` doesn't work well with provenance

Status: unconfirmed
Link: https://github.com/souffle-lang/souffle/issues/2385
Found by: Chi Zhang

Assertion failure on `Auto-Scheduling`

Status: confirmed
Link: https://github.com/souffle-lang/souffle/issues/2426
Found by: Chi Zhang

CozoDB (5 bugs)

Unexpected error in query parser

Status: fixed
Link: https://github.com/cozodb/cozo/issues/97
Found by: Chi Zhang

System panic on modulo by zero

Status: fixed
Link: https://github.com/cozodb/cozo/issues/99
Found by: Chi Zhang

Inconsistent results of two equivalent programs

Status: fixed
Link: https://github.com/cozodb/cozo/issues/101
Found by: Chi Zhang

unexpected error of function `trim_start`

Status: confirmed
Link: https://github.com/cozodb/cozo/issues/113
Found by: Chi Zhang

Unexpected result of `ge` on `-0.0` and `0.0` under magic rewrite

Status: confirmed
Link: https://github.com/cozodb/cozo/issues/122
Found by: Chi Zhang

μZ (2 bugs)

Wrong result of z3 datalog

Status: fixed
Link: https://github.com/Z3Prover/z3/issues/6446
Found by: Chi Zhang

Wrong result of z3 datalog with predict

Status: confirmed
Link: https://github.com/Z3Prover/z3/issues/6447
Found by: Chi Zhang

XML Processors (26 bugs)

BaseX (16 bugs)

Error in arithemetic calculation result comparison

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2188
Found by: ShuxinLi

Unexpected exception of division by zero

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2189
Found by: ShuxinLi

Bug of operation on non-existing attribute

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2190
Found by: ShuxinLi

Bug on node selection with last()

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2191
Found by: ShuxinLi

Bug on child node selection with count()

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2193
Found by: ShuxinLi

Bug on node selection with self axis

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2194
Found by: ShuxinLi

Internal crash on has-children() result comparison

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2213
Found by: ShuxinLi

Incorrect result for count after subsequence

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2214
Found by: ShuxinLi

Unexpected exception of mapping double attributes

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2215
Found by: ShuxinLi

Bug on map operation of empty sequence

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2216
Found by: ShuxinLi

Bug on consecutive map with distinct-values

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2217
Found by: ShuxinLi

Bug on node selection with position()

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2219
Found by: ShuxinLi

Bug on arithemetic operations with last() and position()

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2220
Found by: ShuxinLi

Bug on contains-token() with token index

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2222
Found by: ShuxinLi

Unexpected exception of arithemetic operations with positional expression

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2224
Found by: ShuxinLi

Incorrect result count with multiple sequence operators

Status: fixed
Link: https://github.com/BaseXdb/basex/issues/2225
Found by: ShuxinLi

eXist-db (6 bugs)

XQuery query with index after predicate selection

Status: confirmed
Link: https://github.com/eXist-db/exist/issues/4968
Found by: ShuxinLi

XQuery fails to select node with true predicate

Status: confirmed
Link: https://github.com/eXist-db/exist/issues/4958
Found by: ShuxinLi

XQuery bug of node selection of tail() after subsequence()

Status: fixed
Link: https://github.com/eXist-db/exist/issues/4830
Found by: ShuxinLi

XQuery bug on selecting nodes with last()

Status: confirmed
Link: https://github.com/eXist-db/exist/issues/4824
Found by: ShuxinLi

XQuery simple node selection return duplicate nodes

Status: confirmed
Link: https://github.com/eXist-db/exist/issues/4811
Found by: ShuxinLi

XQuery return wrong results on start-with comparison

Status: confirmed
Link: https://github.com/eXist-db/exist/issues/4810
Found by: ShuxinLi

Saxonica (4 bugs)

Bug on exist() with non-existing attribute

Status: fixed
Link: https://saxonica.plan.io/issues/6051
Found by: ShuxinLi

NullPointerException with upper-case function

Status: fixed
Link: https://saxonica.plan.io/issues/6067
Found by: ShuxinLi

Bug on predicate with last()

Status: fixed
Link: https://saxonica.plan.io/issues/6093
Found by: ShuxinLi

Bug on '-' castable to xs:duration

Status: fixed
Link: https://saxonica.plan.io/issues/6059
Found by: ShuxinLi