[GitHub] [incubator-doris] xy720 edited a comment on issue #2399: 【sql mode】|| ‘-’ Symbol in expression，doris return NULL，mysql process by first value

[GitBox <gi...@apache.org>]

xy720 edited a comment on issue #2399: 【sql mode】|| ‘-’ Symbol in expression，doris return NULL，mysql  process by first value
URL: https://github.com/apache/incubator-doris/issues/2399#issuecomment-565517113
 
 
   I think this bug is very similar with issue #2142. (reference pr #2362 )
   This bug is not cause by PIPES_AS_CONCAT mode, but the Arithmetic operation processing logic of Doris.
   In Mysql, we can get result between numeric and non-numeric that:
   
   ```
   1 + "10xy" = 11
   1 + "10-1" = 11
   1 + "xy10" = 1
   ```
   
   But in Doris, our logic will get null.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org