MySQL - cause of view definition to change to all 1s for the column values
Posted by: NOT_FOUND NOT_FOUND
Date: May 21, 2018 02:30PM

I have a view in MySQL database whose definition has gotten changed from
create view v1 select a.id AS id, a.created_date AS created_date from t1;
to
create view v1 select 1 AS id, 1 AS created_date

What are some of the MySQL operations that can cause that to happen? Is there a bug in MySQL that can cause this?

thanks for the help

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.