3.0.3 show create view 语句逻辑有误

Viewed 3

建 view 语句如下:

CREATE VIEW data_model.`vw_ads_table` AS 
select a.*
from `ads`.`table` a

show create view 展示如下:

CREATE VIEW `vw_ads_table` AS 
  select 
  `internal`.`ads`.`a`.`TICKET_ID`, 
  `internal`.`ads`.`a`.`TICKET_CHANGE_TS`, 
  `internal`.`ads`.`a`.`TICKET_CREATE_TS`, 
  `internal`.`ads`.`a`.`TICKET_EDITOR`, 
  `internal`.`ads`.`a`.`TICKET_DESC`
from `internal`.`ads`.`table` `a`;

在字段名里面 internal.ads. 后面会多一个 .a 这个逻辑应该有点问题

0 Answers