← All database systems
StarRocks has no testing implementation in the
main SQLancer repository.
SQLancer is credited with 183 bugs in it, reported between 2021-10-16 and
2025-06-18.
Its source is at StarRocks/starrocks.
How the project uses SQLancer
Developer use
StarRocks' own release notes credit SQLancer with finding bugs in the release, and point at the sqlancer label on their issue tracker. Decided by reading the file in this session rather than by an API call.
A few bugs are detected by Synthesized Query Lancer (SQLancer).
docs/en/release_notes/release-2.2.md in the StarRocks repository.docs/en/release_notes/release-2.2.md
last verified 2026-09-13
How the bugs break down
By year reported
- 2021
-
3
- 2022
-
119
- 2023
-
59
- 2025
-
2
Who found them
- Found by someone outside the project
-
183
By symptom
- Unclassified
-
183
By technique
- Technique not recorded
-
148
- Ternary Logic Partitioning (TLP)
-
28
- Non-optimizing Reference Engine Construction (NoREC)
-
7
Why each bug counts
- The reproducer carries SQLancer's generated schema
-
182
- The report names SQLancer
-
1
Who reported them (8)
- wanpengfei-git
-
55
- andyziye
-
36
- dulong41
-
29
- satanson
-
27
- yongbingwang
-
10
- colorfulu
-
8
- tiannan-sr
-
7
- wangruin
-
5
Every bug on record (183)
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 |
Status |
Technique |
Reporter |
| 2025-06-18 |
[BUG][SQLancer] late materialized crash |
fixed |
— |
Seaven |
| 2025-06-16 |
[BUG][SQLancer] array column append crash |
fixed |
— |
Seaven |
| 2023-10-27 |
[sqlancer] Unexpected exception: failed to init view stmt |
fixed |
TLP |
packy92 |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
fixed |
TLP |
satanson |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
fixed |
TLP |
satanson |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
fixed |
TLP |
satanson |
| 2023-08-09 |
Sqlancer report error: CardinalityOfResultSetsMismatchError |
fixed |
TLP |
satanson |
| 2023-08-09 |
Sqlancer report error: Cancelled |
fixed |
TLP |
satanson |
| 2023-08-08 |
Sqlancer report error: Getting analyzing error from line 1, column 511 to line 1, column 554. Detail messag... |
fixed |
TLP |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
fixed |
TLP |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
fixed |
TLP |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
fixed |
TLP |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
fixed |
TLP |
satanson |
| 2023-08-08 |
Sqlancer report error: BE Crashed |
fixed |
TLP |
satanson |
| 2023-07-27 |
Sqlancer report error: cannot find statistics of col: 13: c_0_2 |
fixed |
TLP |
satanson |
| 2023-04-24 |
Sqlancer report error: Unexpected exception: fail to create tablet: timed out. unfinished replicas(1/1): 84... |
fixed |
— |
satanson |
| 2023-04-24 |
Sqlancer report error: Unexpected exception: Failed to acquire globalStateMgr lock. Try again |
fixed |
— |
satanson |
| 2023-04-24 |
Sqlancer report error: StarRocks process failed |
fixed |
— |
satanson |
| 2023-04-24 |
Sqlancer report error: StarRocks planner use long time 3000 ms in logical phase, This probably because 1. F... |
fixed |
— |
satanson |
| 2023-04-24 |
Sqlancer report error: Getting analyzing error. Detail message: Column 'c_1_0' is ambiguous. |
fixed |
— |
satanson |
| 2023-04-24 |
Sqlancer report error: Getting analyzing error from line 1, column 591 to line 1, column 632. Detail messag... |
fixed |
— |
satanson |
| 2023-04-24 |
Sqlancer report error: Getting analyzing error from line 1, column 377 to line 1, column 393. Detail messag... |
fixed |
— |
satanson |
| 2023-04-21 |
Sqlancer report error: Getting syntax error at line 1, column 193. Detail message: Input 'AS' is not valid ... |
fixed |
TLP |
satanson |
| 2023-04-21 |
Sqlancer report error: Getting syntax error at line 1, column 193. Detail message: Input 'AS' is not valid ... |
fixed |
TLP |
satanson |
| 2023-04-20 |
Sqlaner error "In Predicate only support literal expression list" |
fixed |
TLP |
satanson |
| 2023-04-20 |
Sqlaner Error "NULL_TYPE is illegal in thrift stage" |
fixed |
TLP |
satanson |
| 2023-04-20 |
Sqlancer error "Unsupported nest window function inside aggregation." |
fixed |
TLP |
satanson |
| 2023-04-20 |
Sqlancer error "Unsupported nest window function inside aggregation" |
fixed |
TLP |
satanson |
| 2023-04-20 |
Sqlancer error "Query exceeded time limit of 1800 seconds" |
fixed |
TLP |
satanson |
| 2023-04-20 |
Sqlancer error "Cancelled" |
fixed |
TLP |
satanson |
| 2023-02-21 |
[StarOS] result mismatch from sqlancer querys |
fixed |
— |
tiannan-sr |
| 2023-02-17 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-13 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-09 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-02-09 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-02-06 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-02-03 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-02-02 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-02 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-02 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-01 |
[sqlancer] query of result set mismatch in asan mode |
fixed |
— |
andyziye |
| 2023-02-01 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-01 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-01 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-02-01 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-01-31 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-01-30 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-01-30 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-01-30 |
[sqlancer] asan be crash |
fixed |
— |
andyziye |
| 2023-01-29 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-01-29 |
[sqlancer] be crash in asan mode |
fixed |
— |
andyziye |
| 2023-01-29 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-01-29 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] query of result set mismatch |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] be crash |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] Unknown error |
fixed |
— |
andyziye |
| 2023-01-28 |
[sqlancer] NullPointerException: no executable plan for this sql |
fixed |
— |
andyziye |
| 2022-12-28 |
[sqlancer] query sql error |
fixed |
— |
wanpengfei-git |
| 2022-12-28 |
[sqlancer] distinct query crash |
fixed |
— |
wanpengfei-git |
| 2022-12-28 |
[sqlancer] be has overloaded with pipeline drivers |
fixed |
— |
wanpengfei-git |
| 2022-12-22 |
[sqlancer] unknown error |
fixed |
— |
wanpengfei-git |
| 2022-12-22 |
[sqlancer] memory leak after be graceful exit |
fixed |
— |
wanpengfei-git |
| 2022-12-20 |
[sqlancer] unknow error |
fixed |
— |
wanpengfei-git |
| 2022-12-20 |
[sqlancer] be memleak |
fixed |
— |
wanpengfei-git |
| 2022-12-15 |
[sqlancer] unknow error |
fixed |
— |
wanpengfei-git |
| 2022-12-15 |
[sqlancer] query result error |
fixed |
— |
wanpengfei-git |
| 2022-12-15 |
[sqlancer] query error |
fixed |
— |
wanpengfei-git |
| 2022-12-15 |
[sqlancer] execute sql error |
fixed |
— |
wanpengfei-git |
| 2022-12-15 |
[sqlancer] be crash in asan mode |
fixed |
— |
wanpengfei-git |
| 2022-12-14 |
[sqlancer] start be crash |
fixed |
— |
andyziye |
| 2022-12-14 |
[sqlancer] heap-use-after-free |
fixed |
— |
andyziye |
| 2022-12-14 |
[sqlancer] be core |
fixed |
— |
andyziye |
| 2022-12-14 |
[sqlancer] Unknown error of "java.lang.IllegalStateException: null" |
fixed |
— |
andyziye |
| 2022-12-14 |
[sqlancer] NullPointerException: no executable plan for this sql |
fixed |
— |
andyziye |
| 2022-12-13 |
[sqlancer] delete table with mv error, Column is not key column in index |
fixed |
— |
andyziye |
| 2022-12-07 |
[sqlancer] crash when compacting data |
fixed |
— |
dulong41 |
| 2022-12-06 |
[sqlancer] coredump when compacting |
fixed |
— |
dulong41 |
| 2022-12-05 |
[sqlancer] unknown error of npe when creating materialized view |
fixed |
— |
dulong41 |
| 2022-12-05 |
[sqlancer] crash when start be |
fixed |
— |
dulong41 |
| 2022-11-30 |
[sqlancer] crash in NestloopJoin |
fixed |
— |
dulong41 |
| 2022-11-29 |
[sqlancer] crash of _M_range_insert |
fixed |
— |
dulong41 |
| 2022-11-25 |
[sqlancer] result set mismatch |
fixed |
— |
dulong41 |
| 2022-11-23 |
[sqlancer] result set mismatch |
fixed |
— |
dulong41 |
| 2022-11-23 |
[sqlancer] crash |
fixed |
— |
dulong41 |
| 2022-11-22 |
[sqlancer] NPE of physical plan translator |
fixed |
— |
dulong41 |
| 2022-11-21 |
[sqlancer] unknown error of NPE |
fixed |
— |
dulong41 |
| 2022-11-18 |
[sqlancer] be crash |
fixed |
— |
dulong41 |
| 2022-11-18 |
[sqlancer] asan crash |
fixed |
— |
dulong41 |
| 2022-11-17 |
[sqlancer] result set correctness |
fixed |
— |
dulong41 |
| 2022-11-14 |
[sqlancer] the size of the result sets mismatch |
fixed |
— |
dulong41 |
| 2022-11-11 |
[sqlancer] be crash |
fixed |
— |
dulong41 |
| 2022-11-11 |
[sqlancer] NullPointerException - no executable plan for this sql |
fixed |
— |
dulong41 |
| 2022-11-11 |
[sqlancer] Expected LE 1 to be returned by expression |
fixed |
— |
dulong41 |
| 2022-11-10 |
[sqlancer] crash when executing query |
fixed |
— |
dulong41 |
| 2022-11-08 |
[sqlancer] query of result set mismatch |
fixed |
— |
dulong41 |
| 2022-11-04 |
[sqlancer] query of left anti join, the size of the result sets mismatch |
fixed |
— |
dulong41 |
| 2022-11-04 |
[sqlancer] no executable plan for this sql |
fixed |
— |
dulong41 |
| 2022-11-04 |
[sqlancer] Unknown error for NullPointerException |
fixed |
— |
dulong41 |
| 2022-11-03 |
[sqlancer] query unkown error |
fixed |
— |
dulong41 |
| 2022-10-10 |
[sqlancer] Invalid regex expression |
fixed |
— |
dulong41 |
| 2022-10-09 |
[sqlancer] unkown error for query |
fixed |
— |
dulong41 |
| 2022-10-09 |
[sqlancer] result sets mismatch |
fixed |
— |
dulong41 |
| 2022-09-30 |
[sqlancer] query unknown error |
fixed |
— |
wanpengfei-git |
| 2022-09-30 |
[sqlancer] query crash in asan mode |
fixed |
— |
wanpengfei-git |
| 2022-09-30 |
[sqlancer] query crash |
fixed |
— |
wanpengfei-git |
| 2022-09-03 |
BE crash in sqlancer test env |
fixed |
— |
tiannan-sr |
| 2022-08-29 |
sqlancer query crash |
fixed |
— |
wanpengfei-git |
| 2022-08-29 |
[sqlancer] query return no plan sql |
fixed |
— |
wanpengfei-git |
| 2022-08-29 |
[sqlancer] query error |
fixed |
— |
wanpengfei-git |
| 2022-08-19 |
[sqlancer] unknow error |
fixed |
— |
wanpengfei-git |
| 2022-08-19 |
[sqlancer] query crash after set enable_filter_unused_columns_in_scan_stage = true |
fixed |
— |
wanpengfei-git |
| 2022-08-12 |
[sqlancer] query unknow error |
fixed |
— |
wanpengfei-git |
| 2022-08-12 |
[sqlancer] query unknow error |
fixed |
— |
wanpengfei-git |
| 2022-08-12 |
[sqlancer] query error which contains UNKNOWN_TYPE |
fixed |
— |
wanpengfei-git |
| 2022-08-12 |
[sqlancer] query crash |
fixed |
— |
wanpengfei-git |
| 2022-08-12 |
[sqlancer] execute sql error |
fixed |
— |
wanpengfei-git |
| 2022-08-12 |
[sqlancer] be crash |
fixed |
— |
wanpengfei-git |
| 2022-08-08 |
[sqlancer] client exit caused by query |
fixed |
— |
wanpengfei-git |
| 2022-08-08 |
[sqlancer] be crash |
fixed |
— |
wanpengfei-git |
| 2022-08-06 |
unknown error from sqlancer |
fixed |
— |
tiannan-sr |
| 2022-08-05 |
[sqlancer] query return unknow error |
fixed |
— |
wanpengfei-git |
| 2022-08-05 |
[sqlancer] query cast error |
fixed |
— |
wanpengfei-git |
| 2022-08-01 |
[sqlancer] query sql crash |
fixed |
— |
wanpengfei-git |
| 2022-08-01 |
[sqlancer] query sql crash |
fixed |
— |
wanpengfei-git |
| 2022-07-29 |
[sqlancer] query unknow error |
fixed |
— |
wanpengfei-git |
| 2022-07-29 |
[sqlancer] query unknow error |
fixed |
— |
wanpengfei-git |
| 2022-07-29 |
[sqlancer] query unknow error |
fixed |
— |
wanpengfei-git |
| 2022-07-12 |
[sqlancer] create view error |
fixed |
— |
wanpengfei-git |
| 2022-07-12 |
[sqlancer] be crash |
fixed |
— |
wanpengfei-git |
| 2022-06-17 |
[sqlancer] empty json path |
fixed |
TLP |
dulong41 |
| 2022-06-09 |
sqlancer query result error |
fixed |
— |
colorfulu |
| 2022-06-09 |
sqlancer query result error |
fixed |
— |
colorfulu |
| 2022-06-09 |
sqlancer query result error |
fixed |
— |
colorfulu |
| 2022-06-09 |
sqlancer query result error |
fixed |
— |
colorfulu |
| 2022-06-08 |
sqlancer query result error |
fixed |
— |
colorfulu |
| 2022-06-08 |
sqlancer query result error |
fixed |
— |
colorfulu |
| 2022-06-08 |
result error from sqlancer query |
fixed |
— |
colorfulu |
| 2022-06-08 |
result error from sqlancer query |
fixed |
— |
colorfulu |
| 2022-06-02 |
error message - Function 'last_value(`t1_86`.`c_1_2`)' not supported with OVER clause |
fixed |
TLP |
dulong41 |
| 2022-06-01 |
BE crash when sqlancer querys |
fixed |
TLP |
tiannan-sr |
| 2022-05-30 |
result error from sqlancer querys |
fixed |
— |
tiannan-sr |
| 2022-05-30 |
result error from sqlancer querys |
fixed |
— |
tiannan-sr |
| 2022-05-30 |
result error from sqlancer query |
fixed |
— |
tiannan-sr |
| 2022-05-28 |
[sqlancer] query crash in asan mode |
fixed |
— |
wanpengfei-git |
| 2022-05-27 |
[sqlancer] query crash |
fixed |
— |
wanpengfei-git |
| 2022-05-27 |
[sqlancer] improve the error message when using json type in sql having clause |
fixed |
— |
wanpengfei-git |
| 2022-05-27 |
[sqlancer] create view failed |
fixed |
— |
wanpengfei-git |
| 2022-05-26 |
[sqlancer] query result error in norec mode |
fixed |
NOREC |
wanpengfei-git |
| 2022-05-26 |
[sqlancer] query result error |
fixed |
— |
wanpengfei-git |
| 2022-05-26 |
[sqlancer] Cross join RF BE crash |
fixed |
— |
wanpengfei-git |
| 2022-05-25 |
[sqlancer] query result error |
fixed |
— |
wanpengfei-git |
| 2022-05-25 |
[sqlancer] JoinReorderGreedy unknow error |
fixed |
— |
wanpengfei-git |
| 2022-05-24 |
[sqlancer] unknow error |
fixed |
— |
wanpengfei-git |
| 2022-05-24 |
[sqlancer] unknow error |
fixed |
— |
wanpengfei-git |
| 2022-05-24 |
[sqlancer] query result error with having tlp |
fixed |
TLP |
wanpengfei-git |
| 2022-05-24 |
[sqlancer] query result error |
fixed |
— |
wanpengfei-git |
| 2022-05-24 |
[sqlancer] query result error |
fixed |
— |
wanpengfei-git |
| 2022-05-24 |
[sqlancer] delete out of partitions data error |
fixed |
— |
wanpengfei-git |
| 2022-05-23 |
[sqlancer] query sql crash |
fixed |
— |
wanpengfei-git |
| 2022-05-19 |
[sqlancer] BE crash at implicit join on unsupported type |
fixed |
— |
wangruin |
| 2022-05-19 |
[sqlancer] BE crash |
fixed |
— |
wangruin |
| 2022-05-19 |
[sqlancer] BE crash |
fixed |
— |
wangruin |
| 2022-05-18 |
[sqlancer] wrong result |
fixed |
— |
wangruin |
| 2022-05-18 |
[sqlancer] planner use long time 3000 ms |
fixed |
— |
wangruin |
| 2022-05-14 |
[sqlancer]Unknown error. |
fixed |
— |
yongbingwang |
| 2022-05-14 |
[sqlancer]Unknown error. |
fixed |
— |
yongbingwang |
| 2022-05-11 |
[sqlancer]Wrong result. |
fixed |
— |
yongbingwang |
| 2022-05-11 |
[sqlancer]Wrong result in norec mode. |
fixed |
NOREC |
yongbingwang |
| 2022-05-11 |
[sqlancer]Wrong result in norec mode. |
fixed |
NOREC |
yongbingwang |
| 2022-05-11 |
[sqlancer]Wrong result in norec mode. |
fixed |
NOREC |
yongbingwang |
| 2022-05-11 |
[sqlancer]Wrong result in norec mode. |
fixed |
NOREC |
yongbingwang |
| 2022-05-11 |
[sqlancer]Wrong result in norec mode. |
fixed |
NOREC |
yongbingwang |
| 2022-05-11 |
[sqlancer]Wrong result in norec mode. |
fixed |
NOREC |
yongbingwang |
| 2022-05-11 |
[sqlancer] in is null Wrong result. |
fixed |
— |
yongbingwang |
| 2022-04-28 |
[SQLancer] Result error |
fixed |
TLP |
murphyatwork |
| 2022-04-08 |
BE core with SQLancer fuzzy mode |
fixed |
— |
kangkaisen |
| 2021-12-22 |
Query return error: No equal on predicate in LEFT SEMI JOIN is not supported |
fixed |
TLP |
wanpengfei-git |
| 2021-11-29 |
Constant-cmp-Column not supported here, should be deal earlier |
fixed |
TLP |
wanpengfei-git |
| 2021-10-16 |
Sqlancer crashes in ASAN Mode |
fixed |
— |
dirtysalt |
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.