TO_DATE: A call with wrong number of arguments causes syntax error (not standard behavior for MariaDB)

MariaDB [test]> SELECT TO_DATE() AS x;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS x' at line 1

MariaDB [test]> SELECT TO_DATE('2026-01-01') AS x;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS x' at line 1

MariaDB [test]> SELECT CONCAT() AS x FROM DUAL;

ERROR 1582 (42000): Incorrect parameter count in the call to native function 'CONCAT'