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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.6
• Component/s: odbc

Environment

CentOS

• Ignite Flags: Docs Required
• Assignee: Igor Sapego
• Reporter: Roman Shtykh
• Created: 16/Oct/18 10:03
• Updated: 15/Nov/18 14:04
• Resolved: 15/Nov/18 14:01

Description

Using odbc_connect returns all column values, but with PDO only the 1st one – all the rest are null.
Reproduced on CentOS.

1. Start a server node with Ignite CPP
2. Run odbc-example (which will create two tables)
3. 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();
}

?>

 

Issue Links

• relates to: IGNITE-7362 ODBC: Third party libraries truncate any inserted varlen data to ColumnSize
• links to: GitHub Pull Request #5248
• links to: Upsource review #943