You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Roman Shtykh (JIRA)" <ji...@apache.org> on 2018/10/16 10:04:00 UTC

[jira] [Created] (IGNITE-9897) PDO returns null for column values of string type

Roman Shtykh created IGNITE-9897:
------------------------------------

             Summary: PDO returns null for column values of string type
                 Key: IGNITE-9897
                 URL: https://issues.apache.org/jira/browse/IGNITE-9897
             Project: Ignite
          Issue Type: Bug
          Components: odbc
         Environment: CentOS
            Reporter: Roman Shtykh


Using _odbc_connect_ returns all column values, but with _PDO_ string and double type values 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();}}
{{}}}
{{?>}}

 



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