« back to all changes in this revision
Viewing changes to tests/r/metadata.result
- browse files at revision 685.4.3
- compare with another revision
- compare with revision 1089
- download diff
- download tarball
- view history from revision 685.4.3
- Committer: Jay Pipes
- Date: 2008-12-17 05:03:52 UTC
- mto: This revision was merged to the branch mainline in revision 717.
- Revision ID: jpipes@serialcoder-20081217050352-6ihkar29r269e9tb
Fixed metadata.test. Only some minor SQL syntax changes, removal of VIEW stuff from the test, and verifying the old differences in the result file were due to our column type being different.
- files renamed:
- tests/suite/broken/r/metadata.result => tests/r/metadata.result
- tests/suite/broken/t/metadata.test => tests/t/metadata.test
added
removed
tests/r/metadata.result
1
1
drop table if exists t1,t2;
2
2
select 1, 1.0, -1, "hello", NULL;
3
3
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
4
def 1 8 1 1 N 32897 0 63
5
def 1.0 246 4 3 N 129 1 63
6
def -1 8 2 2 N 32897 0 63
7
def hello 253 5 5 N 1 31 8
8
def NULL 6 0 0 Y 32896 0 63
9
1 1.0 -1 hello NULL
10
1 1.0 -1 hello NULL
11
create table t1 (a tinyint, b smallint, c mediumint, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), i year, j date, k timestamp, l datetime, m enum('a','b'), n set('a','b'), o char(10));
4
def 1 5 1 1 N 32897 0 63
5
def 1.0 11 4 3 N 129 1 63
6
def -1 5 2 2 N 32897 0 63
7
def hello 9 20 5 N 1 31 45
8
def NULL 3 0 0 Y 32896 0 63
9
1 1.0 -1 hello NULL
10
1 1.0 -1 hello NULL
11
create table t1 (a int, b int, c int, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), j date, k timestamp, l datetime, m enum('a','b'), n char(10));
12
12
select * from t1;
13
13
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
14
def test t1 t1 a a 1 4 0 Y 32768 0 63
15
def test t1 t1 b b 2 6 0 Y 32768 0 63
16
def test t1 t1 c c 9 9 0 Y 32768 0 63
17
def test t1 t1 d d 3 11 0 Y 32768 0 63
18
def test t1 t1 e e 8 20 0 Y 32768 0 63
19
def test t1 t1 f f 4 3 0 Y 32768 2 63
20
def test t1 t1 g g 5 4 0 Y 32768 3 63
21
def test t1 t1 h h 246 7 0 Y 0 4 63
22
def test t1 t1 i i 13 4 0 Y 32864 0 63
23
def test t1 t1 j j 10 10 0 Y 128 0 63
24
def test t1 t1 k k 7 19 0 N 9441 0 63
25
def test t1 t1 l l 12 19 0 Y 128 0 63
26
def test t1 t1 m m 254 1 0 Y 256 0 8
27
def test t1 t1 n n 254 3 0 Y 2048 0 8
28
def test t1 t1 o o 254 10 0 Y 0 0 8
29
a b c d e f g h i j k l m n o
14
def test t1 t1 a a 1 11 0 Y 32768 0 63
15
def test t1 t1 b b 1 11 0 Y 32768 0 63
16
def test t1 t1 c c 1 11 0 Y 32768 0 63
17
def test t1 t1 d d 1 11 0 Y 32768 0 63
18
def test t1 t1 e e 5 20 0 Y 32768 0 63
19
def test t1 t1 f f 2 3 0 Y 32768 2 63
20
def test t1 t1 g g 2 4 0 Y 32768 3 63
21
def test t1 t1 h h 11 7 0 Y 0 4 63
22
def test t1 t1 j j 8 10 0 Y 128 0 63
23
def test t1 t1 k k 4 19 0 N 9377 0 63
24
def test t1 t1 l l 7 19 0 Y 128 0 63
25
def test t1 t1 m m 12 4 0 Y 256 0 45
26
def test t1 t1 n n 9 40 0 Y 0 0 45
27
a b c d e f g h j k l m n
30
28
select a b, b c from t1 as t2;
31
29
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
32
def test t1 t2 a b 1 4 0 Y 32768 0 63
33
def test t1 t2 b c 2 6 0 Y 32768 0 63
30
def test t1 t2 a b 1 11 0 Y 32768 0 63
31
def test t1 t2 b c 1 11 0 Y 32768 0 63
34
32
b c
35
33
drop table t1;
36
CREATE TABLE t1 (id tinyint(3) default NULL, data varchar(255) default NULL);
34
CREATE TABLE t1 (id int default NULL, data varchar(255) default NULL);
37
35
INSERT INTO t1 VALUES (1,'male'),(2,'female');
38
CREATE TABLE t2 (id tinyint(3) unsigned default NULL, data char(3) default '0');
36
CREATE TABLE t2 (id int default NULL, data char(3) default '0');
39
37
INSERT INTO t2 VALUES (1,'yes'),(2,'no');
40
38
select t1.id, t1.data, t2.data from t1, t2 where t1.id = t2.id;
41
39
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
42
def test t1 t1 id id 1 3 1 Y 32768 0 63
43
def test t1 t1 data data 253 255 6 Y 0 0 8
44
def test t2 t2 data data 254 3 3 Y 0 0 8
40
def test t1 t1 id id 1 11 1 Y 32768 0 63
41
def test t1 t1 data data 9 1020 6 Y 0 0 45
42
def test t2 t2 data data 9 12 3 Y 0 0 45
45
43
id data data
46
44
1 male yes
47
45
2 female no
48
46
select t1.id, t1.data, t2.data from t1, t2 where t1.id = t2.id order by t1.id;
49
47
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
50
def test t1 t1 id id 1 3 1 Y 32768 0 63
51
def test t1 t1 data data 253 255 6 Y 0 0 8
52
def test t2 t2 data data 254 3 3 Y 0 0 8
48
def test t1 t1 id id 1 11 1 Y 32768 0 63
49
def test t1 t1 data data 9 1020 6 Y 0 0 45
50
def test t2 t2 data data 9 12 3 Y 0 0 45
53
51
id data data
54
52
1 male yes
55
53
2 female no
56
54
select t1.id from t1 union select t2.id from t2;
57
55
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
58
def id id 1 4 1 Y 32768 0 63
56
def id id 1 11 1 Y 32768 0 63
59
57
id
60
58
1
61
59
2
66
64
set @arg00=1 ;
67
65
select @arg00 FROM t1 where a=1 union distinct select 1 FROM t1 where a=1;
68
66
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
69
def @arg00 @arg00 8 20 1 Y 32768 0 63
67
def @arg00 @arg00 5 20 1 Y 32768 0 63
70
68
@arg00
71
69
1
72
70
select * from (select @arg00) aaa;
73
71
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
74
def aaa @arg00 @arg00 8 20 1 Y 32768 0 63
72
def aaa @arg00 @arg00 5 20 1 Y 32768 0 63
75
73
@arg00
76
74
1
77
75
select 1 union select 1;
78
76
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
79
def 1 1 8 20 1 N 32769 0 63
77
def 1 1 5 20 1 N 32769 0 63
80
78
1
81
79
1
82
80
select * from (select 1 union select 1) aaa;
83
81
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
84
def aaa 1 1 8 20 1 N 32769 0 63
82
def aaa 1 1 5 20 1 N 32769 0 63
85
83
1
86
84
1
87
85
drop table t1;
96
94
2
97
95
affected rows: 1
98
96
affected rows: 0
99
create table t1 (id int(10));
100
insert into t1 values (1);
101
CREATE VIEW v1 AS select t1.id as id from t1;
102
CREATE VIEW v2 AS select t1.id as renamed from t1;
103
CREATE VIEW v3 AS select t1.id + 12 as renamed from t1;
104
select * from v1 group by id limit 1;
105
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
106
def test t1 v1 id id 3 10 1 Y 32768 0 63
107
id
108
1
109
select * from v1 group by id limit 0;
110
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
111
def test t1 v1 id id 3 10 0 Y 32768 0 63
112
id
113
select * from v1 where id=1000 group by id;
114
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
115
def test t1 v1 id id 3 10 0 Y 32768 0 63
116
id
117
select * from v1 where id=1 group by id;
118
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
119
def test t1 v1 id id 3 10 1 Y 32768 0 63
120
id
121
1
122
select * from v2 where renamed=1 group by renamed;
123
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
124
def test t1 v2 id renamed 3 10 1 Y 32768 0 63
125
renamed
126
1
127
select * from v3 where renamed=1 group by renamed;
128
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
129
def v3 renamed 8 12 0 Y 32896 0 63
130
renamed
131
drop table t1;
132
drop view v1,v2,v3;
133
97
select a.* from (select 2147483648 as v_large) a;
134
98
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
135
def a v_large v_large 8 10 10 N 32769 0 63
99
def a v_large v_large 5 10 10 N 32769 0 63
136
100
v_large
137
101
2147483648
138
102
select a.* from (select 214748364 as v_small) a;
139
103
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
140
def a v_small v_small 3 9 9 N 32769 0 63
104
def a v_small v_small 1 9 9 N 32769 0 63
141
105
v_small
142
106
214748364
143
CREATE TABLE t1 (c1 CHAR(1));
144
CREATE TABLE t2 (c2 CHAR(1));
145
CREATE VIEW v1 AS SELECT t1.c1 FROM t1;
146
CREATE VIEW v2 AS SELECT t2.c2 FROM t2;
147
INSERT INTO t1 VALUES ('1'), ('2'), ('3');
148
INSERT INTO t2 VALUES ('1'), ('2'), ('3'), ('2');
149
SELECT v1.c1 FROM v1 JOIN t2 ON c1=c2 ORDER BY 1;
150
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
151
def test t1 v1 c1 c1 254 1 1 Y 0 0 8
152
c1
153
1
154
2
155
2
156
3
157
SELECT v1.c1, v2.c2 FROM v1 JOIN v2 ON c1=c2;
158
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
159
def test t1 v1 c1 c1 254 1 1 Y 0 0 8
160
def test t2 v2 c2 c2 254 1 1 Y 0 0 8
161
c1 c2
162
1 1
163
2 2
164
3 3
165
2 2
166
SELECT v1.c1, v2.c2 FROM v1 JOIN v2 ON c1=c2 GROUP BY v1.c1;
167
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
168
def test t1 v1 c1 c1 254 1 1 Y 32768 0 8
169
def test t2 v2 c2 c2 254 1 1 Y 0 0 8
170
c1 c2
171
1 1
172
2 2
173
3 3
174
SELECT v1.c1, v2.c2 FROM v1 JOIN v2 ON c1=c2 GROUP BY v1.c1 ORDER BY v2.c2;
175
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
176
def test t1 v1 c1 c1 254 1 1 Y 32768 0 8
177
def test t2 v2 c2 c2 254 1 1 Y 0 0 8
178
c1 c2
179
1 1
180
2 2
181
3 3
182
DROP VIEW v1,v2;
183
DROP TABLE t1,t2;
184
107
End of 5.0 tests
Loggerhead is a web-based interface for Breezy
Version: 2.0.1