Lines Matching refs:dbh
99 $dbh = $server->connect();
108 $dbh->do("drop table bench1" . $server->{'drop_attr'});
109 $dbh->do("drop table bench2" . $server->{'drop_attr'});
110 $dbh->do("drop table bench3" . $server->{'drop_attr'});
111 do_many($dbh,$server->create("bench1",
121 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
141 $dbh->{AutoCommit} = 0;
160 $sth = $dbh->do(substr($res,0,length($res)-1)) or die $DBI::errstr;
175 $sth = $dbh->do(substr($res,0,length($res)-1)) or die $DBI::errstr;
190 $sth = $dbh->do(substr($res,0,length($res)-1)) or die $DBI::errstr;
194 $sth = $dbh->do(substr($res,0,length($res)-1)) or die $DBI::errstr;
201 $sth = $dbh->do($query . "($i,$i,$i,'ABCDEFGHIJ')") or die $DBI::errstr;
207 $sth = $dbh->do($query . "(" . ($total_rows-1-$i) . "," .
217 $sth = $dbh->do($query . "(". $random[$i] . "," . $random[$i] .
224 $dbh->commit;
225 $dbh->{AutoCommit} = 1;
234 $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr;
238 $server->vacuum(1,\$dbh,"bench1");
242 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
256 $dbh->{AutoCommit} = 0;
264 if ($dbh->do($tmpquery))
271 $dbh->commit;
272 $dbh->{AutoCommit} = 1;
297 $sth = $dbh->prepare($query);
315 $sth = $dbh->prepare($query);
347 if (($found_rows=fetch_all_rows($dbh,"select id from bench1")) !=
370 $rows+=fetch_all_rows($dbh,"select id,id2 from bench1 order by id,id2",1);
387 $rows+=fetch_all_rows($dbh,"select id,id2 from bench1 order by id desc, id2 desc",1);
404 $rows+=fetch_all_rows($dbh,"select id from bench1 order by id desc",1);
421 $rows+=fetch_all_rows($dbh,"select id3 from bench1 order by id3",1);
439 $rows+=fetch_all_rows($dbh,"select $sel from bench1 order by id3",1);
457 $rows+=fetch_all_rows($dbh,"select $sel from bench1 order by id2,id3",1);
477 …$rows+=fetch_all_rows($dbh,"select $sel from bench1 where id>=$start and id <= $end order by id3",…
496 …$rows+=fetch_all_rows($dbh,"select $sel from bench1 where id>=$start and id <= $end order by id",1…
515 …$rows+=fetch_all_rows($dbh,"select $sel from bench1 where id3>=$start and id3 <= $end order by id3…
540 $rows+=fetch_all_rows($dbh,"select id2 from bench1 where id=$rnd or id3=$rnd2",1);
630 $sth=$dbh->prepare($query="select count(*) from bench1") or die $DBI::errstr;
640 fetch_all_rows($dbh,"select min(id) from bench1");
641 fetch_all_rows($dbh,"select max(id) from bench1");
642 fetch_all_rows($dbh,"select sum(id+0.0) from bench1");
643 fetch_all_rows($dbh,"select min(id3),max(id3),sum(id3-0.0) from bench1");
646 fetch_all_rows($dbh,"select min(dummy1),max(dummy1) from bench1");
649 $sth=$dbh->prepare($query="select count(*) from bench1 where id >= " .
659 …$sth=$dbh->prepare($query="select count(*),sum(id+0.0),min(id),max(id),avg(id-0.0) from bench1") o…
682 …if (fetch_all_rows($dbh,$query=$server->query("select $tmp as last_digit,count(*) from bench1 grou…
687 …if (fetch_all_rows($dbh,$query=$server->query("select $tmp,count(*) from bench1 group by 1")) != 1…
697 …if (fetch_all_rows($dbh, $query="select id,id3,dummy1 from bench1 where id < 100+$count-$count gro…
715 fetch_all_rows($dbh,"select min(id) from bench1");
716 fetch_all_rows($dbh,"select max(id) from bench1");
717 fetch_all_rows($dbh,"select min(id2) from bench1 where id=$tests");
718 fetch_all_rows($dbh,"select max(id2) from bench1 where id=$tests");
721 fetch_all_rows($dbh,"select min(dummy1) from bench1 where id=$tests");
722 fetch_all_rows($dbh,"select max(dummy1) from bench1 where id=$tests");
740 fetch_all_rows($dbh,"select min(id2) from bench1");
741 fetch_all_rows($dbh,"select max(id2) from bench1");
742 fetch_all_rows($dbh,"select min(id3) from bench1 where id2=$tests");
743 fetch_all_rows($dbh,"select max(id3) from bench1 where id2=$tests");
746 fetch_all_rows($dbh,"select min(dummy1) from bench1 where id2=$tests");
747 fetch_all_rows($dbh,"select max(dummy1) from bench1 where id2=$tests");
766 fetch_all_rows($dbh,"select count(id) from bench1 where id < $tests");
777 fetch_all_rows($dbh,"select count(dummy1) from bench1 where id2 < $tests");
790 fetch_all_rows($dbh,"select count(distinct dummy1) from bench1");
791 fetch_all_rows($dbh,"select dummy1,count(distinct id) from bench1 group by dummy1");
808 $dbh->disconnect; # close connection
809 $dbh = $server->connect();
825 $sth = $dbh->do("update bench1 set id3=-$tmp where id3=$tmp") or die $DBI::errstr;
834 do_query($dbh,"UNLOCK TABLES");
838 $server->vacuum(1,\$dbh,"bench1");
842 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
847 $dbh->disconnect; # close connection
848 $dbh = $server->connect();
857 $sth=$dbh->do("update bench1 set id3= 0-id3 where id3 >= 0 and id3 <= $i") or die $DBI::errstr;
862 $dbh->disconnect; # close connection
863 $dbh = $server->connect();
866 …$sth=$dbh->do("update bench1 set id3= 0-id3 where id3 >= 0 and id3 < $opt_loop_count") or die $DBI…
870 $dbh->disconnect; # close connection
871 $dbh = $server->connect();
874 …$sth=$dbh->do("update bench1 set id3= 0-id3 where id3 >= $opt_loop_count and id3 < ". ($opt_loop_c…
883 $dbh->disconnect; # close connection
884 $dbh = $server->connect();
887 if (($sth=$dbh->prepare("select count(*) from bench1 where id3>=0"))
901 $dbh->disconnect; # close connection
902 $dbh = $server->connect();
908 $sth=$dbh->do($query="update bench1 set id3=$func where id3<0") or die $DBI::errstr;
921 $sth=$dbh->prepare("select id3 from bench1 where id3 >= 0") or die $DBI::errstr;
927 my $sth1 = $dbh->do("update bench1 set id3 = $tmp1 where id3 = $tmp[0]");
940 if (fetch_all_rows($dbh,$query="select * from bench1 where id3>=0") != 1)
948 $sth=$dbh->prepare("select id3 from bench1 where id3 < 0") or die $DBI::errstr;
954 my $sth1 = $dbh->do("update bench1 set id3 = $tmp1 where id3 = $tmp[0]");
972 do_query($dbh,"UNLOCK TABLES");
974 $server->vacuum(1,\$dbh,"bench1");
977 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
989 $sth = $dbh->do("update bench1 set dummy1='updated' where id=$i and id2=$i") or die $DBI::errstr;
1000 $sth = $dbh->do("update bench1 set dummy1='updated' where id=$i and id2=$i") or die $DBI::errstr;
1011 $sth = $dbh->do("update bench1 set dummy1='really updated' where id=$i") or die $DBI::errstr;
1027 $sth = $dbh->do("update bench1 set dummy1='updated $i'") or die $DBI::errstr;
1042 $sth = $dbh->do("LOCK TABLES bench1 a READ, bench1 b READ") || die $DBI::errstr;
1049 …$count+=fetch_all_rows($dbh,"select count(*) from bench1 as a left outer join bench1 as b on (a.id…
1059 …$count+=fetch_all_rows($dbh,"select count(a.dummy1),count(b.dummy1) from bench1 as a left outer jo…
1069 …$count+=fetch_all_rows($dbh,"select count(a.dummy1),count(b.dummy1) from bench1 as a left outer jo…
1079 …$count+=fetch_all_rows($dbh,"select count(a.dummy1),count(b.dummy1) from bench1 as a left outer jo…
1094 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
1100 $dbh->disconnect; # close connection
1101 $dbh = $server->connect();
1112 $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr;
1115 do_many($dbh,$server->create("bench2",
1123 $sth = $dbh->do("LOCK TABLES bench1 READ, bench2 WRITE") ||
1131 $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr;
1133 $sth = $dbh->do("DROP TABLE bench2" . $server->{'drop_attr'}) ||
1137 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
1149 $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr;
1152 do_many($dbh,$server->create("bench2",
1158 do_many($dbh,$server->create("bench3",
1166 $sth = $dbh->do("INSERT INTO bench2 SELECT * from bench1") ||
1172 $sth = $dbh->do("INSERT INTO bench3 SELECT * from bench1") ||
1178 $sth = $dbh->do("DROP TABLE bench2" . $server->{'drop_attr'}) ||
1180 $sth = $dbh->do("DROP TABLE bench3" . $server->{'drop_attr'}) ||
1188 $server->vacuum(1,\$dbh);
1192 $dbh->disconnect; # close connection
1193 $dbh = $server->connect();
1197 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
1214 $dbh->do("delete from bench1 where id3=$tmp") or die $DBI::errstr;
1223 $dbh->disconnect; # close connection
1224 $dbh = $server->connect();
1231 $sth=$dbh->do("delete from bench1 where id3 >= 0 and id3 <= $i") or die $DBI::errstr;
1237 $dbh->disconnect; # close connection
1238 $dbh = $server->connect();
1240 $sth=$dbh->do("delete from bench1 where id3 >= 0 and id3 <= $opt_loop_count") or die $DBI::errstr;
1243 $dbh->disconnect; # close connection
1244 $dbh = $server->connect();
1247 …$sth=$dbh->do("delete from bench1 where id >= $opt_loop_count and id <= " . ($opt_loop_count*2) ) …
1251 $dbh->disconnect; # close connection
1252 $dbh = $server->connect();
1256 $sth=$dbh->do("delete from bench1") or die $DBI::errstr;
1260 $sth = $dbh->do("delete from bench1 where id3 < " . ($total_rows)) or die $DBI::errstr;
1269 $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr;
1271 $sth = $dbh->do("drop table bench1" . $server->{'drop_attr'}) or die $DBI::errstr;
1276 $dbh->disconnect; # close connection
1277 $dbh = $server->connect();
1281 $server->vacuum(1,\$dbh);
1328 do_many($dbh,$server->create("bench1",\@fields,\@keys));
1331 $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
1336 $dbh->disconnect; # close connection
1337 $dbh = $server->connect();
1343 $dbh->{AutoCommit} = 0;
1369 $sth = $dbh->do(substr($res,0,length($res)-1)) or die $DBI::errstr;
1373 $sth = $dbh->do(substr($res,0,length($res)-1)) or die $DBI::errstr;
1390 $dbh->do($query) or die "Got error $DBI::errstr with query: $query\n";
1396 $dbh->commit;
1397 $dbh->{AutoCommit} = 1;
1406 $dbh->disconnect; # close connection
1407 $dbh = $server->connect();
1413 do_query($dbh,"UNLOCK TABLES");
1415 $server->vacuum(1,\$dbh,"bench1");
1418 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
1431 $dbh->{AutoCommit} = 0;
1436 $dbh->do("update bench1 set field5=1 where field_search=$i")
1442 $dbh->commit;
1443 $dbh->{AutoCommit} = 1;
1452 $dbh->disconnect; # close connection
1453 $dbh = $server->connect();
1459 do_query($dbh,"UNLOCK TABLES");
1461 $server->vacuum(1,\$dbh,"bench1");
1464 $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr;
1470 $dbh->disconnect; # close connection
1471 $dbh = $server->connect();
1485 $dbh->do("delete from bench1 where field_search = $i") or die $DBI::errstr;
1494 $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr;
1503 $dbh->do($query) or die $DBI::errstr;
1507 $dbh->do("delete from bench1 where field1 > 0") or die $DBI::errstr;
1514 $sth = $dbh->do("drop table bench1" . $server->{'drop_attr'}) or die $DBI::errstr;
1517 $server->vacuum(1,\$dbh);
1528 $sth = $dbh->do("drop table bench1" . $server->{'drop_attr'});
1529 do_many($dbh,$server->create("bench1",
1541 $sth = $dbh->do("LOCK TABLES bench1 write") || die $DBI::errstr;
1545 $dbh->{AutoCommit} = 0;
1560 do_query($dbh,substr($res,0,length($res)-1));
1564 do_query($dbh,substr($res,0,length($res)-1));
1568 $sth = $dbh->do("UNLOCK TABLES ") || die $DBI::errstr;
1572 $dbh->commit;
1573 $dbh->{AutoCommit} = 1;
1582 $sth = $dbh->do("UNLOCK TABLES ") || die $DBI::errstr;
1587 $sth = $dbh->do("drop table bench1" . $server->{'drop_attr'}) or die $DBI::errstr;
1597 $dbh->disconnect; # close connection
1622 fetch_all_rows($dbh,"select $sel_columns from bench1 where $column=$tmp")
1625 …defined($row_count=fetch_all_rows($dbh,"select $sel_columns from bench1 where $column=$tmp")) or d…
1654 fetch_all_rows($dbh,"select $sel_columns from bench1 where $column=$tmp and $column2=$tmp")
1657 …defined($row_count=fetch_all_rows($dbh,"select $sel_columns from bench1 where $column=$tmp and $co…
1691 if (($row_count=fetch_all_rows($dbh,$query)) != $rows)
1751 ($rows=fetch_all_rows($dbh,$query . $or_part)) or die $DBI::errstr;
1760 fetch_all_rows($dbh,$query . $in_part) or die $DBI::errstr;
1764 defined(($rows=fetch_all_rows($dbh,"$query($or_part) and $column < 10"))) or die $DBI::errstr;
1800 $dbh->do("insert into $t2 values($i)") or die $DBI::errstr;
1804 $server->vacuum(1,\$dbh,"bench1");
1808 "select_in", $query, $dbh,
1812 $dbh, $range_loop_count);