Bug #90440 version comments with new charsets are not useful

• Submitted: 14 Apr 2018 19:45
• Modified: 16 Apr 2018 6:02
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 8.0.12
• OS: Any
• CPU Architecture: Any

[14 Apr 2018 19:45] Shane Bester

Description:
See this on 8.0:

mysql> show create database mysql;
+----------+----------------------------------------------------------------------------------------------+
| Database | Create Database                                                                              |
+----------+----------------------------------------------------------------------------------------------+
| mysql    | CREATE DATABASE `mysql` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ |
+----------+----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

That charset isn't going to work on older versions since it was recently invented.

How to repeat:
..

Suggested fix:
actually I'd like to get rid of all these version comments since they are unneeded bloat.

invent some sql function to check the minimum version of the database and write that at the top of a mysqldump file instead.

[16 Apr 2018 6:02] MySQL Verification Team

Hello Shane,

Thank you for the report and feedback!

Thanks,
Umesh