Implicit cast of string to boolean is broken

[mcgray]

We noticed that in case we are using string field in WHERE clause without expression it is always mistakenly cast to FALSE

Steps to reproduce the behavior (Required)

Use String value without expression (going to be used as cast(table.field as boolean)) .

Expected behavior (Required)

Non-empty non-null String cast to TRUE and SQL has results.

Real behavior (Required)

SQL has no results. String cast to false.

StarRocks version (Required)

3.2.1

[murphyatwork]

MySQL> select cast('123123' as boolean)
1

MySQL> select cast('100018588397' as boolean)
<null>

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!