1--TEST--
2Bug #63921 sqlite3::bindvalue and relative PHP functions aren't using sqlite3_*_int64 API
3--SKIPIF--
4<?php
5if (!extension_loaded('sqlite3')) die('skip sqlite3 extension not loaded');
6if (PHP_INT_SIZE > 4) die('skip 32-bit only'); // skip for 64bit builds - there is another test for that
7?>
8--FILE--
9<?php
10$num = PHP_INT_MAX; // 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
22var_dump($num,$result[0]);
23
24?>
25--EXPECT--
26int(2147483647)
27int(2147483647)
28