-- The contents of this file are subject to the MonetDB Public License
-- Version 1.1 (the "License"); you may not use this file except in
-- compliance with the License. You may obtain a copy of the License at
-- http://www.monetdb.org/Legal/MonetDBLicense
--
-- Software distributed under the License is distributed on an "AS IS"
-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-- License for the specific language governing rights and limitations
-- under the License.
--
-- The Original Code is the MonetDB Database System.
--
-- The Initial Developer of the Original Code is CWI.
-- Portions created by CWI are Copyright (C) 1997-July 2008 CWI.
-- Copyright August 2008-2014 MonetDB B.V.
-- All Rights Reserved.

create table systemfunctions (function_id)
	as (select id from functions) with data;
grant select on systemfunctions to public;
update _tables
	set system = true
	where name = 'systemfunctions'
		and schema_id = (select id from schemas where name = 'sys');

-- so far only system schemas
update schemas set system = true;

-- The contents of this file are subject to the MonetDB Public License
-- Version 1.1 (the "License"); you may not use this file except in
-- compliance with the License. You may obtain a copy of the License at
-- http://www.monetdb.org/Legal/MonetDBLicense
--
-- Software distributed under the License is distributed on an "AS IS"
-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-- License for the specific language governing rights and limitations
-- under the License.
--
-- The Original Code is the MonetDB Database System.
--
-- The Initial Developer of the Original Code is CWI.
-- Portions created by CWI are Copyright (C) 1997-July 2008 CWI.
-- Copyright August 2008-2014 MonetDB B.V.
-- All Rights Reserved.

create table systemfunctions (function_id)
	as (select id from functions) with data;
grant select on systemfunctions to public;
update _tables
	set system = true
	where name = 'systemfunctions'
		and schema_id = (select id from schemas where name = 'sys');

-- so far only system schemas
update schemas set system = true;

COMMIT;
Add an explicit commit statement at the end of the system.sql script. This should force commit the changes applied by the previous scripts, s.t. when these are executed on SQL store init, they are applied.
Add an explicit commit statement at the end of the system.sql script.
This should force commit the changes applied by the previous scripts, s.t. when these are executed on SQL store init, they are applied.
