s4
changeset 475:c01081811298
typo of SQL statement
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Thu, 07 Sep 2017 12:14:32 +0859 |
parents | 4f9036d35b57 |
children | 16e4eb9ea86c |
files | s4-funcs.sh |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line diff
1.1 --- a/s4-funcs.sh Thu Sep 07 12:11:45 2017 +0859 1.2 +++ b/s4-funcs.sh Thu Sep 07 12:14:32 2017 +0859 1.3 @@ -2005,7 +2005,7 @@ 1.4 max(case key when 'gecos' then val end) as gecos, 1.5 max(case key when 'tag' then val end) as tag, 1.6 max(case key when 'mtime' then val end) as mtime, 1.7 - max(case key when 'wtime' then val end) as wtime 1.8 + max(case key when 'wtime' then val end) as wtime, 1.9 max(case key when 'login' then val end) as login 1.10 from ${tbl}_s group by $nm) 1.11 b on a.$nm=b.name $cond $3