Mercurial > hgrepos > hgweb.cgi > s4
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 |