Thread: bug in sqlDescribeCol for the result set returned by a stored procedure

the6campbells wrote:
> Does not seem to matter if the driver has server side prepare, parse etc
> options enabled.

Unfortunately it seems very difficult to detect that the field
is not null.

regards,
Hiroshi Inoue

> 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@gmail.com
> <mailto:the6campbells@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