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"