Bool Data Type issue in Kusto

Question

Hi,

I have a table called "ActivityStatus" and it has one column i.e. "Status" and its datatype is bool in Azure Data Explorer database.

when i am inserting the data in it its working fine.

.ingest inline into table ActivityStatus<|
1
0

and when i query the data it showing as
true
false

till this part it is fine. But when i am inserting the value as '3' it is showing as true

.ingest inline into table ActivityStatus<|
3

and when i query the data it showing as
true

which means if we insert any value >=1 then the data will be stored as true and <=0 as false.

Please suggest and confirm me the same

Answer 1

Hello @ADX
,
Thanks for the ask and using Microsoft Q&A platform .
This is what i trried and it behaves differently then what i called out above . Can you please more details ?

.drop table T

.create table T (text:string, b:bool)

.ingest inline into table T <|
null,null
false,false
0,0
-1,-1
1,1
2,2
3,3
true,true

T | extend ['null?']=isnull(b)

Please do let me if you have any queries .
Thanks
Himanshu

-------------------------------------------------------------------------------------------------------------------------