xref: /PHP-7.3/ext/pdo/tests/bug_65946.phpt (revision ded3d984)
1--TEST--
2PDO Common: Bug #65946 (pdo_sql_parser.c permanently converts values bound to strings)
3--SKIPIF--
4<?php
5if (!extension_loaded('pdo')) die('skip');
6$dir = getenv('REDIR_TEST_DIR');
7if (false == $dir) die('skip no driver');
8require_once $dir . 'pdo_test.inc';
9PDOTest::skip();
10?>
11--FILE--
12<?php
13if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/');
14require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
15$db = PDOTest::factory();
16$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
17$db->exec('CREATE TABLE test(id int)');
18$db->exec('INSERT INTO test VALUES(1)');
19switch ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) {
20	case 'dblib':
21		$sql = 'SELECT TOP :limit * FROM test';
22		break;
23	case 'odbc':
24		$sql = 'SELECT TOP (:limit) * FROM test';
25		break;
26	case 'firebird':
27		$sql = 'SELECT FIRST :limit * FROM test';
28		break;
29	case 'oci':
30		//$sql = 'SELECT * FROM test FETCH FIRST :limit ROWS ONLY';  // Oracle 12c syntax
31		$sql = "select id from (select a.*, rownum rnum from (SELECT * FROM test) a where rownum <= :limit)";
32		break;
33	default:
34		$sql = 'SELECT * FROM test LIMIT :limit';
35		break;
36}
37$stmt = $db->prepare($sql);
38$stmt->bindValue('limit', 1, PDO::PARAM_INT);
39if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
40if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
41var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
42?>
43--EXPECT--
44array(1) {
45  [0]=>
46  array(1) {
47    ["id"]=>
48    string(1) "1"
49  }
50}
51