~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
ImportĀ upstreamĀ versionĀ 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
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