s4

changeset 994:f0a62a22e33c

find changesets by author, revision, files, or words in the commit message
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