MySQL Bugs: #73376: Mark old_password() as deprecated

Bug #73376	Mark old_password() as deprecated
Submitted:	24 Jul 2014 14:05	Modified:	25 Sep 2014 16:50
Reporter:	Georgi Kodinov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	5.6	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
We have marked mysql_old_password as deprecated in 5.6.
But it makes very little sense to not do the same for old_password() SQL function as it's

How to repeat:
SELECT OLD_PASSWORD()

Suggested fix:
Add a deprecation warning in 5.6 for this function.

Noted in 5.6.22, 5.7.6 changelogs.

OLD_PASSWORD() is deprecated, but no warning was produced when it was
invoked.

$ bzr log -r 6149 -n0
------------------------------------------------------------
revno: 6149 [merge]
committer: Georgi Kodinov <georgi.kodinov@oracle.com>
branch nick: B19285177-5.6
timestamp: Mon 2014-09-08 13:23:16 +0300
message:
  merge
    ------------------------------------------------------------
    revno: 6093.1.1
    committer: Georgi Kodinov <georgi.kodinov@oracle.com>
    branch nick: B19285177-5.6
    timestamp: Mon 2014-09-08 13:20:25 +0300
    message:
      Bug #19285177: MARK OLD_PASSWORD() AS DEPRECATED
      
      * Added a deprecation warning to use PASSWORD instead.
      * Fixed the tests that invoke old password to have 
       the warning