Unknown column 'Infinity' in 'where clause'

[Bhuemann]

Checklist

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

Hosting

• Self
  • Method: docker single image via docker compose (image: https://hub.docker.com/r/budibase/budibase)
  • Budibase Version: 2.24.1
  • App Version: 2.24.1

Receive the error Unknown column 'Infinity' in 'where clause' on fetch row action. The action is 'on selection' of a card component where it pulls primary key of data displayed on the card and attempts to do a fetch row action. For all other rows Ive tested in my database this works just fine; however, this row with primary key value of 3959e3100762 seems to throw this error. I have verified the key value upon row fetch action.

To Reproduce
Steps to reproduce the behavior (From my exported app):
Note: These steps assume database is populated with data.

1. Go to Explore>Trails By Name in navigation bar
2. The name of the trail causing the issue was 'Indian Rock Ranch Skyline Trail Loop' enter this into search bar and hit enter
3. Select card corresponding trail and error appears

Expected behavior
The action will fetch the row with provided primary key.

Screenshots

App Export
Hiking Journal-export-1715144770453.tar.gz

Desktop

• OS: Windows 11
• Browser: Firefox (64-bit)
• Version: 125.0.3

Additional context
DB Schema Export: MySQL-dump.zip

[linear]

BUDI-8233 Unknown column 'Infinity' in 'where clause'