The SELECT statement within a FUNCTION in MariaDB may not work when selecting a table because table-level operations are not allowed in a function. Functions are designed to return a single value, and table-level operations may return multiple rows and columns, which can cause issues with the function's behavior. To perform table-level operations, use a stored procedure instead of a function.
Asked: 2021-08-08 11:00:00 +0000
Seen: 10 times
Last updated: Apr 01 '23