Ticket #176 (new defect)
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
Note: See
TracTickets for help on using
tickets.

