postgresql double precision columns get loaded as null

[fboerman]

Steps To Reproduce

1. have a postgresql connection
2. load a table with one (or more) columns with double precision type
3. reference it in a post

Environment

• Node version (node -v): v20.11.1
• npm version (npm -v): 10.4.0
• OS: archlinux 6.6.10-arch1-1-surface SMP PREEMPT_DYNAMIC Sat, 13 Jan 2024 00:20:37 +0000 x86_64 GNU/Linux
• Browser: firefox
• Database: postgresql

Expected Behavior

data is loaded correctly with correct type

Actual Behaviour

table on page shows null values and the parquet file in the static folder shows all column values as null

Workarounds

cast in the original query the column to ::numeric then values are correctly loaded in

[fboerman]

update: when I use the workaround and cast to all UPPERCASE column titles the bug returns. really strange