SQLite handle boolean

[SailMile]

Can we access your project?

• I give permission for members of the FlutterFlow team to access and test my project for the sole purpose of investigating this issue.

Current Behavior

When handle boolean in a sqLite querry and trying to pass the value to e.g. supabse or a text widget, error: 'int' is not a suptype of type 'bool' shows up. In sqLite I decleared variable "test" as BOOLEAN. And in Flutterflow Read Query as an output also as boolean.
The query is not the issue (it shows 0 or 1). But when trying to pass the value bool to bool it has an error.

Expected Behavior

Flutterflow converts 0 and 1 to false and true to be able to pass the value to e.g text widget as a bool.

Steps to Reproduce

1. Create SQLite db with variable BOOLEAN
2. Make a Read Querry with output variable of type bool.
3. Try to show value in a widget text or try to do anything with the value.

Reproducible from Blank

• The steps to reproduce above start from a blank project.

Bug Report Code (Required)

IT40hfLl5YxgobxA1rrtbcFF9T45JUQ8a4ErlsJ7aDYvCIyqOph/Y+ClU1tDXuKodFNhHFGbgnIHwvyKk+GWE8E7OUysQYBAzJNUETqUTXq8SqrXErWwW0FAEptYGUim16u43RUlIs5qSmQn3Ez3N+mudC3DN5+/Zwh9f6PHaOI=

Visual documentation

Environment

- FlutterFlow version: v6.3.1+
- Platform: Windows Desktop
- Browser name and version: -
- Operating system and version affected: windows 11

Additional Information

No response

[Alezanello]

Hello! 👋

I wasn’t able to find the SQL DB test with the query you mentioned in your project. Could you please share a bug report code for that project so I can test it directly?

[Alezanello]

Closing this issue since we haven't heard back from you. If you are still facing the problem please submit a new issue. Thank you!