[ https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16660317#comment-16660317 ]
Roman Shtykh commented on IGNITE-9897: -------------------------------------- Actually, it can acquire only the first object in the row, no matter what the type is. > Quering with 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 > Affects Versions: 2.6 > Environment: CentOS > Reporter: Roman Shtykh > Priority: Major > > 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)