tracker issue : CF-3745969

select a category, or use search below
(searches all categories and all time range)
Title:

Include is_virtual in cfinfo.columns resultset

| View in Tracker

Status/Resolution/Reason: To Fix//Investigate

Reporter/Name(from Bugbase): Paul Rowe / Paul Rowe (P Rowe)

Created: 04/20/2014

Components: Database

Versions: 11.0

Failure Type: Enhancement Request

Found In Build/Fixed In Build: PublicBeta /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Win All

Vote Count: 0

Many database engines support virtual columns. These columns do not allow assignment; the value is either computed when the record is changed or when a query includes it. As such, an automated database interaction component using dbinfo to gather column specifications has no way to know which columns are virtual.

Please include a boolean column, perhaps named is_virtual, in the resultset for dbinfo.columns that indicates if the column is virtual. This will always be false when the database engine does not support virtual columns.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3745969

External Customer Info:
External Company:  
External Customer Name: P Rowe
External Customer Email:

Attachments:

Comments:

Note that virtual columns are called "computed columns" in MS SQL Server.
Comment by External U.
12610 | April 20, 2014 10:05:56 AM GMT