|
1
by brian
clean slate |
1 |
drop table if exists t1,t2; |
2 |
select 1, 1.0, -1, "hello", NULL; |
|
3 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
4 |
def 1 5 1 1 N 32897 0 63 |
|
998.1.4
by Brian Aker
Final bits to Virtual Column code |
5 |
def 1.0 9 4 3 N 129 1 63 |
|
685.4.3
by Jay Pipes
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. |
6 |
def -1 5 2 2 N 32897 0 63 |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
7 |
def hello 8 20 5 N 1 31 45 |
|
685.4.3
by Jay Pipes
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. |
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)); |
|
|
1
by brian
clean slate |
12 |
select * from t1; |
13 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
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 |
|
|
998.1.4
by Brian Aker
Final bits to Virtual Column code |
21 |
def test t1 t1 h h 9 7 0 Y 0 4 63 |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
22 |
def test t1 t1 j j 7 10 0 Y 128 0 63 |
|
1079.4.1
by Stewart Smith
fix length of timestamp type for metadata test (and fix its result). See jay's description at https://code.launchpad.net/~stewart-flamingspork/drizzle/bug373468/+merge/8089 |
23 |
def test t1 t1 k k 4 26 0 Y 160 0 63 |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
24 |
def test t1 t1 l l 6 19 0 Y 128 0 63 |
|
998.1.4
by Brian Aker
Final bits to Virtual Column code |
25 |
def test t1 t1 m m 10 4 0 Y 256 0 45 |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
26 |
def test t1 t1 n n 8 40 0 Y 0 0 45 |
|
685.4.3
by Jay Pipes
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. |
27 |
a b c d e f g h j k l m n |
|
1
by brian
clean slate |
28 |
select a b, b c from t1 as t2; |
29 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
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 |
|
|
1
by brian
clean slate |
32 |
b c |
33 |
drop table t1; |
|
|
685.4.3
by Jay Pipes
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. |
34 |
CREATE TABLE t1 (id int default NULL, data varchar(255) default NULL); |
|
1
by brian
clean slate |
35 |
INSERT INTO t1 VALUES (1,'male'),(2,'female'); |
|
685.4.3
by Jay Pipes
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. |
36 |
CREATE TABLE t2 (id int default NULL, data char(3) default '0'); |
|
1
by brian
clean slate |
37 |
INSERT INTO t2 VALUES (1,'yes'),(2,'no'); |
38 |
select t1.id, t1.data, t2.data from t1, t2 where t1.id = t2.id; |
|
39 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
40 |
def test t1 t1 id id 1 11 1 Y 32768 0 63 |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
41 |
def test t1 t1 data data 8 1020 6 Y 0 0 45 |
42 |
def test t2 t2 data data 8 12 3 Y 0 0 45 |
|
|
1
by brian
clean slate |
43 |
id data data |
44 |
1 male yes |
|
45 |
2 female no |
|
46 |
select t1.id, t1.data, t2.data from t1, t2 where t1.id = t2.id order by t1.id; |
|
47 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
48 |
def test t1 t1 id id 1 11 1 Y 32768 0 63 |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
49 |
def test t1 t1 data data 8 1020 6 Y 0 0 45 |
50 |
def test t2 t2 data data 8 12 3 Y 0 0 45 |
|
|
1
by brian
clean slate |
51 |
id data data |
52 |
1 male yes |
|
53 |
2 female no |
|
54 |
select t1.id from t1 union select t2.id from t2; |
|
55 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
56 |
def id id 1 11 1 Y 32768 0 63 |
|
1
by brian
clean slate |
57 |
id
|
58 |
1
|
|
59 |
2
|
|
60 |
drop table t1,t2; |
|
61 |
create table t1 ( a int, b varchar(30), primary key(a)); |
|
62 |
insert into t1 values (1,'one'); |
|
63 |
insert into t1 values (2,'two'); |
|
64 |
set @arg00=1 ; |
|
65 |
select @arg00 FROM t1 where a=1 union distinct select 1 FROM t1 where a=1; |
|
66 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
67 |
def @arg00 @arg00 5 20 1 Y 32768 0 63 |
|
1
by brian
clean slate |
68 |
@arg00 |
69 |
1
|
|
70 |
select * from (select @arg00) aaa; |
|
71 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
72 |
def aaa @arg00 @arg00 5 20 1 Y 32768 0 63 |
|
1
by brian
clean slate |
73 |
@arg00 |
74 |
1
|
|
75 |
select 1 union select 1; |
|
76 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
77 |
def 1 1 5 20 1 N 32769 0 63 |
|
1
by brian
clean slate |
78 |
1
|
79 |
1
|
|
80 |
select * from (select 1 union select 1) aaa; |
|
81 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
82 |
def aaa 1 1 5 20 1 N 32769 0 63 |
|
1
by brian
clean slate |
83 |
1
|
84 |
1
|
|
85 |
drop table t1; |
|
86 |
select a.* from (select 2147483648 as v_large) a; |
|
87 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
88 |
def a v_large v_large 5 10 10 N 32769 0 63 |
|
1
by brian
clean slate |
89 |
v_large
|
90 |
2147483648
|
|
91 |
select a.* from (select 214748364 as v_small) a; |
|
92 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
685.4.3
by Jay Pipes
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. |
93 |
def a v_small v_small 1 9 9 N 32769 0 63 |
|
1
by brian
clean slate |
94 |
v_small
|
95 |
214748364
|
|
96 |
End of 5.0 tests |