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"
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>