Status: Closed (View Workflow)
Affects Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7
Environment:Debian 9.0, CentOS 7.9, CentOS 8.2
Database users cannot use data export if the database contains views with subqueries. This causes difficulties in backing up data and causes an application compatibility issue with newer versions of MariaDB.
Steps to reproduce
- Create database and user, grant all privileges:
- Create test data:
- Try to dump the database:
The dump fails with an error:
The dump procedure is completed successfully.
The issue is reproduced on versions: 10.5.8, 10.4.17. But I have not tested earlier versions (10.5.* and 10.4.*).
The issue does not occur on earlier versions of MariaDB (10.3.27 works correct).