Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8389

Table functions: create the result table and return it to the function caller

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          This task is a part of diwas joshi'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.

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Task - A task that needs to be done. MDEV-8100 Table functions (aka SQL functions returning tables)

                • Major - Major loss of function.
                • Open

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      psergey Sergei Petrunia
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated: