Incorrect behavior when filtering 'Query Results (Preview)' grid on columns containing NULL values

[jonp0]

• MSSQL Extension Version: 1.28.0
• Version: 1.97.2 (user setup)
• Commit: e54c774e0add60467559eb0d1e229c6452cf8447
• Date: 2025-02-12T23:20:35.343Z
• Electron: 32.2.7
• ElectronBuildId: 10982180
• Chromium: 128.0.6613.186
• Node.js: 20.18.1
• V8: 12.8.374.38-electron.0
• OS: Windows_NT x64 10.0.22631

Steps to Reproduce:

1. Run a query whose output contains NULL values, e.g.:

select 0 [col_a], 0 [col_b], 0 [col_c], 'a' [col_d]
UNION
select 0 , 0 , 99, 'a' 
UNION
select 0 , 1 , null, 'b' 
UNION
select 1 , 0 , 98, 'b' 
UNION
select 1 , 1 , 97, 'a' 
UNION
select 1 , 0 , null, 'a' 
UNION
select 1 , 1 , 96, 'b'

2. Filter the output grid on [col_c] = 99 >>> Output is filtered as expected
3. Filter the output grid on [col_c] = 96 >>> Output disappears as if filter returns nothing
4. Filter the output grid on [col_c] = 0 >>> Output is filtered as expected
5. Filter the output grid on [col_c] = NULL >>> Output disappears as if filter returns nothing
6. Filters on all other columns work as expected

[cssuh]

Hi @jonp0 we made some updates to the query filtering experience in version 1.29. Can you please give it a try to see if this fixes your issue?

[jonp0]

Hi @cssuh ,
Upon initial testing with the same query above (and a few others), it looks like this specific issue is fixed in 1.29.0. Thanks!

[cssuh]

@jonp0 , thanks for the quick reply. I'll close this issue since it's fixed.