#35945 [Opn->Fbk]: sybase_query() fails on AMD64

From: Date: Mon, 09 Jan 2006 17:18:21 +0000
Subject: #35945 [Opn->Fbk]: sybase_query() fails on AMD64
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-91691@lists.php.net to get a copy of this message 
 ID:               35945
 Updated by:       sniper@php.net
 Reported By:      dbaffaleuf at ixis-cib dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         Sybase-ct (ctlib) related
 Operating System: Linux 2.6.9-22 RedHat AMD64
 PHP Version:      4.4.2RC2
 New Comment:

Please try using this CVS snapshot:

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

There is no real 64bit support in PHP 4. It came with PHP 5..


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

[2006-01-09 16:17:45] dbaffaleuf at ixis-cib dot com

Description:
------------
Acutally I have the problem both in PHP 4.4.1 and 4.4.2RC3


Always returns a correct resource id for the handler, but FALSE for the
query (see the following code)

The Sybase OpenClient warning code suggest an overflow in the
CS_DATAFMT.maxlength C struct. When returning, the datalength is sized
whether the type is CS_NUMERIC, CS_MONEY, etc... in the
php_sybase_fetch_result_set() fonction (src: php_sybase_ct.c). 

Works fine in DB-LIB.

The configure :

./configure     \
       
--prefix=/msmorzine/sgbd/contrib/src/php4-STABLE-200601091335/MKTEST   
\
       
--with-sybase-ct=/msmorzine/sgbd/MX_MT_MSMORZINE/ASE1253/OCS-12_5/devlib
\
        --enable-static=sybase-ct \
       
--with-config-file-path=/msmorzine/sgbd/contrib/src/php4-STABLE-200601091335/MKTEST
\
        --with-apxs2=/msmorzine/sgbd/contrib/bin/apxs   \
        --with-gd=/msmorzine/sgbd/contrib/ \
        --enable-sysvmsg \
        --enable-sysvsem \
        --enable-sysvshm



Reproduce code:
---------------
The following code:

$STR    = "select name from syslogins";
$DBH    = @sybase_connect("MX_MT_MSMORZINE","sa", "mypassword");
$QUERY  = sybase_query($STR,$DBH);
var_dump($DBH);
var_dump($QUERY);

while($row = sybase_fetch_row($QUERY)) {
    while(list($k, $v) = each($row)) {
        echo "\$row[$k] => $v\n";
    }
}


Expected result:
----------------
int(4)
int(5)
$row[0] => probe
$row[0] => sa


Actual result:
--------------
"Warning: sybase_query(): Sybase:  Client message:  (): user api layer:
internal common library error: The bind of result set item 1 resulted in
truncation. (severity 116) in
/msmorzine/sgbd/contrib/src/php4-STABLE-200601091335/MKTEST/bin/test_sybase_ct.php
on line 5
resource(4) of type (sybase-ct link)
bool(false)".



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


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

Thread (10 messages)

« previous php.bugs (#91691) next »