ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
Date Fri, 02 Nov 2018 14:34:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16673165#comment-16673165
] 

ASF GitHub Bot commented on IGNITE-9897:
----------------------------------------

GitHub user isapego opened a pull request:

    https://github.com/apache/ignite/pull/5248

    IGNITE-9897: ODBC fix for PDO when used with unixODBC

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gridgain/apache-ignite ignite-9897

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/ignite/pull/5248.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #5248
    
----
commit 28f4a3a866f0d090baf4b20fa2085e9e58c68cee
Author: Igor Sapego <isapego@...>
Date:   2018-11-02T14:16:37Z

    IGNITE-9897: ODBC fix for PDO when used with unixODBC

----


> 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: odbc.log, phpPDO2.out, phpPdo.out, unixOdbc.log
>
>
> 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
> 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)

Mime
View raw message