Column default values like '' or false aren't used when a value is omitted for that column.
For example, if I have a table foo with a column bar that has a default value of '', and I don't provide a value for bar in my call to bulk_insert, the newly-inserted row will have a bar value of NULL, and not '' like I expect.
The issue seems to be the use of #present? to determine a column has a default value:
|
if column.default.present? |
Column default values like
''orfalsearen't used when a value is omitted for that column.For example, if I have a table
foowith a columnbarthat has a default value of'', and I don't provide a value forbarin my call tobulk_insert, the newly-inserted row will have abarvalue ofNULL, and not''like I expect.The issue seems to be the use of
#present?to determine a column has a default value:bulk_insert/lib/bulk_insert/worker.rb
Line 50 in 3ded6b0