Query is fetching Datatype along with column value from table in MySQL

Robot Framework
1

After connecting database I am writing the query -

(my_list} Query SELECT COLUMN2 FROM TABLE_NAME WHERE COLUMN1=*
Log to Console ${my_list}*

After executing above code, I am getting the below result -
[(Decimal (‘92.0054’),)]

Could you please help me to get rid of this datatype and extract only data from the column?
Thanks.

2

Search for documentation on how to convert/format results in MySQL.
SQL Library is returning just what it gets, and in this case was a decimal number, which is inside a tuple, the first element of the list.

It is important to understand how the values are returned. In your test you do the output to the Console, and it is shown as an object. But if you assign to a variable, you may get the converted value.

You can try:

${my_number}=    Set Variable    ${my_list[0]}[0]
Log To Console     ${my_number}