sqlDescribeCol not setting null flag correctly for sqlDescribeCol

From: the6campbells <the6campbells(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: sqlDescribeCol not setting null flag correctly for sqlDescribeCol
Date: 2009-09-29 15:25:07
Message-ID: 22431f1b0909290825o42e55baahe3d514ad1f918867@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Ramon Discua 2009-09-29 19:19:33 cannot find pg_hba.conf file
Previous Message Fred Parkinson 2009-09-28 18:33:01 Re: Error installing ODBC driver: answer