src/test/performance/sqls/inssimple


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
30

# $PostgreSQL: pgsql/src/test/performance/sqls/inssimple,v 1.2 2006/03/11 04:38:41 momjian Exp $
#
# 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`;