ID: 41241
User updated by: develar at gmail dot com
Reported By: develar at gmail dot com
-Status: Feedback
+Status: Open
Bug Type: PDO related
Operating System: Windows XP SP2
PHP Version: 5.2.1
New Comment:
<?php
$Pdo = new PDO('pgsql:host=localhost port=5432 dbname=postgres
user=postgres password=password');
var_export($Pdo->query('select proargnames from pg_catalog.pg_proc
order by proargnames limit 1')->fetchAll(PDO::FETCH_ASSOC));
?>
actual:
array (
0 =>
array (
'proargnames' => '{"",x,n}',
),
)
expected:
proargnames is array, but not string
array (
0 =>
array (
'proargnames' =>
array (
0 => '',
1 => 'x',
2 => 'n',
),
),
)
Previous Comments:
------------------------------------------------------------------------
[2007-04-30 13:25:40] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
Try with a short reproduce code if you're unable to explain your
problem in English.
------------------------------------------------------------------------
[2007-04-30 13:20:08] develar at gmail dot com
Pdo (pdo_pgsql) supports SQL 2003 T031 - BOOLEAN data type. If I select
value of a field, it will be returned with type BOOL.
I ask, that also was supported SQL 2003 S091 - ARRAY data type. If I
select proargnames with type text[], I expect, that PDO will return to
me array, instead of string.
------------------------------------------------------------------------
[2007-04-30 13:08:34] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
------------------------------------------------------------------------
[2007-04-30 13:06:53] develar at gmail dot com
"Actual result" and "Expected result" reverse, excuse me :).
------------------------------------------------------------------------
[2007-04-30 13:01:28] develar at gmail dot com
Description:
------------
SQL 2003, S091.
Reproduce code:
---------------
PostgreSQL 8.2
select proargnames from pg_catalog.pg_proc order by proargnames limit 1
Expected result:
----------------
array (
0 =>
array (
'proargnames' =>
'{"","","",id,uri,time_create,priority_base_time_create,title,time_modify,status,priority_base_title,type_name,leaf,version,author_name,author_surname,author_patronymic,privilege_edit,privilege_delete,privilege_grant}',
),
)
Actual result:
--------------
array (
0 =>
array (
'proargnames' =>
'{"","","",id,uri,time_create,priority_base_time_create,title,time_modify,array
(
0 =>
array (
'proargnames' =>
array (
0 => '',
1 => '',
2 => '',
3 => 'id',
4 => 'uri',
5 => 'time_create',
6 => 'priority_base_time_create',
7 => 'title',
8 => 'time_modify',
9 => 'status',
10 => 'priority_base_title',
11 => 'type_name',
12 => 'leaf',
13 => 'version',
14 => 'author_name',
15 => 'author_surname',
16 => 'author_patronymic',
17 => 'privilege_edit',
18 => 'privilege_delete',
19 => 'privilege_grant',
),
),
)}',
),
)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=41241&edit=1
