diff options
author | unknown <hhunger@hh-nb.hungers> | 2007-02-06 19:07:48 +0100 |
---|---|---|
committer | unknown <hhunger@hh-nb.hungers> | 2007-02-06 19:07:48 +0100 |
commit | 630091fed42e48df481d67835e48cb98cb863ae7 (patch) | |
tree | 1f3a82ed5e90d7c7be80041002990f6372f5dce9 /mysql-test/suite/funcs_1/README.txt | |
parent | 9bb750f5e8ddbf2b400d43f9e1799793f6ed42ce (diff) | |
download | mariadb-git-630091fed42e48df481d67835e48cb98cb863ae7.tar.gz |
copy from test-extra-5.0 to main tree
BitKeeper/etc/ignore:
Added mysql-test/mysql-test-run-shell to the ignore list
mysql-test/suite/funcs_2/include/check_charset.inc:
finished files with newline
Diffstat (limited to 'mysql-test/suite/funcs_1/README.txt')
-rw-r--r-- | mysql-test/suite/funcs_1/README.txt | 112 |
1 files changed, 112 insertions, 0 deletions
diff --git a/mysql-test/suite/funcs_1/README.txt b/mysql-test/suite/funcs_1/README.txt new file mode 100644 index 00000000000..4661864cf5e --- /dev/null +++ b/mysql-test/suite/funcs_1/README.txt @@ -0,0 +1,112 @@ +Matthias 17.06.2005 +------------------- +1. I changed the database test1 (dropped + created in SP test) + to test4. + Please adjust the SP test cases. +2. There is a difference between my definition of + innodb_tb4 + memory_tb4 + to the latest table definition used by disha. + Please adjust the table definition if needed. +3. The data load files are product of the Disha data generation script + (downloaded ~20 May ?) + modified by Omer + These load data fit fairly to the table definitions. + +4. How to execute the "small" test with 10 rows per table. + Do NOT set the environment variable NO_REFRESH to a + value <> ''. + Start the test for example by + ./mysql-test-run.pl --vardir=/dev/shm/var \ + --force --suite=funcs_1 --do-test=myisam + The "result" files fit mostly to this variant. + + Any database not in ('mysql','test') and any tables + needed within a testcase ( t/<storage engine>_<test filed>.test ) + will be (re)created at the beginning of the test. + +5. How to execute the "big" test with many rows per table. + Replace the directories + suite/funcs_1/data and + suite/funcs_1/r + with the appropriate ones for the "big" test. + Set the environment variable NO_REFRESH to a value <> ''. + Start the test for example by + ./mysql-test-run.pl --vardir=/dev/shm/var \ + --force --suite=funcs_1 --do-test=myisam + + All databases and tables will be (re)created by the script + <storage engine>__load.test . + +6. I am not sure of the files + ./funcs_1/include/create_<whatever>.inc + are in the moment needed. I included them, because I + guess my VIEW testcase example needs them. + +I guess the pushed files are far away from being perfect. +It is a 8 hours hack. +Please try them, create missing files and come up with improvements. + +Good luck ! + +Matthias 17.06.2005 +=================================================================== +Omer 19.06.2005 +--------------- +1. Changed the structure of the memory_tb3 table to include two + additional column f121, f122. These columns exist for the table in + the other storage engines as TEXT. Since memory does not support + TEXT, Disha did not include them. How ever I am using them in the + Trigger tests so added them to the memory definition as CHAR(50);. + Also modifyed the DataGen_modiy.pl file to account for these two + column when generating the data. + - checked in a new DataGen_modify.pl (create a 'lib' directory + under 'funcs_1'). + - checked in a new memory_tb3.txt +2. Added three <storage>_triggers.test files based on Matthias's + structure above. +3. Added three <storage>__triggers.result files +4. Added the Trigger_master.test file in the trigger dierctory + Note: This is not complete and is still under work +5. Created a 'lib' directory and added the DataGen*.pl scripts to it + (exists under the disha suite) but should be here as well). +Omer 19.06.2005 +=================================================================== +Matthias 12.09.2005 +------------------- + Replace the geometry data types by VARBINARY + The removal of the geometry data types was necessary, because the + execution of the funcs_1 testsuite should not depend on the + availability of the geometry feature. + Note: There are servers compiled without the geometry feature. + + The columns are not removed, but their data type was changed + VARBINARY. This allows us to omit any changes within the loader + input files or data generation scripts. + The replacement of geometry by VARCHAR allows us to use our + +Matthias 12.09.2005 +=================================================================== +Matthias 14.09.2005 +------------------- + The results of the <storage_engine>_views testcases suffer when + executed in "--ps-protocol" mode from the open + Bug#11589: mysqltest, --ps-protocol, strange output, + float/double/real with zerofill . + Implementation of a workaround: + At the beginning of views_master.inc is a variable $have_bug_11589 . + If this varable is set to 1, the ps-protocol will be switched + of for the critical statements. +Matthias 14.09.2005 +=================================================================== +Carsten 16.09.2005 +------------------ +1. The results of the datadict_<engine> testcases have been changed in nearly + all occurrencies of --error <n> because now for the INFORMATION_SCHEMA only + the --error 1044 (ERROR 42000: Access denied for user '..' to database + 'information_schema') seems to be used. +2. To get identical results when using "--ps-protocol" some SELECTs FROM + information_schema has been wrapped to suppress using ps-protocol because + there are differences. +3. The test using SELECT .. OUTFILE has been disabled due to bug #13202. +4. Fixed datadict_<engine>.result files after the change that added 2 columns to + the VIEWS table (DEFINER varchar(77), SECURITY_TYPE varchar(7)). +=================================================================== |