Changeset: ac79383ea2ce for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ac79383ea2ce
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
monetdb5/modules/kernel/batmmath.c
monetdb5/modules/kernel/batmmath.h
monetdb5/modules/kernel/batmmath.mal
monetdb5/modules/kernel/mmath.c
monetdb5/modules/kernel/mmath.h
monetdb5/modules/kernel/mmath.mal
sql/ChangeLog.Apr2019
sql/common/sql_types.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out.powerpc64.int128
Branch: Apr2019
Log Message:
Implemented function log2.
This fixes bug 3946.
diffs (truncated from 39675 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -8827,6 +8827,10 @@ Ready.
[ "batmmath", "log10", "command batmmath.log10(x:bat[:dbl],
s:bat[:oid]):bat[:dbl] ", "CMDscience_bat_dbl_log10_cand;", "" ]
[ "batmmath", "log10", "command batmmath.log10(x:bat[:flt]):bat[:flt]
", "CMDscience_bat_flt_log10;", "" ]
[ "batmmath", "log10", "command batmmath.log10(x:bat[:flt],
s:bat[:oid]):bat[:flt] ", "CMDscience_bat_flt_log10_cand;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:dbl]):bat[:dbl] ",
"CMDscience_bat_dbl_log2;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:dbl],
s:bat[:oid]):bat[:dbl] ", "CMDscience_bat_dbl_log2_cand;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:flt]):bat[:flt] ",
"CMDscience_bat_flt_log2;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:flt],
s:bat[:oid]):bat[:flt] ", "CMDscience_bat_flt_log2_cand;", "" ]
[ "batmmath", "pow", "command batmmath.pow(x:bat[:dbl], y:dbl):bat[:dbl] ",
"CMDscience_bat_cst_pow_dbl;", "" ]
[ "batmmath", "pow", "command batmmath.pow(x:bat[:dbl], y:dbl,
s:bat[:oid]):bat[:dbl] ", "CMDscience_bat_cst_pow_dbl_cand;", "" ]
[ "batmmath", "pow", "command batmmath.pow(x:bat[:flt], y:flt):bat[:flt] ",
"CMDscience_bat_cst_pow_flt;", "" ]
@@ -11268,6 +11272,8 @@ Ready.
[ "mmath", "log", "command mmath.log(x:flt):flt ",
"MATHunary_LOGflt;", "" ]
[ "mmath", "log10", "command mmath.log10(x:dbl):dbl ",
"MATHunary_LOG10dbl;", "The log10(x) function returns the base-10 logarithm of
x." ]
[ "mmath", "log10", "command mmath.log10(x:flt):flt ",
"MATHunary_LOG10flt;", "" ]
+[ "mmath", "log2", "command mmath.log2(x:dbl):dbl ",
"MATHunary_LOG2dbl;", "The log2(x) function returns the base-2 logarithm of
x." ]
+[ "mmath", "log2", "command mmath.log2(x:flt):flt ",
"MATHunary_LOG2flt;", "" ]
[ "mmath", "pi", "command mmath.pi():dbl ", "MATHpi;", "return
an important mathematical value" ]
[ "mmath", "pow", "command mmath.pow(x:dbl, y:dbl):dbl ",
"MATHbinary_POWdbl;", "The pow(x,y) function returns the value of x raised
to the power of y." ]
[ "mmath", "pow", "command mmath.pow(x:flt, y:flt):flt ",
"MATHbinary_POWflt;", "" ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -12555,6 +12555,10 @@ Ready.
[ "batmmath", "log10", "command batmmath.log10(x:bat[:dbl],
s:bat[:oid]):bat[:dbl] ", "CMDscience_bat_dbl_log10_cand;", "" ]
[ "batmmath", "log10", "command batmmath.log10(x:bat[:flt]):bat[:flt]
", "CMDscience_bat_flt_log10;", "" ]
[ "batmmath", "log10", "command batmmath.log10(x:bat[:flt],
s:bat[:oid]):bat[:flt] ", "CMDscience_bat_flt_log10_cand;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:dbl]):bat[:dbl] ",
"CMDscience_bat_dbl_log2;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:dbl],
s:bat[:oid]):bat[:dbl] ", "CMDscience_bat_dbl_log2_cand;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:flt]):bat[:flt] ",
"CMDscience_bat_flt_log2;", "" ]
+[ "batmmath", "log2", "command batmmath.log2(x:bat[:flt],
s:bat[:oid]):bat[:flt] ", "CMDscience_bat_flt_log2_cand;", "" ]
[ "batmmath", "pow", "command batmmath.pow(x:bat[:dbl], y:dbl):bat[:dbl] ",
"CMDscience_bat_cst_pow_dbl;", "" ]
[ "batmmath", "pow", "command batmmath.pow(x:bat[:dbl], y:dbl,
s:bat[:oid]):bat[:dbl] ", "CMDscience_bat_cst_pow_dbl_cand;", "" ]
[ "batmmath", "pow", "command batmmath.pow(x:bat[:flt], y:flt):bat[:flt] ",
"CMDscience_bat_cst_pow_flt;", "" ]
@@ -15680,6 +15684,8 @@ Ready.
[ "mmath", "log", "command mmath.log(x:flt):flt ",
"MATHunary_LOGflt;", "" ]
[ "mmath", "log10", "command mmath.log10(x:dbl):dbl ",
"MATHunary_LOG10dbl;", "The log10(x) function returns the base-10 logarithm of
x." ]
[ "mmath", "log10", "command mmath.log10(x:flt):flt ",
"MATHunary_LOG10flt;", "" ]
+[ "mmath", "log2", "command mmath.log2(x:dbl):dbl ",
"MATHunary_LOG2dbl;", "The log2(x) function returns the base-2 logarithm of
x." ]
+[ "mmath", "log2", "command mmath.log2(x:flt):flt ",
"MATHunary_LOG2flt;", "" ]
[ "mmath", "pi", "command mmath.pi():dbl ", "MATHpi;", "return
an important mathematical value" ]
[ "mmath", "pow", "command mmath.pow(x:dbl, y:dbl):dbl ",
"MATHbinary_POWdbl;", "The pow(x,y) function returns the value of x raised
to the power of y." ]
[ "mmath", "pow", "command mmath.pow(x:flt, y:flt):flt ",
"MATHbinary_POWflt;", "" ]
diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -1083,6 +1083,8 @@ str CMDscience_bat_dbl_floor_cand(bat *r
str CMDscience_bat_dbl_log(bat *ret, const bat *bid);
str CMDscience_bat_dbl_log10(bat *ret, const bat *bid);
str CMDscience_bat_dbl_log10_cand(bat *ret, const bat *bid, const bat *sid);
+str CMDscience_bat_dbl_log2(bat *ret, const bat *bid);
+str CMDscience_bat_dbl_log2_cand(bat *ret, const bat *bid, const bat *sid);
str CMDscience_bat_dbl_log_cand(bat *ret, const bat *bid, const bat *sid);
str CMDscience_bat_dbl_radians(bat *ret, const bat *bid);
str CMDscience_bat_dbl_radians_cand(bat *ret, const bat *bid, const bat *sid);
@@ -1121,6 +1123,8 @@ str CMDscience_bat_flt_floor_cand(bat *r
str CMDscience_bat_flt_log(bat *ret, const bat *bid);
str CMDscience_bat_flt_log10(bat *ret, const bat *bid);
str CMDscience_bat_flt_log10_cand(bat *ret, const bat *bid, const bat *sid);
+str CMDscience_bat_flt_log2(bat *ret, const bat *bid);
+str CMDscience_bat_flt_log2_cand(bat *ret, const bat *bid, const bat *sid);
str CMDscience_bat_flt_log_cand(bat *ret, const bat *bid, const bat *sid);
str CMDscience_bat_flt_radians(bat *ret, const bat *bid);
str CMDscience_bat_flt_radians_cand(bat *ret, const bat *bid, const bat *sid);
@@ -1395,6 +1399,8 @@ str MATHunary_ISINF(int *res, const dbl
str MATHunary_ISNAN(bit *res, const dbl *a);
str MATHunary_LOG10dbl(dbl *res, const dbl *a);
str MATHunary_LOG10flt(flt *res, const flt *a);
+str MATHunary_LOG2dbl(dbl *res, const dbl *a);
+str MATHunary_LOG2flt(flt *res, const flt *a);
str MATHunary_LOGdbl(dbl *res, const dbl *a);
str MATHunary_LOGflt(flt *res, const flt *a);
str MATHunary_RADIANSdbl(dbl *res, const dbl *a);
diff --git a/monetdb5/modules/kernel/batmmath.c
b/monetdb5/modules/kernel/batmmath.c
--- a/monetdb5/modules/kernel/batmmath.c
+++ b/monetdb5/modules/kernel/batmmath.c
@@ -376,6 +376,7 @@ scienceImpl(degrees)
scienceImpl(exp)
scienceImpl(log)
scienceImpl(log10)
+scienceImpl(log2)
scienceImpl(sqrt)
#ifdef HAVE_CBRT
scienceImpl(cbrt)
diff --git a/monetdb5/modules/kernel/batmmath.h
b/monetdb5/modules/kernel/batmmath.h
--- a/monetdb5/modules/kernel/batmmath.h
+++ b/monetdb5/modules/kernel/batmmath.h
@@ -38,6 +38,7 @@ scienceDef(degrees)
scienceDef(exp)
scienceDef(log)
scienceDef(log10)
+scienceDef(log2)
scienceDef(sqrt)
scienceDef(cbrt)
scienceDef(ceil)
diff --git a/monetdb5/modules/kernel/batmmath.mal
b/monetdb5/modules/kernel/batmmath.mal
--- a/monetdb5/modules/kernel/batmmath.mal
+++ b/monetdb5/modules/kernel/batmmath.mal
@@ -132,6 +132,15 @@ module batmmath;
command log10(x:bat[:flt],s:bat[:oid]) :bat[:flt]
address CMDscience_bat_flt_log10_cand;
+ command log2(x:bat[:dbl]) :bat[:dbl]
+ address CMDscience_bat_dbl_log2;
+ command log2(x:bat[:dbl],s:bat[:oid]) :bat[:dbl]
+ address CMDscience_bat_dbl_log2_cand;
+ command log2(x:bat[:flt]) :bat[:flt]
+ address CMDscience_bat_flt_log2;
+ command log2(x:bat[:flt],s:bat[:oid]) :bat[:flt]
+ address CMDscience_bat_flt_log2_cand;
+
command sqrt(x:bat[:dbl]) :bat[:dbl]
address CMDscience_bat_dbl_sqrt;
command sqrt(x:bat[:dbl],s:bat[:oid]) :bat[:dbl]
diff --git a/monetdb5/modules/kernel/mmath.c b/monetdb5/modules/kernel/mmath.c
--- a/monetdb5/modules/kernel/mmath.c
+++ b/monetdb5/modules/kernel/mmath.c
@@ -160,6 +160,7 @@ unopM5(_TANH,tanh)
unopM5(_EXP,exp)
unopM5(_LOG,log)
unopM5(_LOG10,log10)
+unopM5(_LOG2,log2)
binopM5(_POW,pow)
unopM5(_SQRT,sqrt)
diff --git a/monetdb5/modules/kernel/mmath.h b/monetdb5/modules/kernel/mmath.h
--- a/monetdb5/modules/kernel/mmath.h
+++ b/monetdb5/modules/kernel/mmath.h
@@ -43,6 +43,7 @@ unopM5_export(_DEGREES)
unopM5_export(_EXP)
unopM5_export(_LOG)
unopM5_export(_LOG10)
+unopM5_export(_LOG2)
binopM5_export(_POW)
unopM5_export(_SQRT)
diff --git a/monetdb5/modules/kernel/mmath.mal
b/monetdb5/modules/kernel/mmath.mal
--- a/monetdb5/modules/kernel/mmath.mal
+++ b/monetdb5/modules/kernel/mmath.mal
@@ -122,6 +122,12 @@ command log10(x:dbl) :dbl
address MATHunary_LOG10dbl
comment "The log10(x) function returns the base-10 logarithm of x.";
+command log2(x:flt) :flt
+address MATHunary_LOG2flt;
+command log2(x:dbl) :dbl
+address MATHunary_LOG2dbl
+comment "The log2(x) function returns the base-2 logarithm of x.";
+
command pow(x:flt,y:flt) :flt
address MATHbinary_POWflt;
diff --git a/sql/ChangeLog.Apr2019 b/sql/ChangeLog.Apr2019
--- a/sql/ChangeLog.Apr2019
+++ b/sql/ChangeLog.Apr2019
@@ -1,6 +1,10 @@
# ChangeLog file for sql
# This file is updated with Maddlog
+* Tue Jan 22 2019 Sjoerd Mullender <[email protected]>
+- Next to the functions log (natural logarithm) and log10 (base 10
+ logarithm), there is now also log2 (base 2 logarithm).
+
* Fri Jan 18 2019 Sjoerd Mullender <[email protected]>
- Removed unused global SQL variable "history".
diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -1956,6 +1956,7 @@ sqltypeinit( sql_allocator *sa)
sql_create_func(sa, "exp", "mmath", "exp", *t, NULL, *t,
SCALE_FIX);
sql_create_func(sa, "log", "mmath", "log", *t, NULL, *t,
SCALE_FIX);
sql_create_func(sa, "log10", "mmath", "log10", *t, NULL, *t,
SCALE_FIX);
+ sql_create_func(sa, "log2", "mmath", "log2", *t, NULL, *t,
SCALE_FIX);
}
sql_create_func(sa, "pi", "mmath", "pi", NULL, NULL, DBL, SCALE_NONE);
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -4778,1077 +4778,1083 @@ insert into sys.args values (24207, 1232
insert into sys.functions values (1233, 'log10', 'log10', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24208, 1233, 'res_0', 'real', 24, 0, 0, 0);
insert into sys.args values (24209, 1233, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.functions values (1234, 'power', 'pow', 'mmath', 0, 1, false,
false, false, 2000, true);
-insert into sys.args values (24210, 1234, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (24211, 1234, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.args values (24212, 1234, 'arg_2', 'double', 53, 0, 1, 2);
-insert into sys.functions values (1235, 'floor', 'floor', 'mmath', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24213, 1235, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (24214, 1235, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1236, 'ceil', 'ceil', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1234, 'log2', 'log2', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24210, 1234, 'res_0', 'real', 24, 0, 0, 0);
+insert into sys.args values (24211, 1234, 'arg_1', 'real', 24, 0, 1, 1);
+insert into sys.functions values (1235, 'power', 'pow', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24212, 1235, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (24213, 1235, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.args values (24214, 1235, 'arg_2', 'double', 53, 0, 1, 2);
+insert into sys.functions values (1236, 'floor', 'floor', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24215, 1236, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24216, 1236, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1237, 'ceiling', 'ceil', 'mmath', 0, 1,
false, false, false, 2000, true);
+insert into sys.functions values (1237, 'ceil', 'ceil', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24217, 1237, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24218, 1237, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1238, 'sin', 'sin', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1238, 'ceiling', 'ceil', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24219, 1238, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24220, 1238, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1239, 'cos', 'cos', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1239, 'sin', 'sin', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24221, 1239, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24222, 1239, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1240, 'tan', 'tan', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1240, 'cos', 'cos', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24223, 1240, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24224, 1240, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1241, 'asin', 'asin', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1241, 'tan', 'tan', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24225, 1241, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24226, 1241, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1242, 'acos', 'acos', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1242, 'asin', 'asin', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24227, 1242, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24228, 1242, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1243, 'atan', 'atan', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1243, 'acos', 'acos', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24229, 1243, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24230, 1243, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1244, 'atan', 'atan2', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1244, 'atan', 'atan', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24231, 1244, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24232, 1244, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.args values (24233, 1244, 'arg_2', 'double', 53, 0, 1, 2);
-insert into sys.functions values (1245, 'sinh', 'sinh', 'mmath', 0, 1, false,
false, false, 2000, true);
-insert into sys.args values (24234, 1245, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (24235, 1245, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1246, 'cot', 'cot', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1245, 'atan', 'atan2', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24233, 1245, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (24234, 1245, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.args values (24235, 1245, 'arg_2', 'double', 53, 0, 1, 2);
+insert into sys.functions values (1246, 'sinh', 'sinh', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24236, 1246, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24237, 1246, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1247, 'cosh', 'cosh', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1247, 'cot', 'cot', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24238, 1247, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24239, 1247, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1248, 'tanh', 'tanh', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1248, 'cosh', 'cosh', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24240, 1248, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24241, 1248, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1249, 'sqrt', 'sqrt', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1249, 'tanh', 'tanh', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24242, 1249, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24243, 1249, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1250, 'exp', 'exp', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1250, 'sqrt', 'sqrt', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24244, 1250, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24245, 1250, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1251, 'log', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1251, 'exp', 'exp', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24246, 1251, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24247, 1251, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1252, 'log10', 'log10', 'mmath', 0, 1,
false, false, false, 2000, true);
+insert into sys.functions values (1252, 'log', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24248, 1252, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24249, 1252, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1253, 'pi', 'pi', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1253, 'log10', 'log10', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24250, 1253, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.functions values (1254, 'rand', 'rand', 'mmath', 0, 1, true,
false, false, 2000, true);
-insert into sys.args values (24251, 1254, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.functions values (1255, 'rand', 'sqlrand', 'mmath', 0, 1,
true, false, false, 2000, true);
-insert into sys.args values (24252, 1255, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (24253, 1255, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.functions values (1256, 'curdate', 'current_date', 'mtime', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (24254, 1256, 'res_0', 'date', 0, 0, 0, 0);
-insert into sys.functions values (1257, 'current_date', 'current_date',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24255, 1257, 'res_0', 'date', 0, 0, 0, 0);
-insert into sys.functions values (1258, 'curtime', 'current_time', 'mtime', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (24256, 1258, 'res_0', 'timetz', 7, 0, 0, 0);
-insert into sys.functions values (1259, 'current_time', 'current_time',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24257, 1259, 'res_0', 'timetz', 7, 0, 0, 0);
-insert into sys.functions values (1260, 'current_timestamp',
'current_timestamp', 'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24258, 1260, 'res_0', 'timestamptz', 7, 0, 0, 0);
-insert into sys.functions values (1261, 'localtime', 'current_time', 'sql', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (24259, 1261, 'res_0', 'time', 7, 0, 0, 0);
-insert into sys.functions values (1262, 'localtimestamp', 'current_timestamp',
'sql', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24260, 1262, 'res_0', 'timestamp', 7, 0, 0, 0);
-insert into sys.functions values (1263, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24261, 1263, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (24262, 1263, 'arg_1', 'date', 0, 0, 1, 1);
-insert into sys.args values (24263, 1263, 'arg_2', 'date', 0, 0, 1, 2);
-insert into sys.functions values (1264, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
