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:MacOS (10.6.4, 64 bit)
Assigned to: 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.

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

Page generated in 0.053 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.