I need to generate data in a VARBINARY field.
When I publishto directly into the table (TGT) everything works well.
When I publishto a SQL file, TDM puts the value between quotes. It should not.
Tested on the TDM portal with version 4.9.291.
1- the create table
2- the generator (I put the value 1 in the field)
3- the submitted request of the TGT publishto
4- the submitted request of the SQL publishto (DBMS SQL Server)
5- The SQL file produced
6- The content of the generated SQL file indicating the apostrophes
7- The result of the execution of the inserts with and without apostrophes
Release : 4.9.1
Component : CA Agile Requirements Designer - TMX Script Generator
I am able to reproduce this issue. This is basically related to type conversion of the value
INSERT INTO JFB_TEST_VARBINARY ([CipherKey]) VALUES ('1') -- This is not a valid SQL because we need to type cast this string value to varbinary before executing this query.
INSERT INTO JFB_TEST_VARBINARY ([CipherKey]) VALUES (1). -- This is valid SQL because the value is number format and internally it will gets converted into varbinary. That is why this query is working while another is giving SQL error.
This has been addressed in later versions of 4.9 releases.
Download and install the latest patch from TDM patches link given below to fix this issue.