← 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/engines/funcs/t/tc_temporary_column_length.test

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-05-11 18:47:32 UTC
  • mto: (2.1.2 sid) (1.2.1 upstream)
  • mto: This revision was merged to the branch mainline in revision 4.
  • Revision ID: james.westby@ubuntu.com-20100511184732-jhn055kfhxze24kt
Tags: upstream-5.1.46
Import upstream version 5.1.46

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/tc_temporary_column_length.test
 
1
--disable_warnings
 
2
DROP TABLE IF EXISTS t5;
 
3
--enable_warnings
 
4
CREATE TEMPORARY TABLE t5(c1 BIT(10) NULL);
 
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 t5; DROP TABLE t5; SHOW TABLES;
 
9
CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NULL);
 
10
SHOW TABLES;
 
11
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
12
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
13
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
14
CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NULL);
 
15
SHOW TABLES;
 
16
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
17
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
18
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
19
CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NULL);
 
20
SHOW TABLES;
 
21
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
22
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
23
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
24
CREATE TEMPORARY TABLE t5(c1 INT(10) NULL);
 
25
SHOW TABLES;
 
26
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
27
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
28
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
29
CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NULL);
 
30
SHOW TABLES;
 
31
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
32
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
33
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
34
CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NULL);
 
35
SHOW TABLES;
 
36
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
37
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
38
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
39
CREATE TEMPORARY TABLE t5(c1 CHAR(10) NULL);
 
40
SHOW TABLES;
 
41
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
42
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
43
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
44
CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NULL);
 
45
SHOW TABLES;
 
46
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
47
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
48
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
49
CREATE TEMPORARY TABLE t5(c1 BINARY(10) NULL);
 
50
SHOW TABLES;
 
51
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
52
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
53
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
54
CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NULL);
 
55
SHOW TABLES;
 
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 t5; DROP TABLE t5; SHOW TABLES;
 
59
CREATE TEMPORARY TABLE t5(c1 BIT(10) NOT NULL);
 
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 t5; DROP TABLE t5; SHOW TABLES;
 
64
CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NOT NULL);
 
65
SHOW TABLES;
 
66
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
67
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
68
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
69
CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NOT NULL);
 
70
SHOW TABLES;
 
71
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
72
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
73
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
74
CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NOT NULL);
 
75
SHOW TABLES;
 
76
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
77
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
78
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
79
CREATE TEMPORARY TABLE t5(c1 INT(10) NOT NULL);
 
80
SHOW TABLES;
 
81
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
82
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
83
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
84
CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NOT NULL);
 
85
SHOW TABLES;
 
86
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
87
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
88
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
89
CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NOT NULL);
 
90
SHOW TABLES;
 
91
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
92
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
93
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
94
CREATE TEMPORARY TABLE t5(c1 CHAR(10) NOT NULL);
 
95
SHOW TABLES;
 
96
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
97
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
98
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
99
CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NOT NULL);
 
100
SHOW TABLES;
 
101
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
102
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
103
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
104
CREATE TEMPORARY TABLE t5(c1 BINARY(10) NOT NULL);
 
105
SHOW TABLES;
 
106
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
107
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
108
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
109
CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NOT NULL);
 
110
SHOW TABLES;
 
111
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 
112
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 
113
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
 
114