In theory we could mitigate issue by throwing exception once we detect duplicated ID. Tree view will be unexpectedly unable to expand specific node, but at least end-user's browser tab won't have a chance to freeze. I am curious about @yuwu9145 's opinion on it. Member yuwu9145 commen...
3105 Jonathan Huurman February 08, 2008 03:36AM Re: Interesting problem with Nested Set and duplicate names in (a) child node 2211 Robert Yeager September 30, 2008 11:07PM Sorry, you can't reply to this topic. It has been closed....
Simply, grouping it by node.id solves the issue! Maybe the author of the tutorial should either mention that the query only works with a table with a UNIQUE index on the name column, or the query should be changed to GROUP BY id.Navigate...
Re: Interesting problem with Nested Set and duplicate names in (a) child nodePosted by: Robert Yeager Date: September 30, 2008 11:07PM Woohoo, you saved me a lot of trouble tracking this issue down. My app made it into production with this flaw...didn't know it until a dup ...