tracker issue : CF-4203834

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

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: 2018

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: "biz.data"
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: [biz.data] 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

Attachments:

Comments:

I wrote a sample test-case and found that i am not able to reproduce this. I created a database bizz.stuff and then used it to create a table named Text and it works fine. Please check with the customer in case he is using . in tableName as i think that is not allowed. Also here creation of the table would work fine but altering the table will have problems as the drivers doesn't allow multiple dots in the tableNames. i checked in hibernate sql thats being generated and sql is being generated fine. *alter table bizz.stuff.dbo.Text add Misc varchar(255) default 'Any Default Value'*
Comment by Ashudeep S.
31772 | December 21, 2018 11:20:52 AM GMT