hop icon indicating copy to clipboard operation
hop copied to clipboard

[Bug]: Table output insert statement does not quote field names in INSERT statement

Open danjreyes opened this issue 8 months ago • 3 comments

Apache Hop version?

2.9.0

Java version?

11.0.22

Operating system

Windows

What happened?

I am trying to use the Table output action to insert data into a SQL Server table. Some of the fields in the table have spaces in them. In the driver settings, I have the "Quote all identifiers in database" option checked.

However, it appears that the INSERT statement is being generated without the quote symbols around the field names which cause a failure.

image

image

Issue Priority

Priority: 2

Issue Component

Component: Actions

danjreyes avatar May 31 '24 22:05 danjreyes