tracker issue : CF-3978609

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

cfdbinfo type=columns does not return correct results

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Dorin Moise / Dorin Moise (Dorin Moise)

Created: 04/29/2015

Components: Database

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Normal / All users will encounter

Locale/System: ALL / Linux CentOS 6.4

Vote Count: 0

Listed in the version 2016.0.0.297996 Issues Fixed doc
Verification notes: verified_possibly_fixed on February 16, 2016 using build 2016.0.01.298513 
Problem Description:
IS_PRIMARYKEY is always 'NO' 

Steps to Reproduce:
<cfdbinfo datasource="#local.datasource#" name="cols" type="columns" table="#local.table#">

Actual Result:
The column 'is_primarykey' is always NO, even if there are primary keys in the table.

Expected Result:
As in CF9, I expect the 'is_primarykey' column to show 'YES' for the fields that are primary keys.

Any Workarounds:
Not aware of

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

Watson Bug ID:	3978609

External Customer Info:
External Company:  
External Customer Name: Dorin
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

  1. April 29, 2015 00:00:00: 1_cf9_vs_cf11.png
  2. May 06, 2015 00:00:00: 2_cf11settings_164.pdf
  3. June 15, 2015 00:00:00: 3_cfdbinfo_cf9_vs_cf11_2.png

Comments:

Hi Dorin, I have tried replicating this issue(CF11w Update 5 + SQL SERVER 2012) but I am unable to replicate it. Can you please provide below mentioned information? 1. Settings Summary 2. Database server version details
Comment by Nimit S.
7697 | May 03, 2015 11:20:13 PM GMT
Hi Nimit, The configuration is CF11 update 5 + Oracle. I currently don't have access to the machine but I will try to send the settings summary and the db version as soon as possible. Thank you, Dorin
Comment by External U.
7698 | May 04, 2015 01:53:34 AM GMT
Nimit, I attached the CF11 settings. The Oracle version is 11.2.0.4.0 Thank you, Dorin
Comment by External U.
7699 | May 06, 2015 03:25:12 AM GMT
Hello, Any more updates on this issue? Did you manage to reproduce it? Thank you, Dorin
Comment by External U.
7700 | June 06, 2015 03:41:15 PM GMT
The same issue is noticed when table contains foreingkeys, with the columns 'IS_FOREIGNKEY, REFERENCED_PRIMARYKEY and REFERENCED_PRIMARYKEY_TABLE which are always 'NO', 'N/A' and 'N/A' in CF 11 (see screenshot - cfdbinfo_cf9 vs cf11_2.png)
Comment by External U.
7701 | June 15, 2015 06:38:56 AM GMT
Hi there, Any updates on this issue? Thanks, Dorin
Comment by External U.
7702 | July 07, 2015 01:47:28 AM GMT
This issue is fixed and this fix for this issue will be available as part of next major release of ColdFusion.
Comment by Nimit S.
7703 | November 02, 2015 10:28:29 PM GMT