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

Create a database.
create table t1(id int, created_date date);
create view v1 as select a.id AS id, a.created_date AS created_date from t1 a;

Take mysqldump of this database
eg
mysqldump --routines --no-data instance_10000000

The output of this dump command will have view definition changed to following
DROP TABLE IF EXISTS `v1`;
/*!50001 DROP VIEW IF EXISTS `v1`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v1` AS SELECT
1 AS `id`,
1 AS `created_date`*/;
SET character_set_client = @saved_cs_client;

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.