Fossil SCM
Fix an ambiguous column reference in a join - problem introduced by the recent additions to the event table.
Commit
d31e054f0d5e12c1c5c4fd9a020782f77fd10e25
Parent
df3e34c2e8b22fa…
1 file changed
+1
-1
+1
-1
| --- src/name.c | ||
| +++ src/name.c | ||
| @@ -123,11 +123,11 @@ | ||
| 123 | 123 | Stmt q; |
| 124 | 124 | int count = 0; |
| 125 | 125 | db_prepare(&q, |
| 126 | 126 | "SELECT (SELECT uuid FROM blob WHERE rid=objid)" |
| 127 | 127 | " FROM tagxref JOIN event ON rid=objid" |
| 128 | - " WHERE tagid=(SELECT tagid FROM tag WHERE tagname=%Q||%Q)" | |
| 128 | + " WHERE tagxref.tagid=(SELECT tagid FROM tag WHERE tagname=%Q||%Q)" | |
| 129 | 129 | " AND tagtype>0" |
| 130 | 130 | " AND value IS NULL" |
| 131 | 131 | " ORDER BY event.mtime DESC", |
| 132 | 132 | pPrefix, |
| 133 | 133 | pName |
| 134 | 134 |
| --- src/name.c | |
| +++ src/name.c | |
| @@ -123,11 +123,11 @@ | |
| 123 | Stmt q; |
| 124 | int count = 0; |
| 125 | db_prepare(&q, |
| 126 | "SELECT (SELECT uuid FROM blob WHERE rid=objid)" |
| 127 | " FROM tagxref JOIN event ON rid=objid" |
| 128 | " WHERE tagid=(SELECT tagid FROM tag WHERE tagname=%Q||%Q)" |
| 129 | " AND tagtype>0" |
| 130 | " AND value IS NULL" |
| 131 | " ORDER BY event.mtime DESC", |
| 132 | pPrefix, |
| 133 | pName |
| 134 |
| --- src/name.c | |
| +++ src/name.c | |
| @@ -123,11 +123,11 @@ | |
| 123 | Stmt q; |
| 124 | int count = 0; |
| 125 | db_prepare(&q, |
| 126 | "SELECT (SELECT uuid FROM blob WHERE rid=objid)" |
| 127 | " FROM tagxref JOIN event ON rid=objid" |
| 128 | " WHERE tagxref.tagid=(SELECT tagid FROM tag WHERE tagname=%Q||%Q)" |
| 129 | " AND tagtype>0" |
| 130 | " AND value IS NULL" |
| 131 | " ORDER BY event.mtime DESC", |
| 132 | pPrefix, |
| 133 | pName |
| 134 |