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
StarRocks> select cast ('123.4' as INT) ;
+-----------------------+
I CAST ('1324.2' AS INT) |
+-----------------------+
| NULL |
+-----------------------+
in this SQL, 123.4 will be treated as a string and cannot be cast into int directly. In snowflake, hive, spark and MySQL, this is castable. However, in PostgreSQL, Clickhouse and trino, this is not castable.
Still a nice to have enhancement though.
The text was updated successfully, but these errors were encountered:
Enhancement
in this SQL, 123.4 will be treated as a string and cannot be cast into int directly. In snowflake, hive, spark and MySQL, this is castable. However, in PostgreSQL, Clickhouse and trino, this is not castable.
Still a nice to have enhancement though.
The text was updated successfully, but these errors were encountered: