[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor Sapego updated IGNITE-9897:
Attachment: odbc.log
unixOdbc.log
> 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}
> 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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Shtykh updated IGNITE-9897:
-
Attachment: phpPDO2.out
> 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: phpPDO2.out, phpPdo.out
>
>
> 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}
> 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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor Sapego 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
{code:php}
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}
was:
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}
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}
> 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: phpPdo.out
>
>
> 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}
> 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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor Sapego 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
{code:php}
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}
was:
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
{{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
>Assignee: Igor Sapego
>Priority: Major
> Attachments: phpPdo.out
>
>
> 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}
> ini_set("display_errors", 1);
> error_reporting(E_ALL);
> ini_set('memory_limit', '-1');
> 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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Shtykh updated IGNITE-9897:
-
Attachment: phpPdo.out
> 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: phpPdo.out
>
>
> 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
> {{ {{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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor Sapego 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
{{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_ 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
{{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
>Assignee: Igor Sapego
>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
> {{ {{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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor Sapego 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
{{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_ 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
{{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
>Assignee: Igor Sapego
>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
> {{ {{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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor Sapego 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
{{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_ 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
{{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
>Assignee: Igor Sapego
>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
> {{ {{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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
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
{{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
{{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
> {{ {{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)
[jira] [Updated] (IGNITE-9897) Quering with PDO returns null for all column values except the 1st one
[
https://issues.apache.org/jira/browse/IGNITE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Shtykh updated IGNITE-9897:
-
Summary: Quering with PDO returns null for all column values except the 1st
one (was: Quering with PDO returns null for column values of string type)
> 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_ 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
> {{ {{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)
