tracker issue : CF-4204046

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

Cannot Retrieve Columns for Tables with Underscore Characters

| View in Tracker

Status/Resolution/Reason: To Track//PRNeedInfo

Reporter/Name(from Bugbase): Travis W. / ()

Created: 02/24/2019

Components: Database, CFDBINFO

Versions: 2016

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: CF 2016 /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 0

Problem Description:

I have tried to replicate this issue with Oracle and MariaDB database types. I have not tried with other database types. 

I have a simple function:

  <cffunction name="getDBTableColumns" output="false" access="public" returntype="query">
    <cfargument name="table" type="string" required="true" />
    <cfdbinfo type="Columns" table="#arguments.table#" name="result" datasource="#variables.dsnName#">
    <cfreturn result/>
  </cffunction>

Table 'mariadbtest.all_plugins' doesn't exist

Table ALL_IND_EXPRESSIONS does not exist.

Steps to Reproduce:

See above

Actual Result:

Error Occurs

Expected Result:

Should be able to see column names for these tables as they do return when I get a table list using cfdbinfo

Any Workarounds:

No

Attachments:

Comments:

Hi Travis, I have tried it with Oracle12c, MySQL 5.6 and MS SQL Server 2016. It is working as expected. Create Table Snippet: {code:java} create table table_test1 (name_test varchar(20)) {code} CFML Code Snippet: {code:java} <cfset variables.dsnName = "mysql56_ND"> <cffunction name="getDBTableColumns" output="false" access="public" returntype="query"> <cfargument name="table" type="string" required="true" /> <cfdbinfo type="Columns" table="#arguments.table#" name="result" datasource="#variables.dsnName#"> <cfreturn result/> </cffunction> <cfdump var="#getDBTableColumns("table_test1")#"> {code}   Can you try reproducing the issue with this table schema? -Nimit
Comment by Nimit S.
30460 | March 11, 2019 10:30:06 AM GMT