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

[7 Feb 2006 8:55] Kristian Nielsen
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
[7 Feb 2006 10:08] 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/2226
[8 Feb 2006 9:54] 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/2305
[8 Feb 2006 10:02] Alexander Nozdrin
Pushed into 5.1 tree; currently tagged 5.1.7-beta.
[14 Feb 2006 3:17] Paul DuBois
No changelog entry needed. (bug in unreleased version only)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.