~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
--disable_warnings
2
DROP TABLE IF EXISTS t1;
3
--enable_warnings
4
5
CREATE TABLE t1 (sint8 tinyint not null);
6
INSERT INTO t1 VALUES ('0.1');
7
INSERT INTO t1 VALUES ('0.5');
8
INSERT INTO t1 VALUES ('127.4');
9
INSERT INTO t1 VALUES ('127.5');
10
INSERT INTO t1 VALUES ('-0.1');
11
INSERT INTO t1 VALUES ('-0.5');
12
INSERT INTO t1 VALUES ('-127.4');
13
INSERT INTO t1 VALUES ('-127.5');
14
INSERT INTO t1 VALUES ('-128.4');
15
INSERT INTO t1 VALUES ('-128.5');
16
SELECT * FROM t1;
17
DROP TABLE t1;
18
19
CREATE TABLE t1 (uint8 tinyint unsigned not null);
20
INSERT INTO t1 VALUES ('0.1');
21
INSERT INTO t1 VALUES ('0.5');
22
INSERT INTO t1 VALUES ('127.4');
23
INSERT INTO t1 VALUES ('127.5');
24
INSERT INTO t1 VALUES ('-0.1');
25
INSERT INTO t1 VALUES ('-0.5');
26
INSERT INTO t1 VALUES ('255.4');
27
INSERT INTO t1 VALUES ('255.5');
28
SELECT * FROM t1;
29
DROP TABLE t1;
30
31
32
CREATE TABLE t1 (sint16 smallint not null);
33
INSERT INTO t1 VALUES ('0.1');
34
INSERT INTO t1 VALUES ('0.5');
35
INSERT INTO t1 VALUES ('32767.4');
36
INSERT INTO t1 VALUES ('32767.5');
37
INSERT INTO t1 VALUES ('-0.1');
38
INSERT INTO t1 VALUES ('-0.5');
39
INSERT INTO t1 VALUES ('-32767.4');
40
INSERT INTO t1 VALUES ('-32767.5');
41
INSERT INTO t1 VALUES ('-32768.4');
42
INSERT INTO t1 VALUES ('-32768.5');
43
SELECT * FROM t1;
44
DROP TABLE t1;
45
46
47
CREATE TABLE t1 (uint16 smallint unsigned not null);
48
INSERT INTO t1 VALUES ('0.1');
49
INSERT INTO t1 VALUES ('0.5');
50
INSERT INTO t1 VALUES ('32767.4');
51
INSERT INTO t1 VALUES ('32767.5');
52
INSERT INTO t1 VALUES ('-0.1');
53
INSERT INTO t1 VALUES ('-0.5');
54
INSERT INTO t1 VALUES ('65535.4');
55
INSERT INTO t1 VALUES ('65535.5');
56
SELECT * FROM t1;
57
DROP TABLE t1;
58
59
CREATE TABLE t1 (sint24 mediumint not null);
60
INSERT INTO t1 VALUES ('0.1');
61
INSERT INTO t1 VALUES ('0.5');
62
INSERT INTO t1 VALUES ('8388607.4');
63
INSERT INTO t1 VALUES ('8388607.5');
64
INSERT INTO t1 VALUES ('-0.1');
65
INSERT INTO t1 VALUES ('-0.5');
66
INSERT INTO t1 VALUES ('-8388607.4');
67
INSERT INTO t1 VALUES ('-8388607.5');
68
INSERT INTO t1 VALUES ('-8388608.4');
69
INSERT INTO t1 VALUES ('-8388608.5');
70
SELECT * FROM t1;
71
DROP TABLE t1;
72
73
CREATE TABLE t1 (uint24 mediumint unsigned not null);
74
INSERT INTO t1 VALUES ('0.1');
75
INSERT INTO t1 VALUES ('0.5');
76
INSERT INTO t1 VALUES ('8388607.4');
77
INSERT INTO t1 VALUES ('8388607.5');
78
INSERT INTO t1 VALUES ('-0.1');
79
INSERT INTO t1 VALUES ('-0.5');
80
INSERT INTO t1 VALUES ('16777215.4');
81
INSERT INTO t1 VALUES ('16777215.5');
82
SELECT * FROM t1;
83
DROP TABLE t1;
84
85
CREATE TABLE t1 (sint64 bigint not null);
86
INSERT INTO t1 VALUES ('0.1');
87
INSERT INTO t1 VALUES ('0.5');
88
INSERT INTO t1 VALUES ('9223372036854775807.4');
89
INSERT INTO t1 VALUES ('9223372036854775807.5');
90
INSERT INTO t1 VALUES ('-0.1');
91
INSERT INTO t1 VALUES ('-0.5');
92
INSERT INTO t1 VALUES ('-9223372036854775807.4');
93
INSERT INTO t1 VALUES ('-9223372036854775807.5');
94
INSERT INTO t1 VALUES ('-9223372036854775808.4');
95
INSERT INTO t1 VALUES ('-9223372036854775808.5');
96
SELECT * FROM t1;
97
DROP TABLE t1;
98
99
CREATE TABLE t1 (uint64 bigint unsigned not null);
100
INSERT INTO t1 VALUES ('0.1');
101
INSERT INTO t1 VALUES ('0.5');
102
INSERT INTO t1 VALUES ('9223372036854775807.4');
103
INSERT INTO t1 VALUES ('9223372036854775807.5');
104
INSERT INTO t1 VALUES ('-0.1');
105
INSERT INTO t1 VALUES ('-0.5');
106
INSERT INTO t1 VALUES ('18446744073709551615.4');
107
INSERT INTO t1 VALUES ('18446744073709551615.5');
108
INSERT INTO t1 VALUES ('1844674407370955161.0');
109
INSERT INTO t1 VALUES ('1844674407370955161.1');
110
INSERT INTO t1 VALUES ('1844674407370955161.2');
111
INSERT INTO t1 VALUES ('1844674407370955161.3');
112
INSERT INTO t1 VALUES ('1844674407370955161.4');
113
INSERT INTO t1 VALUES ('1844674407370955161.5');
114
INSERT INTO t1 VALUES ('1844674407370955161.0e1');
115
INSERT INTO t1 VALUES ('1844674407370955161.1e1');
116
INSERT INTO t1 VALUES ('1844674407370955161.2e1');
117
INSERT INTO t1 VALUES ('1844674407370955161.3e1');
118
INSERT INTO t1 VALUES ('1844674407370955161.4e1');
119
INSERT INTO t1 VALUES ('1844674407370955161.5e1');
120
INSERT INTO t1 VALUES ('18446744073709551610e-1');
121
INSERT INTO t1 VALUES ('18446744073709551611e-1');
122
INSERT INTO t1 VALUES ('18446744073709551612e-1');
123
INSERT INTO t1 VALUES ('18446744073709551613e-1');
124
INSERT INTO t1 VALUES ('18446744073709551614e-1');
125
INSERT INTO t1 VALUES ('18446744073709551615e-1');
126
SELECT * FROM t1;
127
DROP TABLE t1;
128
129
CREATE TABLE t1 (str varchar(128), sint64 bigint not null default 0);
130
INSERT INTO t1 (str) VALUES ('1.5');
131
INSERT INTO t1 (str) VALUES ('1.00005e4');
132
INSERT INTO t1 (str) VALUES ('1.0005e3');
133
INSERT INTO t1 (str) VALUES ('1.005e2');
134
INSERT INTO t1 (str) VALUES ('1.05e1');
135
INSERT INTO t1 (str) VALUES ('1.5e0');
136
INSERT INTO t1 (str) VALUES ('100005e-1');
137
INSERT INTO t1 (str) VALUES ('100050e-2');
138
INSERT INTO t1 (str) VALUES ('100500e-3');
139
INSERT INTO t1 (str) VALUES ('105000e-4');
140
INSERT INTO t1 (str) VALUES ('150000e-5');
141
UPDATE t1 SET sint64=str;
142
SELECT * FROM t1;
143
DROP TABLE t1;
144
145