Automatic single space inserted when dragging column to field, breaks SOQL

[trijste]

Describe the bug When I drag a column to a field in n8n, it automatically inserts a single space in front of the column expression. This can cause issues when writing SOQL queries as the space can alter the query. In the demo provided in "Additional context," leaving the space in the query results in no results being returned. However, when the space is removed, the results are returned correctly. Therefore, every time I write queries that involve dragging a column to a field, I have to manually remove the automatically inserted space.

To Reproduce Steps to reproduce the behavior:

1. See "Additional context" for demo.

Expected behavior Either no space, or conditionally prepended space given context (no space in this condition).

Environment (please complete the following information):

• OS: Cloud
• n8n Version 1.16.0

Additional context

https://github.com/n8n-io/n8n/assets/23725702/a1c01740-2126-4444-830b-b4382fadca8a

[Joffcom]

Hey @trijste,

It looks like we add a space when dragging an expression into any text field that alreadys contains text, I am not really sure if this is a bug as we intentionally added this although I can see why it would be annoying sometimes.

I will get a dev ticket created anyway and we can talk about it internally to work out what to do.

[Joffcom]

Internal ticket for this is PAY-1238

[trijste]

Thanks @Joffcom I'm not sure it's a bug either. It's only in this situation that I've tripped over it.