Using the "NOT LIKE" filter, does not show <null> values

[IvoMoor]

Example:
I would expect filter COLUMN_A NOT LIKE 'B%', to return row 1, 2, 4 and 5. However, the filter now returns only row 1 and 2.

[rpbouman]

Related: LIKE NULL also doesn't work.

[IvoMoor]

Sample data:

data.csv

Query executed now:
SELECT "__huey_data_foundation"."COLUMN_A" AS COLUMN_A ,"__huey_data_foundation"."COLUMN_B" AS COLUMN_B ,COUNT(*) OVER () AS "COUNT(*) OVER ()" FROM read_csv( 'data.csv', store_rejects = true, rejects_scan = 'reject_scans', rejects_table = 'reject_errors', rejects_limit = 0 ) AS "__huey_data_foundation" WHERE "__huey_data_foundation"."COLUMN_A" NOT LIKE 'A%' GROUP BY COLUMN_A ,COLUMN_B ORDER BY COLUMN_A ASC NULLS FIRST ,COLUMN_B ASC NULLS FIRST