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

No servid special column in ConnectSE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.3
    • Fix Version/s: 10.0.5
    • Component/s: None
    • Labels:
    • Environment:
      Ubuntu/Presice/LXContainer

      Description

      ConnectSE ships with special columns. I.e. tabid and servid.
      Given:

      CREATE TABLE `federatedconnect` (
        `id` int(11) NOT NULL,
        `id2` int(11) DEFAULT NULL
      ) ENGINE=CONNECT DEFAULT CHARSET=latin1 `TABLE_TYPE`='mysql' `TABNAME`='aha' `DBNAME`='test' `OPTION_LIST`='user=me,host=10.0.3.191'

      We build a table_type=tbl table with the special column tabid

       CREATE TABLE `federatedconnect_s` (
        `server` char(20) NOT NULL DEFAULT 'nix' `special`=tabid,
        `id` int(11) NOT NULL,
        `id2` int(11) DEFAULT NULL
      ) ENGINE=CONNECT DEFAULT CHARSET=latin1 `TABLE_TYPE`='tbl' `table_list`='federatedconnect' 

      MariaDB [test]> select * from federatedconnect_s limit 1;
      +------------------+----+------+
      | server           | id | id2  |
      +------------------+----+------+
      | federatedconnect |  5 | NULL |
      +------------------+----+------+
      1 row in set (0.00 sec)

      Ok that works as expected. Now use the special column servid.

      CREATE TABLE `federatedconnect_s` (
        `server` char(20) NOT NULL DEFAULT 'nix' `special`=servid,
        `id` int(11) NOT NULL,
        `id2` int(11) DEFAULT NULL
      ) ENGINE=CONNECT DEFAULT CHARSET=latin1 `TABLE_TYPE`='tbl' `table_list`='federatedconnect' 

      MariaDB [test]> select * from federatedconnect_s limit 1;
      ERROR 1296 (HY000): Got error 174 'Column *SERVID not found in federatedconnect_s' from CONNECT

      So servid is not there to be used.
      Regards
      Erkan

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            erkules erkan yanar
            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.