# HG changeset patch # User HIROSE Yuuji # Date 1555543044 -32400 # Node ID 2d1d651aa1f26057a927c4edfc8759daa53a226b # Parent b87e1cbf34916e20ccbc00c82b403d5f2edba062 $DT_SQL handling fixed diff -r b87e1cbf3491 -r 2d1d651aa1f2 s4-funcs.sh --- a/s4-funcs.sh Thu Apr 18 07:24:19 2019 +0900 +++ b/s4-funcs.sh Thu Apr 18 08:17:24 2019 +0900 @@ -3149,7 +3149,8 @@ CREATE TEMPORARY TABLE _target AS SELECT b.rowid trowid, b.id FROM "$2" b JOIN "$2_s" s - ON b.id=s.id AND s.key='owner' AND s.val=$DT_QOWNER; + ON b.id=s.id AND s.key='owner' + ${DT_QOWNER:+ AND s.val=$DT_QOWNER}; CREATE TEMPORARY TABLE _children AS SELECT a.trowid trowid, $_i, a.id, s.val ctime @@ -3211,7 +3212,7 @@ scols="$scols${scols:+, }b.$as" done #case author when '$user' then a.rowid else '---' end as ID, - if [ -z "DT_SQL" ]; then + if [ -n "$DT_SQL" ]; then echo "$DT_SQL" else cat<<-EOF