Overview

Database Management Systems (801 bugs)

SQLite (217 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, https://www.sqlite.org/src/info/01868ebcd25fadb2
Found by: Suyang Zhong
COLLATE nocase index on a WITHOUT ROWID table malfunctions Status: fixed
Link: https://www.sqlite.org/src/tktview/3182d3879020ef3b2e6db56be2470a0266d3c773
Found by: mrigger
PRAGMA case_sensitive_like can corrupt some databases Status: fixed
Link: https://www.sqlite.org/src/info/a340eef47b0cad5
Found by: mrigger
Unique index that uses GLOB does not detect duplicate due to REAL conversion Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-April/084324.html
Found by: mrigger
Multi-row insert circumvents index check Status: fixed
Link: https://www.sqlite.org/src/info/3be1295b264be2fa
Found by: mrigger
COLLATE NOCASE index on REAL column malfunctions Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084334.html
Found by: mrigger
UPSERT documentation issue Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084347.html
Found by: mrigger
TYPEOF index on REAL column malfunctions Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084350.html
Found by: mrigger
Index on REAL column malfunctions when multiplying with a string Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084355.html
Found by: mrigger
Problem with REAL values and string functions used in indexes or on expressions Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084366.html
Found by: mrigger
GLOB and minus in index and real column Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084367.html
Found by: mrigger
Incorrect result on a table scan of a partial index Status: fixed
Link: https://www.sqlite.org/src/tktview?name=5c6955204c
Found by: mrigger
ALTER TABLE fails when renaming an INTEGER PRIMARY KEY column in a WITHOUT ROWID table Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084426.html
Found by: mrigger
INSERT OR FAIL inserts row although it violates a table constraint Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084439.html
Found by: mrigger
Incorrect result for "<" and "<=" comparison of rowid and non-numeric text value Status: fixed
Link: https://www.sqlite.org/src/tktview?name=9cf6c9bb51
Found by: mrigger
'./' LIKE './' does not match Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084478.html
Found by: mrigger
Row is not fetched with PRAGMA reverse_unordered_selects=true Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084480.html
Found by: mrigger
Malformed database image when using a REAL PRIMARY KEY Status: fixed
Link: https://www.sqlite.org/src/tktview/6c1d3febc00b22d457c7
Found by: mrigger
Incorrect handling of Infinity by the ROUND function Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084497.html
Found by: mrigger
Partial NOT NULL index malfunctions with IS NOT/!= Status: fixed
Link: https://sqlite.org/src/tktview/80256748471a01
Found by: mrigger
REINDEX causes rows not to be fetched in a WITHOUT ROWIDs table and PRIMARY KEY DESC Status: fixed
Link: https://www.sqlite.org/src/tktview?name=bba7b69f98
Found by: mrigger
PRAGMA reverse_unordered_selects=true results in row not being fetched Status: fixed
Link: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-May/084539.html
Found by: mrigger
REAL rounding seems to depend on FROM clause Status: fixed
Link: https://www.sqlite.org/src/tktview?name=3c27b97e31
Found by: mrigger
Malformed image when using no journal mode, zero cache size, and failing when creating an index Status: fixed
Link: https://www.sqlite.org/src/tktview?name=f4ec250930
Found by: mrigger
Query results in a SEGFAULT Status: fixed
Link: https://sqlite.org/src/info/787fa716be3a7f650c
Found by: mrigger
Index on non-existing column results in a fabricated value being fetched Status: fixed
Link: https://www.sqlite.org/src/tktview/9b78184be266fd7084e9e8038ad631a21b37eb9e
Found by: mrigger
Nested boolean formula with IN operator computes an incorrect result Status: fixed
Link: https://www.sqlite.org/src/tktview?name=d3e7f2ba5b
Found by: mrigger
"Malformed database schema" when creating a failing index within a transaction Status: fixed
Link: https://www.sqlite.org/src/tktview/b5ca442af9fadf5eff5b2bf64839516ab82cfc3d
Found by: mrigger
CAST('-' AS NUMERIC) computes 0.0 Status: fixed
Link: https://www.sqlite.org/src/tktview?name=4c2d7639f0
Found by: mrigger
Incorrect result when subtracting a large integer number from a TEXT value Status: fixed
Link: https://www.sqlite.org/src/tktview?name=e8bedb2a18
Found by: mrigger
CAST to NUMERIC no longer converts to INTEGER Status: fixed
Link: https://www.sqlite.org/src/tktview/dd6bffbfb6e61db9ecc9ea833d586427961ccc9d
Found by: mrigger
TEXT value interpreted as column name in an index with empty list in an IN expression Status: fixed
Link: https://www.sqlite.org/src/tktview/fd76310a5e843e074a30ed98b859dd0be11d0276
Found by: mrigger
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b1d8c79314
Found by: mrigger
Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" Status: fixed
Link: https://www.sqlite.org/src/tktview?name=533010b8ca
Found by: mrigger
CAST('.' AS NUMERIC) computes 0.0 rather than 0 Status: fixed
Link: https://www.sqlite.org/src/tktview?name=412bba9b22
Found by: mrigger
COLLATE expression has an affinity Status: fixed
Link: https://www.sqlite.org/src/tktview/d60b3cd7cb0bdff8ff39f76c9faf16ba2efa442f
Found by: mrigger
Another case of Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" Status: fixed
Link: https://www.sqlite.org/src/tktview/533010b8cacebe82533a8cd4e230fbb819565115
Found by: mrigger
-'1.0' computes -1.0 rather than -1 Status: fixed
Link: https://www.sqlite.org/src/tktview?name=1819598c09
Found by: mrigger
COLLATE expression in the right side of an IN operator results in an affinity conversion Status: fixed
Link: https://www.sqlite.org/src/tktview?name=57353f8243
Found by: mrigger
Lossless conversion when casting a large TEXT number to NUMERIC is not performed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=afdc5a29dc
Found by: mrigger
LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities Status: fixed
Link: https://www.sqlite.org/src/tktview?name=0c620df60b
Found by: mrigger
IS TRUE operator malfunctions with COLLATE and REAL value Status: fixed
Link: https://www.sqlite.org/src/tktview?name=4d01eda811
Found by: mrigger
CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 Status: fixed
Link: https://www.sqlite.org/src/tktview/674385aeba91c774d47736f1aefd259b074dc5d3
Found by: mrigger
CAST takes implicit COLLATE of its operand Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b148fa6105
Found by: mrigger
LIKE malfunctions for UNIQUE COLLATE NOCASE column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=ce8717f088
Found by: mrigger
Built-in RTRIM collating sequence yields incorrect comparisons Status: fixed
Link: https://www.sqlite.org/src/tktview?name=f1580ba1b5
Found by: mrigger
COLLATE in BETWEEN expression is ignored Status: fixed
Link: https://www.sqlite.org/src/tktview?name=e1e07ef202
Found by: mrigger
Query with ORDER BY results in "database disk image is malformed" error Status: fixed
Link: https://www.sqlite.org/src/tktview?name=ba2f4585cf
Found by: mrigger
ANALYZE causes DISTINCT to malfunction in CROSS JOIN Status: fixed
Link: https://www.sqlite.org/src/tktview?name=ccbe5759fb
Found by: mrigger
Query with DISTINCT does not fetch all distinct rows Status: fixed
Link: https://www.sqlite.org/src/tktview?name=ced41c7c7d
Found by: mrigger
MIN() malfunctions for UNIQUE column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=41866dc373
Found by: mrigger
MIN() malfunctions for a query with ISNULL condition Status: fixed
Link: https://www.sqlite.org/src/tktview?name=71e183cab6
Found by: mrigger
Unexpected affinity conversion in view Status: fixed
Link: https://www.sqlite.org/src/tktview?name=d52a29a9e6
Found by: mrigger
Row is not fetched in SELECT from VIEW Status: fixed
Link: https://www.sqlite.org/src/tktview?name=61c853857f
Found by: mrigger
Unexpected affinity conversion for view column in IN operator Status: fixed
Link: https://www.sqlite.org/src/tktview?name=0a5e2c1dcb
Found by: mrigger
Incorrect result for query that uses MIN() and a CAST on rowid Status: fixed
Link: https://www.sqlite.org/src/tktview?name=f8a7060ece
Found by: mrigger
Constant expression in partial index results in row not being fetched Status: fixed
Link: https://www.sqlite.org/src/tktview?name=9080b6227f
Found by: mrigger
Null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) Status: fixed
Link: https://www.sqlite.org/src/tktview?name=256741a16b
Found by: mrigger
LEFT JOIN fails to fetch row Status: fixed
Link: https://www.sqlite.org/src/tktview?name=6710d2f7a1
Found by: mrigger
WHERE clause erroneously influences value of fetched column from view Status: fixed
Link: https://www.sqlite.org/src/tktview?name=c7a1171907
Found by: mrigger
INDEXED BY results in row not being fetched Status: fixed
Link: https://www.sqlite.org/src/tktview?name=f043b1130b
Found by: mrigger
DISTINCT malfunctions for IS NULL Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b86894020e
Found by: mrigger
Row is not fetched in table with INTEGER PRIMARY KEY Status: fixed
Link: https://www.sqlite.org/src/tktview?name=d9f584e936
Found by: mrigger
Row with comparison on TEXT UNIQUE column is not fetched Status: fixed
Link: https://www.sqlite.org/src/tktview?name=ac184eb571
Found by: mrigger
LIKELY() seems to cause unexpected affinity conversion for rowid Status: fixed
Link: https://www.sqlite.org/src/tktview?name=7e07a3dbf5
Found by: mrigger
Unexpected affinity conversion is performed for the IN operator Status: fixed
Link: https://www.sqlite.org/src/tktview?name=dbaf8a6820
Found by: mrigger
Partial index causes row to not be fetched Status: fixed
Link: https://www.sqlite.org/src/tktview?name=a6408d42b9
Found by: mrigger
Partial index causes row to not be fetched in BETWEEN expression Status: fixed
Link: https://www.sqlite.org/src/tktview?name=fba33c8b1d
Found by: mrigger
Partial index and BETWEEN issue Status: fixed
Link: https://www.sqlite.org/src/tktview?name=f8f472cbc7
Found by: mrigger
REINDEX causes "UNIQUE constraint failed" error Status: fixed
Link: https://www.sqlite.org/src/tktview?name=5a3dba8104
Found by: mrigger
Expression computed on row yields incorrect result Status: fixed
Link: https://www.sqlite.org/src/tktview?name=57af00b664
Found by: mrigger
Different rounding when converting TEXT to REAL Status: fixed
Link: https://www.sqlite.org/src/tktview?name=2841e99d10
Found by: mrigger
IS NULL unexpectedly evaluates to TRUE Status: fixed
Link: https://www.sqlite.org/src/tktview?name=29f635e0af
Found by: mrigger
COLLATE NOCASE string comparison yields incorrect result Status: fixed
Link: https://www.sqlite.org/src/tktview?name=767a8cbc6d
Found by: mrigger
BETWEEN issue in view Status: fixed
Link: https://www.sqlite.org/src/tktview?name=a7debbe0ad
Found by: mrigger
COLLATE issue in view Status: fixed
Link: https://www.sqlite.org/src/tktview?name=18458b1ad6
Found by: mrigger
GLOB unexpectedly does not match Status: fixed
Link: https://www.sqlite.org/src/tktview?name=0f0428096f
Found by: mrigger
Row is not fetched when using WHERE clause with INSTR() Status: fixed
Link: https://www.sqlite.org/src/tktview?name=587791f926
Found by: mrigger
Comparison on view malfunctions Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b2d4edaffd
Found by: mrigger
FTS integrity-check malfunctions Status: fixed
Link: https://www.sqlite.org/src/tktview?name=8fe768e9c9
Found by: mrigger
FTS pgsz option results in "database disk image is malformed" error Status: fixed
Link: https://www.sqlite.org/src/tktview?name=265e935b26
Found by: mrigger
FTS rebuild in transaction causes integrity-check to fail Status: fixed
Link: https://www.sqlite.org/src/tktview?name=e258f008ce
Found by: mrigger
FTS integrity-check indicates that the database disk image is malformed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=81a7f7b9e2
Found by: mrigger
FTS rebuild in combination with crisismerge results in error "database or disk is full" Status: fixed
Link: https://www.sqlite.org/src/tktview?name=d392017c8e
Found by: mrigger
LEFT JOIN in view malfunctions Status: fixed
Link: https://www.sqlite.org/src/tktview?name=a976c487d1
Found by: mrigger
LEFT JOIN in view malfunctions with NOTNULL Status: fixed
Link: https://www.sqlite.org/src/tktview?name=c31034044b
Found by: mrigger
FTS order=DESC results into integrity-check failing Status: fixed
Link: https://www.sqlite.org/src/tktview?name=8a6fa2bb22
Found by: mrigger
FTS integrity-check malfunctions for transaction and the prefix option Status: fixed
Link: https://www.sqlite.org/src/tktview?name=745f1abcdc
Found by: mrigger
FTS integrity_check fails when inserting x'00' Status: fixed
Link: https://www.sqlite.org/src/tktview?name=278ac14262
Found by: mrigger
Trigger inserts duplicate value in UNIQUE column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=a8a4847a2d
Found by: mrigger
FTS merge does not terminate Status: fixed
Link: https://www.sqlite.org/src/tktview?name=bf1aab8978
Found by: mrigger
Comparison of row values results in incorrect result Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b47e3627ec
Found by: mrigger
Comparison of row values results in incorrect result (incomplete fix) Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b47e3627ec
Found by: mrigger
Row value comparison yields incorrect result Status: fixed
Link: https://www.sqlite.org/src/tktview?name=6ef984af89
Found by: mrigger
Comparison of row values with COLLATE NOCASE yields incorrect result Status: fixed
Link: https://www.sqlite.org/src/tktview?name=135c9da751
Found by: mrigger
Crash on REPLACE INTO of a table with an AFTER DELETE trigger Status: fixed
Link: https://www.sqlite.org/src/tktview?name=50c09fc2cf
Found by: mrigger
FTS integrity-check malfunctions nondeterministically with tokenize="ascii" Status: fixed
Link: https://www.sqlite.org/src/tktview?name=dd1f67bf25
Found by: mrigger
Trigger causes query to compute incorrect result Status: fixed
Link: https://www.sqlite.org/src/tktview?name=c1e19e1204
Found by: mrigger
REINDEX causes "UNIQUE constraint failed" error for generated column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=3ea1755124
Found by: mrigger
Segfault in table with generated columns Status: fixed
Link: https://www.sqlite.org/src/tktview?name=91e8695101
Found by: mrigger
Segfault when updating table with generated columns Status: fixed
Link: https://sqlite.org/src/tktview?name=9621dd78a0
Found by: mrigger
VACUUM issue on table with generated column Status: fixed
Link: https://sqlite.org/src/tktview?name=166347c6fc
Found by: mrigger
VACUUM on table with generated column results in an error Status: fixed
Link: https://sqlite.org/src/tktview?name=6484e6ce67
Found by: mrigger
VACUUM on table with generated column that uses TYPEOF results in an error Status: fixed
Link: https://sqlite.org/src/tktview?name=1d2a8efc6c
Found by: mrigger
Segfault in table with generated column and foreign key Status: fixed
Link: https://sqlite.org/src/tktview?name=b9befa4b83
Found by: mrigger
REPLACE causes segfault in table with generated column and foreign key Status: fixed
Link: https://sqlite.org/src/tktview?name=c28a01da72
Found by: mrigger
Incorrect result for GLOB operator Status: fixed
Link: https://sqlite.org/src/tktview?name=a9efb42811
Found by: mrigger
LEFT JOIN in view malfunctions with partial index on table Status: fixed
Link: https://sqlite.org/src/tktview?name=623eff57e7
Found by: mrigger
PRAGMA integrity_check fails due to CHECK constraint even without records Status: fixed
Link: https://sqlite.org/src/tktview?name=3c9eadd2a6
Found by: mrigger
Row value comparison malfunctions on view with left join Status: fixed
Link: https://sqlite.org/src/tktview?name=02aa2bd02f
Found by: mrigger
REPLACE on table with generated NOT NULL column results in segfault Status: fixed
Link: https://sqlite.org/src/tktview?name=2399f59861
Found by: mrigger
NULL WHERE condition unexpectedly results in row being fetched Status: fixed
Link: https://sqlite.org/src/tktview?name=ce22a07731
Found by: mrigger
Segfault when inserting into table with generated columns Status: fixed
Link: https://sqlite.org/src/tktview?name=4fc08501f4
Found by: mrigger
UPDATE on table with two generated columns and CHECK clause results in segfault Status: fixed
Link: https://www.sqlite.org/src/tktview?name=299b50ba81
Found by: mrigger
VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=302027baf1
Found by: mrigger
DISTINCT malfunctions for VIEW with virtual table Status: fixed
Link: https://www.sqlite.org/src/tktview?name=7e59041f9c
Found by: mrigger
LEFT JOIN malfunctions with partial ISNULL index Status: fixed
Link: https://www.sqlite.org/src/tktview?name=7f39060a24
Found by: mrigger
Incorrect result for TEXT comparison on rtree table Status: fixed
Link: https://www.sqlite.org/src/tktview?name=a55ab6d97d
Found by: mrigger
column = NULL predicate evaluates to TRUE for rtree table Status: fixed
Link: https://www.sqlite.org/src/tktview?name=30e2c183b6
Found by: mrigger
Join on two rtree tables malfunctions Status: fixed
Link: https://www.sqlite.org/src/tktview?name=9fe487ba3c
Found by: mrigger
Row value comparison malfunctions with rtree table Status: fixed
Link: https://www.sqlite.org/src/tktview?name=f096d191b6
Found by: mrigger
Comparison on INT column in rtree table malfunctions Status: fixed
Link: https://www.sqlite.org/src/tktview?name=aa573a787b
Found by: mrigger
Incorrect result for predicate on rtree table Status: fixed
Link: https://www.sqlite.org/src/tktview?name=367a86e288
Found by: mrigger
NOT NULL auxiliary column in rtree table malfunctions Status: fixed
Link: https://www.sqlite.org/src/tktview?name=8bf76328ac
Found by: mrigger
CREATE VIRTUAL TABLE causes segfault Status: fixed
Link:
Found by: mrigger
Generated column and foreign key causes a segfault Status: fixed
Link:
Found by: mrigger
Query on table without rows and generated column results in "out of memory" error Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b92e5e8ec2
Found by: mrigger
PRAGMA integrity_check does not terminate on table with generated column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=bd8c280671
Found by: mrigger
LEFT JOIN segfault on rtree table Status: fixed
Link:
Found by: mrigger
REINDEX results in "UNIQUE constraint failed" for generated column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=d7c3f125c9
Found by: mrigger
FTS database disk image is malformed for UTF-16 encoding after update Status: fixed
Link: https://www.sqlite.org/src/tktview?name=cf36cb4e02
Found by: mrigger
REINDEX segfaults on table with generated columns Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b439bfcfb7
Found by: mrigger
LEFT JOIN malfunctions with generated column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=3b84b42943
Found by: mrigger
UPDATE causes "database table is locked" for rtree table Status: fixed
Link: https://www.sqlite.org/src/tktview?name=56a74875be
Found by: mrigger
FILTER clause in window function causes a segfault Status: fixed
Link:
Found by: mrigger
Incorrect result for BETWEEN and generated column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=e0a8120553
Found by: mrigger
FTS database disk image is malformed for UTF-16 encoding Status: fixed
Link: https://sqlite.org/src/tktview?name=e431c35542
Found by: mrigger
FTS database disk image is malformed for update on languageid Status: fixed
Link: https://sqlite.org/src/tktview?name=cd3311e323
Found by: mrigger
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=5ad2aa6921
Found by: mrigger
Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=9cb7d0ef44
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=f00d096cae
Found by: mrigger
SELECT on window function causes a segfault Status: fixed
Link: https://sqlite.org/src/tktview?name=d9ed4ebef1
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=1b06916e01
Found by: mrigger
Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=b0cb8aff56
Found by: mrigger
Debug assertion constructAutomaticIndex: Assertion `!ExprHasProperty(pExpr, EP_FromJoin) || pExpr->iRightJoinTable!=pSrc->iCursor || pLoop->prereq!=0' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=7929c1efb2
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=188f912b51
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed (2) Status: fixed
Link: https://www.sqlite.org/src/tktview?name=9d708e4742
Found by: mrigger
Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=0911b5d161
Found by: mrigger
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed (2) Status: fixed
Link: https://www.sqlite.org/src/tktview?name=c62c5e5852
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=3ab4a9f02c
Found by: mrigger
Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=dfd66334cf
Found by: mrigger
Debug assertion rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=5eadca17c4
Found by: mrigger
FTS database disk image is malformed for special characters in table Status: fixed
Link: https://sqlite.org/src/tktview?name=d62981b76d
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2) Status: fixed
Link: https://www.sqlite.org/src/tktview?name=b383b90278
Found by: mrigger
UPDATE with complex WHERE condition on rtree results in "database table is locked" error Status: fixed
Link: https://www.sqlite.org/src/tktview?name=cafeafe605
Found by: mrigger
Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=df46a6f38e
Found by: mrigger
FTS database disk image is malformed for UTF-16 encoding and integrity check Status: fixed
Link: https://sqlite.org/src/tktview?name=752fdbf6e7
Found by: mrigger
Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=167b2aac34
Found by: mrigger
Debug assertion sqlite3TableColumnAffinity: Assertion `iColnCol' failed. Status: fixed
Link: https://www.sqlite.org/src/tktview?name=d87336c81c
Found by: mrigger
Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=ec8abb025e
Found by: mrigger
Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pParse->mayAbort)' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=7c13db5c3b
Found by: mrigger
Debug assertion assert_pager_state: Assertion `pPager->changeCountDone==0 || pPager->eLock>=RESERVED_LOCK' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=fb3b3024ea
Found by: mrigger
FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding Status: fixed
Link: https://www.sqlite.org/src/tktview?name=1dc432db3b
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMem[pOp->p1])' failed. Status: fixed
Link: https://www.sqlite.org/src/tktview?name=37823501c6
Found by: mrigger
Debug assertion exprSrcCount: Assertion `0' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=36ffedcb9a
Found by: mrigger
Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=5fbc159eeb
Found by: mrigger
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed Status: fixed
Link: https://sqlite.org/src/tktview?name=de4b04149b
Found by: mrigger
Trigger on normal table causes the database disk image to become malformed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=314cc133e5
Found by: mrigger
NATURAL JOIN on virtual table results in "parse error in rank function" Status: fixed
Link: https://www3.sqlite.org/src/tktview?name=7c0e06b162
Found by: mrigger
Debug assertion codeVectorCompare: Assertion `0' failed Status: fixed
Link: https://www.sqlite.org/src/tktview?name=892575cdba
Found by: mrigger
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed (2) Status: fixed
Link: https://www.sqlite.org/src/tktview?name=46fcd700b8
Found by: mrigger
FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR Status: fixed
Link: https://www.sqlite.org/src/tktview?name=771fe61761
Found by: mrigger
DBSTAT query computes incorrect result for aggregate column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=727074e2ae
Found by: mrigger
DBSTAT query computes incorrect result for name column Status: fixed
Link: https://www.sqlite.org/src/tktview?name=74a4c3860c
Found by: mrigger
Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition Status: fixed
Link: https://www.sqlite.org/src/tktview?name=82ac75ba00
Found by: mrigger
Incorrect result for COUNT(), UTF16be encoding and SUBSTR Status: fixed
Link: https://www.sqlite.org/src/tktview?name=9eda2697f5
Found by: mrigger
GROUP BY causes unexpected conversion Status: fixed
Link: https://www.sqlite.org/src/tktview?name=e0c2ad1aa8
Found by: mrigger
MAX yields unexpected result for UTF-16 Status: fixed
Link: https://www.sqlite.org/src/tktview?name=1b8d726456
Found by: mrigger
Unexpected result for MIN on string that contains a null character Status: fixed
Link: https://www.sqlite.org/src/tktview?name=fa146dcfe6
Found by: mrigger
UNION operator malfunctions in LEFT JOIN on view Status: fixed
Link: https://www.sqlite.org/src/tktview?name=45f4bf4eb4
Found by: mrigger
Incorrect result for IN expression with right-hand IS TRUE sub-expression Status: fixed
Link:
Found by: mrigger
Unexpected result for % and '1E1' Status: fixed
Link: https://www.sqlite.org/src/tktview?name=be31cf009c
Found by: mrigger

DuckDB (111 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: fixed
Link: https://github.com/duckdb/duckdb/issues/10087
Found by: Suyang Zhong
Unexpected Result When Using `IS DISTINCT FROM` and `CASE WHEN` in a JOIN clause Status: fixed
Link: https://github.com/duckdb/duckdb/issues/12181
Found by: Suyang Zhong
Unexpected result when using IN with DATE values Status: fixed
Link: https://github.com/duckdb/duckdb/issues/13380
Found by: Suyang Zhong
Unexpected result when casting negative integer to BIT Status: fixed
Link: https://github.com/duckdb/duckdb/issues/13506
Found by: Suyang Zhong
Unexpected result after creating index on varchar column Status: fixed
Link: https://github.com/duckdb/duckdb/issues/13785
Found by: Suyang Zhong
Unexpected result when using IN with TIME values Status: confirmed
Link: https://github.com/duckdb/duckdb/issues/13813
Found by: Suyang Zhong
INTERNAL ERROR: Unimplemented type for normalify Status: fixed
Link: https://github.com/duckdb/duckdb/issues/13933
Found by: Ming Wei Tan
A predicate NOT(NULL OR TRUE) unexpectedly evaluates to TRUE Status: fixed
Link: https://github.com/cwida/duckdb/issues/489
Found by: mrigger
A comparison column=column unexpectedly evaluates to TRUE for column=NULL Status: fixed
Link: https://github.com/cwida/duckdb/issues/490
Found by: mrigger
PRAGMA table_info provides no output Status: fixed
Link: https://github.com/cwida/duckdb/issues/491
Found by: mrigger
SIMILAR TO results in an "Unknown error -1" Status: fixed
Link: https://github.com/cwida/duckdb/issues/493
Found by: mrigger
Comparison on UNIQUE NUMERIC column causes a query to omit a row in the result set Status: fixed
Link: https://github.com/cwida/duckdb/issues/495
Found by: mrigger
INSERT causes an abort with "terminate called after throwing an instance of 'duckdb::InvalidTypeException'" Status: fixed
Link: https://github.com/cwida/duckdb/issues/496
Found by: mrigger
Comparison of two boolean columns in different tables results in an error "Not implemented: Unimplemented type for sort" Status: fixed
Link: https://github.com/cwida/duckdb/issues/497
Found by: mrigger
SELECT causes JDBC driver to crash Status: fixed
Link: https://github.com/cwida/duckdb/issues/500
Found by: mrigger
RIGHT JOIN with a predicate that compares two integer columns results in an "Unhandled type" error Status: fixed
Link: https://github.com/cwida/duckdb/issues/503
Found by: mrigger
INSERT results in an error "Not implemented: Cannot create data from this type" Status: fixed
Link: https://github.com/cwida/duckdb/issues/504
Found by: mrigger
A RIGHT JOIN unexpectedly fetches rows Status: fixed
Link: https://github.com/cwida/duckdb/issues/505
Found by: mrigger
Query results in an error "INTERNAL: Failed to bind column reference "c0" [5.0] (bindings: [6.0])" Status: fixed
Link: https://github.com/cwida/duckdb/issues/506
Found by: mrigger
Creating an empty table results in a crash Status: fixed
Link: https://github.com/cwida/duckdb/issues/507
Found by: mrigger
LEFT JOIN on column with NULL value results in a segmentation fault Status: fixed
Link: https://github.com/cwida/duckdb/issues/508
Found by: mrigger
SIMILAR TO results in an incorrect result Status: fixed
Link: https://github.com/cwida/duckdb/issues/510
Found by: mrigger
LEFT JOIN with comparison on integer columns results in "Not implemented: Unimplemented type for nested loop join!" Status: fixed
Link: https://github.com/cwida/duckdb/issues/513
Found by: mrigger
Incorrect result after an INSERT violates a UNIQUE constraint Status: fixed
Link: https://github.com/cwida/duckdb/issues/514
Found by: mrigger
Query with a negative shift predicate yields an incorrect result Status: fixed
Link: https://github.com/cwida/duckdb/issues/515
Found by: mrigger
Query with comparison on boolean column results in "Invalid type: Invalid Type [BOOL]: Invalid type for index" Status: fixed
Link: https://github.com/cwida/duckdb/issues/516
Found by: mrigger
Query with an AND predicate, NOT and comparison yields an incorrect result Status: fixed
Link: https://github.com/cwida/duckdb/issues/517
Found by: mrigger
Query using the LN() function does not terminate Status: fixed
Link: https://github.com/cwida/duckdb/issues/518
Found by: mrigger
ROUND() evaluates to -nan Status: fixed
Link: https://github.com/cwida/duckdb/issues/521
Found by: mrigger
Casting a large number to REAL and multiplying it with zero results in -nan Status: fixed
Link: https://github.com/cwida/duckdb/issues/522
Found by: mrigger
The trigonometric functions can result in -nan Status: fixed
Link: https://github.com/cwida/duckdb/issues/523
Found by: mrigger
Incorrect result for a JOIN predicate t1.c0 IN (t0.c0) and WHERE predicate t1.c0<=t0.c0 Status: fixed
Link: https://github.com/cwida/duckdb/issues/525
Found by: mrigger
Query that uses the CONCAT() function and OR expression crashes Status: fixed
Link: https://github.com/cwida/duckdb/issues/526
Found by: mrigger
Incorrect result for query that uses REGEXP_MATCHES() Status: fixed
Link: https://github.com/cwida/duckdb/issues/528
Found by: mrigger
SELECT on DATE column with a large negative value results in a "double free or corruption" Status: fixed
Link: https://github.com/cwida/duckdb/issues/531
Found by: mrigger
Overflow when casting from REAL to INT results in "Invalid TypeId -1" Status: fixed
Link: https://github.com/cwida/duckdb/issues/533
Found by: mrigger
UPDATE causes subsequent query to segfault Status: fixed
Link: https://github.com/cwida/duckdb/issues/534
Found by: mrigger
GROUP BY clause results in non-deterministic result Status: fixed
Link: https://github.com/cwida/duckdb/issues/535
Found by: mrigger
Nondeterministic clause when using an UNION query and HAVING clause Status: fixed
Link: https://github.com/cwida/duckdb/issues/536
Found by: mrigger
Fetching from table and view results in a crash Status: fixed
Link: https://github.com/cwida/duckdb/issues/537
Found by: mrigger
Incorrect result for predicate with shift on a BIGINT column Status: fixed
Link: https://github.com/cwida/duckdb/issues/538
Found by: mrigger
[JDBC] Special character causes the JVM to terminate with "basic_string::_M_construct null not valid" Status: fixed
Link: https://github.com/cwida/duckdb/issues/539
Found by: mrigger
Nested MAX() results in nondeterministic result or double free Status: fixed
Link: https://github.com/cwida/duckdb/issues/540
Found by: mrigger
Unexpected result for SUM() upon overflow Status: fixed
Link: https://github.com/cwida/duckdb/issues/543
Found by: mrigger
SELECT on view with text constant in ORDER BY crashes Status: fixed
Link: https://github.com/cwida/duckdb/issues/544
Found by: mrigger
Query with SIMILAR TO results in "Assertion `strlen(dataptr) == length' failed" Status: fixed
Link: https://github.com/cwida/duckdb/issues/547
Found by: mrigger
Nested CASE expression results in Assertion `other.auxiliary->type == VectorBufferType::STRING_BUFFER' failed Status: fixed
Link: https://github.com/cwida/duckdb/issues/549
Found by: mrigger
RIGHT JOIN results in Assertion `filter->expressions.size() == 1' failed Status: fixed
Link: https://github.com/cwida/duckdb/issues/552
Found by: mrigger
Incorrect result for SUM() and negative number Status: fixed
Link: https://github.com/cwida/duckdb/issues/560
Found by: mrigger
SELECT with CASE expression causes an assertion failure "Assertion `!entry.first->Equals(&expr)' failed" Status: fixed
Link: https://github.com/cwida/duckdb/issues/562
Found by: mrigger
REVERSE() on special character results in "Assertion `strcmp(dataptr, normalized) == 0' failed." Status: fixed
Link: https://github.com/cwida/duckdb/issues/567
Found by: mrigger
Incorrect result for BETWEEN query that casts column to boolean Status: fixed
Link: https://github.com/cwida/duckdb/issues/571
Found by: mrigger
Query using PREFIX() results in an error std::bad_alloc Status: fixed
Link: https://github.com/cwida/duckdb/issues/572
Found by: mrigger
Updated value in column is not visible in a SELECT Status: fixed
Link: https://github.com/cwida/duckdb/issues/579
Found by: mrigger
SUBSTRING with an invalid start position causes a segmentation fault Status: fixed
Link: https://github.com/cwida/duckdb/issues/580
Found by: mrigger
DISTINCT malfunctions for BOOLEAN Status: fixed
Link: https://github.com/cwida/duckdb/issues/581
Found by: mrigger
Comparing a string with a boolean yields an incorrect result after UPDATE Status: fixed
Link: https://github.com/cwida/duckdb/issues/583
Found by: mrigger
A select with BETWEEN and VARCHAR cast results in an incorrect result Status: fixed
Link: https://github.com/cwida/duckdb/issues/584
Found by: mrigger
Predicate checking for an empty string yields an incorrect result Status: fixed
Link: https://github.com/cwida/duckdb/issues/585
Found by: mrigger
NOACCENT.NOCASE comparison with a special character results in a segmentation fault Status: fixed
Link: https://github.com/cwida/duckdb/issues/586
Found by: mrigger
A negative DATE results in a "double free or corruption" crash Status: fixed
Link: https://github.com/cwida/duckdb/issues/587
Found by: mrigger
Query with complex ORDER BY causes an incorrect rowid value Status: fixed
Link: https://github.com/cwida/duckdb/issues/588
Found by: mrigger
Creating an index on rowid results in an internal error "Failed to bind column reference" Status: fixed
Link: https://github.com/cwida/duckdb/issues/589
Found by: mrigger
Comparison with a DATE yields an incorrect result Status: fixed
Link: https://github.com/cwida/duckdb/issues/590
Found by: mrigger
Expression with LIKE and comparison causes an assertion failure Status: fixed
Link: https://github.com/cwida/duckdb/issues/592
Found by: mrigger
STDDEV_POP unexpectedly does not fetch any rows Status: fixed
Link: https://github.com/cwida/duckdb/issues/596
Found by: mrigger
UPDATE results in crash or assertion failure Status: fixed
Link: https://github.com/cwida/duckdb/issues/599
Found by: mrigger
GROUP BY does not take COLLATE into account Status: fixed
Link: https://github.com/cwida/duckdb/issues/602
Found by: mrigger
BETWEEN with COLLATE NOACCENT.NOCASE expression results in a segfault/ASan failure Status: fixed
Link: https://github.com/cwida/duckdb/issues/603
Found by: mrigger
Incorrect result for MIN() on expression involving rowid Status: fixed
Link: https://github.com/cwida/duckdb/issues/609
Found by: mrigger
Large argument to RPAD results in std::bad_alloc Status: fixed
Link: https://github.com/cwida/duckdb/issues/610
Found by: mrigger
Failed ALTER COLUMN results in a "Transaction conflict" error that cannot be aborted Status: fixed
Link: https://github.com/cwida/duckdb/issues/618
Found by: mrigger
Query on altered table results in a segmentation fault Status: fixed
Link: https://github.com/cwida/duckdb/issues/619
Found by: mrigger
UPDATE on altered table results in an error "Could not find node in column segment tree" Status: fixed
Link: https://github.com/cwida/duckdb/issues/622
Found by: mrigger
ALTER TABLE results in an assertion failure "Assertion `expr.return_type == vector.type' failed" Status: fixed
Link: https://github.com/cwida/duckdb/issues/624
Found by: mrigger
DROP column results in an assertion failure unique.index < base.columns.size(). Status: fixed
Link: https://github.com/cwida/duckdb/issues/625
Found by: mrigger
DROP column results in an assertion failure unique.index < base.columns.size() 2 Status: fixed
Link: https://github.com/cwida/duckdb/issues/628
Found by: mrigger
ALTER TYPE with USING results in an assertion failure "types.size() > 0" Status: fixed
Link: https://github.com/cwida/duckdb/issues/629
Found by: mrigger
Query using LEFT() results in a segmentation fault Status: fixed
Link: https://github.com/cwida/duckdb/issues/633
Found by: mrigger
SELECT with RIGHT JOIN causes an assertion failure "Assertion `!finalized' failed" Status: fixed
Link: https://github.com/cwida/duckdb/issues/637
Found by: mrigger

CockroachDB (83 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
internal error: comparison overload not found (ge, unknown, unknown) Status: confirmed
Link: https://github.com/cockroachdb/cockroach/issues/128889
Found by: Suyang Zhong
Generated column causes query to omit a record in the result set Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44132
Found by: mrigger
Crash when using VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44133
Found by: mrigger
Internal error in expression that uses a CAST and COLLATE Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44137
Found by: mrigger
Unexpected error when using EXPERIMENTAL SCRUB Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44142
Found by: mrigger
DEFAULT value causes unexpected syntax error when executing INSERT Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44148
Found by: mrigger
TO_ENGLISH(-9223372036854775808) results in an internal error Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44152
Found by: mrigger
Incorrect result for BETWEEN SYMMETRIC query Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44154
Found by: mrigger
Internal error for BETWEEN operator and CAST to BYTES Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44181
Found by: mrigger
Query on VIEW with OFFSET NULL and WHERE condition involving CURRENT_USER() unexpectedly fetches a row Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44203
Found by: mrigger
Incorrect result for query with IS NULL condition on UNIQUE column and VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44207
Found by: mrigger
Internal error setting tracing=true Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44244
Found by: mrigger
Incorrect result for IS NULL query on VIEW using SELECT DISTINCT Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44296
Found by: mrigger
Internal error for CASE expression and VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44304
Found by: mrigger
Deadlock in SHOW TABLES Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44385
Found by: mrigger
Internal error "estimated distinct count must be non-zero" Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44418
Found by: mrigger
Multi-record UPSERT inserts duplicate values in PRIMARY KEY, resulting in inconsistent results Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44466
Found by: mrigger
Internal error for NATURAL JOIN and VECTORIZE='experimental_on' Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44547
Found by: mrigger
Server exits on query with LEFT JOIN Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44565
Found by: mrigger
Internal error for ILIKE_ESCAPE and special characters Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44621
Found by: mrigger
Complex ORDER BY clause results in internal error with VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44624
Found by: mrigger
Internal error for SUBSTRING with negative length and VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44625
Found by: mrigger
Internal error for arithmetic operators and NULLIF Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44632
Found by: mrigger
Internal error for query with negative LIMIT on view with negative LIMIT Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44683
Found by: mrigger
Internal error for case expression involving NULLIF and VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44726
Found by: mrigger
FULL JOIN with an SUBSTRING ON clause results in an internal error Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44746
Found by: mrigger
NOT BETWEEN query on VIEW results in an internal error with VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44822
Found by: mrigger
Internal error for SUBSTRING, INT4 cast, and VECTORIZE=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44881
Found by: mrigger
Internal error when setting VECTORIZE = experimental_on and DEFAULT_INT_SIZE = 4 Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44904
Found by: mrigger
EXPERIMENTAL SCRUB TABLE crashes server for table with TIMESTAMP column Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/44992
Found by: mrigger
Internal error for VECTORIZE=experimental_on, DEFAULT_INT_SIZE=4, and aggregate query Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/45038
Found by: mrigger
COUNT_ROWS() malfunctions for GROUP BY Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/45453
Found by: mrigger
EXPLAIN (VEC) SELECT results in an internal error "zero length schema unsupported" Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46122
Found by: mrigger
EXPLAIN (VEC) SELECT results in an internal error "input to aggregatorBase is not an execinfra.OpNode" Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46123
Found by: mrigger
Incorrect result for MAX, INTERLEAVE IN PARENT, and vectorize=experimental_on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46140
Found by: mrigger
Query with negative LIMIT results in an internal error "node lookup-join with MaxCost added to the memo" Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46187
Found by: mrigger
VALUES table expression malfunctions with MAX Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46196
Found by: mrigger
DROP DATABASE issue with TEMP tables Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46393
Found by: mrigger
UPSERT causes a decoding error in collated string column Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46394
Found by: mrigger
INSERT ... DO NOTHING results in an error "UPSERT or INSERT...ON CONFLICT command cannot affect row a second time" Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46395
Found by: mrigger
UPSERT on table with FOREIGN KEY constraint results in an internal error "cannot convert int to type bool" Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46397
Found by: mrigger
NATURAL JOIN fails with "duplicate column name" on view Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46403
Found by: mrigger
EXPLAIN (VEC) results in an internal error "input to aggregatorBase is not an execinfra.OpNode" Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46404
Found by: mrigger
HAVING clause incorrectly evaluates to TRUE for VARIANCE(0) IS NOT NULL predicate Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46412
Found by: mrigger
Query with HAVING clause, DISTSQL=off, and vectorize=on results in an internal error Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46503
Found by: mrigger
Internal error for vectorize=on and multiplication of INT4 values Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46714
Found by: mrigger
Internal error: lookup for ComparisonExpr ((@2)[float] != ('NaN')[string])[bool]'s CmpOp failed Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46914
Found by: mrigger
Unexpected syntax error for expression involving ARRAY[NULL] Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46915
Found by: mrigger
CREATE STATISTICS on table with ARRAY column Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46964
Found by: mrigger
Comparison with (-9223372036854775808)::TIMESTAMP results in an unexpected error Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46973
Found by: mrigger
Query with an invalid regular expression unexpectedly does not fail Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/46981
Found by: mrigger
Incorrect result for query on interleaved index when vectorize=on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/47029
Found by: mrigger
TRUNCATE on temporary table results in "unexpected value: " Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/47030
Found by: mrigger
Internal error for an invalid CREATE INDEX statement Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/47037
Found by: mrigger
SELECT statement on table with a hash-sharded index results in an internal error Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/47041
Found by: mrigger
ORDER BY unexpectedly causes a value to be represented in E notation when VECTORIZE=on Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/47115
Found by: mrigger
Column that is used both as an INT2 and INT4 results in an internal error Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/47131
Found by: mrigger
BETWEEN expression with an INTERVAL and DECIMAL cast results in an incorrect result Status: fixed
Link: https://github.com/cockroachdb/cockroach/issues/47327
Found by: mrigger

TiDB (74 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: fixed
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
Unexpected Result with NATURAL RIGHT JOIN and Bitwise NOT Status: confirmed
Link: https://github.com/pingcap/tidb/issues/53506
Found by: Suyang Zhong
Double negation causes incorrect result Status: fixed
Link: https://github.com/pingcap/tidb/issues/15725
Found by: mrigger
Incorrect result for an UNION query and a generated column Status: fixed
Link: https://github.com/pingcap/tidb/issues/15733
Found by: mrigger
ANALYZE TABLE causes SIGSEGV on latest trunk Status: fixed
Link: https://github.com/pingcap/tidb/issues/15746
Found by: mrigger
ANALYZE TABLE results in "analyze worker panic" with tidb_enable_fast_analyze=1 Status: fixed
Link: https://github.com/pingcap/tidb/issues/15751
Found by: mrigger
ANALYZE TABLE results in "invalid encoded key" with tidb_enable_fast_analyze=1 Status: fixed
Link: https://github.com/pingcap/tidb/issues/15752
Found by: mrigger
COLLATE causes an incorrect result in the presence of an index Status: fixed
Link: https://github.com/pingcap/tidb/issues/15789
Found by: mrigger
Unexpected "Data truncation: %s value is out of range in '%s'" error in UNION query Status: fixed
Link: https://github.com/pingcap/tidb/issues/15790
Found by: mrigger
GROUP BY clause nondeterministically results in an incorrect result or error Status: fixed
Link: https://github.com/pingcap/tidb/issues/15810
Found by: mrigger
A predicate column1 = -column2 incorrectly evaluates to false for 0 values Status: fixed
Link: https://github.com/pingcap/tidb/issues/15812
Found by: mrigger
Join on tables with redundant indexes causes a server panic Status: fixed
Link: https://github.com/pingcap/tidb/issues/15813
Found by: mrigger
Incorrect result for LEFT JOIN and NULL values Status: fixed
Link: https://github.com/pingcap/tidb/issues/15846
Found by: mrigger
Query with a NATURAL LEFT JOIN unexpectedly results in an error Status: fixed
Link: https://github.com/pingcap/tidb/issues/15850
Found by: mrigger
Query with RIGHT JOIN causes a server panic Status: fixed
Link: https://github.com/pingcap/tidb/issues/15858
Found by: mrigger
Incorrect result for a predicate that uses the CHAR() function Status: fixed
Link: https://github.com/pingcap/tidb/issues/15986
Found by: mrigger
LIKE operator malfunctions for COLLATE 'latin1_bin' Status: fixed
Link: https://github.com/pingcap/tidb/issues/15988
Found by: mrigger
Using a column both in a string comparison and as a boolean yields an incorrect result Status: fixed
Link: https://github.com/pingcap/tidb/issues/15990
Found by: mrigger
A USE_INDEX_MERGE hint causes a server panic Status: fixed
Link: https://github.com/pingcap/tidb/issues/15991
Found by: mrigger
USE_INDEX_MERGE on table with generated column causes a server crash Status: fixed
Link: https://github.com/pingcap/tidb/issues/15992
Found by: mrigger
fast ANALYZE TABLE on INDEX PRIMARY causes an error "analyze worker panic" Status: fixed
Link: https://github.com/pingcap/tidb/issues/15993
Found by: mrigger
USE_INDEX_MERGE results in an incorrect result for a generated column Status: fixed
Link: https://github.com/pingcap/tidb/issues/15994
Found by: mrigger
SELECT on table with generated column causes a server panic Status: fixed
Link: https://github.com/pingcap/tidb/issues/16020
Found by: mrigger
RIGHT JOIN with CONCAT_WS fails to fetch a row Status: fixed
Link: https://github.com/pingcap/tidb/issues/16023
Found by: mrigger
INSERT IGNORE causes an incorrect result for a query on a DECIMAL column Status: fixed
Link: https://github.com/pingcap/tidb/issues/16025
Found by: mrigger
REGEXP predicate unexpectedly results in an error "No valid regexp pattern found" Status: fixed
Link: https://github.com/pingcap/tidb/issues/16029
Found by: mrigger
NATURAL LEFT JOIN with a NOT predicate results in a server panic Status: fixed
Link: https://github.com/pingcap/tidb/issues/16419
Found by: mrigger
A predicate with COLLATE 'binary' results in a server panic "invalid memory address or nil pointer dereference" Status: fixed
Link: https://github.com/pingcap/tidb/issues/16779
Found by: mrigger

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
Unexpected results when Using UNION ALL for JOIN Status: fixed
Link: None
Found by: Suyang Zhong
Unexpected results when Mod negative number with 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 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

MonetDB (45 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
Crash when INNER JOIN with VIEW Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7456
Found by: Suyang Zhong
Unexpected result when using AND with INTEGER Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7457
Found by: Suyang Zhong
Unexpected result when using SIGN Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7458
Found by: Suyang Zhong
Crash when using CONTAINS in ORDER BY clause Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7459
Found by: Suyang Zhong
Crash when using CAST and BETWEEN AND Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7460
Found by: Suyang Zhong
Crash by potentially use of bad escape characters Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7461
Found by: Suyang Zhong
Unexpected result when using CONTAINS and type casting Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7463
Found by: Suyang Zhong
Crash when using BETWEEN AND Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7462
Found by: Suyang Zhong
Crash when INNER JOIN with CONTAINS Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7466
Found by: Suyang Zhong
Unexpected result when using NULL in BETWEEN Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7465
Found by: Suyang Zhong
Unexpected result when using IFNULL with large numbers Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7468
Found by: Suyang Zhong
Crash when using CONTAINS Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7469
Found by: Suyang Zhong
Unexpected result when using IS DISTINCT FROM Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7521
Found by: Suyang Zhong
Assertion failure when using CONTAINS Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7523
Found by: Suyang Zhong
Crash when creating view with HAVING Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7522
Found by: Suyang Zhong
Unexpected error when using NATURAL RIGHT JOIN Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7524
Found by: Suyang Zhong
Unexpected result when using IS DISTINCT FROM with RIGHT JOIN Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7527
Found by: Suyang Zhong
Assertion failure when using JAROWINKLER in ORDER BY clause Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7528
Found by: Suyang Zhong
Assertion failure when using JAROWINKLER with empty string Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7530
Found by: Suyang Zhong
Unexpected result when using IS DISTINCT FROM with AND Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7534
Found by: Suyang Zhong
Assertion failure when using GROUP BY when CREATE VIEW Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7535
Found by: Suyang Zhong
Crash when using IS DISTINCT FROM with SIN Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7539
Found by: Suyang Zhong
Assertion failure when using STARTSWITH Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7540
Found by: Suyang Zhong
Unexpected result when using LEVENSHTEIN Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7541
Found by: Suyang Zhong
Unexpected result when using IS DISTINCT FROM with constants Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7543
Found by: Suyang Zhong
Unexpected result when using STARTSWITH Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7544
Found by: Suyang Zhong
Crash when creating view with GROUP BY Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7545
Found by: Suyang Zhong
Assertion failure when using INNER JOIN on STARTSWITH Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7553
Found by: Suyang Zhong
Unexpected result when using NULL constant in comparison Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7552
Found by: Suyang Zhong
Unexpected result when using range comparison with NULL Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7554
Found by: Suyang Zhong
Unexpected result when casting integer to boolean in comparison Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7555
Found by: Suyang Zhong
Assertion failure when using STARTSWITH with view Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7556
Found by: Suyang Zhong
Assertion failure when comparing INTERVAL value Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7562
Found by: Suyang Zhong
Unexpected result when using IS DISTINCT FROM in VIEW Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7563
Found by: Suyang Zhong
Crash when integer overflow in ORDER BY Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7571
Found by: Suyang Zhong
Crash at strcpy_len () Status: fixed
Link: https://github.com/MonetDB/MonetDB/issues/7573
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

cratedb (35 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: fixed
Link: https://github.com/crate/crate/issues/15537
Found by: Suyang Zhong
Weird string substitution when using JDBC Status: fixed
Link: https://github.com/crate/crate/issues/15566
Found by: Suyang Zhong
Unexpected result when using OR Status: fixed
Link: https://github.com/crate/crate/issues/15592
Found by: Suyang Zhong
Unexpected result when using INNER JOIN and CASE in filter Status: fixed
Link: https://github.com/crate/crate/issues/15613
Found by: Suyang Zhong
Unexpected result when using LIKE Status: fixed
Link: https://github.com/crate/crate/issues/15743
Found by: Suyang Zhong
Unexpected results when using system information functions Status: fixed
Link: https://github.com/crate/crate/issues/16026
Found by: Suyang Zhong
Unexpected result when using CURRENT_SETTING Status: fixed
Link: https://github.com/crate/crate/issues/16062
Found by: Suyang Zhong
Unexpected result when using PG_GET_PARTKEYDEF Status: fixed
Link: https://github.com/crate/crate/issues/16172
Found by: Suyang Zhong
Unexpected result when using DEFAULT during creating table Status: fixed
Link: https://github.com/crate/crate/issues/16173
Found by: Suyang Zhong
Unexpected result when querying with boolean comparisons Status: fixed
Link: https://github.com/crate/crate/issues/16227
Found by: Suyang Zhong
Unexpected result when using FORMAT_TYPE Status: fixed
Link: https://github.com/crate/crate/issues/16225
Found by: Suyang Zhong
Unexpected result when using escape character in LIKE Status: fixed
Link: https://github.com/crate/crate/issues/16350
Found by: Suyang Zhong
Unexpected result when using empty OBJECT literal Status: fixed
Link: https://github.com/crate/crate/issues/16476
Found by: Suyang Zhong
Unexpected results when using OBJECT nulls Status: fixed
Link: https://github.com/crate/crate/issues/16556
Found by: Suyang Zhong
Unexpected results when matching empty string with indexing disabled Status: fixed
Link: https://github.com/crate/crate/issues/16567
Found by: Suyang Zhong
Unexpected result when querying partitioned table with null values Status: confirmed
Link: https://github.com/crate/crate/issues/16577
Found by: Suyang Zhong

Dolt (28 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
Crash by IF and CHAR Status: fixed
Link: https://github.com/dolthub/dolt/issues/7515
Found by: Suyang Zhong

MySQL (27 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
Inconsistent result with index and collapsing symbol Status: confirmed
Link: https://bugs.mysql.com/bug.php?id=114534
Found by: Ming Wei Tan
Functional index seems to malfunction with UNSIGNED column Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95889
Found by: mrigger
The negation of a "<=>" comparison malfunctions depending on the column's type Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95908
Found by: mrigger
Row is not fetched when using a function expression that should yield TRUE Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95926
Found by: mrigger
XOR operator returns incorrect result for strings with a floating-point number Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95927
Found by: mrigger
Duplicate entry for key 'PRIMARY' when querying information_schema.TABLES Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95929
Found by: mrigger
CHECK TABLE FOR UPGRADE crashes server (segfault) Status: fixed
Link:
Found by: mrigger
BENCHMARK() returns NULL in some cases but is documented to always return 0 Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95937
Found by: mrigger
Function return value with newline yields wrong result when used as a boolean Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95938
Found by: mrigger
TEXT column used as boolean incorrectly evaluates to false Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95942
Found by: mrigger
CAST of negative function return value to UNSIGNED malfunctions with BIGINT Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95954
Found by: mrigger
AND/OR/XOR compute wrong result for small floating-point numbers in TEXT columns Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95958
Found by: mrigger
The logical operators &, |, and ^ do not ignore newlines in TEXT Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95960
Found by: mrigger
Compare that uses UNSIGNED cast and function malfunctions in the MEMORY engine Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95964
Found by: mrigger
Setting sort_buffer_size to a large value causes query to go out of memory Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95969
Found by: mrigger
Unexpected result for IN operator and constants Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95975
Found by: mrigger
Query involving &, <, and AND operators computes incorrect result Status: fixed
Link: https://bugs.mysql.com/bug.php?id=95983
Found by: mrigger
Query with GREATEST function malfunctions Status: fixed
Link: https://bugs.mysql.com/bug.php?id=96012
Found by: mrigger
A predicate that compares 0 with -0 yields an incorrect result Status: fixed
Link: https://bugs.mysql.com/bug.php?id=99122
Found by: mrigger

H2 (18 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
Query with an expression "NOT NOT - C0" causes a NullPointerException Status: fixed
Link: https://github.com/h2database/h2database/issues/2804
Found by: mrigger
Incorrect result for query and NOT (c0 != -1 AND c0) predicate Status: fixed
Link: https://github.com/h2database/h2database/issues/2803
Found by: mrigger
Query with CASE operator unexpectedly results in "Column must be in the GROUP BY list" error Status: fixed
Link: https://github.com/h2database/h2database/issues/2813
Found by: mrigger
Query on view that uses the BETWEEN operator results in an unexpected syntax error Status: fixed
Link: https://github.com/h2database/h2database/issues/2816
Found by: mrigger
Query with % operator results in a ClassCastException Status: fixed
Link: https://github.com/h2database/h2database/issues/2825
Found by: mrigger
Table with a generated column cycle results in a NullPointerException Status: fixed
Link: https://github.com/h2database/h2database/issues/2826
Found by: mrigger
Query on view with BINARY column results in an unexpected syntax error Status: fixed
Link: https://github.com/h2database/h2database/issues/2828
Found by: mrigger
Restore YEAR data type for MySQL compatibility mode Status: fixed
Link: https://github.com/h2database/h2database/issues/2831
Found by: mrigger
Calling math functions with a string argument results in a NullPointerException Status: fixed
Link: https://github.com/h2database/h2database/issues/2835
Found by: mrigger
MERGE INTO causes an unexpected syntax error Status: fixed
Link: https://github.com/h2database/h2database/issues/2833
Found by: mrigger
ROUND() function runs very long Status: fixed
Link: https://github.com/h2database/h2database/issues/2837
Found by: mrigger
INSERT() with NULL arguments for the original string and string to be added results in NPE Status: fixed
Link: https://github.com/h2database/h2database/issues/2838
Found by: mrigger
Querying a view that uses the POSITION() function results in an unexpected syntax error Status: fixed
Link: https://github.com/h2database/h2database/issues/2839
Found by: mrigger
Call to STRINGDECODE results in StringIndexOutOfBoundsException Status: fixed
Link: https://github.com/h2database/h2database/issues/2841
Found by: mrigger
Querying view that uses LTRIM/RTRIM results in a syntax error Status: fixed
Link: https://github.com/h2database/h2database/issues/2842
Found by: mrigger
CREATE TABLE with a BINARY column and large size specification results in a NegativeArraySizeException Status: fixed
Link: https://github.com/h2database/h2database/issues/2832
Found by: mrigger

PostgreSQL (11 bugs)

GROUP BY and inheritance issue Status: fixed
Link: https://www.postgresql.org/message-id/CA%2Bu7OA7VLKf_vEr6kLF3MnWSA9LToJYncgpNX2tQ-oWzYCBQAw%40mail.gmail.com
Found by: mrigger
DISCARD TEMP results in "ERROR: cache lookup failed for type 0" Status: fixed
Link: https://www.postgresql.org/message-id/CA%2Bu7OA4JKCPFrdrAbOs7XBiCyD61XJxeNav4LefkSmBLQ-Vobg%40mail.gmail.com
Found by: mrigger
ERROR: found unexpected null value in index Status: fixed
Link: https://www.postgresql.org/message-id/CA%2Bu7OA7W4NWEhCvftdV6_8bbm2vgypi5nuxfnSEJQqVKFSUoMg%40mail.gmail.com
Found by: mrigger
ERROR: negative bitmapset member not allowed in SELECT Status: fixed
Link: https://www.postgresql.org/message-id/CA%2Bu7OA7fmtm3kR%2BY6Mgr9djU3WeOsMzQLWtNPMvoEVSm%3Dr9XaQ%40mail.gmail.com
Found by: mrigger
REINDEX CONCURRENTLY causes ALTER TABLE to fail Status: fixed
Link: https://www.postgresql.org/message-id/CA%2Bu7OA5Hp0ra235F3czPom_FyAd-3%2BXwSJmX95r1%2BsRPOJc9VQ%40mail.gmail.com
Found by: mrigger
INSERT INTO causes segfault on trunk Status: fixed
Link:
Found by: mrigger
Unexpected "cache lookup failed for collation 0" failure Status: fixed
Link: https://www.postgresql.org/message-id/flat/CA%2Bu7OA4HOjtymxAbuGNh4-X_2R0Lw5n01tzvP8E5-i-2gQXYWA%40mail.gmail.com
Found by: mrigger
Failed assertion clauses != NIL Status: fixed
Link: https://www.postgresql.org/message-id/flat/CA%2Bu7OA7H5rcE2%3D8f263w4NZD6ipO_XOrYB816nuLXbmSTH9pQQ%40mail.gmail.com
Found by: mrigger
No = operator for opfamily 426 Status: fixed
Link: https://www.postgresql.org/message-id/flat/CA%2Bu7OA7nnGYy8rY0vdTe811NuA%2BFrr9nbcBO9u2Z%2BJxqNaud%2Bg%40mail.gmail.com
Found by: mrigger
Fetching from information_schema.tables results in segfault Status: fixed
Link:
Found by: mrigger
Segfault when creating constant bit_length() index on TEMP table Status: fixed
Link:
Found by: mrigger

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

Firebird (10 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: fixed
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
Unexpected results when using LIKE with boolean values Status: confirmed
Link: https://github.com/FirebirdSQL/firebird/issues/8132
Found by: Suyang Zhong

Virtuoso (10 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
Unexpected results when using ORDER BY Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1241
Found by: Suyang Zhong
Crash by CASE WHEN Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1249
Found by: Suyang Zhong
Unexpected results when using LEFT JOIN and UNION Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1250
Found by: Suyang Zhong
Unexpected results when using INNER JOIN and UNION Status: fixed
Link: https://github.com/openlink/virtuoso-opensource/issues/1251
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

Doris (5 bugs)

SELECT DISTINCT returns duplicate column with aggregate key Status: fixed
Link: https://github.com/apache/doris/issues/36072
Found by: Ming Wei Tan
Wrong result with TINYINT column Status: open
Link: https://github.com/apache/doris/issues/36351
Found by: Ming Wei Tan
SELECT DISTINCT returns wrong value for UNIQUE model Status: open
Link: https://github.com/apache/doris/issues/36343
Found by: Ming Wei Tan
`WHERE / HAVING TIMESTAMP 'CURRENT TIMESTAMP' IS NULL` retrieves unwante rows Status: open
Link: https://github.com/apache/doris/issues/36342
Found by: Ming Wei Tan
NULL expression from function ot recorgnised with BETWEEN of floats Status: open
Link: https://github.com/apache/doris/issues/36070
Found by: Ming Wei Tan

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

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

Databend (3 bugs)

`FALSE AND exp1 OR exp1` in WHERE clause results in Lost connection from server Status: fixed
Link: https://github.com/databendlabs/databend/issues/15569
Found by: Ming Wei Tan
WHERE clause not working as expected with NOT Status: fixed
Link: https://github.com/databendlabs/databend/issues/15572
Found by: Ming Wei Tan
Mismatch between SUM and AVERAGE due to optimisation Status: fixed
Link: https://github.com/databendlabs/databend/issues/15867
Found by: Ming Wei Tan

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

MariaDB (2 bugs)

Internal error from OPTIMIZE TABLE t0 NOWAIT Status: confirmed
Link: https://jira.mariadb.org/browse/MDEV-33893
Found by: Ming Wei Tan
UNIQUE constraint causes a query with string comparison to omit a row in the result set Status: fixed
Link: https://jira.mariadb.org/browse/MDEV-21065
Found by: mrigger

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

QuestDB (2 bugs)

NULL record not retrieved if NULL is in WHERE clause Status: confirmed
Link: https://github.com/questdb/questdb/issues/4965
Found by: Ming Wei Tan
Internal error thrown in select query Status: fixed
Link: https://github.com/questdb/questdb/issues/4981
Found by: Ming Wei Tan

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

ClickHouse (1 bugs)

Unexpected result when comparing IN expression and integer Status: confirmed
Link: https://github.com/ClickHouse/ClickHouse/issues/65316
Found by: Suyang Zhong

Presto (1 bugs)

Query failed with error `failed: at index 1` Status: fixed
Link: https://github.com/prestodb/presto/issues/23613
Found by: Ming Wei Tan

TDEngine (1 bugs)

DROP DATABASE seems to leave behind a table when using the "tables" configuration option Status: fixed
Link: https://github.com/taosdata/TDengine/issues/586
Found by: mrigger

Compilers and Interpreters (60 bugs)

php-src (60 bugs)

Out of int range in Zend/zend_strtod.c Status: open
Link: https://github.com/php/php-src/issues/15712
Found by: YuanchengJiang
Segmentation fault in Zend/zend_execute_API.c Status: open
Link: https://github.com/php/php-src/issues/15672
Found by: YuanchengJiang
Polymorphic cache slot issue in DOM Status: confirmed
Link: https://github.com/php/php-src/issues/15670
Found by: YuanchengJiang
Access null pointer in Zend/Optimizer/zend_inference.c Status: confirmed
Link: https://github.com/php/php-src/issues/15661
Found by: YuanchengJiang
Segmentation fault in Zend/zend_vm_execute.h Status: confirmed
Link: https://github.com/php/php-src/issues/15658
Found by: YuanchengJiang
Segmentation fault in ext/opcache/jit/ir/dynasm/dasm_x86.h Status: open
Link: https://github.com/php/php-src/issues/15657
Found by: YuanchengJiang
Signed integer overflow in ext/dom/nodelist.c Status: confirmed
Link: https://github.com/php/php-src/issues/15654
Found by: YuanchengJiang
Signed integer overflow in ext/standard/file.c Status: confirmed
Link: https://github.com/php/php-src/issues/15653
Found by: YuanchengJiang
Segmentation fault in the Zend engine (JIT enabled) Status: confirmed
Link: https://github.com/php/php-src/issues/15652
Found by: YuanchengJiang
Signed integer overflow in ext/standard/pack.c Status: open
Link: https://github.com/php/php-src/issues/15613
Found by: YuanchengJiang
Segmentation fault (access null pointer) in ext/date/lib/parse_tz.c Status: open
Link: https://github.com/php/php-src/issues/15582
Found by: YuanchengJiang
Segmentation fault (access null pointer) in ext/dom/html5_serializer.c Status: confirmed
Link: https://github.com/php/php-src/issues/15570
Found by: YuanchengJiang
Signed integer overflow in ext/standard/scanf.c Status: confirmed
Link: https://github.com/php/php-src/issues/15552
Found by: YuanchengJiang
Segmentation fault (access null pointer) in ext/dom/xml_common.h Status: confirmed
Link: https://github.com/php/php-src/issues/15551
Found by: YuanchengJiang
Segmentation fault (access null pointer) in Zend/zend_stack.c Status: open
Link: https://github.com/php/php-src/issues/15496
Found by: YuanchengJiang
Member access within misaligned address in ext/opcache/jit/zend_jit.c Status: confirmed
Link: https://github.com/php/php-src/issues/15490
Found by: YuanchengJiang
Member access within misaligned address in ext/opcache/jit/zend_jit_vm_helpers.c Status: confirmed
Link: https://github.com/php/php-src/issues/15481
Found by: YuanchengJiang
Segmentation fault (null pointer) in Zend/zend_builtin_functions.c Status: confirmed
Link: https://github.com/php/php-src/issues/15456
Found by: YuanchengJiang
heap buffer overflow in phpdbg (zend_hash_num_elements() Zend/zend_hash.h) Status: confirmed
Link: https://github.com/php/php-src/issues/15268
Found by: YuanchengJiang
Heap use-after-free in phpdbg (zend_hash.c:57 in _zend_is_inconsistent) Status: confirmed
Link: https://github.com/php/php-src/issues/15210
Found by: YuanchengJiang
Segmentation fault in phpdbg (phpdbg_bp.c:132) Status: open
Link: https://github.com/php/php-src/issues/15208
Found by: YuanchengJiang
Segmentation fault in dom extension (html5_serializer) Status: confirmed
Link: https://github.com/php/php-src/issues/15192
Found by: YuanchengJiang
Segmentation fault (access illegal address) in zend allocator Status: confirmed
Link: https://github.com/php/php-src/issues/15187
Found by: YuanchengJiang
Disabled output handler is flushed again Status: confirmed
Link: https://github.com/php/php-src/issues/15181
Found by: YuanchengJiang
Segmentation fault (null pointer dereference) in ext/standard/url_scanner_ex.re Status: confirmed
Link: https://github.com/php/php-src/issues/15179
Found by: YuanchengJiang
stack overflow when var serialization in ext/standard/var Status: open
Link: https://github.com/php/php-src/issues/15169
Found by: YuanchengJiang
stack overflow in json_encode() Status: open
Link: https://github.com/php/php-src/issues/15168
Found by: YuanchengJiang
Unexpected null pointer in Zend/zend_smart_str.h Status: confirmed
Link: https://github.com/php/php-src/issues/15137
Found by: YuanchengJiang
Unexpected null pointer in Zend/zend_string.h Status: confirmed
Link: https://github.com/php/php-src/issues/14808
Found by: YuanchengJiang
Signed integer overflow in ext/standard/levenshtein.c Status: open
Link: https://github.com/php/php-src/issues/14807
Found by: YuanchengJiang
Signed integer overflow in ext/standard/array.c Status: confirmed
Link: https://github.com/php/php-src/issues/14775
Found by: YuanchengJiang
Segmentation fault in Zend/zend_types.h Status: confirmed
Link: https://github.com/php/php-src/issues/14741
Found by: YuanchengJiang
Segmentation fault (jump to 0x0) in Zend/zend_vm_execute.h Status: confirmed
Link: https://github.com/php/php-src/issues/14712
Found by: YuanchengJiang
Signed integer overflow in ext/date/php_date.c Status: open
Link: https://github.com/php/php-src/issues/14709
Found by: YuanchengJiang
Segmentation fault (access null pointer) in ext/libxml/libxml.c Status: confirmed
Link: https://github.com/php/php-src/issues/14698
Found by: YuanchengJiang
Segmentation fault (access null pointer) in ext/spl/spl_directory.c Status: open
Link: https://github.com/php/php-src/issues/14687
Found by: YuanchengJiang
Segmentation fault in ext/dom/php_dom.c Status: confirmed
Link: https://github.com/php/php-src/issues/14652
Found by: YuanchengJiang
Member access within null pointer in ext/standard/basic_functions.c Status: confirmed
Link: https://github.com/php/php-src/issues/14643
Found by: YuanchengJiang
Member access within null pointer in ext/spl/spl_observer.c Status: confirmed
Link: https://github.com/php/php-src/issues/14639
Found by: YuanchengJiang
Memory access within the null pointer with simplexml extension Status: confirmed
Link: https://github.com/php/php-src/issues/14638
Found by: YuanchengJiang
Memory leak in xml extension with zend allocator Status: confirmed
Link: https://github.com/php/php-src/issues/14637
Found by: YuanchengJiang
Unexpected null pointer at Zend/zend_string.h:200:24 Status: confirmed
Link: https://github.com/php/php-src/issues/14603
Found by: YuanchengJiang
Deep recursion in zend_cfg.c causes segfault instead of error Status: confirmed
Link: https://github.com/php/php-src/issues/14361
Found by: YuanchengJiang
Memory leak in xml and dom Status: confirmed
Link: https://github.com/php/php-src/issues/14343
Found by: YuanchengJiang
Member access within null pointer in extension spl Status: confirmed
Link: https://github.com/php/php-src/issues/14290
Found by: YuanchengJiang
Segmentation fault on unknown address 0x0001ffff8041 with XML extension under certain memory limit Status: confirmed
Link: https://github.com/php/php-src/issues/14124
Found by: YuanchengJiang
Segmentation fault on unknown address 0x600000000018 in ext/opcache/jit/zend_jit.c Status: open
Link: https://github.com/php/php-src/issues/14082
Found by: YuanchengJiang
Signed Integer Overflow in ext/date/lib/parse_posix.c Status: open
Link: https://github.com/php/php-src/issues/14075
Found by: YuanchengJiang
Memory leak in xml extension Status: open
Link: https://github.com/php/php-src/issues/14044
Found by: YuanchengJiang
Applying zero offset to null pointer in Zend/zend_opcode.c Status: confirmed
Link: https://github.com/php/php-src/issues/13931
Found by: YuanchengJiang
Stack buffer underflow when executing copy() Status: confirmed
Link: https://github.com/php/php-src/issues/13903
Found by: YuanchengJiang
Member access within null pointer of type 'ps_files' in ext/session/mod_files.c Status: confirmed
Link: https://github.com/php/php-src/issues/13856
Found by: YuanchengJiang
Renaming a file in a Phar to an already existing filename causes a NULL pointer dereference Status: confirmed
Link: https://github.com/php/php-src/issues/13836
Found by: YuanchengJiang
Applying non-zero offset 36 to null pointer in zend_jit.c Status: confirmed
Link: https://github.com/php/php-src/issues/13834
Found by: YuanchengJiang
Applying zero offset to null pointer in zend_hash.c Status: confirmed
Link: https://github.com/php/php-src/issues/13833
Found by: YuanchengJiang
Null pointer access of type 'zval' in phpdbg_frame Status: confirmed
Link: https://github.com/php/php-src/issues/13827
Found by: YuanchengJiang
Segfault caused by a derefernce of a high value address Status: confirmed
Link: https://github.com/php/php-src/issues/13695
Found by: YuanchengJiang
Unexpected null pointer in zend_string.h Status: confirmed
Link: https://github.com/php/php-src/issues/13685
Found by: YuanchengJiang
phpdbg_watch null pointer access Status: confirmed
Link: https://github.com/php/php-src/issues/13681
Found by: YuanchengJiang
Segfault from ASan: SEGV on unknown address 0x7ffd00000042 Status: confirmed
Link: https://github.com/php/php-src/issues/13680
Found by: YuanchengJiang

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