| Bug #31408 | funcs_1: <engine>_trig_03e test fail | ||
|---|---|---|---|
| Submitted: | 4 Oct 2007 20:31 | Modified: | 1 Nov 2007 12:51 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Any |
| Assigned to: | Matthias Leich | CPU Architecture: | Any |
[19 Oct 2007 14:36]
Joerg Bruehe
Repeated using the "mysql-5.1-build" tree as of October 18, identical for all memory engines tested (innodb, memory, myisam, ndb). System Linux, SuSE 9.3, x86.
[23 Oct 2007 16:42]
Matthias Leich
The reason for the observed change in the test results can be found in the comments of Bug#31673 SUPER privilege no more needed for SHOW TRIGGERS etc.
[24 Oct 2007 13:17]
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/36259 ChangeSet@1.2589, 2007-10-24 15:18:03+02:00, mleich@four.local.lan +4 -0 Fix for Bug#31408 funcs_1: <engine>_trig_03e test fail Modification: The TRIGGER PRIVILEGE is now needed for getting informations about TRIGGERs. Therefore after REVOKE TRIGGER privilege the - SHOW TRIGGERS - SELECT * FROM INFORMATION_SCHEMA.TRIGGERS result sets are now empty.
[26 Oct 2007 15:36]
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/36441 ChangeSet@1.2590, 2007-10-26 17:36:22+02:00, mleich@four.local.lan +4 -0 Fix for Bug#31408 funcs_1: <engine>_trig_03e test fail Modification: The TRIGGER PRIVILEGE is now needed for getting informations about TRIGGERs. Therefore after REVOKE TRIGGER privilege the - SHOW TRIGGERS - SELECT * FROM INFORMATION_SCHEMA.TRIGGERS result sets are now empty.
[29 Oct 2007 9:23]
Matthias Leich
Maintenance of tests, no documentation needed.
[1 Nov 2007 10:14]
Bugs System
Pushed into 6.0.4-alpha
[1 Nov 2007 10:16]
Bugs System
Pushed into 5.1.23-rc
Description: Source tree mysql-5.1-build Last ChangeSet@1.2572, 2007-10-04 Some rows within result sets disappeared. diff suite/funcs_1/r/myisam_trig_03e.result \ /dev/shm/var1/log/myisam_trig_03e.reject 574d573 < trg1_1 INSERT t1 set new.f1 = 'trig 1_1-yes' BEFORE NULL test_yesprivs@localhost latin1 latin1_swedish_ci latin1_swedish_ci 577d575 < NULL priv_db trg1_1 INSERT NULL priv_db t1 0 NULL set new.f1 = 'trig 1_1-yes' ROW BEFORE NULL NULL OLD NEW NULL test_yesprivs@localhostlatin1 latin1_swedish_ci latin1_swedish_ci How to repeat: 1. Build a MySQL release. 2. cd mysql-test 3. ./mysql-test-run.pl --mem --suite=funcs_1 --force