~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

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