Re: Sargable Custom Functions in Queries

[David Allen]

Thanks, John! Sadly, it looks like I won't be able to do what I want as I use custom internal functions. Blows my mind MySQL doesn't allow the enforcement of a function as truly DETERMINISTIC (and thus static) as a function.

For example:

SELECT * FROM table t1 WHERE t1.row_val = get_val('OBJECT','STATIC');

Where get_value queries the values from our own database. What's sad is if I put the actual SELECT from get_val into the query, it's Sargable.

No idea why they even have DETERMINISTIC in a function if it's never treated as such in a query :(