Date: 2020-03-26 23:28:24 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.35.19 (Nov2019-SP3)
CC: @PedroTadim

Last updated: 2020-10-19 11:06:20 +0200

Comment 27628

Date: 2020-03-26 23:28:24 +0100
From: Martin van Dinther <<martin.van.dinther>>

User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:74.0) Gecko/20100101 Firefox/74.0
Build Identifier:

The function sys.getcontent(url) always returns error "Feature not supported".
It has not been implemented, see monetdb5/modules/atoms/url.c lines 393-400.

It is better to remove this function from the list of functions in sys.functions
(so also from sql/scripts/12_url.sql and monetdb5/modules/atoms/url.mal) as it is not usefull. I do not expect it will ever be implemented.

Reproducible: Always

Steps to Reproduce:

select sys.getcontent(url 'https://www.monetdb.org/Home');

select * from sys.functions where name = 'getcontent' and mod = 'url' and schema_id = 2000 and system;

Actual Results:

sql>select sys.getcontent(url 'https://www.monetdb.org/Home');
Feature not supported
sql>
sql>select * from sys.functions where name = 'getcontent' and mod = 'url' and schema_id = 2000 and system;
+------+------------+---------------------------------------------------+------+------+------+-------+-------+-------+------+-------+
| id | name | func | mod | lang | type | side_ | varre | varar | sche | syste |
: : : : : uage : : effec : s : g : ma_i : m :
: : : : : : : t : : : d : :
+======+============+===================================================+======+======+======+=======+=======+=======+======+=======+
| 5087 | getcontent | create function getcontent(theurl url) returns st | url | 1 | 1 | false | false | false | 2000 | true |
: : : ring : : : : : : : : :
: : : external name url."getContent"; : : : : : : : : :
+------+------------+---------------------------------------------------+------+------+------+-------+-------+-------+------+-------+
1 tuple
sql>

Expected Results:

function sys.getcontent() removed from the system

I will adapt the documentation on
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype

Comment 27853

Date: 2020-06-15 18:10:33 +0200
From: MonetDB Mercurial Repository <>

Changeset f3537e77b80b made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=f3537e77b80b

Changeset description:

Removed obsolete sys.getContent(url) function. This fixes bug #6843