Title:
Bug 85531:(Watson Migration Closure)cfdbinfo tag returns column_size of 10 for MySQL columns of datatype INT(8)
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): A. Bakia / A. Bakia (A. Bakia)
Created: 01/06/2011
Components: Database, CFDBINFO
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 9,0,1,274733 /
Priority/Frequency: Normal / Some users will encounter
Locale/System: English / Win All
Vote Count: 0
Problem:
cfdbinfo tag returns column_size of 10 for MySQL columns of datatype INT(8)
Method:
1) I create a database with a number of tables, each of which has a column of type INT(8)
2) When I run the following code, Coldfusion tells me the column_size for each such table is 10, instead of the correct 8. <cfdbinfo datasource="mydsn" name="tbls" type="tables" dbname="mydb"><cfoutput query="tbls"><cfdbinfo datasource="mydsn" name="tbl" type="columns" table="#tbls.table_name#"> <cfdump var="#tbl#" label="#tbls.table_name#"> </cfoutput>
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3043034
External Customer Info:
External Company:
External Customer Name: A. Bakia
External Customer Email: 4E2913DC4455DE13992016B6
External Test Config: 01/06/2011Attachments:
Comments: