SELECT1/0AS a,0/0AS b,8/4AS c
####################
┌───a─┬───b─┬─c─┐
│ inf │ nan │ 2 │
└─────┴─────┴───┘
整数除法函数
结果向下取舍,除0会报错
SELECT
intDiv(7,3),7/3;###################
┌─intDiv(7,3)─┬───────divide(7,3)─┐
│ 2 │ 2.3333333333333335 │
└──────────────┴────────────────────┘
SELECT intDiv(1,0);###################
Received exception from server (version 22.12.6):
Code: 153. DB::Exception: Received from localhost:9000. DB::Exception: Division by zero: While processing intDiv(1,0).(ILLEGAL_DIVISION)