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

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"