Re: segfault in SQLSpecialColumns when table name is null string

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Lionel Elie Mamane <lionel(at)mamane(dot)lu>
Cc: Terrence Enger <tenger(at)iseries-guru(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: segfault in SQLSpecialColumns when table name is null string
Date: 2012-07-15 15:50:40
Message-ID: 5002E6D0.6090303@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

(2012/07/15 14:02), Lionel Elie Mamane wrote:
> 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

SQLColattribute returns non null string here under Windows environment.
Well how are you setting odbc.ini?

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Lionel Elie Mamane 2012-07-15 16:40:42 Re: segfault in SQLSpecialColumns when table name is null string
Previous Message Lionel Elie Mamane 2012-07-15 05:02:11 Re: segfault in SQLSpecialColumns when table name is null string