tracker issue : CF-4203834

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

Database Names no longer escaped during ORM table create/update

| View in Tracker

Status/Resolution/Reason: To Test//CannotReproduce

Reporter/Name(from Bugbase): Mike Hodgson / ()

Created: 12/19/2018

Components: ORM Support

Versions: 13.0

Failure Type: Crash

Found In Build/Fixed In Build: CF 2018 /

Priority/Frequency: Normal / Few users will encounter

Locale/System: English / Windows 7 64-bit

Vote Count: 0

Problem Description:

If your database name contains a period, ie: "biz.stuff", ORM create/update of tables will fail with an error regarding "too many prefixes". This may be specific to Microsoft SQL Server.

Steps to Reproduce:

create a database with a period in the name, ie: ""
set up a datasource to point to your database
create an ORM CFC
load application
When Coldfusion attempts to create the table for the ORM object, the "too many prefixes" error will occur.

In SQL Server, the database name should be wrapped in square brackets ie: [] to avoid this. This is how CF 2016 and previous worked.

Actual Result:

"too many prefixes" error

Expected Result:

Table created.

Any Workarounds:

Rename databases to not contain a period