ID: 42704
User updated by: carl dot washburn at iridium dot com
Reported By: carl dot washburn at iridium dot com
Status: Open
Bug Type: Sybase (dblib) related
Operating System: Solaris 10
PHP Version: 5.2.4
New Comment:
Added info:
This is 64 bit php build. 32 bit has not been tested.
Code that reproduces bug:
<?php
$btime=mktime(0,0,0,09,17,2007);
$etime=mktime(23,59,59,09,18,2007);
sybase_connect('OURhost','OURuser','OURpass');
sybase_select_db("OURdb");
$querytxt="SELECT COUNT(MT_ID_) FROM MTTS_MaintenanceTicket WHERE
(Creation_Date_Time__Submit__ BETWEEN CONVERT(INT,'$btime') AND
CONVERT(INT,'$etime') OR Modified_Date_Time_ BETWEEN
CONVERT(INT,'$btime') AND CONVERT(INT,'$etime')) AND
CONVERT(VARCHAR,Priority__code_) like '%' AND CONVERT(VARCHAR,MT_State_)
like '%' AND Assigned_to__Login_Name_ LIKE '%' AND MT_ID_ like '%'
AND(Ownership_Server_ LIKE '%' OR To_Server LIKE '$server' or
Current_Server LIKE '$server') ORDER BY Creation_Date_Time__Submit__";
$mttsq=sybase_query("$querytxt");
?>
Previous Comments:
------------------------------------------------------------------------
[2007-09-18 19:16:16] carl dot washburn at iridium dot com
Description:
------------
I have seen this problem in both 5.2.3 and 5.2.4.
If I compile php with:
--with-sybase=/usr/local/freetds
--enable-soap,
I receive the following when calling sybase_query:
"Allowed memory size of 104857600 bytes exhausted (tried to allocate
4722688 bytes)"
If I use:
ini_set("memory_limit","-1");
ini_set("max_execution_time","-1");
I receive from the same call to sybase_query:
"Out of memory (allocated 8156348416) (tried to allocate 370671616
bytes)" .
The query returns requested information if I do not enable soap
extensions.
Expected result:
----------------
Query to return the same information as without --enable-soap.
Actual result:
--------------
Query fails.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=42704&edit=1
