Bug in SQLColumns() and SQLTables() with "Parse Statement".

From: TANIDA Yutaka <tanida(at)sra(dot)co(dot)jp>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Bug in SQLColumns() and SQLTables() with "Parse Statement".
Date: 2003-11-07 08:45:25
Message-ID: 20031107165801.EA8C.TANIDA@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I got a strange result when executing SQLColumns and SQLTables.

1. "Parse Statement" option turns on.
2. Connect to PostgreSQL by ODBC Driver.
3. Execute simple select statement by SQLExecDirect().
4. Execute SQLColumns().
5. Check all columns. It's same as select result of 3.

Attached C program will reproduce this problem .If this option turns on ,
You can see SQLNumResultCols() returns invalid column informations.

Output of "Parse Statement" off.
--
20
20

Output of "Parse Statement" on.
--
20
1

--
TANIDA Yutaka <tanida(at)sra(dot)co(dot)jp>

Attachment Content-Type Size
columns2.c application/octet-stream 1.5 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Theodore Petrosky 2003-11-07 14:14:46 Re: help with OSX make problem
Previous Message Philippe Lang 2003-11-07 07:17:12 Re: Access, pass-through queries and isolation level