Hello,
I'm using MonetDB Oct2014-SP1 and have run into another problem with the inet datatype. When the data value is a network specification (address + prefix length in CIDR notation), it is possible to insert/update values using INSERT or UPDATE, but COPY INTO fails. For example, the following works fine:
create "testing" ( network inet ); insert into "testing" values('192.168.0.1/24');
However if you create a file for bulk loading:
copy 1 records into "sys"."testing" from stdin using delimiters '\t','\n','"' 192.168.0.1
and then try to load it, it fails:
mclient -d test <testing.dmp value '192' from line 1 field 1 not inserted, expecting type inet failed to import table
It seems like the parser for COPY INTO has a problem. Thus, among other things, it's impossible to use msqldump to save the content of a table and then restore it.
This also has big impact on my application at least, since individual inserts take much longer than COPY INTO.
Just thought I'd let you know!
Tim