PDO returns erroneous columns from within pdt [message #492191] |
Mon, 19 October 2009 11:49 |
No real name Messages: 1 Registered: October 2009 |
Junior Member |
|
|
Hi All,
This is a truly weird behavior:
When using a simple pdo fetch, erroneous columns are returned!
Steps to reproduce:
------------------------------------------------------------ -----------
1.create a table with 4 columns, such as:
CREATE TABLE `t1` (
`col1` int(11) DEFAULT NULL,
`col2` varchar(20) DEFAULT NULL,
`col3` int(11) DEFAULT NULL,
`col4` int(11) DEFAULT NULL
)
2. Insert some data:
INSERT IGNORE INTO t1 VALUES (1, 'test', 2, 3);
3. Try the following code:
$pdo = new PDO("mysql:host=localhost;dbname=test", 'usr', 'pwd');
$pdoStatement = $pdo->query('select * from t1');
$dbResult = $pdoStatement->fetchAll(PDO::FETCH_ASSOC);
var_dump($dbResult);
------------------------------------------------------------ -------
This produces the results:
array(1) {
[0]=>
array(3) {
["col1"]=>
string(1) "1"
["col2"]=>
string(4) "test"
["t1"]=>
string(1) "2"
}
That is, instead of returning 4 columns named col1,col2,col3,col4,
only 3 columns are returned, col1, col2 and t1!
While t1 is the name of the table!!!!
What's going on here (This drove me crazy at first )??
By the way, when running directly from under Apache this code produces the correct results. Is this some kind of a version issue? I'm running this from the latest release of eclipse pdt: PDT 2.1-SR1, Eclipse 3.5-SR1
Is there a latter one?
Many Thanks!
Vitaliy
|
|
|
Powered by
FUDForum. Page generated in 0.03346 seconds