I found that the nightly stable build of MonetDB5/sql apparently does not like empty values in tbl text records for importing when using Copy Into, even though the field is defined to allow nulls.
This is different behavior compared to the RELEASE version, which did allow this.
Please allow me to explain...
I have a text file like this: field1|field2||
My db has defined field 1 and 2 as varchar null, and field 3 as INT null.
When I run the Copy Into command on the nightly stable, it errors out with this:
' from line 0 field 3 not inserted, expecting type int !SQLException:importTable:failed to import table
As a quick test I edited the first line of my text file to insert a fake integer into the 3rd field like this: field1|field2|12345|
Then I reran the Copy Into command, this time it errored out on the SECOND line (even those it says line 1 it is really 0 index based so its line 2): ' from line 1 field 3 not inserted, expecting type int !SQLException:importTable:failed to import table
So it was happy when I inserted the fake data for the field and does not like rows that are empty. Again, this column is defined as int NULL.
Was this change intentional? If not I think there is a bug there.
How can I important my text file that has many nulls in it, short of going back to the released version, which I cannot do due to problems with that earlier version. Thank you.