Message Title

I am at a loss to explain what and why it happens, but it does consistently. I ran my system with format_sql=true and opened the relevant log levels and here are the results:

Version 5.2.12

16:57:55,938 INFO  [stdout] DEBUG [default task-2        ] [org.hibernate.SQL             ] 
16:57:55,938 INFO  [stdout]     insert 
16:57:55,938 INFO  [stdout]     into
16:57:55,938 INFO  [stdout]         data_source_resources
16:57:55,938 INFO  [stdout]         (host, parameters, password, path, port, protocol, username, created_date, date_format, missing_values_str, discriminator) 
16:57:55,938 INFO  [stdout]     values
16:57:55,938 INFO  [stdout]         (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'CSV')
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [1] as [VARCHAR] - [localhost]
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [2] as [VARCHAR] - [null]
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [3] as [VARCHAR] - [3777347]
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [4] as [VARCHAR] - [/home/lyor]
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [5] as [INTEGER] - [0]
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [6] as [VARCHAR] - [file]
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [7] as [VARCHAR] - [lyor]
16:57:55,939 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [8] as [TIMESTAMP] - [Tue Jun 19 16:57:55 IDT 2018]
16:57:55,940 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [9] as [VARCHAR] - [null]
16:57:55,940 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [10] as [VARCHAR] - [null]
16:57:55,941 INFO  [stdout] DEBUG [default task-2        ] [org.hibernate.SQL             ] 
16:57:55,941 INFO  [stdout]     select
16:57:55,941 INFO  [stdout]         currval('data_source_resources_id_seq')
16:57:55,962 INFO  [stdout] DEBUG [default task-2        ] [org.hibernate.SQL             ] 
16:57:55,962 INFO  [stdout]     insert 
16:57:55,962 INFO  [stdout]     into
16:57:55,962 INFO  [stdout]         csv_settings
16:57:55,962 INFO  [stdout]         (code_page, column_delimiter, first_row_is_header, locale, num_of_rows_in_csv, num_rows_to_process, id) 
16:57:55,962 INFO  [stdout]     values
16:57:55,962 INFO  [stdout]         (?, ?, ?, ?, ?, ?, ?)
16:57:55,962 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [1] as [VARCHAR] - [UTF-8]
16:57:55,962 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [2] as [CHAR] - [,]
16:57:55,963 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [3] as [BOOLEAN] - [true]
16:57:55,963 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [4] as [VARCHAR] - [English (United States)]
16:57:55,963 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [5] as [BIGINT] - [null]
16:57:55,964 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [6] as [BIGINT] - [null]
16:57:55,964 INFO  [stdout] TRACE [default task-2        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [7] as [BIGINT] - [9]

Version 5.2.17

06:50:50,146 INFO  [stdout] DEBUG [default task-4        ] [org.hibernate.SQL             ] 
06:50:50,146 INFO  [stdout]     insert 
06:50:50,146 INFO  [stdout]     into
06:50:50,146 INFO  [stdout]         data_source_resources
06:50:50,146 INFO  [stdout]         (host, parameters, password, path, port, protocol, username, created_date, date_format, missing_values_str, discriminator) 
06:50:50,147 INFO  [stdout]     values
06:50:50,147 INFO  [stdout]         (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'CSV')
06:50:50,147 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [1] as [VARCHAR] - [localhost]
06:50:50,147 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [2] as [VARCHAR] - [null]
06:50:50,147 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [3] as [VARCHAR] - [3777347]
06:50:50,147 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [4] as [VARCHAR] - [/home/lyor]
06:50:50,149 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [5] as [INTEGER] - [0]
06:50:50,150 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [6] as [VARCHAR] - [file]
06:50:50,150 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [7] as [VARCHAR] - [lyor]
06:50:50,150 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [8] as [TIMESTAMP] - [Wed Jun 20 06:50:50 IDT 2018]
06:50:50,150 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [9] as [VARCHAR] - [null]
06:50:50,150 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [10] as [VARCHAR] - [null]
06:50:50,150 INFO  [stdout] DEBUG [default task-4        ] [org.hibernate.SQL             ] 
06:50:50,150 INFO  [stdout]     select
06:50:50,150 INFO  [stdout]         currval('data_source_resources_id_seq')
06:50:50,186 INFO  [stdout] DEBUG [default task-4        ] [org.hibernate.SQL             ] 
06:50:50,186 INFO  [stdout]     insert 
06:50:50,186 INFO  [stdout]     into
06:50:50,186 INFO  [stdout]         csv_settings
06:50:50,186 INFO  [stdout]         (code_page, column_delimiter, first_row_is_header, locale, num_of_rows_in_csv, num_rows_to_process, id) 
06:50:50,186 INFO  [stdout]     values
06:50:50,186 INFO  [stdout]         (?, ?, ?, ?, ?, ?, ?)
06:50:50,186 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [1] as [VARCHAR] - [UTF-8]
06:50:50,186 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [2] as [CHAR] - [,]
06:50:50,186 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [3] as [BOOLEAN] - [true]
06:50:50,186 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [4] as [VARCHAR] - [English (United States)]
06:50:50,187 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [5] as [BIGINT] - [null]
06:50:50,187 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [6] as [BIGINT] - [null]
06:50:50,187 INFO  [stdout] TRACE [default task-4        ] [o.h.t.d.sql.BasicBinder       ] binding parameter [7] as [BIGINT] - [10]

A quick comparison shows that they are virtually identical. Furthermore, the INSERT statements are correct - first the base table is populated, then the assigned ID value is queried and finally the "sub-table" is populated using the correct ID (9 in the case of version 5.2.12 and 10 for version 5.2.17).