inssimple
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- #
- # 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_Xactn";
- 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`;