--00c09f9057891acd700473c4e500
Content-Type: text/plain; charset=ISO-8859-1
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.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
--00c09f9057891acd700473c4e500
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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.<=
div><br><div><span class=3D"Apple-style-span" style=3D"font-family: verdana=
; font-size: 11px; "><pre style=3D"font-family: monospace; font-size: 1.2em=
; word-wrap: break-word; ">
Bug reference: 5051
Logged by: the6campbells
Email address: <a href=3D"mailto:the6campbells [at] gmail.com">the6campbell=
s [at] gmail.com</a>
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". Us=
ing 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 =3D 0x00841B10, StatementText =3D "with t_cte ( cte=
1, cte2 )
as ( select tset1.c1, ts...", TextLength =3D 88
Return: SQL_SUCCESS=3D0
SQLNumResultCols:
In:StatementHandle =3D 0x00841B10, ColumnCountPtr =3D 0x0009ED90
Return: SQL_SUCCESS=3D0
Out:*ColumnCountPtr =3D 0</pre></span></div></div>
--00c09f9057891acd700473c4e500--
