Changeset: a4ae02311a47 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a4ae02311a47
Modified Files:
sql/common/sql_types.c
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: Oct2020
Log Message:
Added missing extract function on intervals, we have to approve the upgrade
tests again
diffs (92 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
@@ -1833,6 +1833,10 @@ sqltypeinit( sql_allocator *sa)
sql_create_func(sa, "year", "mtime", "year", FALSE, FALSE, SCALE_NONE,
0, INT, 1, MONINT);
sql_create_func(sa, "month", "mtime", "month", FALSE, FALSE,
SCALE_NONE, 0, INT, 1, MONINT);
sql_create_func(sa, "day", "mtime", "day", FALSE, FALSE, SCALE_NONE, 0,
LNG, 1, DAYINT);
+ sql_create_func(sa, "hour", "mtime", "hours", FALSE, FALSE, SCALE_NONE,
0, INT, 1, DAYINT);
+ sql_create_func(sa, "minute", "mtime", "minutes", FALSE, FALSE,
SCALE_NONE, 0, INT, 1, DAYINT);
+ sql_create_func(sa, "second", "mtime", "seconds", FALSE, FALSE,
SCALE_NONE, 0, INT, 1, DAYINT);
+ sql_create_func(sa, "day", "mtime", "day", FALSE, FALSE, SCALE_NONE, 0,
LNG, 1, SECINT);
sql_create_func(sa, "hour", "mtime", "hours", FALSE, FALSE, SCALE_NONE,
0, INT, 1, SECINT);
sql_create_func(sa, "minute", "mtime", "minutes", FALSE, FALSE,
SCALE_NONE, 0, INT, 1, SECINT);
sql_create_func(sa, "second", "mtime", "seconds", FALSE, FALSE,
SCALE_NONE, 0, INT, 1, SECINT);
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -601,6 +601,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "day", 1, "timestamptz", "" ]
[ "sys", "day", 0, "bigint", "day" ]
[ "sys", "day", 1, "day_interval", "" ]
+[ "sys", "day", 0, "bigint", "day" ]
+[ "sys", "day", 1, "sec_interval", "" ]
[ "sys", "dayofmonth", 0, "int", "day" ]
[ "sys", "dayofmonth", 1, "date", "" ]
[ "sys", "dayofweek", 0, "int", "dayofweek" ]
@@ -862,6 +864,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "hour", 0, "int", "hours" ]
[ "sys", "hour", 1, "timestamptz", "" ]
[ "sys", "hour", 0, "int", "hours" ]
+[ "sys", "hour", 1, "day_interval", "" ]
+[ "sys", "hour", 0, "int", "hours" ]
[ "sys", "hour", 1, "sec_interval", "" ]
[ "sys", "identity", 0, "oid", "identity" ]
[ "sys", "identity", 1, "any", "" ]
@@ -1424,6 +1428,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "minute", 0, "int", "minutes" ]
[ "sys", "minute", 1, "timestamptz", "" ]
[ "sys", "minute", 0, "int", "minutes" ]
+[ "sys", "minute", 1, "day_interval", "" ]
+[ "sys", "minute", 0, "int", "minutes" ]
[ "sys", "minute", 1, "sec_interval", "" ]
[ "sys", "mod", 0, "tinyint", "%" ]
[ "sys", "mod", 1, "tinyint", "" ]
@@ -2290,6 +2296,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "second", 0, "decimal", "sql_seconds" ]
[ "sys", "second", 1, "timestamptz", "" ]
[ "sys", "second", 0, "int", "seconds" ]
+[ "sys", "second", 1, "day_interval", "" ]
+[ "sys", "second", 0, "int", "seconds" ]
[ "sys", "second", 1, "sec_interval", "" ]
[ "sys", "sessions", 0, "int", "create function
sys.sessions()\nreturns table(\n\"sessionid\" int,\n\"username\"
string,\n\"login\" timestamp,\n\"idle\" timestamp,\n\"optimizer\"
string,\n\"sessiontimeout\" int,\n\"querytimeout\" int,\n\"workerlimit\"
int,\n\"memorylimit\" int\n)\nexternal name sql.sessions;" ]
[ "sys", "sessions", 1, "clob", "" ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
@@ -656,6 +656,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "day", 1, "timestamptz", "" ]
[ "sys", "day", 0, "bigint", "day" ]
[ "sys", "day", 1, "day_interval", "" ]
+[ "sys", "day", 0, "bigint", "day" ]
+[ "sys", "day", 1, "sec_interval", "" ]
[ "sys", "dayofmonth", 0, "int", "day" ]
[ "sys", "dayofmonth", 1, "date", "" ]
[ "sys", "dayofweek", 0, "int", "dayofweek" ]
@@ -929,6 +931,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "hour", 0, "int", "hours" ]
[ "sys", "hour", 1, "timestamptz", "" ]
[ "sys", "hour", 0, "int", "hours" ]
+[ "sys", "hour", 1, "day_interval", "" ]
+[ "sys", "hour", 0, "int", "hours" ]
[ "sys", "hour", 1, "sec_interval", "" ]
[ "sys", "identity", 0, "oid", "identity" ]
[ "sys", "identity", 1, "any", "" ]
@@ -1523,6 +1527,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "minute", 0, "int", "minutes" ]
[ "sys", "minute", 1, "timestamptz", "" ]
[ "sys", "minute", 0, "int", "minutes" ]
+[ "sys", "minute", 1, "day_interval", "" ]
+[ "sys", "minute", 0, "int", "minutes" ]
[ "sys", "minute", 1, "sec_interval", "" ]
[ "sys", "mod", 0, "tinyint", "%" ]
[ "sys", "mod", 1, "tinyint", "" ]
@@ -2566,6 +2572,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "second", 0, "decimal", "sql_seconds" ]
[ "sys", "second", 1, "timestamptz", "" ]
[ "sys", "second", 0, "int", "seconds" ]
+[ "sys", "second", 1, "day_interval", "" ]
+[ "sys", "second", 0, "int", "seconds" ]
[ "sys", "second", 1, "sec_interval", "" ]
[ "sys", "sessions", 0, "int", "create function
sys.sessions()\nreturns table(\n\"sessionid\" int,\n\"username\"
string,\n\"login\" timestamp,\n\"idle\" timestamp,\n\"optimizer\"
string,\n\"sessiontimeout\" int,\n\"querytimeout\" int,\n\"workerlimit\"
int,\n\"memorylimit\" int\n)\nexternal name sql.sessions;" ]
[ "sys", "sessions", 1, "clob", "" ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
