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