Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.5

Bug #405 joining on a table with the same field name causes overwriting of values
Submitted: 2003-12-11 08:43 UTC
From: justinpatrin Assigned:
Status: Bogus Package: DB_DataObject
PHP Version: 4.3.3 OS: Gentoo Linux
Roadmaps: (Not assigned)    

 [2003-12-11 08:43 UTC] justinpatrin
Description: ------------ Joining on a table that has a field name that is the same as the current table's causes overwriting of that field's value. For instance, if you have a table named "person" with a field called "name" and a foreign key "group_id" which links to the table "group" which has a field "name", the name field will have the group's name. This *may* not be a bug as I don't know how it could be "fixed" except to have a sub-object....which is what getLinks() does. Reproduce code: --------------- This is the same code as bug 404 (which I just posted). If you add an entry in table, add an entry in music, then add a link in media_music between them, this happens to the length and title fields.