--source include/have_innodb.inc

set names utf8;

CREATE TABLE `Table1` (  `Id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,  `Size` BIGINT UNSIGNED NOT NULL,  CONSTRAINT pk_Id1 PRIMARY KEY (`Id`)) ENGINE=INNODB;

CREATE TABLE `Table2` (  `IdKey` INT UNSIGNED NOT NULL AUTO_INCREMENT,  `Id` MEDIUMINT UNSIGNED NOT NULL,  CONSTRAINT pk_Id2 PRIMARY KEY (`IdKey`)) ENGINE=INNODB;

INSERT INTO Table1(Id,Size) VALUE (1, 123456789012345);

INSERT INTO Table2(IdKey,Id) VALUE (1,  1);

SELECT DISTINCT(Table1.Id), Table1.Size, CAST(Table1.Size AS CHAR) FROM Table1, Table2 WHERE Table1.Id=Table2.Id;

SELECT (Table1.Id), Table1.Size, CAST(Table1.Size AS CHAR) FROM Table1, Table2 WHERE Table1.Id=Table2.Id;