Results 21 comments of nitao

simplest cases to reproduce: MySQL [mo]> SELECT cast('1.1' as signed int); ERROR 20203 (HY000): invalid argument cast to int, bad value 1.1 MySQL [mo]> MySQL [mo]> SELECT cast(1e30 as signed...

for this error, keep this unchanged. confirmed with @domingozhang MySQL [mo]> SELECT cast(1e30 as signed int); ERROR 20201 (HY000): data out of range: data type int64, value '1e+30'

these errors still keep unchanged. confirmed with @domingozhang MySQL [mo]> SELECT cast('1.1' as int); ERROR 20203 (HY000): invalid argument cast to int, bad value 1.1 MySQL [mo]> MySQL [mo]> SELECT...

waiting for #4172, should we move this to 0.7?

no progress

no progress

same problem as #4172 , assign @iamlinjunhong

https://github.com/matrixorigin/matrixone/pull/6888 already fixed in this pr