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
• Status: Closed
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• Version: 8.0.25
• OS: Any
• CPU Architecture: Any

[27 Aug 2021 1:57] Qilu Wei

Description:
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.