Debian Codegraph @

test/decimal.test

raw
1 # 2017 December 9
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 #
12
13 set testdir [file dirname $argv0]
14 source $testdir/tester.tcl
15 set testprefix decimal
16
17 if {[catch {load_static_extension db decimal} error]} {
18 puts "Skipping decimal tests, hit load error: $error"
19 finish_test; return
20 }
21
22 do_execsql_test 1000 {
23 SELECT decimal(1);
24 } {1}
25 do_execsql_test 1001 {
26 SELECT decimal('+0'), decimal('-0');
27 } {0 0}
28 do_execsql_test 1010 {
29 SELECT decimal('1.0');
30 } {1.0}
31 do_execsql_test 1020 {
32 SELECT decimal('0001.0');
33 } {1.0}
34 do_execsql_test 1030 {
35 SELECT decimal('+0001.0');
36 } {1.0}
37 do_execsql_test 1040 {
38 SELECT decimal('-0001.0');
39 } {-1.0}
40 do_execsql_test 1041 {
41 SELECT decimal('-0000.0');
42 } {0.0}
43 do_execsql_test 1042 {
44 SELECT decimal(0.0)==decimal(-0.0);
45 } {1}
46 do_execsql_test 1050 {
47 SELECT decimal('1.0e72');
48 } {1000000000000000000000000000000000000000000000000000000000000000000000000}
49 # 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123
50 do_execsql_test 1060 {
51 SELECT decimal('1.0e-72');
52 } {0.0000000000000000000000000000000000000000000000000000000000000000000000010}
53 # 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123
54 do_execsql_test 1070 {
55 SELECT decimal('-123e-4');
56 } {-0.0123}
57 do_execsql_test 1080 {
58 SELECT decimal('+123e+4');
59 } {1230000}
60 do_execsql_test 1081 {
61 SELECT decimal_exp('+123e+4');
62 } {+1.23e+06}
63
64
65 do_execsql_test 2000 {
66 CREATE TABLE t1(seq INTEGER PRIMARY KEY, val TEXT);
67 INSERT INTO t1 VALUES
68 (1, '-9999e99'),
69 (2, '-9998.000e+99'),
70 (3, '-9999.0'),
71 (4, '-1'),
72 (5, '-9999e-20'),
73 (6, '0'),
74 (7, '1e-30'),
75 (8, '1e-29'),
76 (9, '1'),
77 (10,'1.00000000000000001'),
78 (11,'+1.00001'),
79 (12,'99e+99');
80 SELECT *, '|'
81 FROM t1 AS a, t1 AS b
82 WHERE a.seq<b.seq
83 AND decimal_cmp(a.val,b.val)>=0;
84 } {}
85 do_execsql_test 2001 {
86 WITH vx(a,b) AS (VALUES
87 ('-0','+0'),
88 ('-000.000','0'),
89 ('1.2','1.2000')
90 )
91 SELECT *, '|' FROM vx
92 WHERE decimal_cmp(a,b)!=0
93 OR decimal_cmp(b,a)!=0;
94 } {}
95 do_execsql_test 2010 {
96 SELECT *, '|'
97 FROM t1 AS a, t1 AS b
98 WHERE a.seq<>b.seq
99 AND decimal_cmp(a.val,b.val)==0;
100 } {}
101 do_execsql_test 2020 {
102 SELECT *, '|'
103 FROM t1 AS a, t1 AS b
104 WHERE a.seq>b.seq
105 AND decimal_cmp(a.val,b.val)<=0;
106 } {}
107 do_execsql_test 2030 {
108 SELECT seq FROM t1 ORDER BY val COLLATE decimal;
109 } {1 2 3 4 5 6 7 8 9 10 11 12}
110 do_execsql_test 2040 {
111 SELECT seq FROM t1 ORDER BY val COLLATE decimal DESC;
112 } {12 11 10 9 8 7 6 5 4 3 2 1}
113
114 do_execsql_test 3000 {
115 CREATE TABLE t3(seq INTEGER PRIMARY KEY, val TEXT);
116 WITH RECURSIVE c(x) AS (VALUES(1) UNION SELECT x+1 FROM c WHERE x<10)
117 INSERT INTO t3(seq, val) SELECT x, x FROM c;
118 WITH RECURSIVE c(x) AS (VALUES(1) UNION SELECT x+1 FROM c WHERE x<5)
119 INSERT INTO t3(seq, val) SELECT x+10, x*1000 FROM c;
120 SELECT decimal(val) FROM t3 ORDER BY seq;
121 } {1 2 3 4 5 6 7 8 9 10 1000 2000 3000 4000 5000}
122 do_execsql_test 3020 {
123 SELECT decimal_add(val,'0.5') FROM t3 WHERE seq>5 ORDER BY seq
124 } {6.5 7.5 8.5 9.5 10.5 1000.5 2000.5 3000.5 4000.5 5000.5}
125 do_execsql_test 3030 {
126 SELECT decimal_add(val,'-10') FROM t3 ORDER BY seq;
127 } {-9 -8 -7 -6 -5 -4 -3 -2 -1 0 990 1990 2990 3990 4990}
128
129 do_execsql_test 4000 {
130 SELECT decimal_sum(val) FROM t3;
131 } {15055}
132 do_execsql_test 4010 {
133 SELECT decimal_sum(decimal_add(val,val||'e+10')) FROM t3;
134 } {150550000015055}
135 do_execsql_test 4010 {
136 SELECT decimal_sum(decimal_add(val||'e+20',decimal_add(val,val||'e-20')))
137 FROM t3;
138 } {1505500000000000000015055.00000000000000015055}
139
140 do_execsql_test 5000 {
141 WITH RECURSIVE c(x,y,z) AS (
142 VALUES(0,'1','1')
143 UNION ALL
144 SELECT x+1, decimal_mul(y,'2'), decimal_mul(z,'0.5')
145 FROM c WHERE x<32
146 )
147 SELECT count(*) FROM c WHERE decimal_mul(y,z)='1';
148 } {33}
149
150 do_execsql_test 5100 {
151 SELECT decimal_mul('1234.00','2.00');
152 } {2468.00}
153 do_execsql_test 5101 {
154 SELECT decimal_mul('1234.00','2.0000');
155 } {2468.00}
156 do_execsql_test 5102 {
157 SELECT decimal_mul('1234.0000','2.000');
158 } {2468.000}
159 do_execsql_test 5103 {
160 SELECT decimal_mul('1234.0000','2');
161 } {2468}
162
163 if {[catch {load_static_extension db ieee754} error]} {
164 puts "Skipping ieee754 tests, hit load error: $error"
165 finish_test; return
166 }
167
168 do_execsql_test 6000 {
169 CREATE TABLE pow2(x INTEGER PRIMARY KEY, v TEXT);
170 WITH RECURSIVE c(x,v) AS (
171 VALUES(0,'1')
172 UNION ALL
173 SELECT x+1, decimal_mul(v,'2') FROM c WHERE x+1<=971
174 ) INSERT INTO pow2(x,v) SELECT x, v FROM c;
175 WITH RECURSIVE c(x,v) AS (
176 VALUES(-1,'0.5')
177 UNION ALL
178 SELECT x-1, decimal_mul(v,'0.5') FROM c WHERE x-1>=-1075
179 ) INSERT INTO pow2(x,v) SELECT x, v FROM c;
180 } {}
181 do_execsql_test 6010 {
182 WITH c(n) AS (SELECT ieee754_from_blob(x'0000000000000001'))
183 SELECT decimal_mul(ieee754_mantissa(c.n),pow2.v)
184 FROM pow2, c WHERE pow2.x=ieee754_exponent(c.n);
185 } {0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004940656458412465441765687928682213723650598026143247644255856825006755072702087518652998363616359923797965646954457177309266567103559397963987747960107818781263007131903114045278458171678489821036887186360569987307230500063874091535649843873124733972731696151400317153853980741262385655911710266585566867681870395603106249319452715914924553293054565444011274801297099995419319894090804165633245247571478690147267801593552386115501348035264934720193790268107107491703332226844753335720832431936092382893458368060106011506169809753078342277318329247904982524730776375927247874656084778203734469699533647017972677717585125660551199131504891101451037862738167250955837389733598993664809941164205702637090279242767544565229087538682506419718265533447265625}
186 do_execsql_test 6011 {
187 WITH c(n) AS (SELECT ieee754_from_blob(x'0000000000000001'))
188 SELECT decimal(c.n) FROM c;
189 } {0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004940656458412465441765687928682213723650598026143247644255856825006755072702087518652998363616359923797965646954457177309266567103559397963987747960107818781263007131903114045278458171678489821036887186360569987307230500063874091535649843873124733972731696151400317153853980741262385655911710266585566867681870395603106249319452715914924553293054565444011274801297099995419319894090804165633245247571478690147267801593552386115501348035264934720193790268107107491703332226844753335720832431936092382893458368060106011506169809753078342277318329247904982524730776375927247874656084778203734469699533647017972677717585125660551199131504891101451037862738167250955837389733598993664809941164205702637090279242767544565229087538682506419718265533447265625}
190 do_execsql_test 6020 {
191 WITH c(n) AS (SELECT ieee754_from_blob(x'7fefffffffffffff'))
192 SELECT decimal_mul(ieee754_mantissa(c.n),pow2.v)
193 FROM pow2, c WHERE pow2.x=ieee754_exponent(c.n);
194 } {179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368}
195
196 do_execsql_test 6100 {
197 SELECT ieee754(ieee754_from_blob(x'0000000000000001'));
198 } {ieee754(1,-1074)}
199 do_execsql_test 6110 {
200 SELECT ieee754(ieee754_from_blob(x'7fefffffffffffff'));
201 } {ieee754(9007199254740991,971)}
202 do_execsql_test 6120 {
203 SELECT printf('%.8e',ieee754_from_blob(x'0000000000000001'));
204 } {4.94065646e-324}
205 do_execsql_test 6130 {
206 SELECT printf('%.8e',ieee754_from_blob(x'ffefffffffffffff'));
207 } {-1.79769313e+308}
208
209
210
211
212 finish_test