parallel/testsuite/wanted-results/parallel-local-sql

echo '### --sqlandworker mysql'
### --sqlandworker mysql
  (sleep 2; parallel --sqlworker $MYSQLTBL sleep .3\;echo >$T1) &
  parallel --sqlandworker $MYSQLTBL sleep .3\;echo ::: {1..5} ::: {a..e} >$T2;   true sort -u $T1 $T2;   sql $MYSQL 'select * from parsql order by seq;'
Seq	Host	Starttime	JobRuntime	Send	Receive	Exitval	_Signal	Command	V1	V2	Stdout	Stderr
1	:999999NULL	4	0	0	sleep .3;echo 1 a	1	a	1 a\n	
2	:999999NULL	4	0	0	sleep .3;echo 1 b	1	b	1 b\n	
3	:999999NULL	4	0	0	sleep .3;echo 1 c	1	c	1 c\n	
4	:999999NULL	4	0	0	sleep .3;echo 1 d	1	d	1 d\n	
5	:999999NULL	4	0	0	sleep .3;echo 1 e	1	e	1 e\n	
6	:999999NULL	4	0	0	sleep .3;echo 2 a	2	a	2 a\n	
7	:999999NULL	4	0	0	sleep .3;echo 2 b	2	b	2 b\n	
8	:999999NULL	4	0	0	sleep .3;echo 2 c	2	c	2 c\n	
9	:999999NULL	4	0	0	sleep .3;echo 2 d	2	d	2 d\n	
999:999999NULL	4	0	0	sleep .3;echo 2 e	2	e	2 e\n	
999:999999NULL	4	0	0	sleep .3;echo 3 a	3	a	3 a\n	
999:999999NULL	4	0	0	sleep .3;echo 3 b	3	b	3 b\n	
999:999999NULL	4	0	0	sleep .3;echo 3 c	3	c	3 c\n	
999:999999NULL	4	0	0	sleep .3;echo 3 d	3	d	3 d\n	
999:999999NULL	4	0	0	sleep .3;echo 3 e	3	e	3 e\n	
999:999999NULL	4	0	0	sleep .3;echo 4 a	4	a	4 a\n	
999:999999NULL	4	0	0	sleep .3;echo 4 b	4	b	4 b\n	
999:999999NULL	4	0	0	sleep .3;echo 4 c	4	c	4 c\n	
999:999999NULL	4	0	0	sleep .3;echo 4 d	4	d	4 d\n	
999:999999NULL	4	0	0	sleep .3;echo 4 e	4	e	4 e\n	
999:999999NULL	4	0	0	sleep .3;echo 5 a	5	a	5 a\n	
999:999999NULL	4	0	0	sleep .3;echo 5 b	5	b	5 b\n	
999:999999NULL	4	0	0	sleep .3;echo 5 c	5	c	5 c\n	
999:999999NULL	4	0	0	sleep .3;echo 5 d	5	d	5 d\n	
999:999999NULL	4	0	0	sleep .3;echo 5 e	5	e	5 e\n	
echo '### --sqlandworker postgresql'
### --sqlandworker postgresql
  (sleep 2; parallel --sqlworker $PGTBL sleep .3\;echo >$T3) &
  parallel --sqlandworker $PGTBL sleep .3\;echo ::: {1..5} ::: {a..e} >$T4;   true sort -u $T3 $T4;   sql $PG 'select * from parsql order by seq;'
 seq | host |   starttime    | jobruntime | send | receive | exitval | _signal |      command      | v1 | v2 | stdout | stderr 
-----+------+----------------+------------+------+---------+---------+---------+-------------------+----+----+--------+--------
   1 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 a | 1  | a  | 1 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   2 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 b | 1  | b  | 1 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   3 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 c | 1  | c  | 1 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   4 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 d | 1  | d  | 1 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   5 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 e | 1  | e  | 1 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   6 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 a | 2  | a  | 2 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   7 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 b | 2  | b  | 2 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   8 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 c | 2  | c  | 2 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   9 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 d | 2  | d  | 2 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 e | 2  | e  | 2 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 a | 3  | a  | 3 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 b | 3  | b  | 3 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 c | 3  | c  | 3 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 d | 3  | d  | 3 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 e | 3  | e  | 3 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 a | 4  | a  | 4 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 b | 4  | b  | 4 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 c | 4  | c  | 4 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 d | 4  | d  | 4 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 e | 4  | e  | 4 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 a | 5  | a  | 5 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 b | 5  | b  | 5 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 c | 5  | c  | 5 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 d | 5  | d  | 5 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 e | 5  | e  | 5 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
(999rows)

echo '### --sqlandworker sqlite'
### --sqlandworker sqlite
  (sleep 2; parallel --sqlworker $SQLITETBL sleep .3\;echo >$T5) &
  parallel --sqlandworker $SQLITETBL sleep .3\;echo ::: {1..5} ::: {a..e} >$T6;   true sort -u $T5 $T6;   sql $SQLITE 'select * from parsql order by seq;'
Seq|Host|Starttime|JobRuntime|Send|Receive|Exitval|_Signal|Command|V1|V2|Stdout|Stderr
1|:|999|999||4|0|0|sleep .3;echo 1 a|1|a|1 a
|
2|:|999|999||4|0|0|sleep .3;echo 1 b|1|b|1 b
|
3|:|999|999||4|0|0|sleep .3;echo 1 c|1|c|1 c
|
4|:|999|999||4|0|0|sleep .3;echo 1 d|1|d|1 d
|
5|:|999|999||4|0|0|sleep .3;echo 1 e|1|e|1 e
|
6|:|999|999||4|0|0|sleep .3;echo 2 a|2|a|2 a
|
7|:|999|999||4|0|0|sleep .3;echo 2 b|2|b|2 b
|
8|:|999|999||4|0|0|sleep .3;echo 2 c|2|c|2 c
|
9|:|999|999||4|0|0|sleep .3;echo 2 d|2|d|2 d
|
999|:|999|999||4|0|0|sleep .3;echo 2 e|2|e|2 e
|
999|:|999|999||4|0|0|sleep .3;echo 3 a|3|a|3 a
|
999|:|999|999||4|0|0|sleep .3;echo 3 b|3|b|3 b
|
999|:|999|999||4|0|0|sleep .3;echo 3 c|3|c|3 c
|
999|:|999|999||4|0|0|sleep .3;echo 3 d|3|d|3 d
|
999|:|999|999||4|0|0|sleep .3;echo 3 e|3|e|3 e
|
999|:|999|999||4|0|0|sleep .3;echo 4 a|4|a|4 a
|
999|:|999|999||4|0|0|sleep .3;echo 4 b|4|b|4 b
|
999|:|999|999||4|0|0|sleep .3;echo 4 c|4|c|4 c
|
999|:|999|999||4|0|0|sleep .3;echo 4 d|4|d|4 d
|
999|:|999|999||4|0|0|sleep .3;echo 4 e|4|e|4 e
|
999|:|999|999||4|0|0|sleep .3;echo 5 a|5|a|5 a
|
999|:|999|999||4|0|0|sleep .3;echo 5 b|5|b|5 b
|
999|:|999|999||4|0|0|sleep .3;echo 5 c|5|c|5 c
|
999|:|999|999||4|0|0|sleep .3;echo 5 d|5|d|5 d
|
999|:|999|999||4|0|0|sleep .3;echo 5 e|5|e|5 e
|
echo '### --sqlandworker postgresql -S lo'
### --sqlandworker postgresql -S lo
  (sleep 2; parallel -S lo --sqlworker $PGTBL2 sleep .3\;echo >$T7) &
  parallel -S lo --sqlandworker $PGTBL2 sleep .3\;echo ::: {1..5} ::: {a..e} >$T8;   true sort -u $T7 $T8;   sql $PG 'select * from parsql2 order by seq;'
 seq | host |   starttime    | jobruntime | send | receive | exitval | _signal |      command      | v1 | v2 | stdout | stderr 
-----+------+----------------+------------+------+---------+---------+---------+-------------------+----+----+--------+--------
   1 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 a | 1  | a  | 1 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   2 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 b | 1  | b  | 1 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   3 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 c | 1  | c  | 1 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   4 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 d | 1  | d  | 1 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   5 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 e | 1  | e  | 1 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   6 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 a | 2  | a  | 2 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   7 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 b | 2  | b  | 2 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   8 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 c | 2  | c  | 2 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
   9 | lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 d | 2  | d  | 2 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 e | 2  | e  | 2 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 a | 3  | a  | 3 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 b | 3  | b  | 3 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 c | 3  | c  | 3 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 d | 3  | d  | 3 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 e | 3  | e  | 3 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 a | 4  | a  | 4 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 b | 4  | b  | 4 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 c | 4  | c  | 4 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 d | 4  | d  | 4 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 e | 4  | e  | 4 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 a | 5  | a  | 5 a   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 b | 5  | b  | 5 b   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 c | 5  | c  | 5 c   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 d | 5  | d  | 5 d   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
999| lo   |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 e | 5  | e  | 5 e   +| 
     |      |                |            |      |         |         |         |                   |    |    |        | 
(999rows)

echo '### --sqlandworker postgresql --results'
### --sqlandworker postgresql --results
  mkdir -p /tmp/out--sql
  (sleep 2; parallel --results /tmp/out--sql --sqlworker $PGTBL3 sleep .3\;echo >$T9) &
  parallel --results /tmp/out--sql --sqlandworker $PGTBL3 sleep .3\;echo ::: {1..5} ::: {a..e} >$T999;   true sort -u $T9 $T999;   sql $PG 'select * from parsql3 order by seq;'
 seq | host |   starttime    | jobruntime | send | receive | exitval | _signal |      command      | v1 | v2 |            stdout            |            stderr            
-----+------+----------------+------------+------+---------+---------+---------+-------------------+----+----+------------------------------+------------------------------
   1 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 a | 1  | a  | /tmp/out--sql/1/1/2/a/stdout | /tmp/out--sql/1/1/2/a/stderr
   2 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 b | 1  | b  | /tmp/out--sql/1/1/2/b/stdout | /tmp/out--sql/1/1/2/b/stderr
   3 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 c | 1  | c  | /tmp/out--sql/1/1/2/c/stdout | /tmp/out--sql/1/1/2/c/stderr
   4 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 d | 1  | d  | /tmp/out--sql/1/1/2/d/stdout | /tmp/out--sql/1/1/2/d/stderr
   5 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 e | 1  | e  | /tmp/out--sql/1/1/2/e/stdout | /tmp/out--sql/1/1/2/e/stderr
   6 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 a | 2  | a  | /tmp/out--sql/1/2/2/a/stdout | /tmp/out--sql/1/2/2/a/stderr
   7 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 b | 2  | b  | /tmp/out--sql/1/2/2/b/stdout | /tmp/out--sql/1/2/2/b/stderr
   8 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 c | 2  | c  | /tmp/out--sql/1/2/2/c/stdout | /tmp/out--sql/1/2/2/c/stderr
   9 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 d | 2  | d  | /tmp/out--sql/1/2/2/d/stdout | /tmp/out--sql/1/2/2/d/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 e | 2  | e  | /tmp/out--sql/1/2/2/e/stdout | /tmp/out--sql/1/2/2/e/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 a | 3  | a  | /tmp/out--sql/1/3/2/a/stdout | /tmp/out--sql/1/3/2/a/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 b | 3  | b  | /tmp/out--sql/1/3/2/b/stdout | /tmp/out--sql/1/3/2/b/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 c | 3  | c  | /tmp/out--sql/1/3/2/c/stdout | /tmp/out--sql/1/3/2/c/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 d | 3  | d  | /tmp/out--sql/1/3/2/d/stdout | /tmp/out--sql/1/3/2/d/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 e | 3  | e  | /tmp/out--sql/1/3/2/e/stdout | /tmp/out--sql/1/3/2/e/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 a | 4  | a  | /tmp/out--sql/1/4/2/a/stdout | /tmp/out--sql/1/4/2/a/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 b | 4  | b  | /tmp/out--sql/1/4/2/b/stdout | /tmp/out--sql/1/4/2/b/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 c | 4  | c  | /tmp/out--sql/1/4/2/c/stdout | /tmp/out--sql/1/4/2/c/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 d | 4  | d  | /tmp/out--sql/1/4/2/d/stdout | /tmp/out--sql/1/4/2/d/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 e | 4  | e  | /tmp/out--sql/1/4/2/e/stdout | /tmp/out--sql/1/4/2/e/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 a | 5  | a  | /tmp/out--sql/1/5/2/a/stdout | /tmp/out--sql/1/5/2/a/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 b | 5  | b  | /tmp/out--sql/1/5/2/b/stdout | /tmp/out--sql/1/5/2/b/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 c | 5  | c  | /tmp/out--sql/1/5/2/c/stdout | /tmp/out--sql/1/5/2/c/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 d | 5  | d  | /tmp/out--sql/1/5/2/d/stdout | /tmp/out--sql/1/5/2/d/stderr
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 e | 5  | e  | /tmp/out--sql/1/5/2/e/stdout | /tmp/out--sql/1/5/2/e/stderr
(999rows)

echo '### --sqlandworker postgresql --linebuffer'
### --sqlandworker postgresql --linebuffer
  (sleep 2; parallel --linebuffer --sqlworker $PGTBL4 sleep .3\;echo >$T999) &
  parallel --linebuffer --sqlandworker $PGTBL4 sleep .3\;echo ::: {1..5} ::: {a..e} >$T999;   true sort -u $T999$T999;   sql $PG 'select * from parsql4 order by seq;'
 seq | host |   starttime    | jobruntime | send | receive | exitval | _signal |      command      | v1 | v2 | stdout | stderr 
-----+------+----------------+------------+------+---------+---------+---------+-------------------+----+----+--------+--------
   1 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 a | 1  | a  |        | 
   2 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 b | 1  | b  |        | 
   3 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 c | 1  | c  |        | 
   4 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 d | 1  | d  |        | 
   5 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 1 e | 1  | e  |        | 
   6 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 a | 2  | a  |        | 
   7 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 b | 2  | b  |        | 
   8 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 c | 2  | c  |        | 
   9 | :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 d | 2  | d  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 2 e | 2  | e  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 a | 3  | a  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 b | 3  | b  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 c | 3  | c  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 d | 3  | d  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 3 e | 3  | e  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 a | 4  | a  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 b | 4  | b  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 c | 4  | c  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 d | 4  | d  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 4 e | 4  | e  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 a | 5  | a  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 b | 5  | b  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 c | 5  | c  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 d | 5  | d  |        | 
999| :    |999|999|      |       4 |       0 |       0 | sleep .3;echo 5 e | 5  | e  |        | 
(999rows)

echo '### --sqlandworker postgresql -u'
### --sqlandworker postgresql -u
  (sleep 2; parallel -u --sqlworker $PGTBL5 sleep .3\;echo >$T999) &
  parallel -u --sqlandworker $PGTBL5 sleep .3\;echo ::: {1..5} ::: {a..e} >$T999;   true sort -u $T999$T999;   sql $PG 'select * from parsql5 order by seq;'
 seq | host |   starttime    | jobruntime | send | receive | exitval | _signal |      command      | v1 | v2 | stdout | stderr 
-----+------+----------------+------------+------+---------+---------+---------+-------------------+----+----+--------+--------
   1 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 1 a | 1  | a  |        | 
   2 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 1 b | 1  | b  |        | 
   3 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 1 c | 1  | c  |        | 
   4 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 1 d | 1  | d  |        | 
   5 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 1 e | 1  | e  |        | 
   6 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 2 a | 2  | a  |        | 
   7 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 2 b | 2  | b  |        | 
   8 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 2 c | 2  | c  |        | 
   9 | :    |999|999|      |         |       0 |       0 | sleep .3;echo 2 d | 2  | d  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 2 e | 2  | e  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 3 a | 3  | a  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 3 b | 3  | b  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 3 c | 3  | c  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 3 d | 3  | d  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 3 e | 3  | e  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 4 a | 4  | a  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 4 b | 4  | b  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 4 c | 4  | c  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 4 d | 4  | d  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 4 e | 4  | e  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 5 a | 5  | a  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 5 b | 5  | b  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 5 c | 5  | c  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 5 d | 5  | d  |        | 
999| :    |999|999|      |         |       0 |       0 | sleep .3;echo 5 e | 5  | e  |        | 
(999rows)