Closed (fixed)
Project:
Node Auto Term [NAT]
Version:
5.x-2.1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
1 Aug 2008 at 00:03 UTC
Updated:
20 Mar 2010 at 15:40 UTC
There is not a proper primary key on the table, so duplicates can (and, at least in my case, *are*) being created.
Since node.vid is now included in this table, the primary key should probably be something like:
PRIMARY KEY (nid, vid)
This came to my attention only because I'm writing a module that pulls from the nat table and causes problems unless I include a 'group by' clause on the nat table, which really shouldn't be necessary.
The fix would require some code to de-dupe this table and then put a proper primary key on it.
Duplicate rows are a good source for hard to find bugs.
Comments
Comment #1
arlinsandbulte commentedIs the D5 version of NAT being actively maintained?
Does this apply to the D6 version too?
Comment #2
anantagati commentedClosing. If there is still problem feel free to reopen issue.