diff options
Diffstat (limited to 'sql-bench/test-insert.sh')
| -rw-r--r-- | sql-bench/test-insert.sh | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/sql-bench/test-insert.sh b/sql-bench/test-insert.sh index 38014f7cddf..b61ad00b557 100644 --- a/sql-bench/test-insert.sh +++ b/sql-bench/test-insert.sh @@ -112,7 +112,7 @@ do_many($dbh,$server->create("bench1", "id3 int NOT NULL", "dummy1 char(30)"], ["primary key (id,id2)", - "index index_id3 (id3)"])); + "index ix_id3 (id3)"])); if ($opt_lock_tables) { @@ -1289,9 +1289,9 @@ if (($opt_fast || $opt_fast_insert) && $server->{'limits'}->{'insert_multi_value { $id= $i & 127; $rand=$random[$i]; - $tmp="($id,$id,$rand," . ($i & 32766) . ",'ABCDEF$rand',0,"; + $tmp="($id,$id,$rand," . ($i & 32766) . ",'ABCDEF$rand',0,$rand,$rand.0,"; - for ($j=6; $j <= $fields ; $j++) + for ($j=8; $j <= $fields ; $j++) { $tmp.= ($types[$j] == 0) ? "$rand," : "'$rand',"; } @@ -1315,9 +1315,9 @@ else $id= $i & 127; $rand=$random[$i]; $query="insert into bench1 values ($id,$id,$rand," . ($i & 32767) . - ",'ABCDEF$rand',0,"; + ",'ABCDEF$rand',0,$rand,$rand.0,"; - for ($j=6; $j <= $fields ; $j++) + for ($j=8; $j <= $fields ; $j++) { $query.= ($types[$j] == 0) ? "$rand," : "'$rand',"; } |