Issue my MSSQL Update in latest version

Questions
1

Describe the problem/error/question

The Microsoft SQL node fails when using “update” if you are referencing a table via its full name

This can be worked around by changing the table to be:
bespoke].[dbo].[test

I believe this is because the update command wraps the table name in square brackets.

What is the error message (if any)?

ERROR: Invalid object name ‘bespoke.dbo.test’.

Please share your workflow

Share the output returned by the last node

ERROR: Invalid object name ‘bespoke.dbo.test’.

Information on your n8n setup

  • n8n version: 1.13.0 → 1.18.0
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): queue
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: ubuntu
1 Like
2

Yes, that is an issue.

3

Hey @Tim_C & @priority1it,

Welcome to the community :tada:

I have taken a quick look and it looks like this is down to a change we made when we introduced a fix to help prevent sql injections. I will get a dev ticket created shortly to resolve this.

@priority1it is it safe to assume that your issue is exactly the same because you work for the same company?

1 Like
4

My issues are way worse than @Tim_C’s. But in this case. They are the same :joy:

2 Likes
5

:joy: Excellent (I guess). I have created a ticket for it and I can see there are multiple operations that would be impacted but I don’t know when this will be fixed.

1 Like
6

New version [email protected] got released which includes the GitHub PR 7801.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.