[explore] Filter unable to select NULL and empty string

[zhaoyongjie]

I can't select NULL and empty string in Filter

How to reproduce the bug

1. First of all, let us create a virtual dataset from SQLLab and open this in Explore page.

SELECT '' as name
UNION ALL
SELECT null as name

2. I can't get NULL and empty string in filter.

3. I can manually input <NULL> and <empty string> to filter that.

Expected results

I can select <NULL> and <empty string> in filter

Environment

latest master branch

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

[jinghua-qa]

I have tried using example dataset covid_vaccines, for the column with "null" value only, i did not see selection for IN filter, keep loading forever

[zhaoyongjie]

I have tried using example dataset covid_vaccines, for the column with "null" value only, i did not see selection for IN filter, keep loading forever

Thanks for you figure it out, but I think your finding is different with this issue. Feel free to open a new issue + ticket for can't load values in a filter.

[jinghua-qa]

ok, i open this issue here #18178