fix(outputs.sql): Fix insert into ClickHouse (#16472)

AndreKR · web-flow · commit 1b2e012f4b83 · 2025-02-05T09:12:21.000-06:00
diff --git a/plugins/outputs/sql/sql.go b/plugins/outputs/sql/sql.go
@@ -187,7 +187,7 @@ func (p *SQL) generateInsert(tablename string, columns []string) string {
 		}
 	}
 
-	return fmt.Sprintf("INSERT INTO %s(%s) VALUES(%s)",
+	return fmt.Sprintf("INSERT INTO %s (%s) VALUES(%s)",
 		quoteIdent(tablename),
 		strings.Join(quotedColumns, ","),
 		strings.Join(placeholders, ","))

Original file line number	Diff line number	Diff line change
`@@ -187,7 +187,7 @@ func (p *SQL) generateInsert(tablename string, columns []string) string {`
`187`	`187`	`}`
`188`	`188`	`}`
`189`	`189`
`190`		`- return fmt.Sprintf("INSERT INTO %s(%s) VALUES(%s)",`
	`190`	`+ return fmt.Sprintf("INSERT INTO %s (%s) VALUES(%s)",`
`191`	`191`	`quoteIdent(tablename),`
`192`	`192`	`strings.Join(quotedColumns, ","),`
`193`	`193`	`strings.Join(placeholders, ","))`