Changeset: 9ce22b66fa23 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9ce22b66fa23 Added Files: sql/scripts/49_strings.sql Modified Files: sql/backends/monet5/CMakeLists.txt sql/scripts/CMakeLists.txt Branch: txtsim Log Message:
Make functions part of the system diffs (73 lines): diff --git a/sql/backends/monet5/CMakeLists.txt b/sql/backends/monet5/CMakeLists.txt --- a/sql/backends/monet5/CMakeLists.txt +++ b/sql/backends/monet5/CMakeLists.txt @@ -102,6 +102,7 @@ set(include_sql_files 46_profiler 47_regexp 48_txtsim + 49_strings 52_describe 58_hot_snapshot 75_storagemodel diff --git a/sql/scripts/49_strings.sql b/sql/scripts/49_strings.sql new file mode 100644 --- /dev/null +++ b/sql/scripts/49_strings.sql @@ -0,0 +1,46 @@ +-- SPDX-License-Identifier: MPL-2.0 +-- +-- This Source Code Form is subject to the terms of the Mozilla Public +-- License, v. 2.0. If a copy of the MPL was not distributed with this +-- file, You can obtain one at http://mozilla.org/MPL/2.0/. +-- +-- Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V. + +create function sys.startswith(x string, y string) +returns boolean external name str."startsWith"; +grant execute on function startswith(string, string) to public; + +create function sys.startswith(x string, y string, icase boolean) +returns boolean external name str."startsWith"; +grant execute on function startswith(string, string, boolean) to public; + +create filter function startswith(x string, y string) +external name str."startsWith"; + +create filter function startswith(x string, y string, icase boolean) +external name str."startsWith"; + +create function sys.endswith(x string, y string) +returns boolean external name str."endsWith"; +grant execute on function endswith(string, string) to public; + +create function sys.endswith(x string, y string, icase boolean) +returns boolean external name str."endsWith"; +grant execute on function endswith(string, string, boolean) to public; + +create filter function endswith(s1 string, s2 string, icase boolean) +external name str."endsWith"; + +create function sys.contains(x string, y string) +returns boolean external name str."contains"; +grant execute on function contains(string, string) to public; + +create function sys.contains(x string, y string, icase boolean) +returns boolean external name str."contains"; +grant execute on function contains(string, string, boolean) to public; + +create function contains(x string, y string, icase boolean) +returns boolean external name str."contains"; + +create filter function contains(x string, y string, icase boolean) +external name str."contains"; diff --git a/sql/scripts/CMakeLists.txt b/sql/scripts/CMakeLists.txt --- a/sql/scripts/CMakeLists.txt +++ b/sql/scripts/CMakeLists.txt @@ -31,6 +31,7 @@ install(FILES 46_profiler.sql 47_regexp.sql 48_txtsim.sql + 49_strings.sql 52_describe.sql 58_hot_snapshot.sql 75_storagemodel.sql _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
