WL#6934: Migrate main suite to run with innodb storage engine - Change tests only having diff in engine values

Status: Complete   —   Priority: Medium

This created as subtask of "Migrate main suite to run with innodb storage
engine" (wl6923)

With this WL , we change tests having result difference in engine values only.

e.g differnce as follow

CURRENT_TEST: main.bigint
---
/export/home2/vfisreka/main_suite/mysql-advanced-5.7.2-m12-linux-glibc2.5-x86_64/mysql-test/r/bigint.result
2013-03-10 13:29:03.000000000 +0300
+++
/export/home2/vfisreka/main_suite/mysql-advanced-5.7.2-m12-linux-glibc2.5-x86_64/mysql-test/var/log/bigint.reject
  2013-03-11 08:06:29.283784681 +0300
@@ -181,14 +181,14 @@
 Table  Create Table
 t1     CREATE TABLE `t1` (
   `a` int(1) NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 drop table t1;
 create table t1 select 9223372036854775809 as 'a';
 show create table t1;
 Table  Create Table
 t1     CREATE TABLE `t1` (
   `a` bigint(19) unsigned NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
Difference in engine value is mostly due to "show create table".

We can store default engine value and replace with generic string for "show
create table". This is allow us to suppress diff due to engine value and will
allow us to run with default engine innodb or mysiam.

e.g
# get default engine value
--let $DEFAULT_ENGINE = `select @@global.default_storage_engine`
--replace_result $DEFAULT_ENGINE ENGINE
show create table t1;


Test with diff in only engine values are - 
main.type_timestamp_explicit
main.type_timestamp
main.lowercase_table
main.ps_2myisam
main.ps_4heap
main.ps_5merge
main.func_misc
main.ansi
main.bigint
main.binary
main.cast
main.constraints
main.create_not_windows
main.ctype_collate
main.ctype_cp1250_ch
main.ctype_create
main.ctype_eucjpms
main.ctype_many
main.ctype_recoding
main.func_gconcat
main.func_system
main.func_weight_string
main.grant
main.partition_mgm_err
main.partition_utf8
main.sql_mode
main.synchronization
main.tablespace
main.temporal_literal
main.type_binary
main.type_decimal
main.type_enum
main.type_float
main.type_nchar
main.type_newdecimal
main.type_set


Test with diff in only engine value and some additional diff in (warning/error 
message) which can be changed.(with other wl)
main.ctype_big5 //warning
main.ctype_binary // diff in one EXPLAIN 
main.ctype_gb2312 // warning innodb file format
main.func_math // diff in error message , ERROR 22003: BIGINT value is out of
range in
main.parser // diff in error message iwth engine name 
main.type_temporal_fractional // only one warning check for space 
main.ctype_sjis // supress requires innodb_file_format > Antelope
main.ctype_tis620 // only warning
main.ctype_uca //supress explian
main.ctype_ujis / supress warning
main.ctype_utf8mb4_heap // supress warning
main.ctype_gbk // supress requires innodb_file_format > Antelope
main.ctype_latin1 // supress requires innodb_file_format > Antelope
main.ctype_euckr //warning
main.ctype_cp1251 // suppress one column of explain 

// diff in set storage engine values
main.wl6219-csv
main.wl6219-innodb
main.wl6219-memory
main.wl6219-merge
main.wl6219-myisam

#-----------------------------------------------------
vinayf@vinayf-laptop:~/repo/branches/test/mysql-trunk-wl6923$ bzr push
bzr+ssh://vfisreka@myrepo.no.oracle.com/bzrroot/server/mysql-trunk-wl6923/
Generating post-push message                                                   
                                                                               
              
Sending post-push message
Sending to COMMITS@LISTS.MYSQL.COM
Do not want a bundle on commit email (reason: useless for push emails).
Pushed up to revision 5269.

modified mysql-test/t/binary.test
modified mysql-test/r/type_nchar.result
modified mysql-test/include/ps_conv.inc
modified mysql-test/r/tablespace.result
modified mysql-test/t/constraints.test
modified mysql-test/r/ps_4heap.result
modified mysql-test/t/tablespace.test
modified mysql-test/t/create_not_windows.test
modified mysql-test/t/type_binary.test
modified mysql-test/t/func_weight_string.test
modified mysql-test/r/type_enum.result
modified mysql-test/t/bigint.test
modified mysql-test/r/ctype_many.result
modified mysql-test/r/type_decimal.result
modified mysql-test/r/type_timestamp.result
modified mysql-test/r/create_not_windows.result
modified mysql-test/r/func_system.result
modified mysql-test/r/type_newdecimal.result
modified mysql-test/suite/ndb/r/ps_7ndb.result
modified mysql-test/t/func_gconcat.test
modified mysql-test/t/func_system.test
modified mysql-test/t/cast.test
modified mysql-test/t/type_float.test
modified mysql-test/r/func_misc.result
modified mysql-test/r/partition_utf8.result
modified mysql-test/r/type_set.result
modified mysql-test/r/partition_mgm_err.result
modified mysql-test/r/ctype_eucjpms.result
modified mysql-test/r/ps_2myisam.result
modified mysql-test/r/ps_5merge.result
modified mysql-test/t/ps_2myisam.test
modified mysql-test/r/func_weight_string.result
modified mysql-test/t/sql_mode.test
modified mysql-test/t/ansi.test
modified mysql-test/t/synchronization.test
modified mysql-test/r/type_float.result
modified mysql-test/t/type_enum.test
modified mysql-test/t/ctype_create.test
modified mysql-test/r/cast.result
modified mysql-test/t/lowercase_table.test
modified mysql-test/r/constraints.result
modified mysql-test/t/type_timestamp_explicit.test
modified mysql-test/r/type_binary.result
modified mysql-test/r/ps_3innodb.result
modified mysql-test/t/partition_utf8.test
modified mysql-test/r/temporal_literal.result
modified mysql-test/t/ctype_collate.test
modified mysql-test/r/type_timestamp_explicit.result
modified mysql-test/r/ctype_collate.result
modified mysql-test/r/bigint.result
modified mysql-test/r/ctype_create.result
modified mysql-test/r/binary.result
modified mysql-test/t/partition_mgm_err.test
modified mysql-test/t/ps_5merge.test
modified mysql-test/t/ctype_eucjpms.test
modified mysql-test/t/ctype_recoding.test
modified mysql-test/r/lowercase_table.result
modified mysql-test/t/type_decimal.test
modified mysql-test/t/type_nchar.test
modified mysql-test/t/func_misc.test
modified mysql-test/r/func_gconcat.result
modified mysql-test/r/synchronization.result
modified mysql-test/t/type_newdecimal.test
modified mysql-test/r/sql_mode.result
modified mysql-test/r/ansi.result
modified mysql-test/t/ctype_many.test
modified mysql-test/t/temporal_literal.test
modified mysql-test/t/ps_4heap.test
modified mysql-test/r/ctype_recoding.result
modified mysql-test/r/ps_w_max_indexes_64.result
modified mysql-test/t/type_set.test
modified mysql-test/t/type_timestamp.test