Re: [I] [Bug] (ip functions) a bug occurred while executing ipv4stringtonumordefault function [doris]

[via GitHub]

superdiaodiao commented on issue #28387:
URL: https://github.com/apache/doris/issues/28387#issuecomment-1855422511

   > > This behavior meets our expectation. The column for ipv4stringtonum or 
ipv4stringtonumordefault is set to be **always not nullable**, so that we can 
have a precheck for the Null situation.
   > > If you want to not check for this, you can use **ipv4stringtonumornull** 
or use the **nvl** function to deal with your column first.
   > 
   > But function ipv4stringtonumordefault 's behavior is different from what 
is defined in ClickHouse <img alt="image" width="1340" 
src="https://private-user-images.githubusercontent.com/114391101/290455574-3206c0b6-943b-4d7d-bf82-880dc8ab631b.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTEiLCJleHAiOjE3MDI1NDM4MDIsIm5iZiI6MTcwMjU0MzUwMiwicGF0aCI6Ii8xMTQzOTExMDEvMjkwNDU1NTc0LTMyMDZjMGI2LTk0M2ItNGQ3ZC1iZjgyLTg4MGRjOGFiNjMxYi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBSVdOSllBWDRDU1ZFSDUzQSUyRjIwMjMxMjE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDIzMTIxNFQwODQ1MDJaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1mNDhmNTBmOWUzNzI3NzYwMWIwZGNkZTYwNGU5N2JiYWQwMzc0NDAyNGM4ODU0NDAzMzIwMzc1OWZiMjUwYWNiJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.yaUM5LO4XPNjtiKBql83lQbV4j2SzSQzzuDPKT0H_k8";>
   
   In Clickhouse, are these ipv4 stringtonum functions: 
ipv4stringtonum(ordefault, ornull) all set to nullable?


-- 
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