Date: 2016-03-08 11:14:08 +0100
From: @swingbit
To: SQL devs <>
Version: -- development
CC: @eyalroz, martin.van.dinther

Last updated: 2019-04-30 12:36:01 +0200

Comment 21870

Date: 2016-03-08 11:14:08 +0100
From: @swingbit

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36
Build Identifier:

SQL provides log (natural log) and log10 (base 10) functions:

sql>select name,func from sys.functions where name like 'log%';
+-------+-------+
| name | func |
+=======+=======+
| log | log |
| log10 | log10 |
| log | log |
| log10 | log10 |
+-------+-------+

Their implementation is a straightforward mapping onto the C library implementation:

unopM5(_LOG,log)
unopM5(_LOG10,log10)

It would be nice to expose the same way "log2" (base 2), which is also available in the C standard library.

This is not very urgent, as one can always write log2(x) = log(x) / log(2). But the log2 implementation is probably faster and since log10 is exposed, it seems logical to also expose log2.

Reproducible: Always

Comment 21871

Date: 2016-03-10 14:46:43 +0100
From: Martin van Dinther <<martin.van.dinther>>

When implementing this request, also implement function LN(), see Bug #3520

Comment 24620

Date: 2016-10-24 23:45:06 +0200
From: @eyalroz

Isn't this a dupe of bug #3416?

Comment 26833

Date: 2019-01-22 12:41:13 +0100
From: MonetDB Mercurial Repository <>

Changeset ac79383ea2ce made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=ac79383ea2ce

Changeset description:

Implemented function log2.
This fixes bug #3946.