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
• Status: Closed
• 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:[e-mail]-20090605074215-1d7l2reqdb9a0t0t) (version source revid:[e-mail]-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:[e-mail]-20090616183122-chjzbaa30qopdra9) (version source revid:[e-mail]-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:[e-mail]-20090826132541-yablppc59e3yb54l) (version source revid:[e-mail]-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:[e-mail]-20090826105955-bkj027t47gfbamnc) (version source revid:[e-mail]-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:[e-mail]-20090825194404-37rtosk049t9koc4) (version source revid:[e-mail]-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:[e-mail]-20090827163030-6o3kk6r2oua159hr) (version source revid:[e-mail]-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)