snippet.sql

-- Demonstration of MySQL bug and a work-around.
-- See http://bugs.mysql.com/bug.php?id=36772
-- It is fixed in MySQL 5.0.74

DROP TABLE `test`;
CREATE TABLE `test` (
  `id` INT
);

INSERT INTO `test` VALUES
  (123456789),
  (123456789);

SET NAMES utf8;

SELECT CAST(id AS CHAR) AS id FROM test GROUP BY id;
-- +------+
-- | id   |
-- +------+
-- | 123  | 
-- +------+

SELECT CAST(id AS CHAR(20)) AS id FROM test GROUP BY id;
-- +-----------+
-- | id        |
-- +-----------+
-- | 123456789 | 
-- +-----------+