Database Management Systems (55 bugs)

CockroachDB (16 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

DuckDB (2 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

SQLite (28 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

TiDB (9 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