#43923 [Asn]: ini scanner silently ignores "{"
ID: 43923
User updated by: develar at gmail dot com
Reported By: develar at gmail dot com
Status: Assigned
Bug Type: *General Issues
Operating System: Linux 2.6.22.13-0.3 openSUSE
PHP Version: 5.3CVS-2008-01-23 (snap)
Assigned To: jani
New Comment:
>> Why would you pass such value anyway? :)
I use blitz - "blitz.tag_open = {". date.timezone as example :)
Previous Comments:
[2008-01-26 00:54:17] [EMAIL PROTECTED]
Why would you pass such value anyway? :)
[2008-01-23 18:00:57] develar at gmail dot com
Description:
set in php.ini any parameter = "{" is ignored (i. e. "no value")
Reproduce code:
---
;php.ini
date.timezone = "{"
Expected result:
{
Actual result:
--
no value
--
Edit this bug report at http://bugs.php.net/?id=43923&edit=1
#43923 [Opn]: parser php.ini ignore "{"
ID: 43923
User updated by: develar at gmail dot com
-Summary: Linux 2.6.22.13-0.3 openSUSE
Reported By: develar at gmail dot com
Status: Open
Bug Type: *Configuration Issues
-Operating System:
+Operating System: Linux 2.6.22.13-0.3 openSUSE
PHP Version: 5.3CVS-2008-01-23 (snap)
New Comment:
changed summary
Previous Comments:
[2008-01-23 18:00:57] develar at gmail dot com
Description:
set in php.ini any parameter = "{" is ignored (i. e. "no value")
Reproduce code:
---
;php.ini
date.timezone = "{"
Expected result:
{
Actual result:
--
no value
--
Edit this bug report at http://bugs.php.net/?id=43923&edit=1
#43923 [NEW]: Linux 2.6.22.13-0.3 openSUSE
From: develar at gmail dot com
Operating system:
PHP version: 5.3CVS-2008-01-23 (snap)
PHP Bug Type: *Configuration Issues
Bug description: Linux 2.6.22.13-0.3 openSUSE
Description:
set in php.ini any parameter = "{" is ignored (i. e. "no value")
Reproduce code:
---
;php.ini
date.timezone = "{"
Expected result:
{
Actual result:
--
no value
--
Edit bug report at http://bugs.php.net/?id=43923&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=43923&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=43923&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=43923&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=43923&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=43923&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=43923&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=43923&r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=43923&r=needscript
Try newer version:http://bugs.php.net/fix.php?id=43923&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=43923&r=support
Expected behavior:http://bugs.php.net/fix.php?id=43923&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=43923&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=43923&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=43923&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=43923&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=43923&r=dst
IIS Stability:http://bugs.php.net/fix.php?id=43923&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=43923&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=43923&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=43923&r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=43923&r=mysqlcfg
#43139 [NEW]: PDO ignore ATTR_DEFAULT_FETCH_MODE in some cases
From: develar at gmail dot com
Operating system: Windows XP SP2
PHP version: 5.2.4
PHP Bug Type: PDO related
Bug description: PDO ignore ATTR_DEFAULT_FETCH_MODE in some cases
Description:
In 5.2.4 (earlier all worked) and 5.2.5RC2dev (I now use this version) PDO
ignore ATTR_DEFAULT_FETCH_MODE.
PostgreSQL 8.2.4 and 8.3beta1.
Reproduce code:
---
setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
print_r($Db->query('select 0 as name, 1 as table, 2 as
schema')->fetchAll(PDO::FETCH_GROUP));
?>
Expected result:
Array
(
[0] => Array
(
[0] => Array
(
[table] => 1
[schema] => 2
)
)
)
Actual result:
--
Array
(
[0] => Array
(
[0] => Array
(
[table] => 1
[0] => 1
[schema] => 2
[1] => 2
)
)
)
--
Edit bug report at http://bugs.php.net/?id=43139&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=43139&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=43139&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=43139&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=43139&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=43139&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=43139&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=43139&r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=43139&r=needscript
Try newer version:http://bugs.php.net/fix.php?id=43139&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=43139&r=support
Expected behavior:http://bugs.php.net/fix.php?id=43139&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=43139&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=43139&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=43139&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=43139&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=43139&r=dst
IIS Stability:http://bugs.php.net/fix.php?id=43139&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=43139&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=43139&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=43139&r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=43139&r=mysqlcfg
#42948 [Fbk->Csd]: DirectoryIterator don't close handle
ID: 42948 User updated by: develar at gmail dot com Reported By: develar at gmail dot com -Status: Feedback +Status: Closed Bug Type: SPL related Operating System: Windows XP SP2 PHP Version: 5.2.4 New Comment: Big thanks. I unset($SplFileInfo); and it works. It is a little difficult to guess, but it is logically correct. This is bogus, excuse me :) Previous Comments: [2007-10-12 17:06:17] [EMAIL PROTECTED] Why are you mixing Unix and Windows paths and please try unsetting $SplFileInfo, too. [2007-10-12 12:59:56] develar at gmail dot com Description: I can't delete directory after use DirectoryIterator. I read http://bugs.php.net/bug.php?id=35997 Reproduce code: --- Expected result: no error Actual result: -- Warning: rmdir(/tmp/49058378) [function.rmdir]: Permission denied in C:\home\test\www\test.php on line 11 -- Edit this bug report at http://bugs.php.net/?id=42948&edit=1
#42948 [NEW]: DirectoryIterator don't close handle
From: develar at gmail dot com Operating system: Windows XP SP2 PHP version: 5.2.4 PHP Bug Type: SPL related Bug description: DirectoryIterator don't close handle Description: I can't delete directory after use DirectoryIterator. I read http://bugs.php.net/bug.php?id=35997 Reproduce code: --- Expected result: no error Actual result: -- Warning: rmdir(/tmp/49058378) [function.rmdir]: Permission denied in C:\home\test\www\test.php on line 11 -- Edit bug report at http://bugs.php.net/?id=42948&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42948&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42948&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42948&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42948&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42948&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42948&r=needtrace Need Reproduce Script:http://bugs.php.net/fix.php?id=42948&r=needscript Try newer version:http://bugs.php.net/fix.php?id=42948&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42948&r=support Expected behavior:http://bugs.php.net/fix.php?id=42948&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42948&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42948&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42948&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42948&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42948&r=dst IIS Stability:http://bugs.php.net/fix.php?id=42948&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42948&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42948&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42948&r=nozend MySQL Configuration Error:http://bugs.php.net/fix.php?id=42948&r=mysqlcfg
#41596 [Fbk->Opn]: crash. when sql syntax is invalid
ID: 41596 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.3 New Comment: win must die. I use debian 4 (Linux 2.6.18-4-486), gdb. #0 0x081a63c8 in pdo_parse_params (stmt=0xb79eec0c, inquery=0xb79eeb14 "delete from users.\"users where id = :id", inquery_len=39, outquery=0xbff3b3c0, outquery_len=0xbff3b3bc) at /tmp/php-5.2.3/ext/pdo/pdo_sql_parser.c:391 #1 0x081aaf63 in pgsql_handle_preparer (dbh=0xb79ee6c4, sql=0xb79eeb14 "delete from users.\"users where id = :id", sql_len=39, stmt=0xb79eec0c, driver_options=0x0) at /tmp/php-5.2.3/ext/pdo_pgsql/pgsql_driver.c:254 #2 0x0819b2b7 in zim_PDO_prepare (ht=1, return_value=0xb79ee894, return_value_ptr=0x0, this_ptr=0xb79ed240, return_value_used=1) at /tmp/php-5.2.3/ext/pdo/pdo_dbh.c:580 #3 0x083a93f1 in zend_do_fcall_common_helper_SPEC (execute_data=0xbff3b794) at /tmp/php-5.2.3/Zend/zend_vm_execute.h:200 #4 0x083aa03b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff3b794) at /tmp/php-5.2.3/Zend/zend_vm_execute.h:322 #5 0x083a8f54 in execute (op_array=0xb79ed938) at /tmp/php-5.2.3/Zend/zend_vm_execute.h:92 #6 0x083848b3 in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /tmp/php-5.2.3/Zend/zend.c:1134 #7 0x08333f4a in php_execute_script (primary_file=0xbff3db30) at /tmp/php-5.2.3/main/main.c:1794 #8 0x083fdc3a in main (argc=2, argv=0xbff3dc74) at /tmp/php-5.2.3/sapi/cli/php_cli.c:1138 Previous Comments: [2007-06-05 15:40:38] [EMAIL PROTECTED] Compare it to the backtrace here: http://bugs.php.net/bugs-generating-backtrace-win32.php ---- [2007-06-05 15:20:25] develar at gmail dot com Call Stack: PHP_PDO! 00fb5323() It what is necessary? [2007-06-05 11:29:17] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. -------- [2007-06-05 11:03:29] develar at gmail dot com Apache die. Server API: Apache 2.0 Handler. Apache Version: Apache/2.0.59 (Win32). [2007-06-05 10:56:50] [EMAIL PROTECTED] Please define "crash". The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/41596 -- Edit this bug report at http://bugs.php.net/?id=41596&edit=1
#41596 [Fbk->Opn]: crash. when sql syntax is invalid
ID: 41596
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.3
New Comment:
Call Stack: PHP_PDO! 00fb5323()
It what is necessary?
Previous Comments:
[2007-06-05 11:29:17] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.
[2007-06-05 11:03:29] develar at gmail dot com
Apache die.
Server API: Apache 2.0 Handler.
Apache Version: Apache/2.0.59 (Win32).
[2007-06-05 10:56:50] [EMAIL PROTECTED]
Please define "crash".
[2007-06-05 10:48:12] develar at gmail dot com
Description:
'delete from users."users where id = :id' is wrong, must be 'delete
from users."users" where id = :id', but why pdo crash.
Reproduce code:
---
setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$Pdo = $Db->prepare('delete from users."users where id = :id');
$Pdo->bindValue(':id', 45, PDO::PARAM_INT);
$Pdo->execute();
?>
Expected result:
not crash
Actual result:
--
crash
--
Edit this bug report at http://bugs.php.net/?id=41596&edit=1
#41596 [Fbk->Opn]: crash. when sql syntax is invalid
ID: 41596
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.3
New Comment:
Apache die.
Server API: Apache 2.0 Handler.
Apache Version: Apache/2.0.59 (Win32).
Previous Comments:
[2007-06-05 10:56:50] [EMAIL PROTECTED]
Please define "crash".
[2007-06-05 10:48:12] develar at gmail dot com
Description:
'delete from users."users where id = :id' is wrong, must be 'delete
from users."users" where id = :id', but why pdo crash.
Reproduce code:
---
setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$Pdo = $Db->prepare('delete from users."users where id = :id');
$Pdo->bindValue(':id', 45, PDO::PARAM_INT);
$Pdo->execute();
?>
Expected result:
not crash
Actual result:
--
crash
--
Edit this bug report at http://bugs.php.net/?id=41596&edit=1
#41596 [NEW]: crash. when sql syntax is invalid
From: develar at gmail dot com
Operating system: Windows XP SP2
PHP version: 5.2.3
PHP Bug Type: PDO related
Bug description: crash. when sql syntax is invalid
Description:
'delete from users."users where id = :id' is wrong, must be 'delete from
users."users" where id = :id', but why pdo crash.
Reproduce code:
---
setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$Pdo = $Db->prepare('delete from users."users where id = :id');
$Pdo->bindValue(':id', 45, PDO::PARAM_INT);
$Pdo->execute();
?>
Expected result:
not crash
Actual result:
--
crash
--
Edit bug report at http://bugs.php.net/?id=41596&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=41596&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=41596&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=41596&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=41596&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=41596&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=41596&r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=41596&r=needscript
Try newer version:http://bugs.php.net/fix.php?id=41596&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=41596&r=support
Expected behavior:http://bugs.php.net/fix.php?id=41596&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=41596&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=41596&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=41596&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41596&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=41596&r=dst
IIS Stability:http://bugs.php.net/fix.php?id=41596&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=41596&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=41596&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=41596&r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=41596&r=mysqlcfg
#41293 [Com]: HTTP_RAW_POST_DATA fails to ever be set
ID: 41293
Comment by: develar at gmail dot com
Reported By: jerome at rainstormconsulting dot com
Status: Assigned
Bug Type: HTTP related
Operating System: linux (centos or ubuntu)
PHP Version: 5.2.2
Assigned To: iliaa
New Comment:
>> php://input is not affected
only in start script, but in end script php://input is empty.
Previous Comments:
[2007-05-04 21:13:59] [EMAIL PROTECTED]
Only happens with RPC stuff. (soap / xml-rpc /..).
php://input is not affected.
[2007-05-04 19:50:32] jerome at rainstormconsulting dot com
Description:
PHP 5.2.2 fails to ever have $HTTP_RAW_POST_DATA set despite the ini
setting to being On
Reproduce code:
---
Server:
setClass('MyService');
$server->handle();
client:
1,
'exceptions' => 1));
try {
$client->doSomething();
}
catch(SoapFault $e) {
print 'Service failure, error message: '.$e->faultstring;
}
Expected result:
This should proceed with no problems, an already working service setup
in a web application, functioning on both PHP 5.1.6 and PHP 5.2.1 with
no issues at all. Should produce no error.
Actual result:
--
Service failure, error message: Bad Request. Can't find
HTTP_RAW_POST_DATA
You USUALLY only see this if you access the server file (say
xmlrpc.php) directly without posting any data.
--
Edit this bug report at http://bugs.php.net/?id=41293&edit=1
#41241 [Fbk->Opn]: Realization array type. SQL 2003, S091
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:
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 ,
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
#41241 [Fbk->Opn]: Realization array type. SQL 2003, S091
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:
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.
Previous Comments:
[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
#41241 [Opn]: Realization array type. SQL 2003, S091
ID: 41241
User updated by: develar at gmail dot com
Reported By: develar at gmail dot com
Status: Open
Bug Type: PDO related
Operating System: Windows XP SP2
PHP Version: 5.2.1
New Comment:
"Actual result" and "Expected result" reverse, excuse me :).
Previous Comments:
[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
#41241 [NEW]: Realization array type. SQL 2003, S091
From: develar at gmail dot com
Operating system: Windows XP SP2
PHP version: 5.2.1
PHP Bug Type: PDO related
Bug description: Realization array type. SQL 2003, S091
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 bug report at http://bugs.php.net/?id=41241&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=41241&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=41241&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=41241&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=41241&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=41241&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=41241&r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=41241&r=needscript
Try newer version:http://bugs.php.net/fix.php?id=41241&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=41241&r=support
Expected behavior:http://bugs.php.net/fix.php?id=41241&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=41241&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=41241&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=41241&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41241&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=41241&r=dst
IIS Stability:http://bugs.php.net/fix.php?id=41241&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=41241&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=41241&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=41241&r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=41241&r=mysqlcfg
#40180 [Asn->Csd]: php_strip_whitespace break hexadecimal int
ID: 40180 User updated by: develar at gmail dot com Reported By: develar at gmail dot com -Status: Assigned +Status: Closed Bug Type: Unknown/Other Function Operating System: Windows XP SP2 PHP Version: 5.2.1RC3 Assigned To: iliaa New Comment: I use 5.2.1RC3-dev. I install last snapshot and now use 5.2.1RC4-dev. Bug fixed. Thanks. Previous Comments: [2007-01-20 12:05:48] php_lists at realplain dot com No, actually that fixed it. :-) The previous code was from a patch of mine, and it was modifying yytext (following HEAD's lead! I had since discovered another bug where changing yytext was causing characters to be dropped, which was fixed). Then I realized this hex bug existed too, and Ilia applied my fix before releasing RC3. The "Reproduce code" posted works as expected in RC3, so the reporter was not using RC3 as indicated. Only RC2 had this problem. [2007-01-20 09:39:36] [EMAIL PROTECTED] ilia, your last scanner commit broke it: http://cvs.php.net/viewvc.cgi/ZendEngine2/zend_language_scanner.l?r1=1.131.2.11.2.6&r2=1.131.2.11.2.7&pathrev=PHP_5_2&view=patch Can you have a look? ---- [2007-01-20 09:20:51] develar at gmail dot com Description: php_strip_whitespace produce invalid code Reproduce code: --- // test.php // stripme.php Expected result: Actual result: -- -- Edit this bug report at http://bugs.php.net/?id=40180&edit=1
#40180 [NEW]: php_strip_whitespace break hexadecimal int
From: develar at gmail dot com Operating system: Windows XP SP2 PHP version: 5.2.1RC3 PHP Bug Type: Unknown/Other Function Bug description: php_strip_whitespace break hexadecimal int Description: php_strip_whitespace produce invalid code Reproduce code: --- // test.php // stripme.php Expected result: Actual result: -- -- Edit bug report at http://bugs.php.net/?id=40180&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=40180&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=40180&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=40180&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=40180&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=40180&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=40180&r=needtrace Need Reproduce Script:http://bugs.php.net/fix.php?id=40180&r=needscript Try newer version:http://bugs.php.net/fix.php?id=40180&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=40180&r=support Expected behavior:http://bugs.php.net/fix.php?id=40180&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=40180&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=40180&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=40180&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=40180&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=40180&r=dst IIS Stability:http://bugs.php.net/fix.php?id=40180&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=40180&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=40180&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=40180&r=nozend MySQL Configuration Error:http://bugs.php.net/fix.php?id=40180&r=mysqlcfg
#39858 [Fbk->Opn]: Lost connection to MySQL server during query by a repeated call stored proced
ID: 39858
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.0
New Comment:
Почитайте
http://phpclub.ru/talk/showthread.php?s=&threadid=92764&rand=10
It always worked normally on linux. My first message: "I read #35333
#35637 #35203, but why the given code
fine works in Debian?" Only in windows.
Previous Comments:
[2006-12-18 09:20:54] [EMAIL PROTECTED]
Works just fine on Linux.
Make sure you're really running the snapshot.
[2006-12-18 08:43:52] develar at gmail dot com
It is not fixed.
[2006-12-18 08:34:30] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.2-win32-latest.zip
[2006-12-17 14:30:25] develar at gmail dot com
Description:
The second call stored procedures causes an error "SQLSTATE[HY000]:
General error: 2013 Lost connection to MySQL server during query" with
probability of 50%. I read #35333 #35637 #35203, but why the given code
fine works in Debian?
Reproduce code:
---
CREATE PROCEDURE `foo`()
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
SELECT 2 * 2;
END;
"SET NAMES 'utf8'",
PDO::ATTR_PERSISTENT => true));
$Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$Pdo = $Db->prepare('CALL foo()');
$Pdo->execute();
print_r($Pdo->fetchAll());
$Pdo = $Db->prepare('CALL foo()');
$Pdo->execute();
print_r($Pdo->fetchAll());
$Pdo->closeCursor();
?>
Expected result:
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Actual result:
--
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Warning: PDOStatement::execute() [function.PDOStatement-execute]:
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server
during query in C:\home\test\www\pdo.php on line 12
Array
(
)
--
Edit this bug report at http://bugs.php.net/?id=39858&edit=1
#39858 [Fbk->Opn]: Lost connection to MySQL server during query by a repeated call stored proced
ID: 39858
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.0
New Comment:
It is not fixed.
Previous Comments:
[2006-12-18 08:34:30] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.2-win32-latest.zip
[2006-12-17 14:30:25] develar at gmail dot com
Description:
The second call stored procedures causes an error "SQLSTATE[HY000]:
General error: 2013 Lost connection to MySQL server during query" with
probability of 50%. I read #35333 #35637 #35203, but why the given code
fine works in Debian?
Reproduce code:
---
CREATE PROCEDURE `foo`()
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
SELECT 2 * 2;
END;
"SET NAMES 'utf8'",
PDO::ATTR_PERSISTENT => true));
$Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$Pdo = $Db->prepare('CALL foo()');
$Pdo->execute();
print_r($Pdo->fetchAll());
$Pdo = $Db->prepare('CALL foo()');
$Pdo->execute();
print_r($Pdo->fetchAll());
$Pdo->closeCursor();
?>
Expected result:
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Actual result:
--
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Warning: PDOStatement::execute() [function.PDOStatement-execute]:
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server
during query in C:\home\test\www\pdo.php on line 12
Array
(
)
--
Edit this bug report at http://bugs.php.net/?id=39858&edit=1
#39858 [NEW]: Lost connection to MySQL server during query by a repeated call stored proced
From: develar at gmail dot com
Operating system: Windows XP SP2
PHP version: 5.2.0
PHP Bug Type: PDO related
Bug description: Lost connection to MySQL server during query by a repeated
call stored proced
Description:
The second call stored procedures causes an error "SQLSTATE[HY000]:
General error: 2013 Lost connection to MySQL server during query" with
probability of 50%. I read #35333 #35637 #35203, but why the given code
fine works in Debian?
Reproduce code:
---
CREATE PROCEDURE `foo`()
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
SELECT 2 * 2;
END;
"SET NAMES 'utf8'",
PDO::ATTR_PERSISTENT => true));
$Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$Pdo = $Db->prepare('CALL foo()');
$Pdo->execute();
print_r($Pdo->fetchAll());
$Pdo = $Db->prepare('CALL foo()');
$Pdo->execute();
print_r($Pdo->fetchAll());
$Pdo->closeCursor();
?>
Expected result:
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Actual result:
--
Array
(
[0] => Array
(
[2 * 2] => 4
)
)
Warning: PDOStatement::execute() [function.PDOStatement-execute]:
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server
during query in C:\home\test\www\pdo.php on line 12
Array
(
)
--
Edit bug report at http://bugs.php.net/?id=39858&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=39858&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=39858&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=39858&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=39858&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=39858&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=39858&r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=39858&r=needscript
Try newer version:http://bugs.php.net/fix.php?id=39858&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=39858&r=support
Expected behavior:http://bugs.php.net/fix.php?id=39858&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=39858&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=39858&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=39858&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39858&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=39858&r=dst
IIS Stability:http://bugs.php.net/fix.php?id=39858&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=39858&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=39858&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=39858&r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=39858&r=mysqlcfg
#39398 [Opn]: No cast of logic type and silence
ID: 39398
User updated by: develar at gmail dot com
Reported By: develar at gmail dot com
Status: Open
Bug Type: PDO related
Operating System: Debian 3
PHP Version: 5.2.0
New Comment:
var_dump($Db->query('SELECT * FROM test')->fetchAll());
Previous Comments:
[2006-11-06 11:56:04] develar at gmail dot com
Description:
PDO does not cast a variable with boolean type in bindValue, does not
do execute and is silent.
I should cast manually - (int).
Reproduce code:
---
CREATE TABLE `test` (
`test` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
$Db = new PDO('mysql:host=localhost;dbname=test', 'root', '');
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$boolean = 1;
$Pdo = $Db->prepare('INSERT INTO test VALUES (:boolean)');
$Pdo->bindValue(':boolean', isset($boolean), PDO::PARAM_INT);
$Pdo->execute();
Expected result:
array(1) { [0]=> array(1) { ["test"]=> string(1) "1" } }
Actual result:
--
array(0) { }
--
Edit this bug report at http://bugs.php.net/?id=39398&edit=1
#39398 [NEW]: No cast of logic type and silence
From: develar at gmail dot com
Operating system: Debian 3
PHP version: 5.2.0
PHP Bug Type: PDO related
Bug description: No cast of logic type and silence
Description:
PDO does not cast a variable with boolean type in bindValue, does not do
execute and is silent.
I should cast manually - (int).
Reproduce code:
---
CREATE TABLE `test` (
`test` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
$Db = new PDO('mysql:host=localhost;dbname=test', 'root', '');
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$boolean = 1;
$Pdo = $Db->prepare('INSERT INTO test VALUES (:boolean)');
$Pdo->bindValue(':boolean', isset($boolean), PDO::PARAM_INT);
$Pdo->execute();
Expected result:
array(1) { [0]=> array(1) { ["test"]=> string(1) "1" } }
Actual result:
--
array(0) { }
--
Edit bug report at http://bugs.php.net/?id=39398&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=39398&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=39398&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=39398&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=39398&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=39398&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=39398&r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=39398&r=needscript
Try newer version:http://bugs.php.net/fix.php?id=39398&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=39398&r=support
Expected behavior:http://bugs.php.net/fix.php?id=39398&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=39398&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=39398&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=39398&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39398&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=39398&r=dst
IIS Stability:http://bugs.php.net/fix.php?id=39398&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=39398&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=39398&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=39398&r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=39398&r=mysqlcfg
