Returning empty list when selecting "IS NULL"

[AndAccioly]

I have a table with some rows containing null values on one column. I am trying to select these rows, but supabase always return with empty list, even on SQL editor:

SQL editor: select * from imoveis where valor_venda IS NULL
react: supabase.from('imoveis').select('*').is('valor_venda', null)

I don't know if I forgot any configuration, but it won't workd even if I have hundreds of null data. The column is a float4 type. Does anyone know how to fix it?

[GaryAustin1]

That should work and does:

Are you sure you don't have RSL enabled and policy not met? This would also mean you are running impersonation mode in the SQL editor though.

[AndAccioly]

It is strange because it works for pretty any select, just the is null does not return data. Example:

I have disabled RSL for all my tables, and I can show here that there are null values:

What I am doing is making 0 as default for this column so I won't have more nulls, it is a workaround but does not fix the problem.

[GaryAustin1]

Try it on another table. Not sure what to say as using the same column type and SQL query it works for me.