summaryrefslogtreecommitdiff
path: root/mysql-test/suite/funcs_1/t/myisam_views-big.test
diff options
context:
space:
mode:
authorGuilhem Bichot <guilhem.bichot@oracle.com>2010-12-31 12:07:34 +0100
committerGuilhem Bichot <guilhem.bichot@oracle.com>2010-12-31 12:07:34 +0100
commit3997d4c694eeafb631831b639f84f29479b0eba7 (patch)
tree9720aba33ee5576a181fc88285e78c4dcfacfbad /mysql-test/suite/funcs_1/t/myisam_views-big.test
parentce37fd6bb1aefab09178b650d1d7e52e7778f344 (diff)
downloadmariadb-git-3997d4c694eeafb631831b639f84f29479b0eba7.tar.gz
Test which runs slowly on some machines, is marked as big
so will be run only weekly; this closes BUG#50595.
Diffstat (limited to 'mysql-test/suite/funcs_1/t/myisam_views-big.test')
-rw-r--r--mysql-test/suite/funcs_1/t/myisam_views-big.test34
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/suite/funcs_1/t/myisam_views-big.test b/mysql-test/suite/funcs_1/t/myisam_views-big.test
new file mode 100644
index 00000000000..21613e78b24
--- /dev/null
+++ b/mysql-test/suite/funcs_1/t/myisam_views-big.test
@@ -0,0 +1,34 @@
+#### suite/funcs_1/t/myisam_views.test
+
+--source include/no_valgrind_without_big.inc
+# because of a pair of slow Solaris Sparc machines in pb2,
+# this test is marked as big:
+--source include/big_test.inc
+
+# MyISAM tables should be used
+#
+# Set $engine_type
+SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
+let $engine_type= myisam;
+
+# Create some objects needed in many testcases
+USE test;
+--source suite/funcs_1/include/myisam_tb2.inc
+--disable_warnings
+DROP DATABASE IF EXISTS test1;
+--enable_warnings
+CREATE DATABASE test1;
+USE test1;
+--source suite/funcs_1/include/myisam_tb2.inc
+USE test;
+
+let $message= Attention: The nesting level @max_level in Testcase 3.3.1.A6
+ (Complicated nested VIEWs) has to be limited to 20 because of
+ MyISAM(only) performance issues Bug#11948;
+--source include/show_msg80.inc
+SET @limit1 = 20;
+--source suite/funcs_1/views/views_master.inc
+
+DROP DATABASE test1;
+DROP TABLE test.tb2;
+