`echo "" | time $FrontEnd`;

if ( $TestDBMS =~ /^pgsql/ )

{

`echo "CREATE TABLE simple (justint int);" | time $FrontEnd`;

}

if ( $TestDBMS =~ /^pgsql/ )

{

`echo "CREATE INDEX simpleidx ON simple (justint);" | time $FrontEnd`;

}

if ( $TestDBMS =~ /^pgsql/ )

{

`echo "DROP TABLE simple;" | time $FrontEnd`;

}

#

# 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`;