diff options
author | unknown <walrus@mysql.com> | 2003-01-25 17:03:00 +0500 |
---|---|---|
committer | unknown <walrus@mysql.com> | 2003-01-25 17:03:00 +0500 |
commit | e1eb5d7c3c5723c4054d01e6c5e1ae6cc778db4f (patch) | |
tree | 413f8a55b201d22232d8089baecb78eb58d17f71 /sql-bench/test-insert.sh | |
parent | f9e1f8e2dc0b04d656eaaa3f61120ee5a0d16ec7 (diff) | |
download | mariadb-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.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',"; } |