From: | Lionel Elie Mamane <lionel(at)mamane(dot)lu> |
---|---|
To: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
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 05:02:11 |
Message-ID: | 20120715050211.GA4207@capsaicin.mamane.lu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2012-07-15 15:50:40 | Re: segfault in SQLSpecialColumns when table name is null string |
Previous Message | Hiroshi Inoue | 2012-07-14 21:50:27 | Re: segfault in SQLSpecialColumns when table name is null string |