Status/Resolution/Reason: To Track//ThirdParty
Reporter/Name(from Bugbase): John O'Connell / John O'Connell ()
Created: 08/18/2017
Components: Database, CFDBINFO
Versions: 10.0
Failure Type: Incorrectly functioning
Found In Build/Fixed In Build: 10,0,23,302580 /
Priority/Frequency: Normal / Some users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 0
Problem Description:
CFDBINFO always returns "empty string" when querying column info on DB for COLUMN_DEFAULT_VALUE along with REMARKS
Steps to Reproduce:
Created Table with 3 columns, one having a default value. (same result if I were to alter table after creation).
CREATE TABLE SAMPLETEST (ID INT NOT NULL, STRCOLUMN VARCHAR(50), DEFAULTCOLUMN VARCHAR(50) DEFAULT 'FOO' NOT NULL)
Call cfdbinfo on this table and view missing data
Actual Result:
COLUMN_DEFAULT_VALUE is "empty string" for column that has default value
Expected Result:
COLUMN_DEFAULT_VALUE should return "FOO"
Attached is an image of the sql view and cf view of the db table. Also is a spy log of the call (table name is different in the call, but same results).Attachments:
- August 18, 2017 00:00:00: cfdbinfo_bug.gif
- August 18, 2017 00:00:00: spy_cfdbinfo.log
Comments: