Reputation: 41
I have a Generic UDF which encrypts a given input value. This UDF gives the correct value when used in a select statement however the UDF returns null when used in "Create table as select" or "Insert into .. select" statement. Input to the udf, output from udf, data type of the table column being created or inserted into, all are of type string.
So what could be the reason behind the select statement behaving differently when part of create or insert statement?
Upvotes: 1
Views: 92