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

Recursive CTE Raises Table is Full Error

    XMLWordPrintable

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

          People

            igor Igor Babaev
            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.