Diff
Not logged in

Differences From:

File src/name.c part of check-in [9acf0bcdbe] - Correctly detect when an artifact prefix does not match any artifact. Provide better error messages for non-matching and ambiguous artifact prefixes. Fix for ticket d0a7fc67e9. by drh on 2008-10-26 15:59:38. [view]

To:

File src/name.c part of check-in [7a2c37063a] - merge trunk into creole branch by bob on 2009-09-22 07:49:39. Also file src/name.c part of check-in [d31e054f0d] - Fix an ambiguous column reference in a join - problem introduced by the recent additions to the event table. by drh on 2009-09-14 15:33:40. [view]

@@ -124,9 +124,9 @@
   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,