s4
changeset 994:f0a62a22e33c
FIX: Too long SQL including binary data put via heredocs.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 15 Oct 2022 17:52:25 +0859 |
parents | 83119d97a2f2 |
children | 9a54ad622318 |
files | s4-funcs.sh |
diffstat | 1 files changed, 12 insertions(+), 4 deletions(-) [+] |
line diff
1.1 --- a/s4-funcs.sh Fri Oct 14 23:22:48 2022 +0859 1.2 +++ b/s4-funcs.sh Sat Oct 15 17:52:25 2022 +0859 1.3 @@ -4258,9 +4258,13 @@ 1.4 # Binary update line is TOO LONG to pipelining 1.5 sqlfile="$tmpd/sqlf.$$" 1.6 if [ -n "$transaction" ]; then 1.7 - printf '%s' "$sql" >> $transaction 1.8 + cat<<-EOF >> $transaction 1.9 + $sql 1.10 + EOF 1.11 else 1.12 - printf '%s' "$sql" > $sqlfile 1.13 + cat<<-EOF > $sqlfile 1.14 + $sql 1.15 + EOF 1.16 query ".read $sqlfile" 1.17 fi 1.18 fi 1.19 @@ -4339,9 +4343,13 @@ 1.20 sqlfile="$tmpd/query.$$" 1.21 ## err sqlfile=`ls -lF $sqlfile` 1.22 if [ -n "$transaction" ]; then 1.23 - printf '%s' "$sql" >> $transaction 1.24 + cat<<-EOF >> $transaction 1.25 + $sql 1.26 + EOF 1.27 else 1.28 - printf '%s' "$sql" > $sqlfile 1.29 + cat<<-EOF >> $sqlfile 1.30 + $sql 1.31 + EOF 1.32 query ".read $sqlfile" 1.33 fi 1.34 fi