I have an execSQL that has statement like insert into TB (field1, field2) values (’%document/firstname%’,’%document/lastname%’)
When I dont enter value to last name (and enter first name as ‘test’)for the document in pipeline-in, the insert gets translated as
insert into TB (field1,field2) values (‘test’,’%document/lastname%’);
causing a data truncation error as the column in table cannot accomodate the raw %document/lastname% literal!!
I would have expected a ‘’ in that place instead of ‘%document/lastname’
Strange enough, when I enter value for lastname, it substitues okay adn insert succeeds,
For those variables/fields where I dont enter any value in the pipeline-in, I would expect it to