[IGNITE-10265] PDOStatement::rowCount returns 0

• Type: Wish
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.6
• Component/s: odbc

Environment

CentOS, unixODBC

• Ignite Flags: Docs Required
• Assignee: Igor Sapego
• Reporter: Roman Shtykh
• Created: 15/Nov/18 04:34
• Updated: 20/Nov/18 10:21

Description

How to reproduce:

$ cat ~/odbc.php
<?php
 
try {
    echo PHP_EOL,PHP_EOL,"# Using PDO",PHP_EOL;
    $dbh = new PDO('odbc:DRIVER={ApacheIgnite};Server=127.0.0.1;PORT=10800');
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 
    $sql = 'SELECT * FROM "Person".Person';
    $statement = $dbh->prepare($sql);
    $statement->execute();
 
    $data = $statement->fetchAll();
 
    foreach($data as $row) {
        var_dump($row);
    }
 
    echo "array Count : " . count($data) . "\n";
    echo "rowCount : " . $statement->rowCount() . "\n";
 
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "\n";
    die();
}
 
$ php ~/odbc.php
 
# Using PDO
array(10) {
  ["ORGID"]=>
  string(1) "1"
  [0]=>
  string(1) "1"
  ["FIRSTNAME"]=>
  string(4) "John"
  [1]=>
  string(4) "John"
  ["LASTNAME"]=>
  string(3) "Doe"
  [2]=>
  string(3) "Doe"
  ["RESUME"]=>
  string(14) "Master Degree."
  [3]=>
  string(14) "Master Degree."
  ["SALARY"]=>
  string(4) "2200"
  [4]=>
  string(4) "2200"
}
・
・
・
array(10) {
  ["ORGID"]=>
  string(1) "2"
  [0]=>
  string(1) "2"
  ["FIRSTNAME"]=>
  string(4) "Mary"
  [1]=>
  string(4) "Mary"
  ["LASTNAME"]=>
  string(5) "Major"
  [2]=>
  string(5) "Major"
  ["RESUME"]=>
  string(16) "Bachelor Degree."
  [3]=>
  string(16) "Bachelor Degree."
  ["SALARY"]=>
  string(4) "1200"
  [4]=>
  string(4) "1200"
}
array Count : 6
rowCount : 0