src/test/regress/sql/orca_udfs.sql.in

drop schema if exists %%GPOPTUTILS_NAMESPACE%% cascade;

create schema %%GPOPTUTILS_NAMESPACE%%;

-- start_ignore
\set Udflib `echo "$GPHOME/lib/libgpoptudf.%%EXT%%"`
-- end_ignore

create function %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(text) returns text as :'Udflib', 'EvalExprFromDXLFile' language c strict;
create function %%GPOPTUTILS_NAMESPACE%%.OptimizeMinidumpFromFile(text) returns text as :'Udflib', 'OptimizeMinidumpFromFile' language c strict;
create function %%GPOPTUTILS_NAMESPACE%%.ExecuteMinidumpFromFile(text) returns text as :'Udflib', 'ExecuteMinidumpFromFile' language c strict;

-- EvalExprFromDXLFile
\set Mypath `pwd`'/udf_input/s01_const_int.xml'
select %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(:'Mypath');

\set Mypath `pwd`'/udf_input/s02_const_string.xml'
select %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(:'Mypath');

\set Mypath `pwd`'/udf_input/s03_add.xml'
select %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(:'Mypath');

\set Mypath `pwd`'/udf_input/s04_length.xml'
select %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(:'Mypath');

\set Mypath `pwd`'/udf_input/s05_position.xml'
select %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(:'Mypath');

\set Mypath `pwd`'/udf_input/s06_nested_string_funcs.xml'
select %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(:'Mypath');

\set Mypath `pwd`'/udf_input/s07_non_const_expr.xml'
-- set client_min_messages= 'log';
select %%GPOPTUTILS_NAMESPACE%%.EvalExprFromDXLFile(:'Mypath');

-- OptimizeMinidumpFromFile
\set Mypath `pwd`'/udf_input/exec01_const_int.mdp'
select %%GPOPTUTILS_NAMESPACE%%.OptimizeMinidumpFromFile(:'Mypath');

\set Mypath `pwd`'/udf_input/exec02_const_text.mdp'
select %%GPOPTUTILS_NAMESPACE%%.OptimizeMinidumpFromFile(:'Mypath');

\set Mypath `pwd`'/udf_input/exec03_add.mdp'
select %%GPOPTUTILS_NAMESPACE%%.OptimizeMinidumpFromFile(:'Mypath');

-- ExecuteMinidumpFromFile
\set Mypath `pwd`'/udf_input/exec01_const_int.mdp'
select %%GPOPTUTILS_NAMESPACE%%.ExecuteMinidumpFromFile(:'Mypath');

\set Mypath `pwd`'/udf_input/exec02_const_text.mdp'
select %%GPOPTUTILS_NAMESPACE%%.ExecuteMinidumpFromFile(:'Mypath');

\set Mypath `pwd`'/udf_input/exec03_add.mdp'
select %%GPOPTUTILS_NAMESPACE%%.ExecuteMinidumpFromFile(:'Mypath');