SQLNumResultCol set to 0 for query using common table expression -broken again
am 27.10.2010 14:47:33 von the6campbells
--20cf301d41c017d5ac049398a1ec
Content-Type: text/plain; charset=ISO-8859-1
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
--20cf301d41c017d5ac049398a1ec
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
nt-size: 12.5px; ">
rial, sans-serif; font-size: 12.5px; border-collapse: collapse; ">This is i=
ssue was reported previously and fixed in=A0
le-span" style=3D"font-size: 12.5px; ">8.4.0101 but see it in the 9.0 drive=
r.
nt-size: 12.5px; ">
5px; ">
y: arial, sans-serif; font-size: 12.5px; ">
<=
/div>
=3D"4">
font-size: 15px;">with t_cte ( cte1,cte2,cte3 ) as ( select tset1.rnum, ts=
et1.c1, tset1.c2 from tset1 ) select * from t_cte
>
size: 15px;">
e; font-family: arial, sans-serif; font-size: 12.5px; ">
<=
/div>
size=3D"4">
pse; font-size: 15px;">SQLPrepare:
>
size: 15px;">In: =
StatementHandle =3D 0x00841B38, StatementText =3D "with t_cte=
( cte1,cte2,cte3 ) as ( select tset1.rn...", TextLength =3D 105
>
>
size: 15px;">Return:
"> SQL_SUCCESS=3D0
>
size: 15px;">SQLNumResultCols:
-style-span" face=3D"arial, sans-serif" size=3D"4">
le-span" style=3D"border-collapse: collapse; font-size: 15px;">In:
ss=3D"Apple-tab-span" style=3D"white-space:pre"> StatementHandle =
=3D 0x00841B38, ColumnCountPtr =3D 0x00095428
>
size: 15px;">Return:
"> SQL_SUCCESS=3D0
>
size: 15px;">Out:
"> *ColumnCountPtr =3D 0
=3D"4">
font-size: 15px;">
ollapse; font-family: arial, sans-serif; font-size: 12.5px; ">
<=
/div>
>
size: 12.5px;">=A0
--20cf301d41c017d5ac049398a1ec--
Re: SQLNumResultCol set to 0 for query using common table expression- broken again
am 27.10.2010 17:32:27 von the6campbells
--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 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 8.4.0101=A0 was not in tha=
t install kit.
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 SQL_DBMS_NAME=3D17, 20, "PostgreSQL"
=A0=
=A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 SQL_DBMS_VER=3D18, 12, "9.0rc1"
=A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 S=
QL_DEFAULT_TXN_ISOLATION=3D26, 4, SQL_TXN_READ_COMMITTED =3D 2
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DESCRIBE_PARAMETER=3D10002, 2, "N"
=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 SQL_DM_VER=3D171, 30, "03.52.1132.0000"
=A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
SQL_DRIVER_HDBC=3D3, 4, 0x013C4830
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DRIVER_HDESC=3D135, 4, 0x013C9728
=A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 S=
QL_DRIVER_HENV=3D4, 4, 0x013C2940
=A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 SQL_DRIVER_HLIB=3D76,=
4, 0x01300000
=A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 SQL_DRIVER_HSTMT=3D5, 4, 0x013C96C0
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DRIVER_NAME=3D6, 30, "PSQLODBC35W.DLL"
=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DRIVER_ODBC_VER=3D77, 10, "03.51"
=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 SQL_DRIVER_VER=3D7, 20, "08.04.0200"
vs
=A0=
SQL_DATABASE_NAME=3D16, 16, &quo=
t;postgres"
=A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 =A0 SQL_DBMS_NAME=3D17, 20, "PostgreS=
QL"
=A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 SQL_DBMS_VER=3D18, 12, "9.0rc1"
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DEFAULT_TXN_ISOLATION=3D26, 4, SQL_TXN_READ_COMMITTED =
=3D 2
=A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 SQL_DESCRIBE_PARAMETER=3D10002, 2, "N"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DM_VER=3D171, 30, "03.52.1132.0000"
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DRIVER_HDBC=3D3, 4, 0x014E4930
=A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 SQL_D=
RIVER_HDESC=3D135, 4, 0x014E95D0
=A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A0 =A0 SQL_DRIVER_HENV=3D4, 4, =
0x014E2940
=A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 SQL_DRIVER_HLIB=3D76, 4, 0x01450000
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DRIVER_HSTMT=3D5, 4, 0x014E9568
=A0 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 SQL_=
DRIVER_NAME=3D6, 30, "PSQLODBC35W.DLL"
=A0 =A0 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 SQL_DRIV=
ER_ODBC_VER=3D77, 10, "03.51"
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 SQL_DRIVER_VER=3D7, 20, "09.00.0101"
=
On Wed, Oct 27, 2010 at 8:47 AM, the6cam=
pbells
<the=
6campbells@gmail.com> wrote:
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
der-collapse: collapse; font-family: arial,sans-serif; font-size: 12.5px;">=
lapse: collapse;">This is issue was reported previously and fixed in=A0
an>
8.4.0101 but see it in the 9.0 driver=
..
t-size: 12.5px;">
tyle=3D"border-collapse: collapse; font-family: arial,sans-serif; font-size=
: 12.5px;">
ace=3D"arial, sans-serif">
ze: 15px;">with t_cte ( cte1,cte2,cte3 ) as ( select tset1.rnum, tset1.c1, =
tset1.c2 from tset1 ) select * from t_cte
apse: collapse; font-size: 15px;">
der-collapse: collapse; font-family: arial,sans-serif; font-size: 12.5px;">
"4" face=3D"arial, sans-serif">
nt-size: 15px;">SQLPrepare:
apse: collapse; font-size: 15px;">In:
> StatementHandle =3D 0x00841B38, StatementText =3D "with t_=
cte ( cte1,cte2,cte3 ) as ( select tset1.rn...", TextLength =3D 105
pan>
apse: collapse; font-size: 15px;">Return:
ap;"> SQL_SUCCESS=3D0
apse: collapse; font-size: 15px;">SQLNumResultCols:
>
: collapse; font-size: 15px;">In: =
StatementHandle =3D 0x00841B38, ColumnCountPtr =3D 0x00095428
>
apse: collapse; font-size: 15px;">Return:
ap;"> SQL_SUCCESS=3D0
apse: collapse; font-size: 15px;">Out:
"> *ColumnCountPtr =3D 0
r-collapse: collapse; font-size: 15px;">
=3D"border-collapse: collapse; font-family: arial,sans-serif; font-size: 12=
..5px;">
=3D"arial, sans-serif">
12.5px;">=A0
--20cf301d41c0c6e22804939aee0a--