[
https://issues.apache.org/jira/browse/IGNITE-10265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Shtykh updated IGNITE-10265:
----------------------------------
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}}
was:
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}}
> 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
> Priority: Major
>
> 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}}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
