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 

Unable to load inet network addresses using COPY INTO

Tim Burress