mariadb/mysql-test/suite/roles/set_default_role_ps-6960.result at bb-10.2.7 - mirror/mariadb - May the force be without you: git.fucktheforce.de

mirror/mariadb

mirror of https://github.com/MariaDB/server.git synced 2025-02-13 17:05:35 +01:00

Sergei Golubchik ba80708f66 MDEV-6960 Server crashes in check_alter_user on setting a default role via PS

There were two issues:

* set_var_default_role::user was overwritten with a new value,
  allocated in the thd->mem_root, which is reset between executions.
  That was causing the crash. Solved by introducing set_var_default_role::real_user

* when privilege tables were opened on EXECUTE, the reprepare_observer
  would abort the statement (as privilege tables are opened using
  the local TABLE_LIST that doesn't preserve metadata from PREPARE, so
  reprepare_observer thought they're changed). This issue also applied
  to SET PASSWORD. Solved by disabling reprepare_observer.

2015-02-28 19:48:22 +01:00

8 lines

221 B

Text

Raw Permalink Blame History

 create role r1;
 prepare stmt from "set password = '11111111111111111111111111111111111111111'";
 execute stmt;
 prepare stmt from "set default role r1";
 execute stmt;
 set password = '';
 set default role NONE;
 drop role r1;