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

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

[MDEV-4855] No servid special column in ConnectSE Created: 2013-08-08 Updated: 2013-08-09 Resolved: 2013-08-09
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	10.0.3
Fix Version/s:	10.0.5