<?php

$tableSql = <<<SQL
DROP TABLE IF EXISTS `typebug`;
CREATE TABLE `typebug` (
  `int_col` integer NOT NULL,
  `int_col2` integer DEFAULT '1',
  `smallint_col` smallint(1) DEFAULT '1',
  `char_col` char(100) NOT NULL,
  `char_col2` varchar(100) DEFAULT 'something',
  `char_col3` text,
  `enum_col` enum('a', 'B', 'c,D'),
  `float_col` double(4,3) NOT NULL,
  `float_col2` double DEFAULT '1.23',
  `blob_col` blob,
  `numeric_col` decimal(5,2) DEFAULT '33.22',
  `time` timestamp NOT NULL DEFAULT '2002-01-01 00:00:00',
  `bool_col` tinyint(1) NOT NULL,
  `bool_col2` tinyint(1) DEFAULT '1',
  `ts_default` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `bit_col` BIT(8) NOT NULL DEFAULT b'10000010'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `typebug` (`int_col`, `char_col`, `float_col`, `bool_col`) VALUES (1, 'A', 9.735, 1), (2, 'B', -2.123, 0), (3, 'C', 2.123, 0);
SQL;

$pdo = new PDO('mysql:host=127.0.0.1;dbname=yiitest', 'root', 'wurstepelle');

$pdo->prepare($tableSql)->execute();

$statement = $pdo->prepare("SELECT int_col FROM `typebug` WHERE `int_col` IN (1,2,3) ORDER BY `int_col`;");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
//print_r($result);
foreach($result as $row) {
    echo $row['int_col'] . "\n";
}

echo "---\n";

$statement = $pdo->prepare("SELECT * FROM `typebug` WHERE `int_col` IN (1,2,3) ORDER BY `int_col`;");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
//print_r($result);
foreach($result as $row) {
    echo $row['int_col'] . "\n";
}