blob: 5e95a0489d8c43d708db54b778e5f5e190d9d690 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
#
# Transactions are unsupported by MySQL - so for insertion of
# 8192 rows, 1 INSERT per Xaction, we returned "Transactions unsupported"
#
if ( $TestDBMS =~ /^mysql/ && $XACTBLOCK eq '' )
{
print STDERR " No_Xact\n";
return;
}
`> .sqlf`; # clean file
#
# PgSQL specific: if all queries from inssimple.data must be executed in
# single xaction ($XACTBLOCK ne '') then add BEGIN/END arround queries
#
`echo "BEGIN;" >> .sqlf` if ( $TestDBMS =~ /^pgsql/ && $XACTBLOCK ne '' );
`cat sqls/inssimple.data >> .sqlf`;
# PgSQL (see above)
`echo "END;" >> .sqlf` if ( $TestDBMS =~ /^pgsql/ && $XACTBLOCK ne '' );
# Ok - run queries
`time $FrontEnd < .sqlf`;
|
