Scenario:

Remote Server
---------------------

CREATE TABLE a (
`v` SMALLINT UNSIGNED
) Engine = InnoDB;

INSERT INTO `a` VALUES(40000);

Local server
---------------------

CREATE TABLE `rem` ENGINE=CONNECT DEFAULT CHARSET=utf8 `TABLE_TYPE`='MYSQL' `DBNAME`='db' `SRCDEF`='SELECT * FROM a' `OPTION_LIST`='host=127.0.0.1,port=3301,user=user,password=password';

SELECT * FROM `rem`;

Actual result
-----------------------
0) `rem` table has `v` column defined as smallint(5).
1) Value of `v` column is selected as 32767 instead of 40000.
2) Out of range warning is generated.

Desired result
-------------------------
0) `rem` table has `v` column defined as smallint unsigned.
1) Value of `v` column is selected as 40000.