LiBinfeng-01 commented on PR #49416: URL: https://github.com/apache/doris/pull/49416#issuecomment-2753131839
> does backend have different behavior to your fix? @LiBinfeng-01 > > for example: > > ```sql > set debug_skip_fold_constant=true; > select cast(1.00000 as varchar(4)); > ``` > > the backend return the result `1.00` > > but your fix will replace `1.00000` to `1` fe and be have same behavior: ``` mysql> select cast(cast (1.00000 as double) as varchar(4)); +----------------------------------------------+ | cast(cast (1.00000 as double) as varchar(4)) | +----------------------------------------------+ | 1 | +----------------------------------------------+ 1 row in set (0.00 sec) mysql> set debug_skip_fold_constant=true; Query OK, 0 rows affected (0.00 sec) mysql> select cast(cast (1.00000 as double) as varchar(4)); +----------------------------------------------+ | cast(cast (1.00000 as double) as varchar(4)) | +----------------------------------------------+ | 1 | +----------------------------------------------+ 1 row in set (0.03 sec) ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
