--001636832a6c68a2250473c4ddb6
Content-Type: text/plain; charset=ISO-8859-1
Does not seem to matter if the driver has server side prepare, parse etc
options enabled.
Would someone also confirm if raising bugs via the web page on the postgres
web site is also for ODBC, JDBC etc issues or not.
> Bug reference: 5056
> Logged by: the6campbells
> Email address: the6campbells [at] gmail.com
> PostgreSQL version: 8.4.1
> Operating system: windows
> Description: SQLDescribeColW for function returning a result set
> incorrectly setting sql_nullable
> Details:
>
> create table TSET1 (RNUM integer not null, C1 integer, C2 char(3));
>
> create function PRES ( )
> returns setof TSET1 as
> '
> select RNUM, C1, C2 from TSET1;
> ' LANGUAGE 'sql'
> ;
>
> in ODBC test sqlPrepare { call pres } then describe the columns. first
> column should be SQL_NO_NULLS not NULLABLE.
>
> Describe Column All:
> icol, szColName,
*pcbColName, *pfSqlType, *pcbColDef, *pibScale,
> *pfNullable
>
1, rnum, 4, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>
2, c1, 2, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>
3, c2, 2, SQL_WCHAR=-8, 3, 0, SQL_NULLABLE=1
--001636832a6c68a2250473c4ddb6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<span class=3D"Apple-style-span" style=3D"border-collapse: collapse; "><div=
>Does not seem to matter if the driver has server side prepare, parse etc o=
ptions enabled.=A0</div><div><br></div><div>Would someone also confirm if r=
aising bugs via the web page on the postgres web site is also for ODBC, JDB=
C etc issues or not.</div>
<div><br></div><div><br></div>> Bug reference: =A0 =A0 =A05056<br>> L=
ogged by: =A0 =A0 =A0 =A0 =A0the6campbells<br>> Email address: =A0 =A0 =
=A0<a href=3D"mailto:the6campbells [at] gmail.com" style=3D"color: rgb(237, 28, =
36); ">the6campbells [at] gmail.com</a><br>
> PostgreSQL version: 8.4.1<br>> Operating system: =A0 windows<br>>=
; Description: =A0 =A0 =A0 =A0SQLDescribeColW for function returning a resu=
lt set<br>> incorrectly setting sql_nullable<br>> Details:<br>><br=
>> create table TSET1 (RNUM integer not null, C1 integer, C2 char(3));<b=
r>
><br>> create function PRES ( )<br>> returns setof TSET1 as<br>>=
; '<br>> =A0select RNUM, C1, C2 from TSET1;<br>> ' =A0LANGUAG=
E 'sql'<br>> ;<br>><br>> in ODBC test sqlPrepare { call pr=
es } then describe the columns. first<br>
> column should be SQL_NO_NULLS not NULLABLE.<br>><br>> Describe C=
olumn All:<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 =A0icol, szColName, *pc=
bColName, *pfSqlType, *pcbColDef, *pibScale,<br>> *pfNullable<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 =A0=
=A0 =A0 =A0 =A01, rnum, 4, SQL_INTEGER=3D4, 10, 0, SQL_NULLABLE=3D1<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 =A0 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A02, c1, 2, SQL_INTEGER=3D4, 10, 0, SQL_NULLABLE=
=3D1<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 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A03, c2, 2, SQL_WCHAR=3D-8, 3, 0, SQL_NULLABL=
E=3D1</span><div><span class=3D"Apple-style-span" style=3D"border-collapse:=
collapse;"><br></span></div>
--001636832a6c68a2250473c4ddb6--
