Bug #82637 SHOW TRIGGER output inconsistency on Windows / Linux on 8.0.0
Submitted: 18 Aug 2016 14:39 Modified: 16 Nov 2016 18:42
Reporter: Pepe Rodriguez Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[18 Aug 2016 14:39] Pepe Rodriguez 
Description:
SHOW TRIGGER produce different output order on Windows or Linux/Solaris.

How to repeat:
These same steps produce different output order on Windows or Linux using latest 8.0.0 dmr:

On Windows/Linux 5.7.14 || 5.7.15:

  1. Start MySQL 5.7.14 || 5.7.15
  2. Execute SHOWTRIGGERS_SQL.sql file (attached). 
     Notice that the last statement (SHOW TRIGGER) order is: trg1a0, trg1a, trg1a2, etc.
  3. Shutdown MySQL 5.7.14 || 5.7.15

On Linux 8.0.0:
  1. Start MySQL 8.0.0
  2. Execute SHOWTRIGGERS_SQL.sql file (attached). 
     Notice that the output follows a different order: trg1a, trg1a3, trg1a2, trg1a0, etc.
  3. Shutdown MySQL 8.0.0

On Windows 8.0.0
  1. Start MySQL 8.0.0
  2. Execute SHOWTRIGGERS_SQL.sql file (attached). 
     Notice that the output follows the same order as in 5.7: trg1a0, trg1a, trg1a2, etc.
  3. Shutdown MySQL 8.0.0

If the new behavior on Linux 8.0.0 is correct, then there is a problem on Windows where the output is the same as it was before.

Suggested fix:
Have consistency output for this command (SHOW TRIGGER) on 8.0.0
[16 Nov 2016 18:42] Paul DuBois 
Posted by developer:
 
Noted in 8.0.1 changelog.

SHOW TRIGGERS output order could differ on Linux and Windows.
[18 Nov 2016 6:23] Erlend Dahl 
Bug#82934 8.0.0 triggers execution sequence is modified by triggers name and by a Select

was marked as a duplicate.