8 results found
-
Source control lost SQL SECURITY options
When submitting routines to SVN through 'Source Control', the SQL Security option is lost
6 votes -
Better error message in data comparison (table name)
Hello,
When doing a data comparison and having an error, a message such as the following one is displayed:
"Error (1,1): Duplicate entry 'WBAH2022-2' for key 'Old'"The problem is that, when the data comparison is against tables, it's not easy to find the table with the problem. It would be very useful to have, at least, the name of the table.
Having also the value of the primary key would help further for this kind of error.
3 votes -
add the ability to change individual table color in the database diagrams
allow the user to specify the header color for a table in a database diagram. ideally you would optionally be able to make it 'sticky' and affect the table in all diagrams
3 votes -
Fix Schema Comparison issue for Stored Functions that return text values
When comparing Stored Functions that return text values using Schema Comparison, it should display the correct character set and collation as reported by information_schema.routines.
Currently, when comparing a MySQL 5.7 source host to a MySQL 8.0 replica of that source, Schema Comparison incorrectly reports the character set and collation of the RETURN value of Stored Functions that return text values on the MySQL 8.0 host. This leads to false positives in the reported list of schema differences.
For example, actual RETURNS value:
RETURNS VARCHAR(80) CHARSET utf8mb3 COLLATE utf8mb3generalciReported RETURNS value (incorrect):
RETURNS VARCHAR(80) CHARSET utf8mb4 COLLATE utf8mb4…2 votes -
select, copy and paste objects between diagrams
allow objects to be 'copied' between diagrams. I would like to be able to select a group of tables from one diagram and create a new diagram from those selected tables.
1 vote -
SQL notebook that can be global or per database. This can be helpful for storing and retrieving reusable SQL queries without saving files
SQL notebook that can be global or per database. This can be helpful for storing and retrieving reusable SQL queries without having to save and organize a bunch of .sql files in folders somewhere.
This is especially useful for complex queries for specific DBs or global generic ones. Also for sharing with a team.
Key word searching or tags would be nice as an option in it too1 vote -
Allow Schema Comparison to ignore differences in integer "size"
In versions of MySQL prior to 8.0, integer values were specified with a "size", such as "INT(11)". In MySQL 8.0 and newer, the size property of integers is removed, resulting in the same value having the type "INT". This results in Schema Comparison across MySQL versions (5.7 vs 8.0) reporting false-positive differences for tables.
The "ignore data types" option in Schema Comparison does not resolve the false positives, and is also probably too blunt, because column size does matter for text and binary data. Please add an option to specifically ignore differences in the "size" of integers.
1 vote -
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,…
1 vote
- Don't see your idea?