SHA1 Hash:	d31e054f0d5e12c1c5c4fd9a020782f77fd10e25
Date:	2009-09-14 15:33:40
User:	drh
Comment:	Fix an ambiguous column reference in a join - problem introduced by the recent additions to the event table.
Timelines:	ancestors | descendants | both | trunk
Other Links:	files | ZIP archive | manifest

• branch=trunk inherited from [a28c83647d]
• sym-trunk inherited from [a28c83647d]

Modified src/name.c from [040558eaa3] to [1511a64c2c].

@@ -123,11 +123,11 @@
   Stmt q;
   int count = 0;
   db_prepare(&q,
     "SELECT (SELECT uuid FROM blob WHERE rid=objid)"
     "  FROM tagxref JOIN event ON rid=objid"
-    " WHERE tagid=(SELECT tagid FROM tag WHERE tagname=%Q||%Q)"
+    " WHERE tagxref.tagid=(SELECT tagid FROM tag WHERE tagname=%Q||%Q)"
     "   AND tagtype>0"
     "   AND value IS NULL"
     " ORDER BY event.mtime DESC",
     pPrefix,
     pName