xref: /PHP-7.3/ext/pdo/tests/bug_44173.phpt (revision b746e698)
1--TEST--
2PDO Common: Bug #44173 (PDO->query() parameter parsing/checking needs an update)
3--SKIPIF--
4<?php # vim:ft=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 getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
15$db = PDOTest::factory();
16
17$db->exec("CREATE TABLE test (x int)");
18$db->exec("INSERT INTO test VALUES (1)");
19
20
21// Bug entry [1]
22$stmt = $db->query();
23var_dump($stmt);
24
25
26// Bug entry [2] -- 1 is PDO::FETCH_LAZY
27$stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, 0);
28var_dump($stmt);
29
30
31// Bug entry [3]
32$stmt = $db->query("SELECT * FROM test", 'abc');
33var_dump($stmt);
34
35
36// Bug entry [4]
37$stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0);
38var_dump($stmt);
39
40
41// Bug entry [5]
42$stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
43var_dump($stmt);
44
45
46// Bug entry [6]
47$stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN);
48var_dump($stmt);
49
50
51// Bug entry [7]
52$stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
53var_dump($stmt);
54
55
56?>
57--EXPECTF--
58Warning: PDO::query() expects at least 1 parameter, 0 given in %s
59bool(false)
60
61Warning: PDO::query(): SQLSTATE[HY000]: General error: fetch mode doesn't allow any extra arguments in %s
62bool(false)
63
64Warning: PDO::query(): SQLSTATE[HY000]: General error: mode must be an integer in %s
65bool(false)
66
67Warning: PDO::query(): SQLSTATE[HY000]: General error: too many arguments in %s
68bool(false)
69
70Warning: PDO::query(): SQLSTATE[HY000]: General error: fetch mode requires the object parameter in %s
71bool(false)
72
73Warning: PDO::query(): SQLSTATE[HY000]: General error: fetch mode requires the colno argument in %s
74bool(false)
75
76Warning: PDO::query(): SQLSTATE[HY000]: General error: fetch mode requires the classname argument in %s
77bool(false)
78