[MDEV-8389] Table functions: create the result table and return it to the function caller Created: 2015-06-27  Updated: 2015-11-26  Resolved: 2015-11-26

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Procedure
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Sergei Petrunia Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-8100 Table functions (aka SQL functions re... Stalled

 Description   

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

Let's denote the query that uses a table function

SELECT ... FROM table_func(args) WHERE ...

as the caller query.

We are not able to execute table functions, yet. Let's make the first step: the code should create a temporary table according to the definition in CREATE FUNCTION ... RETURNS TABLE statement, and pass it to the caller query.

In other words, the caller query should execute as if table_func returned an empty table.

The code inside table_func is irrelevant as far as this task goes. It can be empty or contain some dummy statement.

This task should be done after MDEV-8342 and MDEV-8356 are finished.


Generated at Thu Feb 08 07:26:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.