[BUGS] BUG #5056: SQLDescribeColW for function returning a result set incorrectly setting sql_nullable

2009-09-14 Thread the6campbells 

The following bug has been logged online:

Bug reference:  5056
Logged by:  the6campbells
Email address:  the6campbe...@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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5056: SQLDescribeColW for function returning a result set incorrectly setting sql_nullable

2009-09-14 Thread Robert Haas 
On Mon, Sep 14, 2009 at 10:40 PM, the6campbells the6campbe...@gmail.com wrote:

 The following bug has been logged online:

 Bug reference:      5056
 Logged by:          the6campbells
 Email address:      the6campbe...@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

I think you may want to try here, for both this and your previous bug report.

pgsql-o...@postgresql.org
http://archives.postgresql.org/pgsql-odbc/

...Robert

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs