Changeset: 9cb052c21919 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9cb052c21919
Modified Files:
sql/common/sql_types.c
sql/test/Tests/systemfunctions.stable.out
sql/test/Tests/systemfunctions.stable.out.int128
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 ln as alias for function log.
Fixes bug 3520.
diffs (truncated from 40123 to 300 lines):
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
@@ -1466,7 +1466,7 @@ sqltypeinit( sql_allocator *sa)
}
#endif
- /* float(n) (n indicates precision of atleast n digits) */
+ /* float(n) (n indicates precision of at least n digits) */
/* ie n <= 23 -> flt */
/* n <= 51 -> dbl */
/* n <= 62 -> long long dbl (with -ieee) (not supported) */
@@ -1954,6 +1954,7 @@ sqltypeinit( sql_allocator *sa)
sql_create_func(sa, "sqrt", "mmath", "sqrt", *t, NULL, *t,
SCALE_FIX);
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, "ln", "mmath", "log", *t, NULL, *t,
SCALE_FIX);
sql_create_func(sa, "log", "mmath", "log", *t, *t, *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);
diff --git a/sql/test/Tests/systemfunctions.stable.out
b/sql/test/Tests/systemfunctions.stable.out
--- a/sql/test/Tests/systemfunctions.stable.out
+++ b/sql/test/Tests/systemfunctions.stable.out
@@ -969,6 +969,10 @@ Ready.
[ "sys", "listdir", 0, "clob", "create procedure
listdir(dirname string) external name fits.listdir;" ]
[ "sys", "listdirpat", 0, "clob", "create procedure
listdirpat(dirname string,pat string) external name fits.listdirpattern;" ]
[ "sys", "listdirpat", 1, "clob", "" ]
+[ "sys", "ln", 0, "real", "log" ]
+[ "sys", "ln", 1, "real", "" ]
+[ "sys", "ln", 0, "double", "log" ]
+[ "sys", "ln", 1, "double", "" ]
[ "sys", "local_timezone", 0, "sec_interval",
"local_timezone" ]
[ "sys", "localtime", 0, "time", "current_time" ]
[ "sys", "localtimestamp", 0, "timestamp",
"current_timestamp" ]
diff --git a/sql/test/Tests/systemfunctions.stable.out.int128
b/sql/test/Tests/systemfunctions.stable.out.int128
--- a/sql/test/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/Tests/systemfunctions.stable.out.int128
@@ -1043,6 +1043,10 @@ Ready.
[ "sys", "listdir", 0, "clob", "create procedure
listdir(dirname string) external name fits.listdir;" ]
[ "sys", "listdirpat", 0, "clob", "create procedure
listdirpat(dirname string,pat string) external name fits.listdirpattern;" ]
[ "sys", "listdirpat", 1, "clob", "" ]
+[ "sys", "ln", 0, "real", "log" ]
+[ "sys", "ln", 1, "real", "" ]
+[ "sys", "ln", 0, "double", "log" ]
+[ "sys", "ln", 1, "double", "" ]
[ "sys", "local_timezone", 0, "sec_interval",
"local_timezone" ]
[ "sys", "localtime", 0, "time", "current_time" ]
[ "sys", "localtimestamp", 0, "timestamp",
"current_timestamp" ]
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
@@ -4781,1094 +4781,1100 @@ insert into sys.args values (24209, 1233
insert into sys.functions values (1234, 'log', 'log', '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, 'log', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1235, 'ln', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24212, 1235, 'res_0', 'real', 24, 0, 0, 0);
insert into sys.args values (24213, 1235, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.args values (24214, 1235, 'arg_2', 'real', 24, 0, 1, 2);
-insert into sys.functions values (1236, 'log10', 'log10', 'mmath', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24215, 1236, 'res_0', 'real', 24, 0, 0, 0);
-insert into sys.args values (24216, 1236, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.functions values (1237, 'log2', 'log2', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1236, 'log', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24214, 1236, 'res_0', 'real', 24, 0, 0, 0);
+insert into sys.args values (24215, 1236, 'arg_1', 'real', 24, 0, 1, 1);
+insert into sys.args values (24216, 1236, 'arg_2', 'real', 24, 0, 1, 2);
+insert into sys.functions values (1237, 'log10', 'log10', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24217, 1237, 'res_0', 'real', 24, 0, 0, 0);
insert into sys.args values (24218, 1237, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.functions values (1238, 'power', 'pow', '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.args values (24221, 1238, 'arg_2', 'double', 53, 0, 1, 2);
-insert into sys.functions values (1239, 'floor', 'floor', 'mmath', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24222, 1239, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (24223, 1239, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1240, 'ceil', 'ceil', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1238, 'log2', 'log2', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24219, 1238, 'res_0', 'real', 24, 0, 0, 0);
+insert into sys.args values (24220, 1238, 'arg_1', 'real', 24, 0, 1, 1);
+insert into sys.functions values (1239, 'power', 'pow', '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.args values (24223, 1239, 'arg_2', 'double', 53, 0, 1, 2);
+insert into sys.functions values (1240, 'floor', 'floor', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24224, 1240, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24225, 1240, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1241, 'ceiling', 'ceil', 'mmath', 0, 1,
false, false, false, 2000, true);
+insert into sys.functions values (1241, 'ceil', 'ceil', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24226, 1241, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24227, 1241, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1242, 'sin', 'sin', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1242, 'ceiling', 'ceil', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24228, 1242, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24229, 1242, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1243, 'cos', 'cos', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1243, 'sin', 'sin', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24230, 1243, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24231, 1243, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1244, 'tan', 'tan', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1244, 'cos', 'cos', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24232, 1244, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24233, 1244, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1245, 'asin', 'asin', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1245, 'tan', 'tan', '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, 'acos', 'acos', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1246, 'asin', 'asin', '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, 'atan', 'atan', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1247, 'acos', 'acos', '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, 'atan', 'atan2', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1248, 'atan', 'atan', '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.args values (24242, 1248, 'arg_2', 'double', 53, 0, 1, 2);
-insert into sys.functions values (1249, 'sinh', 'sinh', 'mmath', 0, 1, false,
false, false, 2000, true);
-insert into sys.args values (24243, 1249, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (24244, 1249, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1250, 'cot', 'cot', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1249, 'atan', 'atan2', '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.args values (24244, 1249, 'arg_2', 'double', 53, 0, 1, 2);
+insert into sys.functions values (1250, 'sinh', 'sinh', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24245, 1250, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24246, 1250, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1251, 'cosh', 'cosh', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1251, 'cot', 'cot', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24247, 1251, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24248, 1251, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1252, 'tanh', 'tanh', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1252, 'cosh', 'cosh', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24249, 1252, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24250, 1252, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1253, 'sqrt', 'sqrt', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1253, 'tanh', 'tanh', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24251, 1253, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24252, 1253, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1254, 'exp', 'exp', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1254, 'sqrt', 'sqrt', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24253, 1254, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24254, 1254, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1255, 'log', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1255, 'exp', 'exp', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24255, 1255, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24256, 1255, 'arg_1', 'double', 53, 0, 1, 1);
insert into sys.functions values (1256, 'log', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
insert into sys.args values (24257, 1256, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.args values (24258, 1256, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.args values (24259, 1256, 'arg_2', 'double', 53, 0, 1, 2);
-insert into sys.functions values (1257, 'log10', 'log10', 'mmath', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24260, 1257, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (24261, 1257, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1258, 'log2', 'log2', 'mmath', 0, 1, false,
false, false, 2000, true);
-insert into sys.args values (24262, 1258, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (24263, 1258, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (1259, 'pi', 'pi', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.functions values (1257, 'ln', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24259, 1257, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (24260, 1257, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.functions values (1258, 'log', 'log', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24261, 1258, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (24262, 1258, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.args values (24263, 1258, 'arg_2', 'double', 53, 0, 1, 2);
+insert into sys.functions values (1259, 'log10', 'log10', 'mmath', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (24264, 1259, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.functions values (1260, 'rand', 'rand', 'mmath', 0, 1, true,
false, false, 2000, true);
-insert into sys.args values (24265, 1260, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.functions values (1261, 'rand', 'sqlrand', 'mmath', 0, 1,
true, false, false, 2000, true);
-insert into sys.args values (24266, 1261, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (24267, 1261, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.functions values (1262, 'curdate', 'current_date', 'mtime', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (24268, 1262, 'res_0', 'date', 0, 0, 0, 0);
-insert into sys.functions values (1263, 'current_date', 'current_date',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24269, 1263, 'res_0', 'date', 0, 0, 0, 0);
-insert into sys.functions values (1264, 'curtime', 'current_time', 'mtime', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (24270, 1264, 'res_0', 'timetz', 7, 0, 0, 0);
-insert into sys.functions values (1265, 'current_time', 'current_time',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24271, 1265, 'res_0', 'timetz', 7, 0, 0, 0);
-insert into sys.functions values (1266, 'current_timestamp',
'current_timestamp', 'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24272, 1266, 'res_0', 'timestamptz', 7, 0, 0, 0);
-insert into sys.functions values (1267, 'localtime', 'current_time', 'sql', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (24273, 1267, 'res_0', 'time', 7, 0, 0, 0);
-insert into sys.functions values (1268, 'localtimestamp', 'current_timestamp',
'sql', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24274, 1268, 'res_0', 'timestamp', 7, 0, 0, 0);
-insert into sys.functions values (1269, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24275, 1269, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (24276, 1269, 'arg_1', 'date', 0, 0, 1, 1);
-insert into sys.args values (24277, 1269, 'arg_2', 'date', 0, 0, 1, 2);
-insert into sys.functions values (1270, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24278, 1270, 'res_0', 'sec_interval', 13, 0, 0,
0);
-insert into sys.args values (24279, 1270, 'arg_1', 'timetz', 7, 0, 1, 1);
-insert into sys.args values (24280, 1270, 'arg_2', 'timetz', 7, 0, 1, 2);
+insert into sys.args values (24265, 1259, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.functions values (1260, 'log2', 'log2', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24266, 1260, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (24267, 1260, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.functions values (1261, 'pi', 'pi', 'mmath', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (24268, 1261, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.functions values (1262, 'rand', 'rand', 'mmath', 0, 1, true,
false, false, 2000, true);
+insert into sys.args values (24269, 1262, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.functions values (1263, 'rand', 'sqlrand', 'mmath', 0, 1,
true, false, false, 2000, true);
+insert into sys.args values (24270, 1263, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (24271, 1263, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.functions values (1264, 'curdate', 'current_date', 'mtime', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (24272, 1264, 'res_0', 'date', 0, 0, 0, 0);
+insert into sys.functions values (1265, 'current_date', 'current_date',
'mtime', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24273, 1265, 'res_0', 'date', 0, 0, 0, 0);
+insert into sys.functions values (1266, 'curtime', 'current_time', 'mtime', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (24274, 1266, 'res_0', 'timetz', 7, 0, 0, 0);
+insert into sys.functions values (1267, 'current_time', 'current_time',
'mtime', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24275, 1267, 'res_0', 'timetz', 7, 0, 0, 0);
+insert into sys.functions values (1268, 'current_timestamp',
'current_timestamp', 'mtime', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24276, 1268, 'res_0', 'timestamptz', 7, 0, 0, 0);
+insert into sys.functions values (1269, 'localtime', 'current_time', 'sql', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (24277, 1269, 'res_0', 'time', 7, 0, 0, 0);
+insert into sys.functions values (1270, 'localtimestamp', 'current_timestamp',
'sql', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24278, 1270, 'res_0', 'timestamp', 7, 0, 0, 0);
insert into sys.functions values (1271, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24281, 1271, 'res_0', 'sec_interval', 13, 0, 0,
0);
-insert into sys.args values (24282, 1271, 'arg_1', 'time', 7, 0, 1, 1);
-insert into sys.args values (24283, 1271, 'arg_2', 'time', 7, 0, 1, 2);
+insert into sys.args values (24279, 1271, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (24280, 1271, 'arg_1', 'date', 0, 0, 1, 1);
+insert into sys.args values (24281, 1271, 'arg_2', 'date', 0, 0, 1, 2);
insert into sys.functions values (1272, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24284, 1272, 'res_0', 'sec_interval', 13, 0, 0,
0);
-insert into sys.args values (24285, 1272, 'arg_1', 'timestamptz', 7, 0, 1, 1);
-insert into sys.args values (24286, 1272, 'arg_2', 'timestamptz', 7, 0, 1, 2);
+insert into sys.args values (24282, 1272, 'res_0', 'sec_interval', 13, 0, 0,
0);
+insert into sys.args values (24283, 1272, 'arg_1', 'timetz', 7, 0, 1, 1);
+insert into sys.args values (24284, 1272, 'arg_2', 'timetz', 7, 0, 1, 2);
insert into sys.functions values (1273, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (24287, 1273, 'res_0', 'sec_interval', 13, 0, 0,
0);
-insert into sys.args values (24288, 1273, 'arg_1', 'timestamp', 7, 0, 1, 1);
-insert into sys.args values (24289, 1273, 'arg_2', 'timestamp', 7, 0, 1, 2);
-insert into sys.functions values (1274, 'sql_sub', 'date_sub_msec_interval',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24290, 1274, 'res_0', 'date', 0, 0, 0, 0);
-insert into sys.args values (24291, 1274, 'arg_1', 'date', 0, 0, 1, 1);
-insert into sys.args values (24292, 1274, 'arg_2', 'sec_interval', 13, 0, 1,
2);
-insert into sys.functions values (1275, 'sql_sub', 'date_sub_month_interval',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24293, 1275, 'res_0', 'date', 0, 0, 0, 0);
-insert into sys.args values (24294, 1275, 'arg_1', 'date', 0, 0, 1, 1);
-insert into sys.args values (24295, 1275, 'arg_2', 'month_interval', 32, 0, 1,
2);
-insert into sys.functions values (1276, 'sql_sub', 'time_sub_msec_interval',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24296, 1276, 'res_0', 'time', 7, 0, 0, 0);
-insert into sys.args values (24297, 1276, 'arg_1', 'time', 7, 0, 1, 1);
-insert into sys.args values (24298, 1276, 'arg_2', 'sec_interval', 13, 0, 1,
2);
-insert into sys.functions values (1277, 'sql_sub', 'time_sub_msec_interval',
'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24299, 1277, 'res_0', 'timetz', 7, 0, 0, 0);
-insert into sys.args values (24300, 1277, 'arg_1', 'timetz', 7, 0, 1, 1);
-insert into sys.args values (24301, 1277, 'arg_2', 'sec_interval', 13, 0, 1,
2);
-insert into sys.functions values (1278, 'sql_sub',
'timestamp_sub_msec_interval', 'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24302, 1278, 'res_0', 'timestamp', 7, 0, 0, 0);
-insert into sys.args values (24303, 1278, 'arg_1', 'timestamp', 7, 0, 1, 1);
-insert into sys.args values (24304, 1278, 'arg_2', 'sec_interval', 13, 0, 1,
2);
-insert into sys.functions values (1279, 'sql_sub',
'timestamp_sub_month_interval', 'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24305, 1279, 'res_0', 'timestamp', 7, 0, 0, 0);
-insert into sys.args values (24306, 1279, 'arg_1', 'timestamp', 7, 0, 1, 1);
-insert into sys.args values (24307, 1279, 'arg_2', 'month_interval', 32, 0, 1,
2);
+insert into sys.args values (24285, 1273, 'res_0', 'sec_interval', 13, 0, 0,
0);
+insert into sys.args values (24286, 1273, 'arg_1', 'time', 7, 0, 1, 1);
+insert into sys.args values (24287, 1273, 'arg_2', 'time', 7, 0, 1, 2);
+insert into sys.functions values (1274, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (24288, 1274, 'res_0', 'sec_interval', 13, 0, 0,
0);
+insert into sys.args values (24289, 1274, 'arg_1', 'timestamptz', 7, 0, 1, 1);
+insert into sys.args values (24290, 1274, 'arg_2', 'timestamptz', 7, 0, 1, 2);
+insert into sys.functions values (1275, 'sql_sub', 'diff', 'mtime', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (24291, 1275, 'res_0', 'sec_interval', 13, 0, 0,
0);
+insert into sys.args values (24292, 1275, 'arg_1', 'timestamp', 7, 0, 1, 1);
+insert into sys.args values (24293, 1275, 'arg_2', 'timestamp', 7, 0, 1, 2);
+insert into sys.functions values (1276, 'sql_sub', 'date_sub_msec_interval',
'mtime', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24294, 1276, 'res_0', 'date', 0, 0, 0, 0);
+insert into sys.args values (24295, 1276, 'arg_1', 'date', 0, 0, 1, 1);
+insert into sys.args values (24296, 1276, 'arg_2', 'sec_interval', 13, 0, 1,
2);
+insert into sys.functions values (1277, 'sql_sub', 'date_sub_month_interval',
'mtime', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24297, 1277, 'res_0', 'date', 0, 0, 0, 0);
+insert into sys.args values (24298, 1277, 'arg_1', 'date', 0, 0, 1, 1);
+insert into sys.args values (24299, 1277, 'arg_2', 'month_interval', 32, 0, 1,
2);
+insert into sys.functions values (1278, 'sql_sub', 'time_sub_msec_interval',
'mtime', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24300, 1278, 'res_0', 'time', 7, 0, 0, 0);
+insert into sys.args values (24301, 1278, 'arg_1', 'time', 7, 0, 1, 1);
+insert into sys.args values (24302, 1278, 'arg_2', 'sec_interval', 13, 0, 1,
2);
+insert into sys.functions values (1279, 'sql_sub', 'time_sub_msec_interval',
'mtime', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (24303, 1279, 'res_0', 'timetz', 7, 0, 0, 0);
+insert into sys.args values (24304, 1279, 'arg_1', 'timetz', 7, 0, 1, 1);
+insert into sys.args values (24305, 1279, 'arg_2', 'sec_interval', 13, 0, 1,
2);
insert into sys.functions values (1280, 'sql_sub',
'timestamp_sub_msec_interval', 'mtime', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (24308, 1280, 'res_0', 'timestamptz', 7, 0, 0, 0);
-insert into sys.args values (24309, 1280, 'arg_1', 'timestamptz', 7, 0, 1, 1);
-insert into sys.args values (24310, 1280, 'arg_2', 'sec_interval', 13, 0, 1,
2);
+insert into sys.args values (24306, 1280, 'res_0', 'timestamp', 7, 0, 0, 0);
+insert into sys.args values (24307, 1280, 'arg_1', 'timestamp', 7, 0, 1, 1);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
