column "{id}" is declared non-nullable but received null; storing a filler value

Warnings reference › store.null.*

Identifier

store.null.*

Raised by

The grid (core)

Since

1.0.1

What happened

A non-nullable column has no presence bitmap, so there is nowhere to record that a value is absent. The null is stored as a filler - NaN for a float column, zero or an empty string elsewhere - and reads back as that filler, not as null. Sorting, filtering and totals all see the filler.

The fix

Declare the column nullable, or clean the data so the value is always present.

Reference

Covered in full at the API reference.