SQLNumResultCol set to 0 for query using common table expression -broken again

--20cf301d41c0c6e22804939aee0a
Content-Type: text/plain; charset=ISO-8859-1

Actually, it was not the 9.0 driver doing this but the one which bundled
with the 9.0 windows server release (one click installer from enterprise
db).So the fix in 8.4.0101 was not in that install kit.

SQL_DBMS_NAME=17, 20, "PostgreSQL"
SQL_DBMS_VER=18, 12, "9.0rc1"
SQL_DEFAULT_TXN_ISOLATION=26, 4,
SQL_TXN_READ_COMMITTED = 2
SQL_DESCRIBE_PARAMETER=10002, 2, "N"
SQL_DM_VER=171, 30, "03.52.1132.0000"
SQL_DRIVER_HDBC=3, 4, 0x013C4830
SQL_DRIVER_HDESC=135, 4, 0x013C9728
SQL_DRIVER_HENV=4, 4, 0x013C2940
SQL_DRIVER_HLIB=76, 4, 0x01300000
SQL_DRIVER_HSTMT=5, 4, 0x013C96C0
SQL_DRIVER_NAME=6, 30, "PSQLODBC35W.DLL"
SQL_DRIVER_ODBC_VER=77, 10, "03.51"
SQL_DRIVER_VER=7, 20, "08.04.0200"
vs

SQL_DATABASE_NAME=16, 16, "postgres"
SQL_DBMS_NAME=17, 20, "PostgreSQL"
SQL_DBMS_VER=18, 12, "9.0rc1"
SQL_DEFAULT_TXN_ISOLATION=26, 4,
SQL_TXN_READ_COMMITTED = 2
SQL_DESCRIBE_PARAMETER=10002, 2, "N"
SQL_DM_VER=171, 30, "03.52.1132.0000"
SQL_DRIVER_HDBC=3, 4, 0x014E4930
SQL_DRIVER_HDESC=135, 4, 0x014E95D0
SQL_DRIVER_HENV=4, 4, 0x014E2940
SQL_DRIVER_HLIB=76, 4, 0x01450000
SQL_DRIVER_HSTMT=5, 4, 0x014E9568
SQL_DRIVER_NAME=6, 30, "PSQLODBC35W.DLL"
SQL_DRIVER_ODBC_VER=77, 10, "03.51"
SQL_DRIVER_VER=7, 20, "09.00.0101"

On Wed, Oct 27, 2010 at 8:47 AM, the6campbells <the6campbells [at] gmail.com>wrote:

> This is issue was reported previously and fixed in 8.4.0101 but see it in
> the 9.0 driver.
>
>
> with t_cte ( cte1,cte2,cte3 ) as ( select tset1.rnum, tset1.c1, tset1.c2
> from tset1 ) select * from t_cte
>
>
> SQLPrepare:
> In: StatementHandle = 0x00841B38, StatementText = "with t_cte (
> cte1,cte2,cte3 ) as ( select tset1.rn...", TextLength = 105
> Return: SQL_SUCCESS=0
> SQLNumResultCols:
> In: StatementHandle = 0x00841B38, ColumnCountPtr = 0x00095428
> Return: SQL_SUCCESS=0
> Out: *ColumnCountPtr = 0
>
>
>

--20cf301d41c0c6e22804939aee0a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Actually, it was not the 9.0 driver doing this but the one which bundled wi=
th the 9.0 windows server release (one click installer from enterprise db).=
So the fix in <span style=3D"font-size: 12.5px;">8.4.0101=A0 was not in tha=
t install kit.</span><span style=3D"font-size: 12.5px;"></span> <br>
<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =
=A0=A0=A0 =A0=A0=A0 SQL_DBMS_NAME=3D17, 20, "PostgreSQL"<br>=A0=
=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=
=A0 =A0=A0=A0 SQL_DBMS_VER=3D18, 12, "9.0rc1"<br>=A0=A0=A0 =A0=A0=
=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 S=
QL_DEFAULT_TXN_ISOLATION=3D26, 4, SQL_TXN_READ_COMMITTED =3D 2<br>
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DESCRIBE_PARAMETER=3D10002, 2, "N"<br>=A0=A0=
=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =
=A0=A0=A0 SQL_DM_VER=3D171, 30, "03.52.1132.0000"<br>=A0=A0=A0 =
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 SQL_DRIVER_HDBC=3D3, 4, 0x013C4830<br>
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DRIVER_HDESC=3D135, 4, 0x013C9728<br>=A0=A0=A0 =A0=A0=
=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 S=
QL_DRIVER_HENV=3D4, 4, 0x013C2940<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=
=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_DRIVER_HLIB=3D76,=
4, 0x01300000<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=
=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_DRIVER_HSTMT=3D5, 4, 0x013C96C0<br>
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DRIVER_NAME=3D6, 30, "PSQLODBC35W.DLL"<br>=
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DRIVER_ODBC_VER=3D77, 10, "03.51"<br>=A0=A0=
=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =
=A0=A0=A0 SQL_DRIVER_VER=3D7, 20, "08.04.0200"<br>
vs<br><br> =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 SQL_DATABASE_NAME=3D16, 16, &quo=
t;postgres"<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_DBMS_NAME=3D17, 20, "PostgreS=
QL"<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_DBMS_VER=3D18, 12, "9.0rc1"<br>
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DEFAULT_TXN_ISOLATION=3D26, 4, SQL_TXN_READ_COMMITTED =
=3D 2<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=
=A0 =A0=A0=A0 =A0=A0=A0 SQL_DESCRIBE_PARAMETER=3D10002, 2, "N"<br=
>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DM_VER=3D171, 30, "03.52.1132.0000"<br>
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DRIVER_HDBC=3D3, 4, 0x014E4930<br>=A0=A0=A0 =A0=A0=A0 =
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_D=
RIVER_HDESC=3D135, 4, 0x014E95D0<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0=
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_DRIVER_HENV=3D4, 4, =
0x014E2940<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_DRIVER_HLIB=3D76, 4, 0x01450000<br>
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DRIVER_HSTMT=3D5, 4, 0x014E9568<br>=A0=A0=A0 =A0=A0=A0=
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_=
DRIVER_NAME=3D6, 30, "PSQLODBC35W.DLL"<br>=A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 SQL_DRIV=
ER_ODBC_VER=3D77, 10, "03.51"<br>
=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=
=A0=A0 =A0=A0=A0 SQL_DRIVER_VER=3D7, 20, "09.00.0101"<br><br><br>=
<br><br><div class=3D"gmail_quote">On Wed, Oct 27, 2010 at 8:47 AM, the6cam=
pbells <span dir=3D"ltr"><<a href=3D"mailto:the6campbells [at] gmail.com">the=
6campbells [at] gmail.com</a>></span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div style=3D"bor=
der-collapse: collapse; font-family: arial,sans-serif; font-size: 12.5px;">=
<span style=3D"font-family: arial,sans-serif; font-size: 12.5px; border-col=
lapse: collapse;">This is issue was reported previously and fixed in=A0</sp=
an><span style=3D"font-size: 12.5px;">8.4.0101 but see it in the 9.0 driver=
..</span></div>

<div style=3D"border-collapse: collapse; font-family: arial,sans-serif; fon=
t-size: 12.5px;"><span style=3D"font-size: 12.5px;"><br></span></div><div s=
tyle=3D"border-collapse: collapse; font-family: arial,sans-serif; font-size=
: 12.5px;">

<span style=3D"font-size: 12.5px;"><br></span></div><div><font size=3D"4" f=
ace=3D"arial, sans-serif"><span style=3D"border-collapse: collapse; font-si=
ze: 15px;">with t_cte ( cte1,cte2,cte3 ) as ( select tset1.rnum, tset1.c1, =
tset1.c2 from tset1 ) select * from t_cte</span></font></div>

<div><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"border-coll=
apse: collapse; font-size: 15px;"><br></span></font></div><div style=3D"bor=
der-collapse: collapse; font-family: arial,sans-serif; font-size: 12.5px;">
<span style=3D"font-size: 12.5px;"><br></span></div><div><div><font size=3D=
"4" face=3D"arial, sans-serif"><span style=3D"border-collapse: collapse; fo=
nt-size: 15px;">SQLPrepare:</span></font></div>
<div><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"border-coll=
apse: collapse; font-size: 15px;">In:<span style=3D"white-space: pre-wrap;"=
> </span>StatementHandle =3D 0x00841B38, StatementText =3D "with t_=
cte ( cte1,cte2,cte3 ) as ( select tset1.rn...", TextLength =3D 105</s=
pan></font></div>

<div><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"border-coll=
apse: collapse; font-size: 15px;">Return:<span style=3D"white-space: pre-wr=
ap;"> </span>SQL_SUCCESS=3D0</span></font></div>
<div><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"border-coll=
apse: collapse; font-size: 15px;">SQLNumResultCols:</span></font></div><div=
><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"border-collapse=
: collapse; font-size: 15px;">In:<span style=3D"white-space: pre-wrap;"> =
</span>StatementHandle =3D 0x00841B38, ColumnCountPtr =3D 0x00095428</span=
></font></div>

<div><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"border-coll=
apse: collapse; font-size: 15px;">Return:<span style=3D"white-space: pre-wr=
ap;"> </span>SQL_SUCCESS=3D0</span></font></div>
<div><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"border-coll=
apse: collapse; font-size: 15px;">Out:<span style=3D"white-space: pre-wrap;=
"> </span>*ColumnCountPtr =3D 0</span></font></div>
</div><div><font size=3D"4" face=3D"arial, sans-serif"><span style=3D"borde=
r-collapse: collapse; font-size: 15px;"><br></span></font></div><div style=
=3D"border-collapse: collapse; font-family: arial,sans-serif; font-size: 12=
..5px;">

<span style=3D"font-size: 12.5px;"><br></span></div><font size=3D"3" face=
=3D"arial, sans-serif"><span style=3D"border-collapse: collapse; font-size:=
12.5px;">=A0</span></font>
</blockquote></div><br>

--20cf301d41c0c6e22804939aee0a--

SQLNumResultCol set to 0 for query using common table expression -broken again

Re: SQLNumResultCol set to 0 for query using common table expression- broken again