Fossil

Check-in [f35abaff]
Login

Check-in [f35abaff]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix query for eType 0 or 2.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | start-of-branch-cte
Files: files | file ages | folders
SHA3-256: f35abaff5c6fb3533428444a4854fdc6257f5d7c74b4bdff29c6c78f9250d420
User & Date: danield 2022-03-04 16:04:50
Context
2022-03-04
17:56
Add braces around an if-block. ... (check-in: 9cd92711 user: danield tags: start-of-branch-cte)
16:04
Fix query for eType 0 or 2. ... (check-in: f35abaff user: danield tags: start-of-branch-cte)
15:32
Fix an assertion failure. ... (check-in: d3625bd9 user: danield tags: start-of-branch-cte)
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/name.c.

︙︙
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185

    "                              WHERE tagid=%d AND tagtype>0" 
    "                                AND value=%Q AND rid=plink.pid),"
    "           1+par.cnt"
    "      FROM plink, par"
    "     WHERE cid=par.pid AND isprim AND par.ex "
    "     LIMIT 100000 "
    "  )"
    " SELECT * FROM par WHERE ex=%d ORDER BY cnt DESC LIMIT 1",
    TAG_BRANCH, zBr, ans, TAG_BRANCH, zBr, eType%2
  );
  fossil_free(zBr);
  rc = db_step(&q);
  if( rc==SQLITE_ROW ) 
    ans = db_column_int(&q, 0);
  db_finalize(&q);
  if( eType==2 && ans>0 ){








|
|








170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185

    "                              WHERE tagid=%d AND tagtype>0" 
    "                                AND value=%Q AND rid=plink.pid),"
    "           1+par.cnt"
    "      FROM plink, par"
    "     WHERE cid=par.pid AND isprim AND par.ex "
    "     LIMIT 100000 "
    "  )"
    " SELECT pid FROM par ORDER BY cnt DESC LIMIT 1",
    TAG_BRANCH, zBr, ans, TAG_BRANCH, zBr
  );
  fossil_free(zBr);
  rc = db_step(&q);
  if( rc==SQLITE_ROW ) 
    ans = db_column_int(&q, 0);
  db_finalize(&q);
  if( eType==2 && ans>0 ){
︙︙