[php-maint] Bug#431044: Bug#431044: Bug#431044: Apache child exits on sql server functions

[Steve Langasek]

Hi Walter,

On Sat, Sep 29, 2007 at 12:09:32PM +0200, Walter Doekes wrote:

> Hi debian folk.

> > It's possible that the problem is also specific to tables containing
> > non-ASCII data.  You mentioned that the problem was not reproducible
> > for you when using sqsh; could you also provide a sample result set
> > for a query that succeeds with sqsh and fails with php5-sybase?

> I don't think it's the same bug, but it's really close.
> Please take a look at this one:
> http://bugs.php.net/bug.php?id=33693
> If also concerns sybase-ct and iconv.

> See this sample script connecting to a MS SQL server:

> <?php
> putenv('TDSVER=7.0');
> $db = sybase_connect($server, $username, $password);
> sybase_select_db('MODULES', $db);
> sybase_query("DROP TABLE test_tbl");
> sybase_query("CREATE TABLE test_tbl
>   (a INT, b NVARCHAR(255), c UNIQUEIDENTIFIER)");
> sybase_query("INSERT INTO test_tbl VALUES
>   (1, N'Hello World', NEWID())");
> if (($q1 = sybase_query("SELECT a, b FROM test_tbl")))
>         print_r(sybase_fetch_row($q1));
> if (($q2 = sybase_query("SELECT a, b, c FROM test_tbl")))
>         print_r(sybase_fetch_row($q2));
> ?>

> This outputs:

> Array
> (
>     [0] => 1
>     [1] => Hello World
> )
> error_handler: Data-conversion resulted in overflow.
> Segmentation fault

Is this problem reproducible for you with the php5-sybase package in
unstable, which is now based on the mssql extension rather than the
sybase-ct extension?  I wasn't able to reproduce it here.

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