Changeset: eb7336df7825 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/eb7336df7825
Modified Files:
sql/test/nested/Tests/events.test.in
sql/test/nested/Tests/webclicks.test.in
Branch: nested
Log Message:
use create or replace
diffs (36 lines):
diff --git a/sql/test/nested/Tests/events.test.in
b/sql/test/nested/Tests/events.test.in
--- a/sql/test/nested/Tests/events.test.in
+++ b/sql/test/nested/Tests/events.test.in
@@ -54,12 +54,12 @@ statement ok
insert into events select * from read_ndjson(r'$TSTSRCDIR/events.ndjson')
statement ok
-CREATE FUNCTION pcre_match(s string, pattern string) RETURNS boolean EXTERNAL
NAME pcre."match"
+CREATE OR REPLACE FUNCTION pcre_match(s string, pattern string) RETURNS
boolean EXTERNAL NAME pcre."match"
# this is not exactly the functionality intended
# in the large query to follow
statement ok
-create function REGEXP_EXTRACT(s string, pattern string)
+create or replace function REGEXP_EXTRACT(s string, pattern string)
returns string
begin
if (pcre_match(s, pattern))
diff --git a/sql/test/nested/Tests/webclicks.test.in
b/sql/test/nested/Tests/webclicks.test.in
--- a/sql/test/nested/Tests/webclicks.test.in
+++ b/sql/test/nested/Tests/webclicks.test.in
@@ -221,12 +221,12 @@ select ecommerce from events
#----
statement ok
-CREATE FUNCTION pcre_match(s string, pattern string) RETURNS boolean EXTERNAL
NAME pcre."match"
+CREATE OR REPLACE FUNCTION pcre_match(s string, pattern string) RETURNS
boolean EXTERNAL NAME pcre."match"
# this is not exactly the functionality intended
# in the large query to follow
statement ok
-create function REGEXP_EXTRACT(s string, pattern string)
+create or replace function REGEXP_EXTRACT(s string, pattern string)
returns string
begin
if (pcre_match(s, pattern))
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
