Re: segfault in SQLSpecialColumns when table name is null string

On Sun, Jul 15, 2012 at 06:50:27AM +0900, Hiroshi Inoue wrote:
> (2012/07/10 23:27), Lionel Elie Mamane wrote:

>>> Working with PostgreSQL version 8.4.12-0ubuntu11.04 and with ODBC
>>> driver versions 1:08.03.0200-1.2 (supplied with ubuntu-natty (11.04))
>>> and pgsqlodbc-09.01.0100 (built locally), I have managed to provoke a
>>> segfault by calling SQLSpecialColumns with a null string for the table
>>> name.  This call is, of course, a strange thing to do, and I cannot
>>> imagine any good result.  Still, a segfault seems a disproportionate
>>> punishment for doing something silly.

>> Also, the ultimate reason for this "strange thing" is that

>>   SQLColAttribute( (SQLHANDLE) 0x1ec7850,
>>                    (SQLUSMALLINT) 1,
>>                    (SQLUSMALLINT) 15,
>>                    (SQLPOINTER) 0x1eb2640,
>>                    128,
>>                    (SQLSMALLINT *) 0x7fffffff97de,
>>                    NULL);

>> where 15 == SQL_DESC_TABLE_NAME == SQL_COLUMN_TABLE_NAME
>> returns (writes at 0x1eb2640) an empty string for this query:

>>   SELECT "Num" "Numero", "data" FROM "foo"."Table1"

> What is your environment e.g. the version of your PG server
> or the version of your psqlodbc?

On Debian GNU/Linux amd64, Debian packages.

Client:
 unixodbc     2.2.14p2-5
 psqlodbc     09.01.0100
 libpq5       9.1.3
Server:
 postgresql   9.0.6


Terrence is getting the same problem with (on Ubunty Natty 11.04):

 unixodbc         2.2.14p2-2ubuntu1
 postgresql       8.4.12-0ubuntu11.04
 odbc-postgresql  1:08.03.0200-1.2

I haven't directly checked that SQLColAttribute returns an empty
string on Terrence's system, but since LibreOffice crashes in the same
conditions, I presume the cause is the same than on my system,
i.e. SQLColAttribute returns an empty string.

--
Lionel