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

ER_SQL_DISCOVER_ERROR from Federated engine, when table has columns of geometry types

    XMLWordPrintable

Details

    Description

      error after POINT, POLYGON, etc.

      --source include/have_innodb.inc 
      --source include/have_sequence.inc 
       
      INSTALL SONAME 'ha_federatedx';
      eval CREATE SERVER fedlink FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST '127.0.0.1', DATABASE 'test', PORT $MASTER_MYPORT);
       
      CREATE TABLE t ( a linestring);
      CREATE TABLE t_fed ENGINE=FEDERATED CONNECTION='fedlink/t';
       
      show create table t_fed;
       
      DROP TABLE t_fed, t;
      UNINSTALL SONAME 'ha_federatedx';
      

       query 'CREATE TABLE t_fed ENGINE=FEDERATED CONNECTION='fedlink/t'' failed: ER_SQL_DISCOVER_ERROR (1939): Engine FEDERATED failed to discover table `test`.`t_fed` with 'CREATE TABLE `t` (
        `a` linestring DEFAULT NULL
      ) CONNECTION='fedlink/t''
      

      Should it be documented currently as a limitation in FederatedX?

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            alice Alice Sherepa
            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.