SQL_DATA_AT_EXEC processing broken for large objects in nightly git

From: Vadym Krevs <vkrevs(at)serena(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQL_DATA_AT_EXEC processing broken for large objects in nightly git
Date: 2015-10-15 12:00:14
Message-ID: 561F954E.7020808@serena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

the nightly git of the psqlODBC driver appears to no longer support
insertion into LO columns when using SQL_DATA_AT_EXEC mode. The latest
released driver version - psqlodbc-09.03.0400 - works. I've tested this
against both PostgreSQL 9.4.4 and 9.4.5 on openSUSE 13.2.

An adapted variant of the large-object-test.c program that uses
SQL_DATA_AT_EXEC mode is attached. When run as part of the regression
test suite against psqlodbc-09.03.0400, both the
large-object-data-at-exec-test.c test completes successfully, just like
large-object-test.c, and produces the following output in
test/results/large-object-data-at-exec.out:

\! "./src/large-object-data-at-exec-test"
connected
inserting large object...
reading it back...
hex: 0102030405060708
disconnecting

However, when run as part of the regression test suite against nightly
git build of psqlodbc, the large-object-data-at-exec-test.c test fails,
unlike large-object-test.c, and produces the following output in
test/results/large-object-data-at-exec.out:

connected
inserting large object...
SQLParamData failed (final call)
HY000=unexpected NULL parameter value

Regards,
Vadym

Attachment Content-Type Size
large-object-data-at-exec-test.c text/x-csrc 3.6 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message PSequel Support 2015-10-25 01:20:20 Regression in SQLGetDiagField
Previous Message david.paulo 2015-10-07 05:47:07 Re: ODBC problem with Microsoft Word and Excel