summaryrefslogtreecommitdiff
path: root/sql-bench/test-insert.sh
diff options
context:
space:
mode:
authorunknown <walrus@mysql.com>2003-01-25 17:03:00 +0500
committerunknown <walrus@mysql.com>2003-01-25 17:03:00 +0500
commite1eb5d7c3c5723c4054d01e6c5e1ae6cc778db4f (patch)
tree413f8a55b201d22232d8089baecb78eb58d17f71 /sql-bench/test-insert.sh
parentf9e1f8e2dc0b04d656eaaa3f61120ee5a0d16ec7 (diff)
downloadmariadb-git-e1eb5d7c3c5723c4054d01e6c5e1ae6cc778db4f.tar.gz
Change bench files for mimer compability, change crash-me for correct testing time datafields
sql-bench/crash-me.sh: rectify mimer section sql-bench/server-cfg.sh: - Add parameter time_format_inresult - add parameters time_format_ISO, time_format_EUR, time_format_USA, time_format_HHMMSS, time_format_HHHHMMSS - changed sub version() for mysql in the server-cfg, that version shows if client connects with SSL - made --verbose by default - paramters func_extra_time_to_sec, ..sec_to_time, ..addtime, ..subtime, ..timediff, ..maketime, ..time, func_odbc_hour, ..hour_time, ...minute, ...second now uses time formats, that understandable for DBMS sql-bench/test-insert.sh: some changes for mimer compability sql-bench/test-select.sh: some changes for mimer compability
Diffstat (limited to 'sql-bench/test-insert.sh')
-rw-r--r--sql-bench/test-insert.sh10
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',";
}