Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working Client interfaces minor

Comments

@monetdb-team
Copy link

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.

@monetdb-team monetdb-team added bug Something isn't working Client interfaces minor labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Client interfaces minor
Projects
None yet
Development

No branches or pull requests

2 participants