Return to bug_63916.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_sqlite/tests/bug_63916.phpt, revision 1.1.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 < 8) die('skip');
                      7: ?>
                      8: --FILE--
                      9: <?php
                     10: $num = 100004313234244; // exceeds 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(100004313234244)
                     27: string(15) "100004313234244"