Skip site navigation (1) Skip section navigation (2)

BUG #5091: sqlDescribeCol incorrectly setting null flag for projection of a view

From: "the6campbells" <the6campbells(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5091: sqlDescribeCol incorrectly setting null flag for projection of a view
Date: 2009-09-30 12:49:13
Message-ID: 200909301249.n8UCnDFN059930@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5091
Logged by:          the6campbells
Email address:      the6campbells(at)gmail(dot)com
PostgreSQL version: 8.4.1
Operating system:   windows
Description:        sqlDescribeCol incorrectly setting null flag for
projection of a view
Details: 

A basic table is described where one column has a null constraint: create
table TNUM( RNUM integer not null, CNUM numeric(7,2)  )

A simple view is defined that projects all the columns of said table: create
view VNUM as select * from TNUM

A query which projects the columns of the table or the view will return
inconsistent null flags when you call sqlDescribeCol after sqlPrepare

Does not matter if you have parse, server side prepare etc enabled/disabled.


Looks like another bug to me. 

SQL_DRIVER_NAME=6, 30, "PSQLODBC35W.DLL"
SQL_DRIVER_ODBC_VER=77, 10, "03.51"
SQL_DRIVER_VER=7, 20, "08.04.0100"


Describe Column All: 
icol, szColName, *pcbColName, *pfSqlType, *pcbColDef, *pibScale, *pfNullable

1, rnum, 4, SQL_INTEGER=4, 10, 0, SQL_NO_NULLS=0 
2, cnum, 4, SQL_NUMERIC=2, 7, 2, SQL_NULLABLE=1 

Describe Column All: 
icol, szColName, *pcbColName, *pfSqlType, *pcbColDef, *pibScale, *pfNullable

1, rnum, 4, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1 
2, cnum, 4, SQL_NUMERIC=2, 7, 2, SQL_NULLABLE=1

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-09-30 13:58:11
Subject: Re: Weird behaviour of = ANY ( SUBQUERY ) ?
Previous:From: EdineiDate: 2009-09-30 11:11:50
Subject: BUG #5090: erro

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group