1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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')
        ;