MariaDB 10.3支持update多表ORDER BY and LIMIT

1）update连表更新，limit语句

updatet1joint2ont1.id=t2.idsett1.name='hechunyang'limit3;

MySQL 8.0 直接报错


MariaDB 10.3 更新成功


---------------------------------------------------

2）update连表更新，ORDER BY and LIMIT语句

updatet1joint2ont1.id=t2.idsett1.name='HEchunyang'orderbyt1.idDESClimit3;

MySQL 8.0 直接报错


MariaDB 10.3 更新成功


参考：https://jira.mariadb.org/browse/MDEV-13911