[MDEV-7015] SET STATEMENT old_passwords has no effect - Jira

XML

Word

Printable

MariaDB [test]> set statement OLD_PASSWORDS = 0 for select password('test');

+-------------------------------------------+

| password('test')                          |

+-------------------------------------------+

| *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |

+-------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> set statement OLD_PASSWORDS = 1 for select password('test');

+-------------------------------------------+

| password('test')                          |

+-------------------------------------------+

| *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |

+-------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> set  old_passwords = 1;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]>  select password('test');

+------------------+

| password('test') |

+------------------+

| 378b243e220ca493 |

+------------------+

1 row in set (0.00 sec)

Percona server seems to work all right.

relates to

MDEV-5231 Per query variables from Percona Server [patch]

MDEV-6923 Testing for SET STATEMENT .. FOR (MDEV-5231, per-query variables)