[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

erkan yanar created issue - 2013-08-08 05:41

Elena Stepanova made changes - 2013-08-08 12:32

Field	Original Value	New Value
Fix Version/s		10.0.5 [ 13201 ]
Assignee		Olivier Bertrand [ bertrandop ]

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

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 28342 ]

MariaDB v2 [ 43910 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 43910 ]

MariaDB v3 [ 64196 ]

Sergei Golubchik made changes - 2021-12-06 21:39

Workflow

MariaDB v3 [ 64196 ]

MariaDB v4 [ 146912 ]

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

MariaDB Server