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 diff
1.1 --- a/s4-funcs.sh Mon Nov 28 12:07:18 2016 +0859 1.2 +++ b/s4-funcs.sh Mon Nov 28 12:08:51 2016 +0859 1.3 @@ -1962,10 +1962,11 @@ 1.4 (select $nm as name, 1.5 max(case key when 'gecos' then val end) as gecos, 1.6 max(case key when 'tag' then val end) as tag, 1.7 - max(case key when 'mtime' then val end) as mtime 1.8 + max(case key when 'mtime' then val end) as mtime, 1.9 + max(case key when 'wtime' then val end) as wtime 1.10 from ${tbl}_s group by $nm) 1.11 b on a.$nm=b.name $cond $3 1.12 - order by b.tag desc, b.mtime desc, a.rowid asc" 1.13 + order by b.tag desc, b.wtime desc, b.mtime desc, a.rowid asc" 1.14 # Give precedence to newer maintained groups (2016-09-24) 1.15 # Note that mtime is stored only in grp_s. 1.16 ## err LE:sql.1="$sql"