mirror of
https://github.com/MariaDB/server.git
synced 2025-01-15 19:42:28 +01:00
9ff04fe526
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.
35 lines
1.5 KiB
PHP
35 lines
1.5 KiB
PHP
################ include/ps_renew.inc #################
|
|
# #
|
|
# renew the content of t1 and t9 #
|
|
# #
|
|
#######################################################
|
|
|
|
# truncate could not be used, because it is not supported
|
|
# in tables of type MERGE
|
|
delete from t1 ;
|
|
insert into t1 values (1,'one');
|
|
insert into t1 values (2,'two');
|
|
insert into t1 values (3,'three');
|
|
insert into t1 values (4,'four');
|
|
commit ;
|
|
|
|
delete from t9 ;
|
|
insert into t9
|
|
set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
|
|
c10= 1, c11= 1, c12 = 1,
|
|
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
|
|
c16= '11:11:11', c17= '2004',
|
|
c18= 1, c19=true, c20= 'a', c21= '123456789a',
|
|
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
|
|
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
|
|
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
|
|
insert into t9
|
|
set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
|
|
c10= 9, c11= 9, c12 = 9,
|
|
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
|
|
c16= '11:11:11', c17= '2004',
|
|
c18= 1, c19=false, c20= 'a', c21= '123456789a',
|
|
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
|
|
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
|
|
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
|
|
commit ;
|