← Back to branch summary

~vadim-tk/percona-server/percona-galera-5.1.57-0.8.1

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/ta_string_drop_column.test

  • Committer: root
  • Date: 2011-07-28 00:14:23 UTC
  • Revision ID: root@r815.office.percona.com-20110728001423-6pw0v4b7r0dkbsr4
Ported to Galera 0.8.1

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/ta_string_drop_column.test
 
1
--disable_warnings
 
2
DROP TABLE IF EXISTS t1;
 
3
--enable_warnings
 
4
CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(30));
 
5
SHOW TABLES; 
 
6
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
7
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
8
 SHOW CREATE TABLE t1; 
 
9
ALTER TABLE t1 DROP   c2;
 
10
--error 1090
 
11
ALTER TABLE t1 DROP   c1;
 
12
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
13
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
14
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
15
CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(30));
 
16
SHOW TABLES; 
 
17
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
18
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
19
 SHOW CREATE TABLE t1; 
 
20
ALTER TABLE t1 DROP   c2;
 
21
--error 1090
 
22
ALTER TABLE t1 DROP   c1;
 
23
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
24
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
25
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
26
CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(30));
 
27
SHOW TABLES; 
 
28
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
29
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
30
 SHOW CREATE TABLE t1; 
 
31
ALTER TABLE t1 DROP   c2;
 
32
--error 1090
 
33
ALTER TABLE t1 DROP   c1;
 
34
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
35
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
36
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
37
CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(30));
 
38
SHOW TABLES; 
 
39
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
40
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
41
 SHOW CREATE TABLE t1; 
 
42
ALTER TABLE t1 DROP   c2;
 
43
--error 1090
 
44
ALTER TABLE t1 DROP   c1;
 
45
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
46
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
47
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
48
CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(30));
 
49
SHOW TABLES; 
 
50
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
51
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
52
 SHOW CREATE TABLE t1; 
 
53
ALTER TABLE t1 DROP COLUMN c2;
 
54
--error 1090
 
55
ALTER TABLE t1 DROP COLUMN c1;
 
56
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
57
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
58
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
59
CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(30));
 
60
SHOW TABLES; 
 
61
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
62
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
63
 SHOW CREATE TABLE t1; 
 
64
ALTER TABLE t1 DROP COLUMN c2;
 
65
--error 1090
 
66
ALTER TABLE t1 DROP COLUMN c1;
 
67
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
68
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
69
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
70
CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(30));
 
71
SHOW TABLES; 
 
72
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
73
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
74
 SHOW CREATE TABLE t1; 
 
75
ALTER TABLE t1 DROP COLUMN c2;
 
76
--error 1090
 
77
ALTER TABLE t1 DROP COLUMN c1;
 
78
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
79
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
80
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
81
CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(30));
 
82
SHOW TABLES; 
 
83
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
84
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
85
 SHOW CREATE TABLE t1; 
 
86
ALTER TABLE t1 DROP COLUMN c2;
 
87
--error 1090
 
88
ALTER TABLE t1 DROP COLUMN c1;
 
89
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 
 
90
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
91
 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 
92