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)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 17 + 26 = ?

 
 [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. http://www.reversefold.com/~papercrane/brokenJoin.tbz2

Comments