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