Summary
Activity
Forums
Tracker
Lists
Tasks
Docs
Surveys
News
SCM
Files

[#1010318] DataReader.GetSchemaTable() returns incorrect ColumnSize

View Trackers | Feature Requests | Download .csv | Monitor

Date:
2008-03-15 15:32		 Priority:
3
State:
Open
Submitted by:
harry do (harrydo) 		Assigned to:
Nobody (None)
Category:
Group:
Resolution:
None		  
Summary:
DataReader.GetSchemaTable() returns incorrect ColumnSize

Detailed description
DataReader.GetSchemaTable() returns incorrect ColumnSize for column of type ENUM. For example,

The sample pagila database defines

CREATE TYPE mpaa_rating AS ENUM (
'G',
'PG',
'PG-13',
'R',
'NC-17'
);


CREATE TABLE film (
film_id integer DEFAULT nextval('film_film_id_seq'::regclass) NOT NULL,
title character varying(255) NOT NULL,
description text,
release_year year,
language_id smallint NOT NULL,
original_language_id smallint,
rental_duration smallint DEFAULT 3 NOT NULL,
rental_rate numeric(4,2) DEFAULT 4.99 NOT NULL,
length smallint,
replacement_cost numeric(5,2) DEFAULT 19.99 NOT NULL,
rating mpaa_rating DEFAULT 'G'::mpaa_rating,
last_update timestamp without time zone DEFAULT now() NOT NULL,
special_features text[],
fulltext tsvector NOT NULL
);


.Net codes

DataTable schema = myDataReader.GetSchemaTable();
schema.Rows[i]["ColumnSize"] will return 4, it should be 5

Followup

Message
Date: 2008-03-16 03:32
Sender: Josh Cooley

We currently don't support custom types in GetSchemaTable. I'll change this to a FeatureRequest so that we can better track this need.

Attached Files:

Changes:

No Changes Have Been Made to This Item
Powered By FusionForge