Boolean expression on 1, 0, true , false

1

Hi everyone
current dremio version: v.19

when filter by boolean field for vds , not possible to use filter value of 1,0 but only can use true , false
such as: WHERE {column} =1 (return nothing even there is valid case hit the true condition)
is there some bug? how to fix it? thx

2

@crazyisjen Please send the job profile. Wondering if the FILTER is been treated as INTEGER,