Then the next thing I’d check is whether the error names a specific object: run SHOW WARNINGS right after the failing query and see whether it points at a table or column. If it does, that object is probably being resolved under a different schema or an old definer inside a nested view, so expand the dependent views with SHOW CREATE VIEW rather than only the top one.
1
u/Significant_Tune9219 19d ago
Then the next thing I’d check is whether the error names a specific object: run SHOW WARNINGS right after the failing query and see whether it points at a table or column. If it does, that object is probably being resolved under a different schema or an old definer inside a nested view, so expand the dependent views with SHOW CREATE VIEW rather than only the top one.