SQLNumResultCol set to 0 for query using common table expression

From: the6campbells <the6campbells(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLNumResultCol set to 0 for query using common table expression
Date: 2009-09-17 12:10:01
Message-ID: 22431f1b0909170510p62155321i7b982b18afbd7e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Similar to my previous post, if someone can confirm if the web page on the
postgres site to report bugs includes ODBC/JDBC that would be appreciated.

Bug reference: 5051
Logged by: the6campbells
Email address: the6campbells(at)gmail(dot)com
PostgreSQL version: 8.4.1
Operating system: windows
Description: SQLNumResultCols returns 0 for common table expression
Details:

"PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit". Using 8.4.0.1
UNICODE ODBC driver.

sqlnumresultcols returns 0 for queries using common table expression.

create table TSET1 (RNUM integer not null, C1 integer, C2 char(3));

using odbctest

sqlPrepare
with t_cte ( cte1, cte2 ) as ( select tset1.c1, tset1.c2 from tset1 )select
* from t_cte

SQLPrepare:
In:StatementHandle = 0x00841B10, StatementText = "with t_cte ( cte1, cte2 )
as ( select tset1.c1, ts...", TextLength = 88
Return: SQL_SUCCESS=0

SQLNumResultCols:
In:StatementHandle = 0x00841B10, ColumnCountPtr = 0x0009ED90
Return: SQL_SUCCESS=0
Out:*ColumnCountPtr = 0

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Lane 2009-09-17 14:14:29 Re: "No response from the backend" error while connecting to postgres db
Previous Message the6campbells 2009-09-17 12:07:52 bug in sqlDescribeCol for the result set returned by a stored procedure