Skip to content

History / as_unique_list_with_null

Revisions

  • Document as_unique_list_with_null; correct the null ordering of frequency_table_with_null as_unique_list_with_null is the as_unique_list counterpart that lists null as well, added in GeoDMS 20.12.0 (ObjectVision/GeoDMS#1170). Its page uses the same City/LifeStyleCode example data as frequency_table_with_null, so the two read as a pair, and is linked from Aggregation functions. frequency_table_with_null showed null *last* in both its examples, which is not what the operator does and is exactly the misunderstanding that #1170 was opened about: null sorts before every defined value, for all value types. Corrected both examples and said so in the description, with a note that this is deliberately not the bit-pattern order of the unsigned int types, whose null is their maximum value. Their since-version was given as 14.4.0. Both operators were added in 981560f58 (2025-01-08), between the 16.1.0 and 16.1.1 release preparations, so 16.1.1 is the first release containing them. Also noted that the no-relation variant of frequency_table_with_null silently skipped nulls until 20.12.0. Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>

    @MaartenHilferink MaartenHilferink committed Aug 8, 2026