Results of WL#1856 "Conversion of client_test.c tests cases to mysqltest

if possible"
        - many new test cases
        - more and improved comments
      New files: t/ps_7ndb.test       test suite for NDB tables
                 r/ps_7ndb.result     expected results
                 include/ps_conv.inc  conversion test cases
+ review comments and fixes.


mysql-test/include/ps_create.inc:
  Rename of t_many_col_types -> t9
mysql-test/include/ps_modify.inc:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Rename: t_many_col_types -> t9
  Cleanups and comments.
  New test cases (derived from client_test.c)
mysql-test/include/ps_modify1.inc:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Rename: t_many_col_types -> t9
  Cleanups and comments.
  New test cases (derived from client_test.c)
mysql-test/include/ps_query.inc:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Rename: t_many_col_types -> t9
  Cleanups and comments.
  New test cases (derived from client_test.c)
mysql-test/include/ps_renew.inc:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Rename: t_many_col_types -> t9
mysql-test/r/ps_1general.result:
  Results updated.
mysql-test/r/ps_2myisam.result:
  Resutls updated.
mysql-test/r/ps_3innodb.result:
  Results updated.
mysql-test/r/ps_4heap.result:
  Results updated.
mysql-test/r/ps_5merge.result:
  Results updated.
mysql-test/r/ps_6bdb.result:
  Results updated.
mysql-test/t/ps_1general.test:
  WL#1856 "Conversion of client_test.c tests cases to mysqltest if
   possible": new test cases added.
mysql-test/t/ps_2myisam.test:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Call of file include/ps_conv.inc (with new test cases) and 
  fulltext test case added.
mysql-test/t/ps_3innodb.test:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Call of file include/ps_conv.inc (with new test cases) added.
mysql-test/t/ps_4heap.test:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Call of file include/ps_conv.inc (with new test cases) added.
mysql-test/t/ps_5merge.test:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
  Call of file include/ps_conv.inc (with new test cases) added.
mysql-test/t/ps_6bdb.test:
  WL#1856 Conversion of client_test.c tests cases to mysqltest if possible.
  Call of file include/ps_conv.inc (with new test cases) added.

1 files changed, 11 insertions, 9 deletions

diff --git a/mysql-test/t/ps_5merge.test b/mysql-test/t/ps_5merge.test
index ff48a50f331..9a79842709c 100644
--- a/mysql-test/t/ps_5merge.test
+++ b/mysql-test/t/ps_5merge.test
@@ -12,13 +12,13 @@ use test;
 
 --disable_warnings
 drop table if exists t1, t1_1, t1_2,
-     t_many_col_types, t_many_col_types_1, t_many_col_types_2;
+     t9, t9_1, t9_2;
 --enable_warnings
 let $type= 'MYISAM' ;
 -- source include/ps_create.inc
-rename table t1 to t1_1, t_many_col_types to t_many_col_types_1 ;
+rename table t1 to t1_1, t9 to t9_1 ;
 -- source include/ps_create.inc
-rename table t1 to t1_2, t_many_col_types to t_many_col_types_2 ;
+rename table t1 to t1_2, t9 to t9_2 ;
 
 create table t1
 (
@@ -26,7 +26,7 @@ create table t1
   primary key(a)
 ) ENGINE = MERGE UNION=(t1_1,t1_2)
 INSERT_METHOD=FIRST;
-create table t_many_col_types
+create table t9
 (
   c1  tinyint, c2  smallint, c3  mediumint, c4  int,
   c5  integer, c6  bigint, c7  float, c8  double,
@@ -38,7 +38,7 @@ create table t_many_col_types
   c29 longblob, c30 longtext, c31 enum('one', 'two', 'three'),
   c32 set('monday', 'tuesday', 'wednesday'),
   primary key(c1)
-)  ENGINE = MERGE UNION=(t_many_col_types_1,t_many_col_types_2)
+)  ENGINE = MERGE UNION=(t9_1,t9_2)
 INSERT_METHOD=FIRST;
 -- source include/ps_renew.inc
 
@@ -47,16 +47,17 @@ INSERT_METHOD=FIRST;
 # no test of ps_modify1, because insert .. select 
 # is not allowed on MERGE tables
 # -- source include/ps_modify1.inc
+-- source include/ps_conv.inc
 
 # Lets's try the same tests with INSERT_METHOD=LAST
-drop table t1, t_many_col_types ;
+drop table t1, t9 ;
 create table t1
 (
   a int, b varchar(30),
   primary key(a)
 ) ENGINE = MERGE UNION=(t1_1,t1_2)
 INSERT_METHOD=LAST;
-create table t_many_col_types
+create table t9
 (
   c1  tinyint, c2  smallint, c3  mediumint, c4  int,
   c5  integer, c6  bigint, c7  float, c8  double,
@@ -68,7 +69,7 @@ create table t_many_col_types
   c29 longblob, c30 longtext, c31 enum('one', 'two', 'three'),
   c32 set('monday', 'tuesday', 'wednesday'),
   primary key(c1)
-)  ENGINE = MERGE UNION=(t_many_col_types_1,t_many_col_types_2)
+)  ENGINE = MERGE UNION=(t9_1,t9_2)
 INSERT_METHOD=LAST;
 -- source include/ps_renew.inc
 
@@ -77,6 +78,7 @@ INSERT_METHOD=LAST;
 # no test of ps_modify1, because insert .. select
 # is not allowed on MERGE tables
 # -- source include/ps_modify1.inc
+-- source include/ps_conv.inc
 
 drop table t1, t1_1, t1_2, 
-           t_many_col_types_1, t_many_col_types_2, t_many_col_types;
+           t9_1, t9_2, t9;