Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.3
-
None
-
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