SQLNumResultCol set to 0 for query using common table expression

[the6campbells]

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@...
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

[Hiroshi Inoue]

the6campbells wrote:

> 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@... <mailto:the6campbells@...>
> 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.

Could you please try the drivers on testing for 8.4.0101 at
  http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue

--
Sent via pgsql-odbc mailing list (pgsql-odbc@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc