from:"jear"

#20641 [Fbk->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

2003-04-03 Thread jear at aabc dot dk

 ID:   20641
 User updated by:  jear at aabc dot dk
 Reported By:  jear at aabc dot dk
-Status:   Feedback
+Status:   Open
 Bug Type: InterBase related
 Operating System: Windows NT / Firebird 1.0
 PHP Version:  4.2.3
 New Comment:

I've downloaded og installed the latest STABLE snaphot with ALL the
dlls. After rebooting, the same erroneous number is returned from
Interbase to PHP:

IB/Firebird datatype (decimal 10,0), value 2303511415 returns
2147483647.


Previous Comments:


[2003-03-31 03:33:38] [EMAIL PROTECTED]

Make sure that you REALLY updated to the latest STABLE snaphot and ALL
the dlls. (and you might need to reboot even)
(don't install anything when your webserver is running)




[2003-03-31 03:08:09] jear at aabc dot dk

I've tried current CVS and php_4_3 for Windows.

Unfortunately the numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), still causes an
overflow.

Example:
InterBase 2303511415 (decimal 10,0) returns 2147483647



[2003-03-13 16:13:10] [EMAIL PROTECTED]

Fixed in current CVS and php_4_3



[2003-02-11 02:37:53] jear at aabc dot dk

I've tried the CVS snapshot for Windows:

  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

Unfortunately the numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), still causes an
overflow.


integer overflow is still there.



[2003-02-10 13:01:59] [EMAIL PROTECTED]

Please try using this CVS snapshot:

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





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/20641

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

#20641 [Csd->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

2003-03-31 Thread jear at aabc dot dk

 ID:   20641
 User updated by:  jear at aabc dot dk
 Reported By:  jear at aabc dot dk
-Status:   Closed
+Status:   Open
 Bug Type: InterBase related
 Operating System: Windows NT / Firebird 1.0
 PHP Version:  4.2.3
 New Comment:

I've tried current CVS and php_4_3 for Windows.

Unfortunately the numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), still causes an
overflow.

Example:
InterBase 2303511415 (decimal 10,0) returns 2147483647


Previous Comments:


[2003-03-13 16:13:10] [EMAIL PROTECTED]

Fixed in current CVS and php_4_3



[2003-02-11 02:37:53] jear at aabc dot dk

I've tried the CVS snapshot for Windows:

  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

Unfortunately the numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), still causes an
overflow.


integer overflow is still there.



[2003-02-10 13:01:59] [EMAIL PROTECTED]

Please try using this CVS snapshot:

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





[2002-12-22 06:04:48] jear at aabc dot dk

The problem still exits after downloadning the latest PHP4 at
http://snaps.php.net/win32/php4-win32-latest.zip.



[2002-12-21 01:00:01] php-bugs at lists dot php dot net

No feedback was provided for this bug for over 2 weeks, 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".



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/20641

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

#20641 [Fbk->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

2003-02-11 Thread jear

 ID:   20641
 User updated by:  [EMAIL PROTECTED]
 Reported By:  [EMAIL PROTECTED]
-Status:   Feedback
+Status:   Open
 Bug Type: InterBase related
 Operating System: Windows NT / Firebird 1.0
 PHP Version:  4.2.3
 New Comment:

I've tried the CVS snapshot for Windows:

  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

Unfortunately the numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), still causes an
overflow.


integer overflow is still there.


Previous Comments:


[2003-02-10 13:01:59] [EMAIL PROTECTED]

Please try using this CVS snapshot:

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





[2002-12-22 06:04:48] [EMAIL PROTECTED]

The problem still exits after downloadning the latest PHP4 at
http://snaps.php.net/win32/php4-win32-latest.zip.



[2002-12-21 01:00:01] [EMAIL PROTECTED]

No feedback was provided for this bug for over 2 weeks, 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".



[2002-12-04 22:49:33] [EMAIL PROTECTED]

Please try using this CVS snapshot:

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





[2002-11-26 04:38:19] [EMAIL PROTECTED]

Numeric type returns invalid result using
ibase_fetch_row/ibase_fetch_object (Windows NT).

Numbers stored as an InterBase/Firebird numeric/decimal datatype
beyond
the bounds of the PHP integer type (> 2147483647), do not return a
float
type but cause an overflow 

Example:
2303511415 (decimal 10,0) returns -1991455881

PHP/Firebird example script:
$sql = "create table temp (large_number numeric(10,0))";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();


$sql = "INSERT INTO temp VALUES (2303511415)";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "SELECT large_number FROM temp WHERE large_number =
2303511415";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

while ($row = ibase_fetch_row($result)) {
   print($row[0]); 
}

ibase_free_result($result);

$sql = "drop table temp";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();



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/20641

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

#20641 [NoF->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

2002-12-22 Thread jear

 ID:   20641
 User updated by:  [EMAIL PROTECTED]
 Reported By:  [EMAIL PROTECTED]
-Status:   No Feedback
+Status:   Open
 Bug Type: InterBase related
 Operating System: Windows NT / Firebird 1.0
 PHP Version:  4.2.3
 New Comment:

The problem still exits after downloadning the latest PHP4 at
http://snaps.php.net/win32/php4-win32-latest.zip.


Previous Comments:


[2002-12-21 01:00:01] [EMAIL PROTECTED]

No feedback was provided for this bug for over 2 weeks, 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".



[2002-12-04 22:49:33] [EMAIL PROTECTED]

Please try using this CVS snapshot:

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





[2002-11-26 04:38:19] [EMAIL PROTECTED]

Numeric type returns invalid result using
ibase_fetch_row/ibase_fetch_object (Windows NT).

Numbers stored as an InterBase/Firebird numeric/decimal datatype
beyond
the bounds of the PHP integer type (> 2147483647), do not return a
float
type but cause an overflow 

Example:
2303511415 (decimal 10,0) returns -1991455881

PHP/Firebird example script:
$sql = "create table temp (large_number numeric(10,0))";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();


$sql = "INSERT INTO temp VALUES (2303511415)";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "SELECT large_number FROM temp WHERE large_number =
2303511415";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

while ($row = ibase_fetch_row($result)) {
   print($row[0]); 
}

ibase_free_result($result);

$sql = "drop table temp";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();



[2002-11-26 03:24:19] [EMAIL PROTECTED]

Numeric type returns invalid result using
ibase_fetch_row/ibase_fetch_object (Windows NT).

Numbers stored as an InterBase/Firebird numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), do not return a
float type but cause an overflow 

Example:
2303511415 (decimal 10,0) returns -1991455881

PHP/Firebird example script:
$sql = "create table temp (large_number numeric(10,0))";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "INSERT INTO temp VALUES (2303511415)";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "SELECT large_number FROM temp WHERE large_number =
2303511415";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

while ($row = ibase_fetch_row($result)) {
   print($row[0]); 
}




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

#20641 [Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

2002-11-26 Thread jear

 ID:   20641
 User updated by:  [EMAIL PROTECTED]
 Reported By:  [EMAIL PROTECTED]
 Status:   Open
 Bug Type: InterBase related
-Operating System: Windows XP / Firebird 1.0
+Operating System: Windows NT / Firebird 1.0
 PHP Version:  4.2.3
 New Comment:

Numeric type returns invalid result using
ibase_fetch_row/ibase_fetch_object (Windows NT).

Numbers stored as an InterBase/Firebird numeric/decimal datatype
beyond
the bounds of the PHP integer type (> 2147483647), do not return a
float
type but cause an overflow 

Example:
2303511415 (decimal 10,0) returns -1991455881

PHP/Firebird example script:
$sql = "create table temp (large_number numeric(10,0))";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();


$sql = "INSERT INTO temp VALUES (2303511415)";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "SELECT large_number FROM temp WHERE large_number =
2303511415";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

while ($row = ibase_fetch_row($result)) {
   print($row[0]); 
}

ibase_free_result($result);

$sql = "drop table temp";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();


Previous Comments:


[2002-11-26 03:24:19] [EMAIL PROTECTED]

Numeric type returns invalid result using
ibase_fetch_row/ibase_fetch_object (Windows NT).

Numbers stored as an InterBase/Firebird numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), do not return a
float type but cause an overflow 

Example:
2303511415 (decimal 10,0) returns -1991455881

PHP/Firebird example script:
$sql = "create table temp (large_number numeric(10,0))";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "INSERT INTO temp VALUES (2303511415)";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "SELECT large_number FROM temp WHERE large_number =
2303511415";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

while ($row = ibase_fetch_row($result)) {
   print($row[0]); 
}




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

#20641 [NEW]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

2002-11-26 Thread jear

From: [EMAIL PROTECTED]
Operating system: Windows XP / Firebird 1.0
PHP version:  4.2.3
PHP Bug Type: InterBase related
Bug description:  Numeric type returns invalid result using 
ibase_fetch_row/ibase_fetch_object

Numeric type returns invalid result using
ibase_fetch_row/ibase_fetch_object (Windows NT).

Numbers stored as an InterBase/Firebird numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), do not return a float
type but cause an overflow 

Example:
2303511415 (decimal 10,0) returns -1991455881

PHP/Firebird example script:
$sql = "create table temp (large_number numeric(10,0))";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "INSERT INTO temp VALUES (2303511415)";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "SELECT large_number FROM temp WHERE large_number = 2303511415";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

while ($row = ibase_fetch_row($result)) {
   print($row[0]); 
}
-- 
Edit bug report at http://bugs.php.net/?id=20641&edit=1
-- 
Try a CVS snapshot: http://bugs.php.net/fix.php?id=20641&r=trysnapshot
Fixed in CVS:   http://bugs.php.net/fix.php?id=20641&r=fixedcvs
Fixed in release:   http://bugs.php.net/fix.php?id=20641&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=20641&r=needtrace
Try newer version:  http://bugs.php.net/fix.php?id=20641&r=oldversion
Not developer issue:http://bugs.php.net/fix.php?id=20641&r=support
Expected behavior:  http://bugs.php.net/fix.php?id=20641&r=notwrong
Not enough info:http://bugs.php.net/fix.php?id=20641&r=notenoughinfo
Submitted twice:http://bugs.php.net/fix.php?id=20641&r=submittedtwice
register_globals:   http://bugs.php.net/fix.php?id=20641&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20641&r=php3
Daylight Savings:   http://bugs.php.net/fix.php?id=20641&r=dst
IIS Stability:  http://bugs.php.net/fix.php?id=20641&r=isapi

#20641 [Fbk->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

#20641 [Csd->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

#20641 [Fbk->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

#20641 [NoF->Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

#20641 [Opn]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

#20641 [NEW]: Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object

6 matches

Site Navigation

Mail list logo

Footer information