Changeset: 5813e3c85ab4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5813e3c85ab4
Branch: default
Log Message:
merged
diffs (30 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2593,6 +2593,14 @@ sql_update_default(Client c, mvc *sql, c
}
}
+ if (!err)
+ err = SQLstatementIntern(
+ c,
+ "ALTER TABLE sys.function_types SET
READ WRITE;\n"
+ "UPDATE sys.function_types SET
function_type_keyword = 'WINDOW' WHERE function_type_id = 6;\n",
+ "ALTER TABLE sys.function_types SET
READ ONLY;\n"
+ "update", true, false, NULL);
+
bailout:
if (b)
BBPunfix(b->batCacheid);
diff --git a/sql/scripts/51_sys_schema_extension.sql
b/sql/scripts/51_sys_schema_extension.sql
--- a/sql/scripts/51_sys_schema_extension.sql
+++ b/sql/scripts/51_sys_schema_extension.sql
@@ -348,7 +348,7 @@ INSERT INTO sys.function_types (function
(3, 'Aggregate function', 'AGGREGATE'),
(4, 'Filter function', 'FILTER FUNCTION'),
(5, 'Function returning a table', 'FUNCTION'),
- (6, 'Analytic function', 'FUNCTION'),
+ (6, 'Analytic function', 'WINDOW'),
(7, 'Loader function', 'LOADER');
ALTER TABLE sys.function_types SET READ ONLY;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
