带别名的视图转化失败

转化后表别名l被认为是一张表
Two methods execute create view current_dept_emp failed, error message is Method 1 execute failed: invalid reference to FROM-clause entry for table "l"; Method 2 execute failed: invalid reference to FROM-clause entry for table "l"

mysql> show create view current_dept_emp\G
*************************** 1. row ***************************
                View: current_dept_emp
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `current_dept_emp` AS select `l`.`emp_no` AS `emp_no`,`d`.`dept_no` AS `dept_no`,`l`.`from_date` AS `from_date`,`l`.`to_date` AS `to_date` from (`dept_emp` `d` join `dept_emp_latest_date` `l` on(((`d`.`emp_no` = `l`.`emp_no`) and (`d`.`from_date` = `l`.`from_date`) and (`l`.`to_date` = `d`.`to_date`))))
character_set_client: utf8mb4
collation_connection: utf8mb4_0900_ai_ci
1 row in set (0.00 sec)

employees=> select * from t_replica_object;
          25 |           1 | VIEW           | 2024-11-13 14:12:50.895113+08 | f        | CREATE ALGORITHM=UNDEFINED 
DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `employees`.`current_dept_emp` AS select `employees`.`l`.`emp_n
o` AS `emp_no`,`d`.`dept_no` AS `dept_no`,`employees`.`l`.`from_date` AS `from_date`,`employees`.`l`.`to_date` AS `t
o_date` from (`employees`.`dept_emp` `d` join `employees`.`dept_emp_latest_date` `l` on(((`d`.`emp_no` = `employees`
.`l`.`emp_no`) and (`d`.`from_date` = `employees`.`l`.`from_date`) and (`employees`.`l`.`to_date` = `d`.`to_date`)))
) |

创建了任务

添加了

sig/tools

标签

登录后才可以发表评论

openGauss/openGauss-tools-chameleon

内容风险标识

评论 (2)