tracker issue : CF-4203833

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

dbdefault no longer quoted properly when generating Hibernate DDL for DB create/update

| View in Tracker

Status/Resolution/Reason: To Test//Fixed

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 / Some users will encounter

Locale/System: ALL / Windows 7 64-bit

Vote Count: 0

Problem Description:

If you have a dbdefault set on a property, and it is a string, it will fail to create the table. The problem is that strings are no longer quoted when passed through to the database.

Steps to Reproduce:

Create a new ORM persisted CFC, Add a property with ormtype="string" and dbdefault="This is a test" 

Actual Result:

Table creation fails, Exception referencing incorrect syntax near ","

Expected Result:

Table created successfully

Any Workarounds:

Add single quotes inside the double quotes, ie: dbdefault="'This is a test'"

Attachments:

Comments: