You can translate the question and the replies:

Restrict UDF to WHERE CLAUSE Only

Is there a way to apply a restriction on UDF such that it can only be executed in a WHERE Clause, and not at any other place. For example, SELECT UDF(123) FROM DUAL(); ---> It should be invalid SELECT * FROM <TableName> WHERE UDF(COLUMN1) = <Some Value> --> It should be valid
UDF User Defined Function WHERE CONDITIONS
user
17-11-2016 07:21:10 -0500
code

1 Answer

Hi, I cannot imagine a scenario where you need a restriction like that, it seems a very particular situation. In addition, although you cannot apply the restriction on the custom function itself, you could create a custom policy to parse the queries and reject those that contains the function in the Select. Hope this helps!
Denodo Team
18-11-2016 06:11:15 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here