Absolute network paths considered invalid for COPY INTO ... FROM statement.

[monetdb-team]

Date: 2014-04-09 18:00:08 +0200
From: Edward Clarkson <<edward.clarkson>>
To: clients devs <>
Version: 11.17.13 (Jan2014-SP1)

Last updated: 2014-05-22 09:52:34 +0200

Comment 19739

Date: 2014-04-09 18:00:08 +0200
From: Edward Clarkson <<edward.clarkson>>

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_2) AppleWebKit/537.75.14 (KHTML, like Gecko) Version/7.0.3 Safari/537.75.14
Build Identifier:

[I selected ODBC, but I know it's present in mclient and wouldn't be surprised if it were on all client interfaces]

Windows network paths look can look like \network-share\path\to\file, but this format is rejected as not an absolute path by the client, e.g.,:

[MonetDB][ODBC Driver 11.17,13] COPY INTO: filename must have absolute path: \vmware-host\Documents\Datasets\baseballdata.csv

You can work around this by mapping the path to a drive letter, but that seems unnecessary, and on systems the user doesn't have the right admin rights, not possible.

Reproducible: Always

Steps to Reproduce:

1. COPY INTO dummy FROM '\dummyserver\test';

Actual Results:

Path rejected prior to SQL parsing as an invalid absolute path.

Expected Results:

SQL parsed (above statement would be rejected b/c the table or file doesn't exist).

Comment 19768

Date: 2014-04-24 15:10:14 +0200
From: MonetDB Mercurial Repository <>

Changeset ae468c8d6e55 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=ae468c8d6e55

Changeset description:

Accept UNC paths as absolute path in Windows.
This fixes bug #3469.

Comment 19787

Date: 2014-04-30 10:26:07 +0200
From: @sjoerdmullender

I believe this is fixed now.