Unable to load inet network addresses using COPY INTO

24 Dec 2014

      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

Unable to load inet network addresses using COPY INTO

Tim Burress