Hi,
I don't know if this is already reported as a bug, I tried to search but I couldn't find any threads.
I am using Toad for MySQL 4.6.0.531
If I do a schema compare it often happens that in the sync window views are shown but without the sql query for creating the view. Here is an example, I compared 2 databases and there where 7 views to synchronize. For 3 of them I got the complete view syntax, but for the other 4 the query was missing:
/* Header line. Object: view__bs_exceptions. Script date: 25.06.2010 10:47:03. */
CREATE VIEW <DATABASE_NAME>.`view__bs_exceptions` AS
; /* Header line. Object: view__bs_reporting. Script date: 25.06.2010 10:47:03. */
CREATE VIEW <DATABASE_NAME>.`view__bs_reporting` AS
; /* Header line. Object: view__bs_reporting_year. Script date: 25.06.2010 10:47:03. */
CREATE VIEW <DATABASE_NAME>.`view__bs_reporting_year` AS
/* ALGORITHM=UNDEFINED */ select <QUERY DELETED>; /* Header line. Object: view__bs_reporting_year_2. Script date: 25.06.2010 10:47:03. */
CREATE VIEW <DATABASE_NAME>.`view__bs_reporting_year_2` AS
/* ALGORITHM=UNDEFINED */ select <QUERY DELETED>; /* Header line. Object: view__open_qchecks_1. Script date: 25.06.2010 10:47:03. */
CREATE VIEW <DATABASE_NAME>.`view__open_qchecks_1` AS
; /* Header line. Object: view__qcheck_statuslist_1. Script date: 25.06.2010 10:47:03. */
CREATE VIEW <DATABASE_NAME>.`view__qcheck_statuslist_1` AS
; /* Header line. Object: view__reporting_result_comments_1. Script date: 25.06.2010 10:47:03. */
CREATE VIEW <DATABASE_NAME>.`view__reporting_result_comments_1` AS
/* ALGORITHM=UNDEFINED */ <QUERY DELETED>;
Everywhere you can see <QUERY DELETED> there was the complete select statement.
But when I look at the code of the views with missing queries with the toad viewer in the original databse I can see the complete statement and it looks alright, here an example:
CREATE ALGORITHM=UNDEFINED DEFINER=`<DELETED>` SQL SECURITY DEFINER VIEW <DATABASE_NAME>.`view__qcheck_statuslist_1` AS select <QUERY DELETED>;
Is there a solution for this problem?
Thx, Martin
|
