xref: /PHP-8.1/ext/pdo_mysql/tests/bug_61207.phpt (revision b5a14e6c)
1--TEST--
2PDO MySQL Bug #61207 (PDO::nextRowset() after a multi-statement query doesn't always work)
3--EXTENSIONS--
4pdo_mysql
5--SKIPIF--
6<?php
7require_once(__DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
8MySQLPDOTest::skip();
9
10?>
11--FILE--
12<?php
13require_once(__DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
14/** @var PDO $db */
15$db = MySQLPDOTest::factory();
16
17$db->query('DROP TABLE IF EXISTS test');
18$db->query('create table `test`( `id` int )');
19
20$handle1 = $db->prepare('insert into test(id) values(1);
21                          select * from test where id = ?;
22                          update test set id = 2 where id = ?;');
23
24$handle1->bindValue(1, '1');
25$handle1->bindValue(2, '1');
26
27$handle1->execute();
28$i = 1;
29print("Handle 1:\n");
30do {
31    print('Rowset ' . $i++ . "\n");
32    if ($handle1->columnCount() > 0)
33        print("Results detected\n");
34} while($handle1->nextRowset());
35
36$handle2 = $db->prepare('select * from test where id = ?;
37                           update test set id = 1 where id = ?;');
38
39$handle2->bindValue(1, '2');
40$handle2->bindValue(2, '2');
41
42$handle2->execute();
43
44$i = 1;
45print("Handle 2:\n");
46do {
47    print('Rowset ' . $i++ . "\n");
48    if ($handle2->columnCount() > 0)
49        print("Results detected\n");
50} while($handle2->nextRowset());
51
52$handle3 = $db->prepare('update test set id = 2 where id = ?;
53                           select * from test where id = ?;');
54
55$handle3->bindValue(1, '1');
56$handle3->bindValue(2, '2');
57
58$handle3->execute();
59
60$i = 1;
61print("Handle 3:\n");
62do {
63    print('Rowset ' . $i++ . "\n");
64    if ($handle3->columnCount() > 0)
65        print("Results detected\n");
66} while($handle3->nextRowset());
67
68$handle4 = $db->prepare('insert into test(id) values(3);
69                           update test set id = 2 where id = ?;
70                           select * from test where id = ?;');
71
72$handle4->bindValue(1, '3');
73$handle4->bindValue(2, '2');
74
75$handle4->execute();
76
77$i = 1;
78print("Handle 4:\n");
79do {
80    print('Rowset ' . $i++ . "\n");
81    if ($handle1->columnCount() > 0)
82        print("Results detected\n");
83} while($handle1->nextRowset());
84
85$db->query("DROP TABLE test");
86?>
87--CLEAN--
88<?php
89require __DIR__ . '/mysql_pdo_test.inc';
90MySQLPDOTest::dropTestTable();
91?>
92--EXPECT--
93Handle 1:
94Rowset 1
95Rowset 2
96Results detected
97Rowset 3
98Handle 2:
99Rowset 1
100Results detected
101Rowset 2
102Handle 3:
103Rowset 1
104Rowset 2
105Results detected
106Handle 4:
107Rowset 1
108Rowset 2
109Rowset 3
110Results detected
111