SQL data type error

[radamesbispo]

Bug Description

the data type is correcly mapped with sql and 100% perfectly in old version of n8n. bug start after update for version 1.75.0

To Reproduce

go to pstgresSql
insert some number to store on it
see the result

Expected behavior

the behaviour expect is save the data

Operating System

ubuntu

n8n Version

1.75.0

Node.js Version

dont know

Database

PostgreSQL

Execution mode

queue

[Joffcom]

Hey @radamesbispo,

We have created an internal ticket to look into this which we will be tracking as "N8N-8130"

[Joffcom]

As a possible work around does it work if you try wrapping it in Number() or parseInt()

[radamesbispo]

the postgresSql are receiving NUMBER, the problem are not in the input but inside of node.... i have try Number() or parseInt() but even do not work

[dana-gill]

@radamesbispo I'm having trouble reproducing the issue. Would you mind sending in workflow to be sure? 🙏