[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one

[Igor Sapego (JIRA)]

     [ 
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Igor Sapego updated IGNITE-9897:
--------------------------------
    Description: 
Using _odbc_connect_ returns all column values, but with _PDO_ only the 1st one 
– all the rest are null.
 Reproduced on CentOS.
 # Start a server node with Ignite CPP
 # Run odbc-example (which will create two tables)
 # Run a simple PHP script

{code:php}
<?php

ini_set("display_errors", 1);
error_reporting(E_ALL);
ini_set('memory_limit', '-1');

try {
    echo PHP_EOL,PHP_EOL,"# Using PDO",PHP_EOL;
    $dbh = new PDO('odbc:ApacheIgnite');
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = 'SELECT * FROM "Person".Person';
    $data = $dbh->query($sql);

    foreach($data as $row) {
        var_export($row);
        }

    echo PHP_EOL,PHP_EOL,"# Using odbc_*( ) Functions",PHP_EOL;
        
    $conn = odbc_connect('ApacheIgnite','','');
    $rs = odbc_exec($conn, $sql);
        
    while($row = odbc_fetch_array($rs)) {
        var_export($row);
        }
                  
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "\n";
    die();
}

?>
{code}

 

  was:
Using _odbc_connect_ returns all column values, but with _PDO_ only the 1st one 
– all the rest are null.
 Reproduced on CentOS.
 # Start a server node with Ignite CPP
 # Run odbc-example (which will create two tables)
 # Run a simple PHP script

{{<?php}}
 {{try {}}
 {{    echo PHP_EOL,PHP_EOL,"# Using PDO",PHP_EOL;}}
 {{    $dbh = new PDO('odbc:ApacheIgnite');}}
 {{    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);}}

{{    $sql = 'SELECT * FROM "Person".Person';}}
 {{    $data = $dbh->query($sql);}}

{{    foreach($data as $row) {}}
 {{        var_export($row);}}

{{    echo PHP_EOL,PHP_EOL,"# Using odbc_*( ) Functions",PHP_EOL;}}
 {{    $conn = odbc_connect('ApacheIgnite','','');}}
 {{    $rs = odbc_exec($conn, $sql);}}
 {{      while($row = odbc_fetch_array($rs)){}}
 {{          var_export($row);}}
      }
 {{} catch (PDOException $e) {}}
 {{    print "Error!: " . $e->getMessage() . "\n";}}
 {{    die();}}
 {{}}}
 {{?>}}

 


> Quering with PDO returns null for all column values except the 1st one
> ----------------------------------------------------------------------
>
>                 Key: IGNITE-9897
>                 URL: https://issues.apache.org/jira/browse/IGNITE-9897
>             Project: Ignite
>          Issue Type: Bug
>          Components: odbc
>    Affects Versions: 2.6
>         Environment: CentOS
>            Reporter: Roman Shtykh
>            Assignee: Igor Sapego
>            Priority: Major
>         Attachments: phpPdo.out
>
>
> Using _odbc_connect_ returns all column values, but with _PDO_ only the 1st 
> one – all the rest are null.
>  Reproduced on CentOS.
>  # Start a server node with Ignite CPP
>  # Run odbc-example (which will create two tables)
>  # Run a simple PHP script
> {code:php}
> <?php
> ini_set("display_errors", 1);
> error_reporting(E_ALL);
> ini_set('memory_limit', '-1');
> try {
>     echo PHP_EOL,PHP_EOL,"# Using PDO",PHP_EOL;
>     $dbh = new PDO('odbc:ApacheIgnite');
>     $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
>     $sql = 'SELECT * FROM "Person".Person';
>     $data = $dbh->query($sql);
>     foreach($data as $row) {
>         var_export($row);
>       }
>     echo PHP_EOL,PHP_EOL,"# Using odbc_*( ) Functions",PHP_EOL;
>       
>     $conn = odbc_connect('ApacheIgnite','','');
>     $rs = odbc_exec($conn, $sql);
>       
>     while($row = odbc_fetch_array($rs)) {
>         var_export($row);
>       }
>                 
> } catch (PDOException $e) {
>     print "Error!: " . $e->getMessage() . "\n";
>     die();
> }
> ?>
> {code}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)