Thread: SQLNumResultCol set to 0 for query using common table expression
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@gmail.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
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@gmail.com <mailto:the6campbells@gmail.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. Could you please try the drivers on testing for 8.4.0101 at http://www.geocities.jp/inocchichichi/psqlodbc/index.html ? regards, Hiroshi Inoue