Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix an ambiguous column reference in a join - problem introduced by the recent additions to the event table. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d31e054f0d5e12c1c5c4fd9a020782f7 |
| User & Date: | drh 2009-09-14 15:33:40.000 |
Context
|
2009-09-14
| ||
| 16:09 | Formatting changes to the similar event suppression in the timeline. check-in: 8cf8ed785e user: drh tags: trunk | |
| 15:33 | Fix an ambiguous column reference in a join - problem introduced by the recent additions to the event table. check-in: d31e054f0d user: drh tags: trunk | |
| 15:14 | Changes to the event mechanism to abbreviate a sequence of edits to the same ticket. Updates through this check-in require a "rebuild". check-in: df3e34c2e8 user: drh tags: trunk | |
Changes
Changes to src/name.c.
| ︙ | ︙ | |||
121 122 123 124 125 126 127 |
*/
int tag_to_uuid(const char *pName, Blob *pUuid,const char *pPrefix){
Stmt q;
int count = 0;
db_prepare(&q,
"SELECT (SELECT uuid FROM blob WHERE rid=objid)"
" FROM tagxref JOIN event ON rid=objid"
| | | 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 |
*/
int tag_to_uuid(const char *pName, Blob *pUuid,const char *pPrefix){
Stmt q;
int count = 0;
db_prepare(&q,
"SELECT (SELECT uuid FROM blob WHERE rid=objid)"
" FROM tagxref JOIN event ON rid=objid"
" 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
);
blob_zero(pUuid);
|
| ︙ | ︙ |