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/t/memory_views.test | |
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/t/memory_views.test')
-rw-r--r-- | mysql-test/suite/funcs_1/t/memory_views.test | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/mysql-test/suite/funcs_1/t/memory_views.test b/mysql-test/suite/funcs_1/t/memory_views.test new file mode 100644 index 00000000000..303d0bb2ac1 --- /dev/null +++ b/mysql-test/suite/funcs_1/t/memory_views.test @@ -0,0 +1,44 @@ +#### suite/funcs_1/t/memory_views.test + +# Memory tables should be used +# +# Set $engine_type +let $engine_type= memory; + +# Decide, if the objects are to be (re)created +# +# - once at the beginning of a set of testcases ('$NO_REFRESH' <> '' --> TRUE) +# That means the current script must not (re)create any object. +# It can expect, that the objects already exist. +# +# - per every testscript/case ('$NO_REFRESH' = '' --> FALSE) +# That means all objects have to be (re)created within the current script. + +eval SET @NO_REFRESH = IF( '$NO_REFRESH' = '', 0, 1); + +let $run= `SELECT @NO_REFRESH = 0`; +if ($run) +{ + + # Create some objects needed in many testcases + USE test; + --source suite/funcs_1/include/memory_tb2.inc + --disable_warnings + DROP DATABASE IF EXISTS test1; + --enable_warnings + CREATE DATABASE test1; + USE test1; + --source suite/funcs_1/include/memory_tb2.inc + USE test; + +} + +--source suite/funcs_1/views/views_master.inc + +# If we created the database in the above loop we now need to drop it +let $run= `SELECT @NO_REFRESH = 0`; +if ($run) +{ + DROP DATABASE IF EXISTS test1; +} + |