yum upgrade doesn't allow existing db use new window functions

9 Jul 2019

      Hi,
I ran:
yum upgrade MonetDB-SQL-server5 MonetDB-client

When I create a new db I can call:

select first_value(col1) over (partition by col2) from analytics;

as per the blog monetdb.org/blog/extended_sql_window_functions

However a db that existed before the update returns:
Function first_value not found.

I can see first_value in sys.functions.

Any suggestions?

Thanks!

Andy Allaway