[MDEV-8649] Table functions: SHOW FUNCTION STATUS gives an error - Jira

XML

Word

Printable

This task is a part of dj 's GSoC project.

I am using the current table functions tree and I run the following:

delimiter |

CREATE FUNCTION f10(param1 VARCHAR(11))

RETURNS TABLE return_table(name VARCHAR(11))

deterministic

BEGIN

insert into return_table values('foo');

END|

DELIMITER ;

Then I run:

MariaDB [test]> show function status;

ERROR 1313 (42000): RETURN is only allowed in a FUNCTION

Apparently some of the code is not aware of the presence of table functions.

is part of

MDEV-8100 Table functions (aka SQL functions returning tables)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.