Mercurial > hgrepos > hgweb.cgi > s4
changeset 387:2c928bb47c90
Sort condition missing
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Mon, 28 Nov 2016 12:08:51 +0859 |
parents | 606404fbb3d3 |
children | 4f6b63c25ab8 |
files | s4-funcs.sh |
diffstat | 1 files changed, 3 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Mon Nov 28 12:07:18 2016 +0859 +++ b/s4-funcs.sh Mon Nov 28 12:08:51 2016 +0859 @@ -1962,10 +1962,11 @@ (select $nm as name, max(case key when 'gecos' then val end) as gecos, max(case key when 'tag' then val end) as tag, - max(case key when 'mtime' then val end) as mtime + max(case key when 'mtime' then val end) as mtime, + max(case key when 'wtime' then val end) as wtime from ${tbl}_s group by $nm) b on a.$nm=b.name $cond $3 - order by b.tag desc, b.mtime desc, a.rowid asc" + order by b.tag desc, b.wtime desc, b.mtime desc, a.rowid asc" # Give precedence to newer maintained groups (2016-09-24) # Note that mtime is stored only in grp_s. ## err LE:sql.1="$sql"