Logical operators with numeric string incorrectly evaluates to FALSE

[momoway]

This issue seems related to other inconsistencies in string-to-boolean casting, as previously discussed in issue #9799.

SELECT '3bxu' OR FALSE;
-- MySQL: 1, Dolt: 0
SELECT '3bxu' AND TRUE;
-- MySQL: 1, Dolt: 0
SELECT '3bxu' XOR FALSE;
-- MySQL: 1, Dolt: 0

mysql> select dolt_version();
+----------------+
| dolt_version() |
+----------------+
| 1.59.6         |
+----------------+
1 row in set (0.00 sec)

[angelamayxie]

It looks like with strings, we need to truncate them to a number and then get the bool from if the number != 0.

'3bxu' truncates to 3 so it should evaluate as true, where as the strings in the following example truncate to 0 or an empty string and should evaluate as false

mysql

mysql> select '' or false;
+-------------+
| '' or false |
+-------------+
|           0 |
+-------------+
1 row in set (0.00 sec)

mysql> select '0' or false;
+--------------+
| '0' or false |
+--------------+
|            0 |
+--------------+
1 row in set (0.00 sec)

mysql> select '00' or false;
+---------------+
| '00' or false |
+---------------+
|             0 |
+---------------+
1 row in set (0.00 sec)

mysql> select '00asdf' or false;
+-------------------+
| '00asdf' or false |
+-------------------+
|                 0 |
+-------------------+
1 row in set, 1 warning (0.00 sec)

mysql> select 'asdf' or false;
+-----------------+
| 'asdf' or false |
+-----------------+
|               0 |
+-----------------+
1 row in set, 1 warning (0.00 sec)