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
• Status: Can't repeat
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.1, 5.5
• OS: MacOS (10.6.4, 64 bit)
• CPU Architecture: Any

[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.