search

rpbouman / huey

A UI for DuckDB
MIT License
181 stars 14 forks source link

Subtotal nulls and real nulls don't sort like they are supposed to. #103

Closed rpbouman closed 1 month ago

rpbouman commented 1 month ago

Subtotals should always sort after the data. Right now, if the dataset has nulls, the subtotal that has a null at the totalled field may sort before the regular null. This is not correct.

See:

image t.csv

rpbouman commented 1 month ago

This seems easy enoug - just include the grouping id in the ORDER BY of the tuple query.

rpbouman commented 1 month ago

image

JTdCJTIydmlld0NsYXNzJTIyJTNBJTIyUGl2b3RUYWJsZVVpJTIyJTJDJTIycXVlcnlNb2RlbCUyMiUzQSU3QiUyMmRhdGFzb3VyY2VJZCUyMiUzQSUyMmZpbGUlM0ElNUMlMjJmaHZodl90cmlwZGF0YV8yMDIzLTAxLnBhcnF1ZXQlNUMlMjIlMjIlMkMlMjJjZWxsc0hlYWRlcnMlMjIlM0ElMjJjb2x1bW5zJTIyJTJDJTIyYXhlcyUyMiUzQSU3QiUyMmNlbGxzJTIyJTNBJTVCJTdCJTIyY29sdW1uJTIyJTNBJTIyKiUyMiUyQyUyMmNvbHVtblR5cGUlMjIlM0ElMjJJTlRFR0VSJTIyJTJDJTIyZGVyaXZhdGlvbiUyMiUzQW51bGwlMkMlMjJhZ2dyZWdhdG9yJTIyJTNBJTIyY291bnQlMjIlN0QlNUQlMkMlMjJjb2x1bW5zJTIyJTNBJTVCJTdCJTIyY29sdW1uJTIyJTNBJTIyZGlzcGF0Y2hpbmdfYmFzZV9udW0lMjIlMkMlMjJjb2x1bW5UeXBlJTIyJTNBJTIyVkFSQ0hBUiUyMiUyQyUyMmRlcml2YXRpb24lMjIlM0FudWxsJTJDJTIyYWdncmVnYXRvciUyMiUzQW51bGwlN0QlMkMlN0IlMjJjb2x1bW4lMjIlM0ElMjJodmZoc19saWNlbnNlX251bSUyMiUyQyUyMmNvbHVtblR5cGUlMjIlM0ElMjJWQVJDSEFSJTIyJTJDJTIyZGVyaXZhdGlvbiUyMiUzQW51bGwlMkMlMjJhZ2dyZWdhdG9yJTIyJTNBbnVsbCUyQyUyMmluY2x1ZGVUb3RhbHMlMjIlM0F0cnVlJTdEJTVEJTJDJTIyZmlsdGVycyUyMiUzQSU1QiU3QiUyMmNvbHVtbiUyMiUzQSUyMmRpc3BhdGNoaW5nX2Jhc2VfbnVtJTIyJTJDJTIyY29sdW1uVHlwZSUyMiUzQSUyMlZBUkNIQVIlMjIlMkMlMjJkZXJpdmF0aW9uJTIyJTNBbnVsbCUyQyUyMmFnZ3JlZ2F0b3IlMjIlM0FudWxsJTJDJTIyZmlsdGVyJTIyJTNBJTdCJTIyZmlsdGVyVHlwZSUyMiUzQSUyMmluJTIyJTJDJTIydmFsdWVzJTIyJTNBJTdCJTIyQjAyNzY0JTIyJTNBJTdCJTIydmFsdWUlMjIlM0ElMjJCMDI3NjQlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMkIwMjc2NCUyMiUyQyUyMmxpdGVyYWwlMjIlM0ElMjInQjAyNzY0JyUyMiU3RCUyQyUyMkIwMjc2NSUyMiUzQSU3QiUyMnZhbHVlJTIyJTNBJTIyQjAyNzY1JTIyJTJDJTIybGFiZWwlMjIlM0ElMjJCMDI3NjUlMjIlMkMlMjJsaXRlcmFsJTIyJTNBJTIyJ0IwMjc2NSclMjIlN0QlMkMlMjJCMDI4MzUlMjIlM0ElN0IlMjJ2YWx1ZSUyMiUzQSUyMkIwMjgzNSUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyQjAyODM1JTIyJTJDJTIybGl0ZXJhbCUyMiUzQSUyMidCMDI4MzUnJTIyJTdEJTdEJTJDJTIydG9WYWx1ZXMlMjIlM0ElN0IlN0QlMkMlMjJ0b2dnbGVTdGF0ZSUyMiUzQSUyMmNsb3NlZCUyMiU3RCU3RCU1RCUyQyUyMnJvd3MlMjIlM0ElNUIlN0IlMjJjb2x1bW4lMjIlM0ElMjJvcmlnaW5hdGluZ19iYXNlX251bSUyMiUyQyUyMmNvbHVtblR5cGUlMjIlM0ElMjJWQVJDSEFSJTIyJTJDJTIyZGVyaXZhdGlvbiUyMiUzQW51bGwlMkMlMjJhZ2dyZWdhdG9yJTIyJTNBbnVsbCUyQyUyMmluY2x1ZGVUb3RhbHMlMjIlM0F0cnVlJTdEJTVEJTdEJTdEJTdE