#26407 [Opn->Csd]: Result set fetching broken around transactions (OpenClient Error #155)

From: Date: Sun, 15 Feb 2004 10:50:38 +0000
Subject: #26407 [Opn->Csd]: Result set fetching broken around transactions (OpenClient Error #155)
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-54931@lists.php.net to get a copy of this message
 ID:               26407
 Updated by:       thekid@php.net
 Reported By:      tvoigt at informatik dot tu-cottbus dot de
-Status:           Open
+Status:           Closed
 Bug Type:         Sybase-ct (ctlib) related
 Operating System: Linux (i686) & Solaris 8
 PHP Version:      4CVS, 5CVS
 New Comment:

This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.

And yes, this patch should make it into PHP 4.3.5.


Previous Comments:
------------------------------------------------------------------------

[2004-02-11 05:42:51] tvoigt at informatik dot tu-cottbus dot de

Hi there!

Just applied your patch to a current snapshot
(php4-STABLE-200402110830) and it works great! A brief test flight
through our various Sybase applications completed without a hassle, so
I consider that one done.

Will this patch make it into PHP-4.3.5?

Thanks again and best regards,
Thomas

------------------------------------------------------------------------

[2004-02-08 19:03:45] thekid@php.net

Please see if the following patches work for you:

* http://sitten-polizei.de/bug26407.diff 
  (patch for CVS head - PHP5)
* http://sitten-polizei.de/bug26407.4.diff 
  (patch for Snapshot/4_3 branch)

make test TEST=ext/sybase_ct is passed now with Sybase-libraries as
well as with FreeTDS(download the new test.inc, it contains a fix for
the "Sybase: Unable to update character set" warning).

Please make sure I didn't break anything else.

------------------------------------------------------------------------

[2004-02-08 18:02:53] thekid@php.net

Have been able to reproduce w/ Debian and Sybase-Libraries.

Bug was introduced when the patch in
http://bugs.php.net/bug.php?id=23682 was
committed.

Am looking into a workaround.

------------------------------------------------------------------------

[2004-02-08 17:20:39] thekid@php.net

4.3.3 doesn't work as expected either. I took your output and diffed it
against the expected one:

thekid@friebes:~ > diff -u sybase_test_expected.out
sybase_test_4_3_3.out
--- sybase_test_expected.out    Sun Feb  8 23:21:15 2004
+++ sybase_test_4_3_3.out       Sun Feb  8 23:20:12 2004
@@ -1,3 +1,4 @@
+Warning: sybase_connect(): Sybase: Unable to update character set. in
/usr/src/php-4.3.3/                 tests/ext/sybase_ct/test.inc on
line 55
 bool(true)
 >>> Query: 
     begin transaction
@@ -7,14 +8,8 @@
     commit
     -- anything afterwards will fail, too
   
-<<< Return: resource
-array(1) {
-  [0]=>
-  array(1) {
-    ["computed"]=>
-    string(3) "foo"
-  }
-}
+<<< Return: boolean
+bool(true)
 >>> Query: 
     begin transaction
       -- no result returned...
@@ -31,7 +26,7 @@
     select "bar"   
   
 
-Notice: sybase_query(): Sybase:  Unexpected results, cancelling
current in %s/test.inc on                  line %d
+Notice: sybase_query(): Sybase:  Unexpected results, cancelling
current in /usr/src/php-4                
.3.3/tests/ext/sybase_ct/test.inc on line 66
 <<< Return: resource
 array(1) {
   [0]=>


------------------------------------------------------------------------

[2004-02-06 03:27:28] detoma dot alessandro at sea-aeroportimilano dot
it

Unfortunatly I don't know to help you, because I have a problem similar
to your(failure to compile PHP4.3.4 with sybase 12.0).
I notice however that you have compiled PHP4.3.4 with gdlib on
solaris8; Could you say me which version you have used? 
Best regards,
Alex

------------------------------------------------------------------------

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

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


Thread (19 messages)

« previous php.bugs (#54931) next »