Return to bug63921-64bit.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / sqlite3 / tests

Annotation of embedaddon/php/ext/sqlite3/tests/bug63921-64bit.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Bug #63921 sqlite3::bindvalue and relative PHP functions aren't using sqlite3_*_int64 API
        !             3: --SKIPIF--
        !             4: <?php
        !             5: if (!extension_loaded('sqlite3')) die('skip');
        !             6: if (PHP_INT_SIZE < 8) die('skip'); // skip for 32bit builds - there is another test for that
        !             7: ?>
        !             8: --FILE--
        !             9: <?php
        !            10: $num = 100004313234244; // notice this exceeds 32 bits
        !            11: $conn = new sqlite3(':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, SQLITE3_INTEGER);
        !            16: $stmt->bindValue(':num', $num, SQLITE3_INTEGER);
        !            17: $stmt->execute();
        !            18: 
        !            19: $stmt = $conn->query('SELECT num FROM users');
        !            20: $result = $stmt->fetchArray();
        !            21: 
        !            22: var_dump($num,$result[0]);
        !            23: 
        !            24: ?>
        !            25: --EXPECT--
        !            26: int(100004313234244)
        !            27: string(15) "100004313234244"