Hi, I'm attempting to test a DB with the JDBC request sampler and Im having an issue with the Response Assertion. My SQL query returns multiple lines and I want to use a Response Assertion (pattern equals) to validate. If I run the query and copy paste the response into a Response Assertion everything works as expected though when I attempt to use a variable from a CSV dataset I can't work out how to get a new line.
Example Response Assertion variable from CSV (doesnt match) -- Assertion error: false Assertion failure: true Assertion failure message: Test failed: text expected to equal / ****** received : Column1[[[ 4 2 4 ]]] ****** comparison: Column1[[[ 4 2 4 ]]] Response Assertion with static values (Matches,set to fail. Received 4 should have been 3) -- Assertion error: false Assertion failure: true Assertion failure message: Test failed: text expected to equal / ****** received : Column1 [[[4]]] 2 4 ****** comparison: Column1 [[[3]]] 2 4 / Thanks for your help Troy -- NOTICE: This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system.
