comparison s4-funcs.sh @ 994:f0a62a22e33c draft

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 e77d6258ad54
children 9a54ad622318
comparison
equal deleted inserted replaced
993:83119d97a2f2 994:f0a62a22e33c
4256 fi 4256 fi
4257 else 4257 else
4258 # Binary update line is TOO LONG to pipelining 4258 # Binary update line is TOO LONG to pipelining
4259 sqlfile="$tmpd/sqlf.$$" 4259 sqlfile="$tmpd/sqlf.$$"
4260 if [ -n "$transaction" ]; then 4260 if [ -n "$transaction" ]; then
4261 printf '%s' "$sql" >> $transaction 4261 cat<<-EOF >> $transaction
4262 $sql
4263 EOF
4262 else 4264 else
4263 printf '%s' "$sql" > $sqlfile 4265 cat<<-EOF > $sqlfile
4266 $sql
4267 EOF
4264 query ".read $sqlfile" 4268 query ".read $sqlfile"
4265 fi 4269 fi
4266 fi 4270 fi
4267 # Rest of kt==m: set multiple mode 4271 # Rest of kt==m: set multiple mode
4268 nr=`getparcount $col` 4272 nr=`getparcount $col`
4337 fi 4341 fi
4338 else 4342 else
4339 sqlfile="$tmpd/query.$$" 4343 sqlfile="$tmpd/query.$$"
4340 ## err sqlfile=`ls -lF $sqlfile` 4344 ## err sqlfile=`ls -lF $sqlfile`
4341 if [ -n "$transaction" ]; then 4345 if [ -n "$transaction" ]; then
4342 printf '%s' "$sql" >> $transaction 4346 cat<<-EOF >> $transaction
4347 $sql
4348 EOF
4343 else 4349 else
4344 printf '%s' "$sql" > $sqlfile 4350 cat<<-EOF >> $sqlfile
4351 $sql
4352 EOF
4345 query ".read $sqlfile" 4353 query ".read $sqlfile"
4346 fi 4354 fi
4347 fi 4355 fi
4348 ## err p2t done 4356 ## err p2t done
4349 done 4357 done

yatex.org