use role sysadmin;
use database ttips;
use schema udfs;

-- creating a javascript function with not null specification
create or replace function null_handling_sql_udf(code string)
returns string 
language sql
returns null on null input
comment = 'This udf will check the return null on null input behaviour'
as
$$
    select 'I am running all the time'
$$;

create or replace function null_handling_js_udf(code string)
returns string 
language javascript
returns null on null input
comment = 'This udf will check the return null on null input behaviour'
as
$$
    return 'I run only when input is NOT null'
$$;

-- list function
show functions like 'NULL_H%';

-- desc the function
desc function NULL_HANDLING_SQL_UDF(string);
desc function NULL_HANDLING_JS_UDF(string);

select  NULL_HANDLING_SQL_UDF(null),
        NULL_HANDLING_SQL_UDF('SQL-Test'),
        NULL_HANDLING_JS_UDF(null),
        NULL_HANDLING_JS_UDF('JS-Test')
        ;