Update Schema Comparison to improve cross-version comparision of Views
When comparing Views between MySQL 5.7 and 8.0, Schema Comparison detects "differences" to two conditions that are actually equivalent, resulting in false-positive change detection.
- Quoted text strings are prefixed with _UTF8 in MySQL 5.7 and _UTF8MB3 in MySQL 8.0. These are actually the same character set and represent no change. In fact, if MySQL 8.0 reported UTF8, it would be different, because in MySQL 8.0 the meaning of UTF8 is now UTF8MB4.
- In MySQL 8.0 Views, the schema prefix on table names (schema.table) is automatically removed when the schema of the specified Table matches the schema of the View. Therefore, a MySQL 5.7 view that contains "FROM schema.table" can be equivalent to a MySQL 8.0 schema that contains only "FROM table". (This also applies to JOINs)
1
vote
Eric Rasmussen
shared this idea
-
AdminDevart (_, Devart) commented
Dear User,
Thank you for your post!
Would you be able to provide us with a screenshot of the view comparison where false differences are detected? This will help us better understand the issue.
You can send it directly to our Support Team using this contact form: https://www.devart.com/company/contactform.html
Best,
Devart Team