TDM - Quoted default value NEWID()

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

In the TDM portal, when the default value of the table field is NEWID() (on SQL Server), the insert generated in the SQL file puts the value between quotes.

This causes an error when the insert is executed.

 

Environment

Release : 4.9.361

Component : TDM Web Portal

Cause

There should be no quotes since it is a SQL Server function.

Resolution

TDMWeb-4.9.378.0.zip and later resolves this issue.