summaryrefslogtreecommitdiff
path: root/mysql-test/main/upgrade_MDEV-23102-2.test
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-24363 (followup fix) mysql.user view shouldRobert Bindar2021-03-081-3/+51
| | | | | | | | | | | | | not be dropped if the DEFINER is custom. Revert changes to MDEV-23102 tests as they were designed to catch this corner case. The explanation for this corner case is that users historically used to tweak the mysql.user table and probably still do even though mysql.user is now a view. Thus, if the DEFINER of the view is not default, i.e. root@localhost or mariadb.sys@localhost, we should avoid dropping the view during upgrade process to not discard potential custom changes.
* MDEV-24363 (followup refactor) avoid listing mysql.userRobert Bindar2021-03-081-50/+2
| | | | | | view definition in tests as it wastes lots of time when they fail for minor fixes like adding/changing a new column in the view, also it's less code
* MDEV-24363 mysql.user password_expired column is incorrectRobert Bindar2021-03-081-1/+0
| | | | | | | | | The mysql.user view password_expired column should display the right result, in sync with whether an account has its password expired or not For mariadb 10.4+ upgrades before this commit, the mysql.user view needs to be dropped and recreated to actually make the view display the correct value for the password_expired column.
* MDEV-23102 10.4 create mariadb.sys user on each update even is the user is ↵Oleksandr Byelkin2020-07-081-0/+141
not needed Check if we really need the mariadb.sys user