mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 19:09:41 +00:00
153 lines
3.1 KiB
Plaintext
153 lines
3.1 KiB
Plaintext
|
|
SELECT decimal(1);
|
|
|
|
|
|
SELECT decimal('1.0');
|
|
|
|
|
|
SELECT decimal('0001.0');
|
|
|
|
|
|
SELECT decimal('+0001.0');
|
|
|
|
|
|
SELECT decimal('-0001.0');
|
|
|
|
|
|
SELECT decimal('1.0e72');
|
|
|
|
|
|
SELECT decimal('1.0e-72');
|
|
|
|
|
|
SELECT decimal('-123e-4');
|
|
|
|
|
|
SELECT decimal('+123e+4');
|
|
|
|
|
|
SELECT decimal_exp('+123e+4');
|
|
|
|
|
|
CREATE TABLE t1(seq INTEGER PRIMARY KEY, val TEXT);
|
|
INSERT INTO t1 VALUES
|
|
(1, '-9999e99'),
|
|
(2, '-9998.000e+99'),
|
|
(3, '-9999.0'),
|
|
(4, '-1'),
|
|
(5, '-9999e-20'),
|
|
(6, '0'),
|
|
(7, '1e-30'),
|
|
(8, '1e-29'),
|
|
(9, '1'),
|
|
(10,'1.00000000000000001'),
|
|
(11,'+1.00001'),
|
|
(12,'99e+99');
|
|
SELECT *, '|'
|
|
FROM t1 AS a, t1 AS b
|
|
WHERE a.seq<b.seq
|
|
AND decimal_cmp(a.val,b.val)>=0;
|
|
|
|
|
|
SELECT *, '|'
|
|
FROM t1 AS a, t1 AS b
|
|
WHERE a.seq<>b.seq
|
|
AND decimal_cmp(a.val,b.val)==0;
|
|
|
|
|
|
SELECT *, '|'
|
|
FROM t1 AS a, t1 AS b
|
|
WHERE a.seq>b.seq
|
|
AND decimal_cmp(a.val,b.val)<=0;
|
|
|
|
|
|
SELECT seq FROM t1 ORDER BY val COLLATE decimal;
|
|
|
|
|
|
SELECT seq FROM t1 ORDER BY val COLLATE decimal DESC;
|
|
|
|
|
|
CREATE TABLE t3(seq INTEGER PRIMARY KEY, val TEXT);
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION SELECT x+1 FROM c WHERE x<10)
|
|
INSERT INTO t3(seq, val) SELECT x, x FROM c;
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION SELECT x+1 FROM c WHERE x<5)
|
|
INSERT INTO t3(seq, val) SELECT x+10, x*1000 FROM c;
|
|
SELECT decimal(val) FROM t3 ORDER BY seq;
|
|
|
|
|
|
SELECT decimal_add(val,'0.5') FROM t3 WHERE seq>5 ORDER BY seq
|
|
|
|
|
|
SELECT decimal_add(val,'-10') FROM t3 ORDER BY seq;
|
|
|
|
|
|
SELECT decimal_sum(val) FROM t3;
|
|
|
|
|
|
SELECT decimal_sum(decimal_add(val,val||'e+10')) FROM t3;
|
|
|
|
|
|
SELECT decimal_sum(decimal_add(val||'e+20',decimal_add(val,val||'e-20')))
|
|
FROM t3;
|
|
|
|
|
|
WITH RECURSIVE c(x,y,z) AS (
|
|
VALUES(0,'1','1')
|
|
UNION ALL
|
|
SELECT x+1, decimal_mul(y,'2'), decimal_mul(z,'0.5')
|
|
FROM c WHERE x<32
|
|
)
|
|
SELECT count(*) FROM c WHERE decimal_mul(y,z)='1';
|
|
|
|
|
|
SELECT decimal_mul('1234.00','2.00');
|
|
|
|
|
|
SELECT decimal_mul('1234.00','2.0000');
|
|
|
|
|
|
SELECT decimal_mul('1234.0000','2.000');
|
|
|
|
|
|
SELECT decimal_mul('1234.0000','2');
|
|
|
|
|
|
CREATE TABLE pow2(x INTEGER PRIMARY KEY, v TEXT);
|
|
WITH RECURSIVE c(x,v) AS (
|
|
VALUES(0,'1')
|
|
UNION ALL
|
|
SELECT x+1, decimal_mul(v,'2') FROM c WHERE x+1<=971
|
|
) INSERT INTO pow2(x,v) SELECT x, v FROM c;
|
|
WITH RECURSIVE c(x,v) AS (
|
|
VALUES(-1,'0.5')
|
|
UNION ALL
|
|
SELECT x-1, decimal_mul(v,'0.5') FROM c WHERE x-1>=-1075
|
|
) INSERT INTO pow2(x,v) SELECT x, v FROM c;
|
|
|
|
|
|
WITH c(n) AS (SELECT ieee754_from_blob(x'0000000000000001'))
|
|
SELECT decimal_mul(ieee754_mantissa(c.n),pow2.v)
|
|
FROM pow2, c WHERE pow2.x=ieee754_exponent(c.n);
|
|
|
|
|
|
WITH c(n) AS (SELECT ieee754_from_blob(x'0000000000000001'))
|
|
SELECT decimal(c.n) FROM c;
|
|
|
|
|
|
WITH c(n) AS (SELECT ieee754_from_blob(x'7fefffffffffffff'))
|
|
SELECT decimal_mul(ieee754_mantissa(c.n),pow2.v)
|
|
FROM pow2, c WHERE pow2.x=ieee754_exponent(c.n);
|
|
|
|
|
|
SELECT ieee754(ieee754_from_blob(x'0000000000000001'));
|
|
|
|
|
|
SELECT ieee754(ieee754_from_blob(x'7fefffffffffffff'));
|
|
|
|
|
|
SELECT printf('%.8e',ieee754_from_blob(x'0000000000000001'));
|
|
|
|
|
|
SELECT printf('%.8e',ieee754_from_blob(x'ffefffffffffffff'));
|
|
|