Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.4.31
Description
create table t1 (a int, b int); |
create procedure sp() with cte as (select * from t1) select * from cte; |
call sp();
|
alter table t1 add column c int; |
call sp();
|
The second sp() call should probably fail with ER_WITH_COL_WRONG_LIST
additionally prepared statements can too suffer from this
(select a as col1, b as col2 from t1
union select a as col3, b as col4 from t2),
cte2 (c3, c4) as
(select a as col5, b as col6 from t1
union select a as col7, b as col8 from t2)
provokes no error.