thanks @filipniziol for sharing the information, that helps!!

Just curious to know if it is the databricks sql behavior or in general sql behavior with all databases?