Different result between Budibase and MySQL CLI

[Philippe-M]

Checklist

• [ *] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 3.5.3
  • App Version: 3.5.3

Describe the bug
The result of a query is different when executed from Budibase compared to when it is executed directly in the MySQL console.

To Reproduce
Steps to reproduce the behavior:

1. Go to query in datasource (mysql)
2. Add this dump : MySQL-dump.zip
3. Create a new query : checkSscc
4. SELECT count(ssccNum) AS nbsscc FROM sdelivery WHERE ssccNum = "{{ ssccnum }}"
5. add binding parameter : ssccnum
6. save
7. in new screen add form with et text field name : ssccnum. And add text field name result
8. add button and add 3 action on click :
9. reset to default value result field
10. execute query checkSscc with parameter : {{ ssccnum.Value }}
11. add update value to result field

14. In sdelivery table i've this data

15. Publish your app and test

In mysql console sdelivery table :

My test

But with mysql cli

If i'm testing with "small" value

Desktop (please complete the following information):

• OS: Linux Fedora 41
• Browser Firefox
• Version 136.01

[linear]

BUDI-9162 Different result between Budibase and MySQL CLI