You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi @ayumu838! It happens because SQLite (which is used as an engine for Query Results) does not return data types for columns, so Redash tries to infer that types. Strings false and true will infer to TYPE_BOOLEAN, therefore you see this result.
But detected data types don't change actual data, just the way the app will interpret them by default. Open Table visualization editor and change "Display As" to "Text".
👋 @ayumu838, we use the issue tracker exclusively for bug reports and planned work. However, this issue appears to be a support request. Please use our forum to get help.
Issue Summary
Query Results returns to
true
when'False' String
Steps to Reproduce
Query Results
SELECT 'FALSE' AS Foo
true
Technical details:
The text was updated successfully, but these errors were encountered: