AnsweredAssumed Answered

JDBC Query behaves strangely with keyword 'LIMIT'

Question asked by turello.simone on Jul 27, 2015

I'm trying to query a MySql database, using an assertion configured like this:

problem.jpg

When i use the context variable "offset" in the query (initialized with "Set Context Variable" for example to 1 either as a String or as an Integer), this assertion fails but when i replace the variable with a number in the query itself it does work. Am i doing something wrong?

Thank you in advance.

 

 

EDIT:

Solved removing the check from"Convert variables to Strings" and using an integer variable, because the query necessary needs an integer after "LIMIT".

 

Messaggio modificato da Simone Turello

Outcomes