Closed
Description
- 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:
- 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'
- Filter the output grid on [col_c] = 99 >>> Output is filtered as expected
- Filter the output grid on [col_c] = 96 >>> Output disappears as if filter returns nothing
- Filter the output grid on [col_c] = 0 >>> Output is filtered as expected
- Filter the output grid on [col_c] = NULL >>> Output disappears as if filter returns nothing
- Filters on all other columns work as expected