ddl: select from view report error but creating it

[AilinKid]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE BASE TABLE

drop table if exists c_st_tab;
create table c_st_tab (
st_id varchar(36) not null,
bj_id varchar(36),
st_code varchar(150),
st_name varchar(150),
primary key (st_id)
);

CREATE VIEW

create or replace view v
as
select
c.bj_id,
group_concat(c.st_code) as st_code,
group_concat(c.st_name) as st_name
from c_st_tab c
group by c.bj_id;

select * from v;

2. What did you expect to see? (Required)

Success With Empty Set

3. What did you see instead (Required)

ERROR 1105 (HY000): line 1 column 61 near "_UTF8',') AS `st_code`,GROUP_CONCAT(`c`.`st_name` SEPARATOR _UTF8',') AS `st_name` FROM `ryl`.`c_st_tab` AS `c` GROUP BY `c`.`bj_id`"

4. What is your TiDB version? (Required)

master, 4.0.10

[xiongjiwei]

this bug has been fixed by #23083. I will close it

[xiongjiwei]

/close

[ti-chi-bot]

@xiongjiwei: Closing this issue.

In response to this:

/close

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes/test-infra repository.

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

[v4.0.10:v4.0.11],[v5.0.0-rc]

6. Fixed versions

master