> I've debug that and see that all of the scalar functions like -/*+ are not in capabilities functions list. There are only functions that I've added explicitly. Later, I've added -/*+ to addPushDownFunction but it requires prefix to be specified what is not what I want. How can I support such functions?
Any function that matches a teiid system function is declared in the getSupportedFunctions list. There you just declare support by name as it's expected that you'll support all forms of the analogous system function - with the exceptions that specific conversions and formatting can have their pushdown tuned.