BUG - Postgres node with "Map Automatically" mangles string arrays

[darylteo]

Describe the problem/error/question

Using Postgres with Map Automatically + text[] column corrupts the output of the previous node, turning it from an string[] to object.

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

expected: 1 item
actual: no items

Information on your n8n setup

• n8n version: 1.120.4
• Database (default: SQLite): postgres
• n8n EXECUTIONS_PROCESS setting (default: own, main): ?? cloud
• Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
• Operating system: os x

[darylteo]

With postgres active

With postgres inactive.

[Mutasem]

@darylteo

Using Postgres with Map Automatically + text column corrupts the output of the previous node, turning it from an string[] to object.

Thank you for sharing this bug report. I was able to reproduce this. I created a bug report. Internal ticket id is NODE-4001. Will get an update when this is fixed.

[jan]

New version n8n@1.123.0 got released which includes the GitHub PR 22426.