Annotation of embedaddon/php/ext/pdo_sqlite/tests/bug_63916-2.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Bug #63916 PDO::PARAM_INT casts to 32bit int internally even on 64bit builds in pdo_sqlite
        !             3: --SKIPIF--
        !             4: <?php
        !             5: if (!extension_loaded('pdo_sqlite')) die('skip');
        !             6: if (PHP_INT_SIZE > 4) die('skip');
        !             7: ?>
        !             8: --FILE--
        !             9: <?php
        !            10: $num = PHP_INT_MAX; // 32 bits
        !            11: $conn = new PDO('sqlite::memory:');
        !            12: $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))');
        !            13: 
        !            14: $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)');
        !            15: $stmt->bindValue(':id', 1, PDO::PARAM_INT);
        !            16: $stmt->bindValue(':num', $num, PDO::PARAM_INT);
        !            17: $stmt->execute();
        !            18: 
        !            19: $stmt = $conn->query('SELECT num FROM users');
        !            20: $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
        !            21: 
        !            22: var_dump($num,$result[0]);
        !            23: 
        !            24: ?>
        !            25: --EXPECT--
        !            26: int(2147483647)
        !            27: string(10) "2147483647"

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>