[MDEV-4855] No servid special column in ConnectSE - Jira

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

Transition	Time In Source Status	Execution Times

Olivier Bertrand made transition - 2013-08-09 20:15

Open

Closed

1d 14h 33m

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

MariaDB Server