1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
--TEST--
PDO_DBLIB: driver supports SET ROWCOUNT and SELECT @@ROWCOUNT in batch statements
--EXTENSIONS--
pdo_dblib
--SKIPIF--
<?php
require __DIR__ . '/config.inc';
$db = getDbConnection();
if (!driver_supports_batch_statements_without_select($db)) die('xfail test will fail with this version of FreeTDS');
?>
--FILE--
<?php
require __DIR__ . '/config.inc';
$db = getDbConnection();
$stmt = $db->query(
"create table #test_batch_stmt_rowcount(id int); " .
"set rowcount 2; " .
"insert into #test_batch_stmt_rowcount values(1), (2), (3); " .
"insert into #test_batch_stmt_rowcount values(4), (5), (6); " .
"update #test_batch_stmt_rowcount set id = 4; " .
"select @@rowcount; "
);
// check results from the create table
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the set rowcount
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the first insert
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the second insert
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the update
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the select rowcount
var_dump($stmt->fetchAll());
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check that there are no more results
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// now cleanup and check that the results are expected
$stmt = $db->query("set rowcount 0;" .
"select * from #test_batch_stmt_rowcount;" .
"delete from #test_batch_stmt_rowcount;" .
"drop table #test_batch_stmt_rowcount;"
);
// check results from set rowcount
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the select
var_dump($stmt->fetchAll());
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the delete
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check results from the drop
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
// check that there are no more results
var_dump($stmt->rowCount());
var_dump($stmt->nextRowset());
?>
--EXPECT--
int(-1)
bool(true)
int(-1)
bool(true)
int(2)
bool(true)
int(2)
bool(true)
int(2)
bool(true)
array(1) {
[0]=>
array(2) {
["computed"]=>
int(2)
[0]=>
int(2)
}
}
int(-1)
bool(false)
int(-1)
bool(false)
int(-1)
bool(true)
array(4) {
[0]=>
array(2) {
["id"]=>
int(4)
[0]=>
int(4)
}
[1]=>
array(2) {
["id"]=>
int(4)
[0]=>
int(4)
}
[2]=>
array(2) {
["id"]=>
int(4)
[0]=>
int(4)
}
[3]=>
array(2) {
["id"]=>
int(5)
[0]=>
int(5)
}
}
int(-1)
bool(true)
int(4)
bool(true)
int(-1)
bool(false)
int(-1)
bool(false)
|
