Ticket #176 (new defect)

Opened 3 weeks ago

Last modified 3 weeks ago

Case-sensitivity MySQL 5 on Linux

Reported by: mgara Owned by: dhughes
Type: defect Priority: normal
Milestone: Component: Reactor - DAO
Version: 1.0 Severity: major
Keywords: Cc:

Description

I have a database with two sets of column-identical tables, the first set is mixed-cased named, the second is all lowercase.
Reactor generates invalid objects that contain duplicate argument names, this is because the information_schema.TABLES table is returning records for both tables.
Reactor is not correctly requesting the table names.
e.g. 2 tables: UserDetails and userdetails.
createGateway("UserDetails") will receive a query containing the columns for UserDetails and userdetails and create a gateway object with duplicated cfargument names: name="iUserDetailsId" (from UserDetails) and name="iUserDetailsId" (from userdetails).

Change History

Changed 3 weeks ago by mgara

Using an innodb with lower_case_table_names system var set to zero (will be case sensitive).

Changed 3 weeks ago by mgara

That Reactor is not correctly requesting the table name is a presumption, it could certainly be something else.

Note: See TracTickets for help on using tickets.