Microsoft SQL Node: Suspected Display Bug in JS Expression

Hi,

I’m seeing some behavior in 1.15.2 where using [brackets] in the expression editor causes the preview of the resulting value to display differently than what the expression specifies. However the node still executes the correct value.

For example, with incoming $json:

[
{
"dbName": "Testing",
"queries": "MenuGetUsers"
}
]

And expression:

EXEC [dbo].[{{ $json.queries }}]

I expect it would display and execute:

EXEC [dbo].[MenuGetUsers]

It does execute that expected value. However in the preview, it shows:

EXEC [dbo][dbo].[{{ $json.queries }}][MenuGetUsers]

image

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
  • n8n version: 1.15.2
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): Default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): AWS EKS
  • Operating system: AWS Linux

Hey @jzrts,

I think we have this issue already being tracked somewhere as it can also cause issues with other special characters as well. I will get this post linked up to the other issue post so you get an alert once fixed.