Bug #1224 Diffrent results for CURRENT_USER, SESSION_USER and USER in embedded libmysql
Submitted: 8 Sep 2003 7:29 Modified: 7 Jan 2004 8:15
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:4.1 OS:Linux (Linux)
Assigned to: Alexey Botchkov CPU Architecture:Any

[8 Sep 2003 7:29] Georg Richter
Description:
diffrent results for USER(), CURRENT_USER and SESSION_USER() in 4.0.15 and 4.1.1

In 4.0.15 CURRENT_USER returns wrong host, in 4.1.1 all functions return an empty string.

How to repeat:
For 4.1.1:

SELECT VERSION()
        "4.1.1-alpha-embedded-debug"
SELECT CURRENT_USER()
       ""
SELECT SESSION_USER()
       ""
SELECT USER()
       ""

For 4.0.0:
SELECT VERSION()
        "4.0.15-embedded-debug"
SELECT CURRENT_USER()
      "georg@¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥"
SELECT SESSION_USER()
      "georg@localhost"
SELECT USER()
      "georg@localhost"
[7 Jan 2004 5:58] Alexey Botchkov
bk commit - 4.1 tree (hf:1.1681) 07 Jan 2004
[7 Jan 2004 8:15] Alexey Botchkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html