Roman Shtykh created IGNITE-10265:
-------------------------------------
Summary: PDOStatement::rowCount returns 0
Key: IGNITE-10265
URL: https://issues.apache.org/jira/browse/IGNITE-10265
Project: Ignite
Issue Type: Bug
Components: odbc
Affects Versions: 2.6
Environment: CentOS, unixODBC
Reporter: Roman Shtykh
How to reproduce:
{quote}{{$ 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}}{quote}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
