#34080 [NEW]: recordset crash on trim and on fields with value null

2005-08-11 Thread mihkel at art dot tartu dot ee
From: mihkel at art dot tartu dot ee
Operating system: MS-Win2000 SP4
PHP version:  5.0.4
PHP Bug Type: Unknown/Other Function
Bug description:  recordset crash on trim and on fields with value null

Description:

Database: MS-SQL Server 2000 (in case it is important)

See code below.

Expecting it to NOT hang forever and produce some output.
Unfortunately - if ANY of the lines with crash comment behind them is
present it will hang forever (until web-server timeout).

'user' - is a present field of type char(20) and value is never NULL.
'kursjuh' - is a present field of type char(1) and will result a crash
only if field value is NULL.

PHP fails to produce error log - so, no info there.

Reproduce code:
---
$db=new COM(ADODB.Connection);
$db-Open(Driver={SQL Server};Server=***;Database=***;);
$dta=$db-Execute(SELECT * FROM Qigus); 

while(!$dta-EOF) {
 echo $dta-Fields['kursjuh']-Value; // crash
 echo $dta['kursjuh']; // crash
 echo $dta['user']; // works fine
 echo trim($dta['user']); // crash
 $dta-MoveNext(); }



-- 
Edit bug report at http://bugs.php.net/?id=34080edit=1
-- 
Try a CVS snapshot (php4):   http://bugs.php.net/fix.php?id=34080r=trysnapshot4
Try a CVS snapshot (php5.0): 
http://bugs.php.net/fix.php?id=34080r=trysnapshot50
Try a CVS snapshot (php5.1): 
http://bugs.php.net/fix.php?id=34080r=trysnapshot51
Fixed in CVS:http://bugs.php.net/fix.php?id=34080r=fixedcvs
Fixed in release:http://bugs.php.net/fix.php?id=34080r=alreadyfixed
Need backtrace:  http://bugs.php.net/fix.php?id=34080r=needtrace
Need Reproduce Script:   http://bugs.php.net/fix.php?id=34080r=needscript
Try newer version:   http://bugs.php.net/fix.php?id=34080r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=34080r=support
Expected behavior:   http://bugs.php.net/fix.php?id=34080r=notwrong
Not enough info: 
http://bugs.php.net/fix.php?id=34080r=notenoughinfo
Submitted twice: 
http://bugs.php.net/fix.php?id=34080r=submittedtwice
register_globals:http://bugs.php.net/fix.php?id=34080r=globals
PHP 3 support discontinued:  http://bugs.php.net/fix.php?id=34080r=php3
Daylight Savings:http://bugs.php.net/fix.php?id=34080r=dst
IIS Stability:   http://bugs.php.net/fix.php?id=34080r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=34080r=gnused
Floating point limitations:  http://bugs.php.net/fix.php?id=34080r=float
No Zend Extensions:  http://bugs.php.net/fix.php?id=34080r=nozend
MySQL Configuration Error:   http://bugs.php.net/fix.php?id=34080r=mysqlcfg


#34080 [Fbk-Opn]: recordset crash on trim and on fields with value null

2005-08-11 Thread mihkel at art dot tartu dot ee
 ID:   34080
 User updated by:  mihkel at art dot tartu dot ee
 Reported By:  mihkel at art dot tartu dot ee
-Status:   Feedback
+Status:   Open
 Bug Type: COM related
 Operating System: MS-Win2000 SP4
 PHP Version:  5.0.4
 New Comment:

The crash is gone now. (for both trim and null fields)

BUT. fields with the value NULL return now 'Object id #4' which doesn't
sound right. Am i missing somethig and it is suposed to do so?

(i would prefer 'NULL' or '' as return value)


Previous Comments:


[2005-08-11 13:22:38] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip





[2005-08-11 13:15:04] mihkel at art dot tartu dot ee

Description:

Database: MS-SQL Server 2000 (in case it is important)

See code below.

Expecting it to NOT hang forever and produce some output.
Unfortunately - if ANY of the lines with crash comment behind them is
present it will hang forever (until web-server timeout).

'user' - is a present field of type char(20) and value is never NULL.
'kursjuh' - is a present field of type char(1) and will result a crash
only if field value is NULL.

PHP fails to produce error log - so, no info there.

Reproduce code:
---
$db=new COM(ADODB.Connection);
$db-Open(Driver={SQL Server};Server=***;Database=***;);
$dta=$db-Execute(SELECT * FROM Qigus); 

while(!$dta-EOF) {
 echo $dta-Fields['kursjuh']-Value; // crash
 echo $dta['kursjuh']; // crash
 echo $dta['user']; // works fine
 echo trim($dta['user']); // crash
 $dta-MoveNext(); }







-- 
Edit this bug report at http://bugs.php.net/?id=34080edit=1


#34080 [Opn]: recordset crash on trim and on fields with value null

2005-08-11 Thread mihkel at art dot tartu dot ee
 ID:   34080
 User updated by:  mihkel at art dot tartu dot ee
 Reported By:  mihkel at art dot tartu dot ee
 Status:   Open
 Bug Type: COM related
 Operating System: MS-Win2000 SP4
 PHP Version:  5.0.4
 New Comment:

Update:

  $x=$rs['kursjuh'];
  echo 'x'.$x;
  echo 'x'.$rs['kursjuh'];

gives me 'Object id #4Object id #5' - this can't be normal.


Previous Comments:


[2005-08-11 14:35:38] mihkel at art dot tartu dot ee

The crash is gone now. (for both trim and null fields)

BUT. fields with the value NULL return now 'Object id #4' which doesn't
sound right. Am i missing somethig and it is suposed to do so?

(i would prefer 'NULL' or '' as return value)



[2005-08-11 13:22:38] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip





[2005-08-11 13:15:04] mihkel at art dot tartu dot ee

Description:

Database: MS-SQL Server 2000 (in case it is important)

See code below.

Expecting it to NOT hang forever and produce some output.
Unfortunately - if ANY of the lines with crash comment behind them is
present it will hang forever (until web-server timeout).

'user' - is a present field of type char(20) and value is never NULL.
'kursjuh' - is a present field of type char(1) and will result a crash
only if field value is NULL.

PHP fails to produce error log - so, no info there.

Reproduce code:
---
$db=new COM(ADODB.Connection);
$db-Open(Driver={SQL Server};Server=***;Database=***;);
$dta=$db-Execute(SELECT * FROM Qigus); 

while(!$dta-EOF) {
 echo $dta-Fields['kursjuh']-Value; // crash
 echo $dta['kursjuh']; // crash
 echo $dta['user']; // works fine
 echo trim($dta['user']); // crash
 $dta-MoveNext(); }







-- 
Edit this bug report at http://bugs.php.net/?id=34080edit=1


#34080 [Opn]: recordset crash on trim and on fields with value null

2005-08-11 Thread mihkel at art dot tartu dot ee
 ID:   34080
 User updated by:  mihkel at art dot tartu dot ee
 Reported By:  mihkel at art dot tartu dot ee
 Status:   Open
 Bug Type: COM related
 Operating System: MS-Win2000 SP4
 PHP Version:  5.0.4
 New Comment:

Correction:
'xObject id #4xObject id #5'

(where is the edit button when you need one? :/ )


Previous Comments:


[2005-08-11 14:47:39] mihkel at art dot tartu dot ee

Update:

  $x=$rs['kursjuh'];
  echo 'x'.$x;
  echo 'x'.$rs['kursjuh'];

gives me 'Object id #4Object id #5' - this can't be normal.



[2005-08-11 14:35:38] mihkel at art dot tartu dot ee

The crash is gone now. (for both trim and null fields)

BUT. fields with the value NULL return now 'Object id #4' which doesn't
sound right. Am i missing somethig and it is suposed to do so?

(i would prefer 'NULL' or '' as return value)



[2005-08-11 13:22:38] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip





[2005-08-11 13:15:04] mihkel at art dot tartu dot ee

Description:

Database: MS-SQL Server 2000 (in case it is important)

See code below.

Expecting it to NOT hang forever and produce some output.
Unfortunately - if ANY of the lines with crash comment behind them is
present it will hang forever (until web-server timeout).

'user' - is a present field of type char(20) and value is never NULL.
'kursjuh' - is a present field of type char(1) and will result a crash
only if field value is NULL.

PHP fails to produce error log - so, no info there.

Reproduce code:
---
$db=new COM(ADODB.Connection);
$db-Open(Driver={SQL Server};Server=***;Database=***;);
$dta=$db-Execute(SELECT * FROM Qigus); 

while(!$dta-EOF) {
 echo $dta-Fields['kursjuh']-Value; // crash
 echo $dta['kursjuh']; // crash
 echo $dta['user']; // works fine
 echo trim($dta['user']); // crash
 $dta-MoveNext(); }







-- 
Edit this bug report at http://bugs.php.net/?id=34080edit=1