Re: MySQL - cause of view definition to change to all 1s for the column values
Posted by: Peter Brawley
Date: May 21, 2018 04:07PM

That's --no-data not --nodata, and as expected I get ...

/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=... SQL SECURITY DEFINER */
/*!50001 VIEW `v1` AS select `a`.`id` AS `id`,`a`.`created_date` AS `created_date` from `t1` `a` */;



Edited 1 time(s). Last edit at 05/21/2018 04:09PM by Peter Brawley.

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.