search

n8n-io / n8n

Free and source-available fair-code licensed workflow automation tool. Easily automate tasks across different services.
https://n8n.io
Other
45.52k stars 6.27k forks source link

If get unexpected behavour and Microsft SQL wrong return #3418

Closed Ofabiojvalentim closed 1 year ago

Ofabiojvalentim commented 2 years ago

If you execute this query for exemple: select name, phone from users where phone = 'phonenumber' and that returns (this output item is empty) then if statement bring me two branch either true and false

image

if you see on this pic value1 is missing reference because Microsft SQL node returns syntactically wrong answer, correct is a row with columns and empty values in each column

xewonder commented 2 years ago

Seems that n8n is not very good at SQL!

3425

Joffcom commented 2 years ago

Hey @Ofabiojvalentim,

Do you have a workflow you can share that reproduces this issue?

xewonder commented 2 years ago

Guys....

From my side, my logic was flawed and I apologize.

The MySQL queries run just fine...contrary to my brain.

I removed my "issues".

Best regards Denis Dorigo

(sent from mobile device)

On 15 June 2022 12:43:37 Jonathan Bennetts @.***> wrote:

Hey @Ofabiojvalentim,

Do you have a workflow you can share that reproduces this issue?

-- Reply to this email directly or view it on GitHub: https://github.com/n8n-io/n8n/issues/3418#issuecomment-1156245740 You are receiving this because you commented.

Message ID: @.***>

Joffcom commented 1 year ago

Hey @Ofabiojvalentim,

For now I am going to mark this as closed as I was not able to reproduce the issue and there wasn't a sample workflow provided.

I suspect there may have been a merge node involved somewhere or something was a bit odd in the output, If you are able to reproduce this still on the latest release let me know and we can get this opened.

Ofabiojvalentim commented 1 year ago

Alright