← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/t/myisam_views.test

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/t/myisam_views.test
 
1
#### suite/funcs_1/t/myisam_views.test
 
2
 
 
3
--source include/no_valgrind_without_big.inc
 
4
 
 
5
# MyISAM tables should be used
 
6
#
 
7
# Set $engine_type
 
8
SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
 
9
let $engine_type= myisam;
 
10
 
 
11
# Create some objects needed in many testcases
 
12
USE test;
 
13
--source suite/funcs_1/include/myisam_tb2.inc
 
14
--disable_warnings
 
15
DROP DATABASE IF EXISTS test1;
 
16
--enable_warnings
 
17
CREATE DATABASE test1;
 
18
USE test1;
 
19
--source suite/funcs_1/include/myisam_tb2.inc
 
20
USE test;
 
21
 
 
22
let $message= Attention: The nesting level @max_level in Testcase 3.3.1.A6
 
23
              (Complicated nested VIEWs) has to be limited to 20 because of
 
24
              MyISAM(only) performance issues Bug#11948;
 
25
--source include/show_msg80.inc
 
26
SET @limit1 = 20;
 
27
--source suite/funcs_1/views/views_master.inc
 
28
 
 
29
DROP DATABASE test1;
 
30
DROP TABLE test.tb2;
 
31