Your message dated Wed, 29 Mar 2006 22:40:23 -0800
with message-id <[EMAIL PROTECTED]>
and subject line Bug#246166: libct1: Problems with IF in queries in new version 
of freetds
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--- Begin Message ---
Package: libct1
Version: 0.61-5
Severity: important

I have a problem with queries using IF's with libct1 0.61-5.
It works properly with an older version of freetds, when the
name of the package was freetds (freetds 0.53-7).

The main problem is that I can't keep using the old version because PHP
is linked with the new version.

### Normal query:
$rs=mssql_query('select 1',$connection);
var_dump($rs);

This prints:
resource(7) of type (sybase-ct result)

### Query with IF's:
$rs=mssql_query('if (EXISTS (select 1)) select 2 else select 0',$connection);
var_dump($rs);

This prints:
bool(true)

As you can see, instead of a proper reource id, the library returned the
boolean value 'true'. Of course trying to fetch data from that resource
doesn't work.

In the non-updated machine with php-sybase and freetds0 (freetds 0.53-7)
and all this queries work well (They return a valid result resource and
the data can be retrieved).

-- System Information
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux colibri 2.4.18-686 #1 Sun Apr 14 11:32:47 EST 2002 i686
Locale: LANG=C, LC_CTYPE=C

Versions of packages libct1 depends on:
ii  debconf                     1.2.34       Debian configuration management sy
ii  libc6                       2.3.2.ds1-10 GNU C Library: Shared libraries an
ii  odbcinst1                   2.2.4-6      Support library and helper program



--- End Message ---
--- Begin Message ---
Version: 0.61-6.2

On Tue, Apr 27, 2004 at 06:20:15PM +0200, [EMAIL PROTECTED] wrote:
> Package: libct1
> Version: 0.61-5
> Severity: important

> I have a problem with queries using IF's with libct1 0.61-5.
> It works properly with an older version of freetds, when the
> name of the package was freetds (freetds 0.53-7).

> The main problem is that I can't keep using the old version because PHP
> is linked with the new version.

> ### Normal query:
> $rs=mssql_query('select 1',$connection);
> var_dump($rs);

> This prints:
> resource(7) of type (sybase-ct result)

> ### Query with IF's:
> $rs=mssql_query('if (EXISTS (select 1)) select 2 else select 0',$connection);
> var_dump($rs);

> This prints:
> bool(true)

> As you can see, instead of a proper reource id, the library returned the
> boolean value 'true'. Of course trying to fetch data from that resource
> doesn't work.

> In the non-updated machine with php-sybase and freetds0 (freetds 0.53-7)
> and all this queries work well (They return a valid result resource and
> the data can be retrieved).

FWIW, I'm not able to reproduce this error with the sarge versions of libct1
and php4-sybase.  Perhaps this was the same bug as 260261; either way, I
guess the bug can be closed now.

Thanks,
-- 
Steve Langasek                   Give me a lever long enough and a Free OS
Debian Developer                   to set it on, and I can move the world.
[EMAIL PROTECTED]                                   http://www.debian.org/

Attachment: signature.asc
Description: Digital signature


--- End Message ---

Reply via email to