[MDEV-11000] Compatibility issues between 10.2 and MySQL 5.7 Created: 2016-10-09  Updated: 2020-12-08  Resolved: 2020-12-08

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Blocks
is blocked by MDEV-6113 merge 5.7 innodb Closed
is blocked by MDEV-11170 MariaDB 10.2 cannot start on MySQL 5.... Closed
PartOf
includes MDEV-10346 Create bind-address as a system variable Closed
includes MDEV-13117 mysqldump to support --skip-definer Open

 Description   

We need to define to which extent MariaDB 10.2 should be compatible with MySQL 5.7.

For MariaDB 10.0/10.1 the major obstacle is MDEV-9904 (closed as "Won't fix").
For MariaDB 10.2, it is not a problem after InnoDB 5.7 has been merged; but it still can't start on MySQL 5.7 datadir due to MDEV-11170.
I expect there will be other issues, so this entry will be an umbrella bug until we are satisfied with the level of compatibility we provide.

Not supported in 10.2

This section will contain random features, syntax and options that I encounter during testing as not supported in 10.2, while supported in MySQL 5.7.
It is not intended to be a full list!

CREATE USER ... PASSWORD EXPIRE ... (see MDEV-7597)
CREATE USER ... ACCOUNT [UN]LOCK
CREATE USER ... IDENTIFIED WITH ... BY ... (see MDEV-11180)

 Comments   
Comment by Otto Kekäläinen [ 2016-11-08 ]

ratzpo What is the plan here? In buildbot we test 5.7 -> 10.2 upgrades, and so far they always fail. Does the test mirror the target state or should the test step be removed or changed to a 5.6 -> 10.2 test?

Comment by Ian Gilfillan [ 2017-08-31 ]

Should this task be re-aimed at 10.3 now? There are quite a few variables in MySQL 5.7 not present in MariaDB. They're listed at https://mariadb.com/kb/en/the-mariadb-library/system-variable-differences-between-mariadb-103-and-mysql-57/

Comment by Elena Stepanova [ 2017-08-31 ]

I'm not aware of any planned effort for 10.3 to be "more compatible" with MySQL 5.7 than 10.2. I'll leave it to ratzpo and serg to decide whether we need a task for it in 10.3.

Comment by Sergei Golubchik [ 2017-08-31 ]

Having some of that in 10.3 is still possible, but not very likely.

Comment by Daniel Black [ 2020-12-08 ]

Account locking implemented in MDEV-13095 (10.4).

updated:
https://mariadb.com/kb/en/incompatibilities-and-feature-differences-between-mariadb-102-and-mysql-57/ and 10.3 version too.

Given the age of this bug now, I suspect the the satisfaction with level of compatibility has been reached.

Generated at Thu Feb 08 07:46:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.