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.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
