MySQL Bugs: #17180: Failure in trigger-grant on Solaris

Bug #17180	Failure in trigger-grant on Solaris
Submitted:	7 Feb 2006 8:55	Modified:	14 Feb 2006 3:17
Reporter:	Kristian Nielsen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.7 (latest bk)	OS:	Solaris (Solaris)
Assigned to:	Alexander Nozdrin	CPU Architecture:	Any

Description:
After push of this changeset to 5.1-new:

    anozdrin@mysql.com|ChangeSet|20060206130520|40489

the test trigger-grant fails on Solaris (detected in pushbuild):

trigger-grant                  [ fail ]

Errors are (from /export/home/mysqldev/users/knielsen/mysql-5.1.7-beta-standard/
mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/trigger-grant.result      Tue Feb  7 09:08:03 2006
--- r/trigger-grant.reject      Tue Feb  7 11:45:43 2006
***************
*** 43,49 ****
  
  ---> connection: wl2818_definer_con
  INSERT INTO t1 VALUES(0);
! ERROR 42000: TRIGGER command denied to user 'mysqltest_dfn'@'localhost' for ta
ble 't1'
  
  ---> connection: default
  GRANT TRIGGER ON mysqltest_db1.t1 TO mysqltest_dfn@localhost;
--- 43,49 ----
  
  ---> connection: wl2818_definer_con
  INSERT INTO t1 VALUES(0);
! ERROR 42000: TRIGGER command denied to user 'mysqltest_dfn'@'localhost' for ta
ble '(null)'
  
  ---> connection: default
  GRANT TRIGGER ON mysqltest_db1.t1 TO mysqltest_dfn@localhost;

(also saw junk characters instead of (null) on another Solaris host, so looks like a memory/pointer problem).

How to repeat:
Run the test suite on Solaris, for example like this:

cd mysql-test/
MTR_BUILD_THREAD=4 ./mysql-test-run.pl --skip-ndb trigger-grant

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/2226

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/2305

Pushed into 5.1 tree; currently tagged 5.1.7-beta.

No changelog entry needed. (bug in unreleased version only)