diff options
Diffstat (limited to 'src/test/performance/sqls/inssimple')
-rw-r--r-- | src/test/performance/sqls/inssimple | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/src/test/performance/sqls/inssimple b/src/test/performance/sqls/inssimple new file mode 100644 index 00000000000..5e95a0489d8 --- /dev/null +++ b/src/test/performance/sqls/inssimple @@ -0,0 +1,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`; + |