# HG changeset patch # User HIROSE Yuuji # Date 1504754099 -32373 # Node ID c0108181129801ea7c2412b2bb7dc8fb8a80a835 # Parent 4f9036d35b573f2c5bad496432a38bebb43fa61f typo of SQL statement diff -r 4f9036d35b57 -r c01081811298 s4-funcs.sh --- a/s4-funcs.sh Thu Sep 07 12:11:45 2017 +0859 +++ b/s4-funcs.sh Thu Sep 07 12:14:32 2017 +0859 @@ -2005,7 +2005,7 @@ 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 'wtime' then val end) as wtime + max(case key when 'wtime' then val end) as wtime, max(case key when 'login' then val end) as login from ${tbl}_s group by $nm) b on a.$nm=b.name $cond $3