Bug #56750 CREATE TRIGGER creates files with filenames having inconsistent case
Submitted: 13 Sep 2010 14:02 Modified: 3 Oct 2016 12:50
Reporter: Jon Olav Hauglid Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.1, 5.5 OS:Mac OS X (10.6.4, 64 bit)
Assigned to: CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[13 Sep 2010 14:02] Jon Olav Hauglid
Description:
If --lower-case-table-names=2 (e.g. Mac OS X), "create trigger TRIG_UPPERCASE ..."
will create the following files:
  TRIG_UPPERCASE.TRN   (as expected).
  trig_uppercase.TRG   (should be upper case).

This could be an issue if the files were copied to a case sensitive file system.

How to repeat:
With --lower-case-table-names=2 execute the following statements:

CREATE TABLE T1(a INT);
CREATE TRIGGER T1_BI BEFORE INSERT ON T1 FOR EACH ROW SET new.a = 1;

Then inspect the files created.
[3 Oct 2016 12:50] Jon Olav Hauglid
Posted by developer:
 
Not repeatable in 8.0 since .TRN/.TRG files are gone.