changeset 21475:011fc620d6f6

dict-sql: Move USING TIMESTAMP to correct location for INSERTs
author Timo Sirainen <timo.sirainen@dovecot.fi>
date Mon, 06 Feb 2017 00:11:14 +0200
parents 6318f9e9b737
children 75ff4f96cdc4
files src/lib-dict/dict-sql.c
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/src/lib-dict/dict-sql.c	Mon Feb 06 00:48:18 2017 +0200
+++ b/src/lib-dict/dict-sql.c	Mon Feb 06 00:11:14 2017 +0200
@@ -952,7 +952,6 @@
 	prefix = t_str_new(64);
 	suffix = t_str_new(256);
 	str_printfa(prefix, "INSERT INTO %s", fields[0].map->table);
-	sql_dict_transaction_add_timestamp(ctx, prefix);
 	str_append(prefix, " (");
 	str_append(suffix, ") VALUES (");
 	for (i = 0; i < field_count; i++) {
@@ -992,6 +991,7 @@
 
 	str_append_str(prefix, suffix);
 	str_append_c(prefix, ')');
+	sql_dict_transaction_add_timestamp(ctx, prefix);
 	if (!dict->has_on_duplicate_key) {
 		*query_r = str_c(prefix);
 		return 0;