79294741

Date: 2024-12-19 15:17:09
Score: 1.5
Natty:
Report link
CREATE OR REPLACE VIEW v_t 
COPY GRANTS 
AS 
SELECT * FROM t;

After running the above if I create a new column in source table and run select * from v_t it breaks with "query produces Y columns but declared only X"

Did anyone have a fix for this. Cannot hardcode the column names because the underlying table in my case in dynamic. I cannot recreate the view every time the table updates its DDL.

Reasons:
  • Blacklisted phrase (0.5): I cannot
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Muffle Fuse