summaryrefslogtreecommitdiff
path: root/mysql-test/main/system_mysql_db.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-24363 mysql.user password_expired column is incorrectRobert Bindar2021-03-081-1/+1
| | | | | | | | | 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-19650: Privilege bug on MariaDB 10.4Oleksandr Byelkin2020-05-071-1/+1
| | | | | | | | | | | | | | | Also fixes: MDEV-21487: Implement option for mysql_upgrade that allows root@localhost to be replaced MDEV-21486: Implement option for mysql_install_db that allows root@localhost to be replaced Add user mariadb.sys to be definer of user view (and has right on underlying table global_priv for required operation over global_priv (SELECT,UPDATE,DELETE)) Also changed definer of gis functions in case of creation, but they work with any definer so upgrade script do not try to push this change.
* Merge 10.3 into 10.4Marko Mäkelä2019-09-231-2/+2
|\ | | | | | | Disable MDEV-20576 assertions until MDEV-20595 has been fixed.
| * Merge 10.2 into 10.3Marko Mäkelä2019-09-231-2/+2
| |
* | MDEV-17658 change the structure of mysql.user tableSergei Golubchik2018-12-121-51/+11
| | | | | | | | | | | | Implement User_table_json. Fix scripts to use mysql.global_priv. Fix tests.
* | MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMPbb-10.4-mdev16991Alexander Barkov2018-11-261-2/+2
| |
* | MDEV-15851 Stop creating mysql.host tableVladislav Vaintroub2018-08-161-26/+0
| | | | | | | | Changed bootstrap scripts, adjusted result files.
* | MDEV-16421 Make system tables crash safeMichael Widenius2018-08-141-13/+13
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Make all system tables in mysql directory of type engine=Aria Privilege tables are using transactional=1 Statistical tables are using transactional=0, to allow them to be quickly updated with low overhead. Help tables are also using transactional=0 as these are only updated at init time. Other changes: - Aria store engine is now a required engine - Update comment for Aria tables to reflect their new usage - Fixed that _ma_reset_trn_for_table() removes unlocked table from transaction table list. This was needed to allow one to lock and unlock system tables separately from other tables, for example when reading a procedure from mysql.proc - Don't give a warning when using transactional=1 for engines that is using transactions. This is both logical and also to avoid warnings/errors when doing an alter of a privilege table to InnoDB. - Don't abort on warnings from ALTER TABLE for changes that would be accepted by CREATE TABLE. - New created Aria transactional tables are marked as not movable (as they include create_rename_lsn). - bootstrap.test was changed to kill orignal server, as one can't anymore have two servers started at same time on same data directory and data files. - Disable maria.small_blocksize as one can't anymore change aria block size after system tables are created. - Speed up creation of help tables by using lock tables. - wsrep_sst_resync now also copies Aria redo logs.
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-0/+318