buffer overflow in 08.04.0100 und 08.04.0200?

Hello,

we ran into a problem with the new versions of psqlODBC (08.04.0100 and
08.04.0200), which causes a crash.
For example one of our functions that dynamically generates queries does
a 'RAISE NOTICE' of the query string before executing it. Sometimes this
string gets very long and the driver crashes. In the CommLog the string
is cut. The limit seems to be 4095. It somehow seems to be connected to
the global socket size which obviously is 4096?
However, it's strange that 8.3.400 is not crashing although the string
seems to be truncated as well.

We checked it with a function that is simply 'raise noticing' a string
longer than 4100 characters/bytes.

-------------------------------------
CREATE OR REPLACE FUNCTION teststringlength() RETURNS CHAR AS

$BODY$

DECLARE
BEGIN

RAISE NOTICE ' ... more than about 4100 characters ...';

RETURN 'Success';

END;
$BODY$

LANGUAGE 'plpgsql' VOLATILE;
-----------------------------------------------

It gets executed with 'SELECT teststringlength();' within a
psqlODBC-connection that uses the same ODBC data source as the other
psqlODBC-Version. In 08.04.0100 and 08.04.0200 it crashes ... in 8.3.400
it doesn't.
Is there maybe a new parameter that is missing, because we reused the
old data source (I'll check tomorrow)?

Thank you very much for any hints,

Peter

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: buffer overflow in 08.04.0100 und 08.04.0200?

Hi,

Could you send me directly the Mylog output?

regards,
Hiroshi Inoue

Jan-Peter Seifert wrote:
> Hello,
>
> we ran into a problem with the new versions of psqlODBC (08.04.0100 and
> 08.04.0200), which causes a crash.
> For example one of our functions that dynamically generates queries does
> a 'RAISE NOTICE' of the query string before executing it. Sometimes this
> string gets very long and the driver crashes. In the CommLog the string
> is cut. The limit seems to be 4095. It somehow seems to be connected to
> the global socket size which obviously is 4096?
> However, it's strange that 8.3.400 is not crashing although the string
> seems to be truncated as well.
>
> We checked it with a function that is simply 'raise noticing' a string
> longer than 4100 characters/bytes.
>
> -------------------------------------
> CREATE OR REPLACE FUNCTION teststringlength() RETURNS CHAR AS
>
> $BODY$
>
> DECLARE
> BEGIN
>
> RAISE NOTICE ' ... more than about 4100 characters ...';
>
> RETURN 'Success';
>
> END;
> $BODY$
>
> LANGUAGE 'plpgsql' VOLATILE;
> -----------------------------------------------
>
> It gets executed with 'SELECT teststringlength();' within a
> psqlODBC-connection that uses the same ODBC data source as the other
> psqlODBC-Version. In 08.04.0100 and 08.04.0200 it crashes ... in 8.3.400
> it doesn't.
> Is there maybe a new parameter that is missing, because we reused the
> old data source (I'll check tomorrow)?
>
> Thank you very much for any hints,
>
> Peter


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc