140
140
def a v_small v_small 3 9 9 N 32769 0 63
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
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
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
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