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

Recursive CTE Raises Table is Full Error

Details

    Description

      When using a Recursive CTE to generate a sample data set I'm getting a table is full error. It seems to be related to the underlying temporary table created by the CTE. Changing tmp_table_size and max_heap_table_size did not have any effect. I've attached an example and the error log.

      Attachments

        1. Example SQL.sql
          0.5 kB
          Shawn Weeks
        2. JDBC Error Log.log
          4 kB
          Shawn Weeks
        3. Test Results.sql
          2 kB
          Shawn Weeks

        Activity

          Transition Time In Source Status Execution Times
          Igor Babaev (Inactive) made transition -
          Open In Progress
          		7d 12h 24m 1
          Igor Babaev (Inactive) made transition -
          In Progress Closed
          		1d 14h 20m 1

          People

            igor Igor Babaev (Inactive)
            absolutesantaja Shawn Weeks
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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