← Bugs over time
SQLancer is credited with 271 bugs reported in
2023, across 21 database
systems, between 2023-01-28 and
2023-12-30.
A further 5 reports were
filed that year and rejected by the developers as invalid or duplicate;
those are kept in the dataset and counted nowhere.
Which systems (21)
- StarRocks
-
59
- QuestDB
-
44
- DuckDB
-
39
- Dolt
-
18
- Umbra
-
18
- CockroachDB
-
12
- CrateDB
-
12
- StoneDB
-
12
- TiDB
-
12
- Apache Doris
-
8
- RisingWave
-
8
- TDengine
-
7
- SQLite
-
6
- Firebird
-
5
- YugabyteDB
-
3
- ClickHouse
-
2
- CnosDB
-
2
- Citus
-
1
- Apache Cloudberry
-
1
- CUBRID
-
1
- Databend
-
1
Each system's own page carries its whole history rather than this year's
share: StarRocks, QuestDB, DuckDB, Dolt, Umbra, CockroachDB, and 15 more.
How they break down
Who found them
- Found by the SQLancer project
-
189
- Found by someone outside the project
-
82
By status
- Fixed
-
237
- Confirmed
-
13
- Open
-
21
By symptom
- Unclassified
-
271
By technique
- Technique not recorded
-
248
- Ternary Logic Partitioning (TLP)
-
23
Why each bug counts
- The reproducer carries SQLancer's generated schema
-
164
- Filed by someone who runs SQLancer campaigns
-
75
- Listed in the project's own bug repository
-
18
- The report names SQLancer
-
12
- The report names a SQLancer oracle
-
2
Who reported them
- YuanchengJiang
-
57
- Suyang Zhong
-
50
- Chi Zhang
-
39
- andyziye
-
30
- satanson
-
27
- suyZhong
-
13
- zhenglin-charlie-li
-
12
- DerZc
-
7
Every bug reported in 2023 (276)
One row per report, newest first, each linking to the report itself. Rejected
reports are marked and are not part of any count above.
| Reported |
Report |
System |
Status |
Reporter |
| 2023-12-30 |
bug(pgwire): byte index 1024 is not a char boundary |
RisingWave
|
fixed |
suyZhong |
| 2023-12-30 |
INTERNAL Error: Failed to bind column reference "" [1.2] (bindings: [1.1]) |
DuckDB
|
fixed |
Suyang Zhong |
| 2023-12-29 |
Unexpected Results when Using ROUND() |
Dolt
|
fixed |
suyZhong |
| 2023-12-28 |
Panic when Using BETWEEN AND |
Dolt
|
fixed |
Suyang Zhong |
| 2023-12-28 |
Flaky result of the expression |
ClickHouse
|
open |
qoega |
| 2023-12-24 |
Unexpected Result when using IS NOT NULL |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-12-23 |
Unexpected results when Using UNION ALL for JOIN |
Umbra
|
fixed |
Suyang Zhong |
| 2023-12-23 |
Unexpected results when Mod negative number with View |
Umbra
|
fixed |
Suyang Zhong |
| 2023-12-19 |
Unexpected results when LEFT JOIN a view |
Umbra
|
fixed |
Suyang Zhong |
| 2023-12-17 |
Previous panic concerning CASE WHEN |
Dolt
|
fixed |
suyZhong |
| 2023-12-16 |
Unexpected results when Using BETWEEN Operator and Comparison |
Umbra
|
fixed |
Suyang Zhong |
| 2023-12-16 |
Unexpected result when using BETWEEN AND |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-12-16 |
Unexpected result when Concatenating NULL |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-12-15 |
Inconsistent Results executing multiple statements at once |
CrateDB
|
fixed |
suyZhong |
| 2023-12-14 |
Segmentation fault when Using Between Operator and integer |
Umbra
|
fixed |
Suyang Zhong |
| 2023-12-14 |
Unexpected Results of IN expression With NATURAL RIGHT JOIN |
TiDB
|
fixed |
Suyang Zhong |
| 2023-12-13 |
Unexpected Results when Using IN after Creating Index |
Dolt
|
fixed |
Suyang Zhong |
| 2023-12-13 |
Panic when Using BETWEEN and CASE WHEN |
Dolt
|
fixed |
Suyang Zhong |
| 2023-12-12 |
Unexpected Results When Using Between Operator and String Concatenation |
Umbra
|
fixed |
Suyang Zhong |
| 2023-12-12 |
Unexpected Results of In expressions |
Dolt
|
fixed |
Suyang Zhong |
| 2023-12-11 |
Unexpected results when comparing NULL value in WHERE clause |
QuestDB
|
open |
suyZhong |
| 2023-12-11 |
ORDER BY causes row to be omitted with index and case expression |
CUBRID
|
fixed |
Manuel Rigger |
| 2023-12-05 |
[YSQL] FATAL: the database system is in recovery mode client error may occur in process kill test |
YugabyteDB
|
open |
qvad |
| 2023-11-30 |
Unexpected Results when Querying with COT |
Dolt
|
fixed |
Suyang Zhong |
| 2023-11-30 |
Potential Issue Using ROUND |
Dolt
|
fixed |
suyZhong |
| 2023-11-29 |
Potential Issue when Dropping table |
Umbra
|
fixed |
Suyang Zhong |
| 2023-11-29 |
Potential Issue in NULLIF function |
Umbra
|
fixed |
Suyang Zhong |
| 2023-11-29 |
Potential Issue about boolean pruning in filter |
Umbra
|
fixed |
Suyang Zhong |
| 2023-11-29 |
Potential Issue about UNIQUE INDEX |
Umbra
|
fixed |
Suyang Zhong |
| 2023-11-29 |
Crash by SQRT |
Dolt
|
fixed |
suyZhong |
| 2023-11-29 |
Unexpected Results Using NULLIF |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-11-29 |
Unexpected Results Using Boolean |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-11-29 |
[Bug] abscissa type not supported, from sqlancer test |
Apache Cloudberry
|
fixed |
congxuebin |
| 2023-11-28 |
Potential Issue in BETWEEN operator |
Umbra
|
fixed |
Suyang Zhong |
| 2023-11-28 |
Incorrect results with nested joins |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-11-28 |
Missing Results when using Floating-point in BETWEEN |
DuckDB
|
fixed |
Suyang Zhong |
| 2023-11-28 |
Crash by Time Functions |
Dolt
|
fixed |
suyZhong |
| 2023-11-27 |
Unexpected Results when Comparing Boolean Values |
Umbra
|
fixed |
Suyang Zhong |
| 2023-11-27 |
Unexpected Results when Using Natural Right Join |
Firebird
|
fixed |
Suyang Zhong |
| 2023-11-26 |
Unexpected Results when using IS NOT NULL |
DuckDB
|
fixed |
Suyang Zhong |
| 2023-11-23 |
Crash by ACOS |
Dolt
|
fixed |
suyZhong |
| 2023-11-22 |
Unexpected Results when Comparing with Bigint |
RisingWave
|
fixed |
Suyang Zhong |
| 2023-11-22 |
Unexpected Results about Decimal-Boolean Casting in Filters |
Dolt
|
fixed |
Suyang Zhong |
| 2023-11-22 |
Crash by Function DAYNAME |
Dolt
|
fixed |
Suyang Zhong |
| 2023-11-22 |
Unexpected Results when Using Concat Operator |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-11-21 |
Unexpected Results when Using NATURAL LEFT JOIN |
RisingWave
|
fixed |
Suyang Zhong |
| 2023-11-20 |
Crash potentially caused by BETWEEN Operator |
Firebird
|
fixed |
Suyang Zhong |
| 2023-11-19 |
Unexpected Results when Querying with NULL values |
Dolt
|
fixed |
Suyang Zhong |
| 2023-11-19 |
Crashing by Division Operators |
Dolt
|
fixed |
Suyang Zhong |
| 2023-11-17 |
Unexpected Results when Inserting NULL to PK column |
RisingWave
|
fixed |
Suyang Zhong |
| 2023-11-17 |
Unexpected Results about Floating-point Type Casting |
Dolt
|
fixed |
Suyang Zhong |
| 2023-11-16 |
Unexpected Results when Using '%' operator |
Dolt
|
fixed |
Suyang Zhong |
| 2023-11-14 |
Unexpected Results when Using AND Operator |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-11-13 |
NullPointerException: Cannot read field "token" because "first" is null |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-11-10 |
Potential bug in BETWEEN operator |
Firebird
|
fixed |
mrigger |
| 2023-11-09 |
Unexpected results when having brackets with window query |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-11-09 |
Unexpected invalid column not completely fixed |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-11-09 |
Unexpected DatabaseError: queries have different number of columns in window function with union |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-11-09 |
NullPointerException: Cannot invoke "io.questdb.cairo.sql.SymbolTable.valueOf(int)" because "this... |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-11-09 |
Incorrect result with window function |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-11-09 |
Inaccurate result with sum float data |
QuestDB
|
open |
YuanchengJiang |
| 2023-10-27 |
[sqlancer] Unexpected exception: failed to init view stmt |
StarRocks
|
fixed |
packy92 |
| 2023-10-14 |
InternalError_: Panicked when processing: internal error: entered unreachable code: Subquery Subq... |
RisingWave
|
fixed |
YuanchengJiang |
| 2023-10-12 |
Panicked when processing: insert at index 4 exceeds fixbitset size 2 |
RisingWave
|
fixed |
YuanchengJiang |
| 2023-10-12 |
Panicked when processing: assertion failed: `(left == right)` |
RisingWave
|
fixed |
YuanchengJiang |
| 2023-10-12 |
Incorrect result with `ORDER BY` in `OVER(PARTITION BY ...)` |
RisingWave
|
fixed |
YuanchengJiang |
| 2023-10-10 |
ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 16 |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-10-09 |
Incorrect results with symbol comparison |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-10-08 |
Unexpected Exception with `ORDER BY` clause with `UNION` |
CrateDB
|
fixed |
YuanchengJiang |
| 2023-10-05 |
Incorrect result returned by `UNION` |
CrateDB
|
fixed |
YuanchengJiang |
| 2023-10-05 |
Couldn't create execution plan from logical plan because of: Index 2 out of bounds for length 2 |
CrateDB
|
fixed |
YuanchengJiang |
| 2023-09-29 |
Unexpected Error: overflow during Encode |
CockroachDB
|
fixed |
bajinsheng |
| 2023-09-29 |
Unexpected Error for timestamp overflow |
CockroachDB
|
fixed |
bajinsheng |
| 2023-09-29 |
Unexpected Error for ascii() |
CockroachDB
|
fixed |
bajinsheng |
| 2023-09-27 |
Permanent FK table should not be allowed to reference a temp table |
YugabyteDB
|
open |
qvad |
| 2023-09-12 |
Segmentation fault when Using Between Operator |
Umbra
|
fixed |
Suyang Zhong |
| 2023-09-12 |
Potential Issue when Using CONCAT with overflow integers |
Umbra
|
fixed |
Suyang Zhong |
| 2023-09-12 |
Segmentation fault when having `IS NULL` in `JOIN` condition |
TDengine
|
open |
YuanchengJiang |
| 2023-09-12 |
Invalid column error not completely fixed |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-09-12 |
Integer Overflow with Index Hints |
CockroachDB
|
fixed |
bajinsheng |
| 2023-09-11 |
Unexpected result when using CASE statement |
CrateDB
|
fixed |
Suyang Zhong |
| 2023-09-10 |
upgrades: auto-repair of catalog corruptions during upgrade may extend cluster finalization indef... |
CockroachDB
|
fixed |
srosenberg |
| 2023-09-10 |
sql: data race in NewDCollatedString |
CockroachDB
|
open |
srosenberg |
| 2023-08-23 |
Recursive SQL Query Leads to Infinite Loop |
DuckDB
|
fixed |
suyZhong |
| 2023-08-19 |
Invalid column error with LEFT OUTER JOIN |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-08-19 |
Incorrect results returned from `UNION` |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
StarRocks
|
fixed |
satanson |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
StarRocks
|
fixed |
satanson |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
StarRocks
|
fixed |
satanson |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
StarRocks
|
fixed |
satanson |
| 2023-08-09 |
Sqlancer report error: Cancelled |
StarRocks
|
fixed |
satanson |
| 2023-08-08 |
Sqlancer report error: Getting analyzing error from line 1, column 511 to line 1, column 554. Det... |
StarRocks
|
fixed |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
StarRocks
|
fixed |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
StarRocks
|
fixed |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
StarRocks
|
fixed |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
StarRocks
|
fixed |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
StarRocks
|
fixed |
satanson |
| 2023-08-07 |
UnsupportedOperationException in IntFunction.getStr(IntFunction.java:145) |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-08-07 |
StringIndexOutOfBoundsException: String index out of range: 0 with ORDER BY empty string |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-08-04 |
Invalid Column error with multiple JOIN |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-07-29 |
bug: can not build from source code when following the doc |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-27 |
Sqlancer report error: cannot find statistics of col: 13: c_0_2 |
StarRocks
|
fixed |
satanson |
| 2023-07-25 |
Unexpected Error Invalid Column with multiple JOIN |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-07-21 |
ClassCastException: GenericRecordMetadata cannot be cast to JoinRecordMetadata in generateJoins() |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-07-19 |
crash: StoneDB crash: PRIMARY KEY, HAVING, IS NULL |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-19 |
crash: StoneDB crash: HAVING, IS NULL |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-19 |
bug: query result wrong: SELECT |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-19 |
bug: query result wrong: NATURAL LEFT JOIN |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-19 |
bug: query result wrong: INSERT, DELETE, UNION ALL |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-19 |
bug: query result wrong: CASE WHEN THEN ELSE |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-19 |
bug: query result wrong: ALTER, DEFAULT |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-19 |
Incorrect result returned by `INTERSECT` |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-07-19 |
Inaccurate results with `EXCEPT`/`INTERSECT` |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-07-18 |
crash: StoneDB crash when executing the right shift operator |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-18 |
Unrobust comparison between string and char |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-07-18 |
Suspicious incorrect result when left join with an empty table |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-07-16 |
bug: expected supported SQL sytax not support (UNION ALL, LIKE) |
StoneDB
|
open |
zhenglin-charlie-li |
| 2023-07-14 |
crash: StoneDB crash when executing the command (SELECT, HAING, GROUP BY, IS NULL) |
StoneDB
|
fixed |
zhenglin-charlie-li |
| 2023-07-13 |
LOGICAL_ERROR: Arguments of 'lcm' have incorrect data types |
ClickHouse
|
fixed |
Algunenano |
| 2023-07-12 |
Unexpected Results when Using IN for Floating-Point |
Dolt
|
fixed |
Suyang Zhong |
| 2023-07-07 |
[BUG]In the deployment mode where storage and computing are separated, CI of some use cases canno... |
CnosDB
|
fixed |
Benxiaohai001 |
| 2023-07-03 |
bug: docker image stoneatom/stonedb:v1.0.4 is too large, is this expected? |
StoneDB
|
fixed |
zhenglin-charlie-li |
| 2023-06-30 |
Unexpected hang on subquery |
DuckDB
|
fixed |
Chi Zhang |
| 2023-06-29 |
java.lang.NullPointerException: Cannot read field "type" because "op" is null in rewriteAggregate... |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-16 |
Unexpected results on common table expressions |
DuckDB
|
fixed |
Chi Zhang |
| 2023-06-15 |
Unexpected results of `ANY` operator |
TiDB
|
verified |
Chi Zhang |
| 2023-06-15 |
Unexpected error when `CHECK` a predicate that is always true. |
TiDB
|
fixed |
Chi Zhang |
| 2023-06-14 |
[BUG]Inconsistent information returned by distributed and single nodes |
CnosDB
|
fixed |
Benxiaohai001 |
| 2023-06-12 |
Unexpected results after triggering an index scan |
Umbra
|
fixed |
Suyang Zhong |
| 2023-06-12 |
Unexpected results when the join condition contains the OR predicate |
Firebird
|
fixed |
Suyang Zhong |
| 2023-06-10 |
StringIndexOutOfBoundsException: String index out of range: 0 |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-10 |
NullPointerException: Cannot read field "type" because "column" is null |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-10 |
CairoException when casting string to timestamp |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-10 |
ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 0 at io.questdb.std.LongList.ex... |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-08 |
ImplicitCastException and stuck when comparing `STRING` with `NULL` |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-08 |
ClassCastException: NullConstant cannot be cast to class SymbolFunction |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-07 |
sql: unexpected internal error message from new schema changer during CREATE INDEX |
CockroachDB
|
fixed |
DerZc |
| 2023-06-05 |
Type DOUBLE variable in predicate produces unexpected results |
TDengine
|
fixed |
YuanchengJiang |
| 2023-06-05 |
NullPointerException Cannot invoke ".isUndefined()" because the return value of ".getQuick(int)" ... |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-06-05 |
Inconsistent result of `AVG` on big float number |
DuckDB
|
verified |
Chi Zhang |
| 2023-06-01 |
ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 16 |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-30 |
roachtest/tlp: 'expected unpartitioned and partitioned results to be equal' assertion |
CockroachDB
|
fixed |
irfansharif |
| 2023-05-29 |
Unexpected Syntax Error with `Null` |
TDengine
|
fixed |
YuanchengJiang |
| 2023-05-29 |
Unexpected StringIndexOutOfBoundsException with empty string |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-29 |
NullPointerException: Cannot read field "type" because "node" is null with constant expression |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-29 |
NullPointerException Cannot invoke ".getAst()" because "queryColumn" is null with `order by` clause |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-23 |
Unexpected UnsupportedOperationException with `join` query on non-boolean expression |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-23 |
Unexpected results related to `INDEX` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-05-22 |
Consuming input failed: server closed the connection unexpectedly |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-21 |
DuckDB hang on `DELETE` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-05-20 |
Inconsistent results of subquery in `INSERT` and `SELECT`, and an unexpected error |
DuckDB
|
fixed |
Chi Zhang |
| 2023-05-18 |
Unexpected generic error with `LIKE` query |
TDengine
|
fixed |
YuanchengJiang |
| 2023-05-17 |
Unexpected error message `Data truncated for column '%s' at row %d` |
TiDB
|
fixed |
DerZc |
| 2023-05-17 |
Unexpected TDengine Exception [0x2604] Column ambiguously defined |
TDengine
|
fixed |
YuanchengJiang |
| 2023-05-17 |
Unexpected Result with `null` in equality operator. |
TDengine
|
open |
YuanchengJiang |
| 2023-05-17 |
`Null` in equality operator |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-17 |
Unexpected NullPointerException with `null` query |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-17 |
Unexpected ClassCastException with `null` query |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-17 |
Segmentation fault on `SELECT` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-05-16 |
Segmentation fault with certain queries |
TDengine
|
fixed |
YuanchengJiang |
| 2023-05-16 |
DuckDB hang on `DELETE` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-05-13 |
Unexpected error `Invalid Error: Argument index "0" out of range` |
DuckDB
|
fixed |
DerZc |
| 2023-05-13 |
[Bug] Wrong result when `value like column from table_join` |
Apache Doris
|
fixed |
ChaseHuangxu |
| 2023-05-13 |
[Bug] Wrong result when `right outer join and where false` |
Apache Doris
|
fixed |
ChaseHuangxu |
| 2023-05-12 |
Segmentation fault when Using NATURAL LEFT JOIN |
Umbra
|
fixed |
Suyang Zhong |
| 2023-05-12 |
Potential issue when Using Boolean values and BETWEEN Operator |
Umbra
|
fixed |
Suyang Zhong |
| 2023-05-12 |
Potential issue handling Boolean values after INDEX |
Umbra
|
fixed |
Suyang Zhong |
| 2023-05-11 |
Unexpected Internal Error: UnsupportedOperationException |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-11 |
Unexpected Internal Error: NullPointerException |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-11 |
Unexpected Internal Error: Index -1 out of bounds for length 16 |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-11 |
DuckDB JDBC throws `Resource temporarily unavailable` |
DuckDB
|
closed not a bug |
SuriZhang |
| 2023-05-10 |
Unexpected error when using `count()` |
QuestDB
|
fixed |
YuanchengJiang |
| 2023-05-08 |
Unexpected results when `CASE` and `IN` use together |
TiDB
|
verified |
Chi Zhang |
| 2023-05-08 |
Unexpected results of `IN` with redundant values list |
DuckDB
|
verified |
Chi Zhang |
| 2023-05-08 |
[Bug] Internal Error occur in GroupBy&Having sql |
Apache Doris
|
fixed |
codenohup |
| 2023-05-08 |
[Bug] Different result of `having not ($value in column)` and `having ($value not in column)` |
Apache Doris
|
fixed |
codenohup |
| 2023-05-06 |
Unexpected error `Unknown column 't1.c0' in 'where clause'` |
TiDB
|
verified |
Chi Zhang |
| 2023-05-02 |
Unexpected error `unknown signature: bit_length(string) (desired )` |
DuckDB
|
verified |
Chi Zhang |
| 2023-05-01 |
Unexpected result of `JOIN` |
SQLite
|
fixed |
Chi Zhang |
| 2023-04-29 |
sql: inconsistent ASC/DESC ordering of BOX2D |
CockroachDB
|
fixed |
cockroach-teamcity |
| 2023-04-27 |
Unexpected results might be related to `BIT` and `INDEX` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-26 |
`INTERNAL Error: Logical column index 1 out of range` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-24 |
Unexpected results of subquery in `INSERT` |
TiDB
|
verified |
Chi Zhang |
| 2023-04-24 |
Sqlancer report error: Unexpected exception: fail to create tablet: timed out. unfinished replica... |
StarRocks
|
fixed |
satanson |
| 2023-04-24 |
Sqlancer report error: Unexpected exception: Failed to acquire globalStateMgr lock. Try again |
StarRocks
|
fixed |
satanson |
| 2023-04-24 |
Sqlancer report error: StarRocks process failed |
StarRocks
|
fixed |
satanson |
| 2023-04-24 |
Sqlancer report error: StarRocks planner use long time 3000 ms in logical phase, This probably be... |
StarRocks
|
fixed |
satanson |
| 2023-04-24 |
Sqlancer report error: Getting analyzing error. Detail message: Column 'c_1_0' is ambiguous. |
StarRocks
|
fixed |
satanson |
| 2023-04-24 |
Sqlancer report error: Getting analyzing error from line 1, column 591 to line 1, column 632. Det... |
StarRocks
|
fixed |
satanson |
| 2023-04-24 |
Sqlancer report error: Getting analyzing error from line 1, column 377 to line 1, column 393. Det... |
StarRocks
|
fixed |
satanson |
| 2023-04-24 |
Unexpected results of `CASE` and `BETWEEN` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-21 |
Sqlancer report error: Getting syntax error at line 1, column 193. Detail message: Input 'AS' is ... |
StarRocks
|
fixed |
satanson |
| 2023-04-21 |
Sqlancer report error: Getting syntax error at line 1, column 193. Detail message: Input 'AS' is ... |
StarRocks
|
fixed |
satanson |
| 2023-04-21 |
`internal error: expected subquery to be lazily planned as a routine` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-20 |
`runtime error: index out of range [1] with length 1` on `SELECT` |
TiDB
|
verified |
Chi Zhang |
| 2023-04-20 |
Sqlaner error "In Predicate only support literal expression list" |
StarRocks
|
fixed |
satanson |
| 2023-04-20 |
Sqlaner Error "NULL_TYPE is illegal in thrift stage" |
StarRocks
|
fixed |
satanson |
| 2023-04-20 |
Sqlancer error "Unsupported nest window function inside aggregation." |
StarRocks
|
fixed |
satanson |
| 2023-04-20 |
Sqlancer error "Unsupported nest window function inside aggregation" |
StarRocks
|
fixed |
satanson |
| 2023-04-20 |
Sqlancer error "Query exceeded time limit of 1800 seconds" |
StarRocks
|
fixed |
satanson |
| 2023-04-20 |
Sqlancer error "Cancelled" |
StarRocks
|
fixed |
satanson |
| 2023-04-20 |
sql: create unique index error: failed to construct index entries during backfill: overflow durin... |
CockroachDB
|
fixed |
rharding6373 |
| 2023-04-19 |
Unexpected results on specific values |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-19 |
Hang on `SELECT` query |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-15 |
Unexpected results when integer overflow |
DuckDB
|
unknown |
Chi Zhang |
| 2023-04-15 |
Unexpected results of `TIME` value under JDBC |
DuckDB
|
unknown |
Chi Zhang |
| 2023-04-15 |
`SQRDIFF` has different results when the order of arguments changed |
CockroachDB
|
open |
DerZc |
| 2023-04-13 |
An expression has two different value in two queries |
TiDB
|
verified |
Chi Zhang |
| 2023-04-13 |
internal error: failed to parse locale "": language: tag is not well-formed |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-13 |
DuckDB JDBC driver segfault at duplicate method call |
DuckDB
|
fixed |
SuriZhang |
| 2023-04-13 |
Different returned datatype of a `CASE` statement in different query. |
DuckDB
|
verified |
Chi Zhang |
| 2023-04-12 |
Unexpected result when take subquery as operand |
DuckDB
|
verified |
Chi Zhang |
| 2023-04-12 |
The `AVG` function modify the value of `REAL` in some query |
DuckDB
|
fixed |
DerZc |
| 2023-04-11 |
Unexpected result of subquery |
TiDB
|
fixed |
Chi Zhang |
| 2023-04-11 |
Unexpected error message on constant |
TiDB
|
verified |
Chi Zhang |
| 2023-04-11 |
Unexpected error in `ORDER BY` |
TiDB
|
verified |
Chi Zhang |
| 2023-04-10 |
[BUG] Execute sql query SELECT SUM(1025561311408145024) FROM m3; , db returns error. |
CnosDB
|
closed not a bug |
Benxiaohai001 |
| 2023-04-09 |
kvcoord: setting `kv.range_descriptor_cache.size=0` results in range iterator to retry endlessly |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-07 |
The phenomenon of inconsistent query results caused by null data values |
MariaDB
|
closed not a bug |
Chenglin Tian |
| 2023-04-05 |
internal error about index |
CockroachDB
|
fixed |
DerZc |
| 2023-04-04 |
internal error: null rejection requested on non-null column |
DuckDB
|
fixed |
Chi Zhang |
| 2023-04-04 |
Incorrect result by subquery and join |
DuckDB
|
fixed |
Chi Zhang |
| 2023-03-27 |
INSERT statement returns unexpected exception |
DuckDB
|
fixed |
SuriZhang |
| 2023-03-25 |
Segmentation fault on `BETWEEN` |
DuckDB
|
fixed |
Chi Zhang |
| 2023-03-25 |
Incorrect results might caused by `INDEX` |
DuckDB
|
fixed |
DerZc |
| 2023-03-23 |
An assertion failure only triggers in JDBC driver with -DSQLITE_DEBUG=1 compile option |
SQLite
|
fixed |
Chi Zhang |
| 2023-03-13 |
INTERNAL Error: Failed to bind column reference "" [18.2] (bindings: [18.1]) |
DuckDB
|
fixed |
fuzzerofducks |
| 2023-03-12 |
Unexpected Results when Using CASE-WHEN with LEFT JOIN |
Firebird
|
fixed |
Suyang Zhong |
| 2023-03-12 |
[Bug] Wrong result when SQL contain `where column not in (values)` |
Apache Doris
|
fixed |
ChaseHuangxu |
| 2023-03-12 |
[Bug] Two similar QUERYs return different results |
Apache Doris
|
fixed |
ChaseHuangxu |
| 2023-03-12 |
[Bug] Cannot use `between and` in boolean column and doris throws Unexpected exception |
Apache Doris
|
fixed |
ChaseHuangxu |
| 2023-03-11 |
[Bug] Logical bug about `where true not in (columns)` |
Apache Doris
|
fixed |
ChaseHuangxu |
| 2023-03-10 |
Segmentation Fault on Select query on table with column of array type. |
DuckDB
|
fixed |
nish-d |
| 2023-03-10 |
Inconsistencies Found When Comparing Null Values within Rows |
DuckDB
|
fixed |
suyZhong |
| 2023-03-10 |
Crash When Updating after Commit |
DuckDB
|
fixed |
suyZhong |
| 2023-03-09 |
Crash When Altering Schema |
DuckDB
|
fixed |
suyZhong |
| 2023-03-04 |
Incorrect result might caused by INDEX |
SQLite
|
fixed |
Chi Zhang |
| 2023-03-03 |
Incorrect result for COUNT on view with window function |
SQLite
|
fixed |
Chi Zhang |
| 2023-03-01 |
Incorrect result that might be caused by json function |
SQLite
|
fixed |
Chi Zhang |
| 2023-02-28 |
Incorrect results with the latest trunk version |
SQLite
|
fixed |
Chi Zhang |
| 2023-02-21 |
[StarOS] result mismatch from sqlancer querys |
StarRocks
|
fixed |
tiannan-sr |
| 2023-02-17 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-13 |
[YSQL][SQLancer] ANALYZE will fail if create index statement where failed before for the table |
YugabyteDB
|
open |
qvad |
| 2023-02-13 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-12 |
Internal Error: Calling StringValue::Get on a NULL value |
DuckDB
|
fixed |
Suyang Zhong |
| 2023-02-09 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-02-09 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-02-06 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-02-03 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-02-02 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-02 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-02 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-02 |
TestDuckDBJDBC::test_lots_of_decimals is broken |
DuckDB
|
fixed |
SuriZhang |
| 2023-02-01 |
[sqlancer] query of result set mismatch in asan mode |
StarRocks
|
fixed |
andyziye |
| 2023-02-01 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-01 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-01 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-02-01 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-01-31 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-01-31 |
bug: Connection error using mysql-connector-java:8.0.30 |
Databend
|
open |
hanyisong |
| 2023-01-30 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-01-30 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-01-30 |
[sqlancer] asan be crash |
StarRocks
|
fixed |
andyziye |
| 2023-01-29 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-01-29 |
[sqlancer] be crash in asan mode |
StarRocks
|
fixed |
andyziye |
| 2023-01-29 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-01-29 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-01-29 |
SQLancer "database is being accessed by other users" |
Citus
|
fixed |
mrigger |
| 2023-01-28 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-01-28 |
[sqlancer] query of result set mismatch |
StarRocks
|
fixed |
andyziye |
| 2023-01-28 |
[sqlancer] be crash |
StarRocks
|
fixed |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
StarRocks
|
fixed |
andyziye |
| 2023-01-28 |
[sqlancer] NullPointerException: no executable plan for this sql |
StarRocks
|
fixed |
andyziye |
Every figure on this page is computed from
_data/impact/.
The attribution policy
explains what has to be true for a bug to be counted.