I already wrote how MariaDB makes the debug of stored procedures much easier via the SQL Error Log. But I recently found out that MariaDB provides a usable workaround for some big limitations of their procedural SQL.
SELECT is not the only SQL statement which returns a resultset. Other examples are
EXPLAIN and administrative commands like
ANALYZE TABLE or
CHECK TABLE. But these commands cannot be used in place of
SELECT in the following contexts:
- Subqueries, derived tables,