Skip to content
← dbForge Studio for MySQL

I suggest you...

dbForge Studio for MySQL: Bugs

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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 utf8mb3generalci

Reported RETURNS value (incorrect):
RETURNS VARCHAR(80) CHARSET utf8mb4 COLLATE utf8mb40900ai_ci

Curiously, if you generate the changeset to update the MySQL 8.0 host, it uses the correct character set and collation.

2 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Eric Rasmussen shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Dear User,

    Thank you for your post!

    We want to assure you that our team is aware of this issue and is actively working on a solution.

    We’ll keep you updated and let you know as soon as we have any new information to share.

    Best,
    Devart Team