0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 23:48:49 +00:00
ad hoc ad79ef48a2
libsql wal tests (#1408)
* add tests

* add bench
2024-05-24 13:59:17 +00:00

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'));