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

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

67 lines
881 B
Plaintext

SELECT likelihood(9223372036854775807, 0.5);
SELECT likelihood(-9223372036854775808, 0.5);
SELECT likelihood(14.125, 0.5);
SELECT likelihood(NULL, 0.5);
SELECT likelihood('test-string', 0.5);
SELECT quote(likelihood(x'010203000405', 0.5));
SELECT likelihood(123, 1.0), likelihood(456, 0.0);
SELECT unlikely(9223372036854775807);
SELECT unlikely(-9223372036854775808);
SELECT unlikely(14.125);
SELECT unlikely(NULL);
SELECT unlikely('test-string');
SELECT quote(unlikely(x'010203000405'));
SELECT likely(CAST(1 AS INT))=='1';
SELECT unlikely(CAST(1 AS INT))=='1';
SELECT likelihood(CAST(1 AS INT),0.5)=='1';
SELECT likely(9223372036854775807);
SELECT likely(-9223372036854775808);
SELECT likely(14.125);
SELECT likely(NULL);
SELECT likely('test-string');
SELECT quote(likely(x'010203000405'));