When running with sql_mode=ORACLE, MariaDB should allow calling stored functions that have no parameters without having to type parentheses after the function name.
Notice, the above two SELECT queries return the same result:
Name resolution will follow Oracle rules. For example, table columns shadow stored functions:
Notice, it returned the value of the column t1.f1 rather than the function f1.
Under terms of this task we'll also allow calling SP control functions SQLCODE and SQLERRM with empty parentheses: