Bug #45120 Fix of Bug #44922 caused regression in funcs_1.processlist_priv_no_prot
Submitted: 27 May 2009 8:54 Modified: 18 Jun 2009 15:31
Reporter: Bjørn Munch Email Updates:
Status: Closed Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Bjørn Munch CPU Architecture:Any

[27 May 2009 8:54] Bjørn Munch
Description:
Fix of Bug #44922 allowed arguments to mtr command to be protected in quotes (' " or `).  But in some rare cases, a test would have '' or "" as an argument to be interpreted literally, now this becomes an empty string.

How to repeat:
./mtr funcs_1.processlist_priv_no_prot

Suggested fix:
Arguments that include enclosing quotes now have to be protected by another type of quote, in this case '' in a connect command is replaced with "''".
[27 May 2009 8:59] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/75027

2796 Bjorn Munch	2009-05-27
      Bug #45120 Fix of 44922 caused regression in funcs_1.processlist_priv_no_prot
      Protected '' in connect command with ""
      modified:
        mysql-test/suite/funcs_1/datadict/processlist_priv.inc
[27 May 2009 14:37] Magnus Blåudd
What differs if you write it like this "(anonymous1,localhost,,,information_schema);" ? Just curious.
[27 May 2009 15:34] Bjørn Munch
Pushed to 5.1-mtr.

To answer last comment: what happens is apparently that you connect using an empty tring rather than a string consisting of '' for the user name, resulting in, in this case, the user being set to your user name.
[5 Jun 2009 8:04] Bugs System
Pushed into 5.1.36 (revid:bjorn.munch@sun.com-20090605074215-1d7l2reqdb9a0t0t) (version source revid:bjorn.munch@sun.com-20090605074215-1d7l2reqdb9a0t0t) (merge vers: 5.1.36) (pib:6)
[5 Jun 2009 15:32] Paul DuBois
Test suite changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[17 Jun 2009 19:21] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090616183122-chjzbaa30qopdra9) (version source revid:matthias.leich@sun.com-20090609174954-3ao9iz97nzrfg9yl) (merge vers: 5.4.4-alpha) (pib:11)
[18 Jun 2009 15:31] Paul DuBois
Test suite changes. No changelog entry needed.
[26 Aug 2009 13:45] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:32] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)