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

FederatedX error on pushdown of statements having CTE

Details

    Description

      --source include/master-slave.inc
       
      connection slave; 
      CREATE TABLE t1 (id int);
      INSERT INTO t1 VALUES (1),(2),(3);
       
      connection master;
      INSTALL SONAME 'ha_federatedx';
      set global federated_pushdown=1;
       
      --replace_result $SLAVE_MYPORT SLAVE_PORT
      eval CREATE TABLE t1 ENGINE="FEDERATED" CONNECTION="mysql://root@127.0.0.1:$SLAVE_MYPORT/test/t1";
       
      with cte as (select * from t1) select * from cte;
      

      mysqltest: At line 15: query 'with cte as (select * from t1) select * from cte' failed: ER_GET_ERRNO (1030): Got error 10000 "Unknown error 10000" from storage engine FEDERATED

      Attachments

        Activity

          oleg.smirnov Oleg Smirnov created issue -
          oleg.smirnov Oleg Smirnov made changes -
          Field Original Value New Value
          oleg.smirnov Oleg Smirnov made changes -
          Summary FederatedX error on pushdown of statement having CTE FederatedX error on pushdown of statements having CTE
          oleg.smirnov Oleg Smirnov made changes -
          Fix Version/s 11.1 [ 28549 ]
          oleg.smirnov Oleg Smirnov made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          oleg.smirnov Oleg Smirnov added a comment -

          psergei, please review this pull request.

          oleg.smirnov Oleg Smirnov added a comment - psergei , please review this pull request .
          oleg.smirnov Oleg Smirnov made changes -
          Assignee Oleg Smirnov [ JIRAUSER50405 ] Sergei Petrunia [ psergey ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          psergei Sergei Petrunia made changes -
          Assignee Sergei Petrunia [ psergey ] Oleg Smirnov [ JIRAUSER50405 ]
          Status In Review [ 10002 ] Stalled [ 10000 ]

          Ok to push after review input is addressed.

          psergei Sergei Petrunia added a comment - Ok to push after review input is addressed.
          oleg.smirnov Oleg Smirnov added a comment -

          Pushed to 11.1

          oleg.smirnov Oleg Smirnov added a comment - Pushed to 11.1
          oleg.smirnov Oleg Smirnov made changes -
          Fix Version/s 11.1.3 [ 29023 ]
          Fix Version/s 11.1 [ 28549 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          JIraAutomate JiraAutomate made changes -
          Fix Version/s 11.2.2 [ 29035 ]

          People

            oleg.smirnov Oleg Smirnov
            oleg.smirnov Oleg Smirnov
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.