Bug #104747 DB crashed when show create view caused by a bug fix in 8.0.20
Submitted: 27 Aug 2021 1:57 Modified: 27 Aug 2021 2:04
Reporter: Qilu Wei Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:8.0.25 OS:Any
Assigned to: CPU Architecture:Any

[27 Aug 2021 1:57] Qilu Wei
When the select field in a create view select contains a comparision

How to repeat:
create table fig (id int not null primary key, varchar_1 varchar(20)) DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_bin;
create view v_substr as select substr(varchar_1,if((-(4) = 0),1,-(4)),4) AS `SUBSTR(varchar_1,-4,4)` from fig;
show create view v_substr;
[27 Aug 2021 2:04] Qilu Wei
Wrong description in this submition, so close it.