php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #40904 invalid request BLR at offset 169 Implementation
Submitted: 2007-03-23 11:15 UTC Modified: 2007-03-31 01:00 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: a_kassasys at yahoo dot com Assigned:
Status: No Feedback Package: InterBase related
PHP Version: 5.2.1 OS: Free BSF
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: a_kassasys at yahoo dot com
New email:
PHP Version: OS:

 

 [2007-03-23 11:15 UTC] a_kassasys at yahoo dot com
Description:
------------
Similar on overflow of the buffer as at 1 inquiry, the server will crash, in other case gives out that a block size limit 

Reproduce code:
---------------
Warning: ibase_fetch_row() [function.ibase-fetch-row]: Error reading data from the connection. in /home/denis/user/0.php on line 51

Warning: Unknown: Unable to complete network request to host "192.168.0.20". Error writing data to the connection. Broken pipe in Unknown on line 0

Warning: Unknown: Unable to complete network request to host "192.168.0.20". Error writing data to the connection. Broken pipe in Unknown on line 0


Expected result:
----------------
Warning: ibase_query() [function.ibase-query]: 
invalid request BLR at offset 169 Implementation limit exceeded block size exceeds implementation restriction 

Actual result:
--------------
$sql="select PR.ID as F0
, PB.ID as F1
, cast(trimx(skui(strlen((select TEXT from GET_LANGUAGE_TEXT('ET', 'PRODUCT', 'NAME', PR.ID))), (select TEXT from GET_LANGUAGE_TEXT('ET', 'PRODUCT', 'NAME', PR.ID)), PR.NAME))||' '||trimx(PB.NAME) as VARCHAR(32000)) as F2
, PR.SEARCHCODE as F8
, cast(trimx(skui(strlen((select TEXTB from GET_LANGUAGE_TEXT2('ET', 'PRODUCT', 'ADDITIONAL', PR.ID))), (select TEXTB from GET_LANGUAGE_TEXT2('ET', 'PRODUCT', 'ADDITIONAL', PR.ID)), PR.ADDITIONAL)) as VARCHAR(32000)) as F3
, PR.PACKAGE as F7
, PR.PICTUREDATAEXT as F6
, skui(strlen((select TEXT from GET_LANGUAGE_TEXT('ET', 'PRODUCT_MEASUREMENT_UNIT', 'NAME', PR.MEASURUNIT_ID))),
         (select TEXT from GET_LANGUAGE_TEXT('ET', 'PRODUCT_MEASUREMENT_UNIT', 'NAME', PR.MEASURUNIT_ID)), PMU.NAME) as F4
, (select PG.POST from PRODUCT_GROUP PG where PG.ID=PR.GROUP_ID) as F9
, (select sum(PQ.FREEQUANTITY) from PRODUCT_QUANTITY PQ where ((PQ.PRODUCT_ID=PR.ID)  and (PQ.BACH_ID=PB.ID) and (PQ.OBJECT_ID=PG.OBJECT_ID)))-rnull(PG.MINLIMIT) as F10
, rnull(0) as F11
, PR.PICTUREDATA as F15
, (select CTP.NAMEET from CUSTOM_PROD_TYPE CTP where CTP.ID=PR.A8) as F60
, (select MAX(FILENAME) from ATTACHMENT where (((TABLENAME='PRODUCT_BACH') and (TABLEITEM_ID=PB.ID))or ((TABLENAME='PRODUCT') and (TABLEITEM_ID=PR.ID))) and (TRIMX(UPPER(FILENAME)) like '%.PDF' )) as F24
, PR.A7 as F51
, PR.A10 as F54
, PR.A11 as F55
, PR.A12 as F56
, PR.A13 as F57
, PR.A14 as F58
, PR.A9 as F53
/*, PR.CUSTOM_DESCRIPTION as A53*/
 from PRODUCT_BACH PB
    left join PRODUCT PR on (PR.ID=PB.PRODUCT_ID)
    left join PRODUCT_MEASUREMENT_UNIT PMU on (PMU.ID=PR.MEASURUNIT_ID) 
left join PRODUCT_GROUP PG on (PG.ID=PR.GROUP_ID) 

    where ((PB.ID=7053) and (PR.ID=4517))";

$sth1=ibase_query($dbh, $sql);
while ($res = ibase_fetch_row($sth1)) {
  print $res[0].'!';
  }



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-03-23 11:22 UTC] tony2001@php.net
>the server will crash
The Interbase server?
 [2007-03-31 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Dec 22 10:01:28 2024 UTC