aboutsummaryrefslogtreecommitdiff
path: root/src/test/performance/sqls/inssimple
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/performance/sqls/inssimple')
-rw-r--r--src/test/performance/sqls/inssimple29
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`;
+