Date: 2016-08-25 16:56:48 +0200
From: @swingbit
To: SQL devs <>
Version: 11.23.7 (Jun2016-SP1)
CC: @njnes

Last updated: 2016-10-13 10:03:37 +0200

Comment 22325

Date: 2016-08-25 16:56:48 +0200
From: @swingbit

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
Build Identifier:

Geom with user 'monetdb'

$ bin/mclient test
user(roberto):monetdb
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Jun2016-SP1)
Database: MonetDB v11.23.7 (Jun2016-SP1), 'mapi:monetdb://photon.hq.spinque.com:50000/test'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>\f tab
sql>select st_point(1,1);
POINT (1 1)

-- Create user 'roberto'
sql>CREATE USER "roberto" WITH UNENCRYPTED PASSWORD 'roberto' NAME 'roberto' SCHEMA "sys";
operation successful (28.601ms)

Geom with user 'roberto' (still in 'sys' schema)
$ bin/mclient test
user(roberto):roberto
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Jun2016-SP1)
Database: MonetDB v11.23.7 (Jun2016-SP1), 'mapi:monetdb://photon.hq.spinque.com:50000/test'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>\f tab
sql>select st_point(1,1);
MAPI = (roberto) /tmp/.s.monetdb.50000
QUERY = select st_point(1,1);
ERROR = !SELECT: no such binary operator 'st_point(tinyint,tinyint)'

Reproducible: Always

Comment 22336

Date: 2016-08-30 13:16:49 +0200
From: MonetDB Mercurial Repository <>

Changeset d9f855efe1f6 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=d9f855efe1f6

Changeset description:

Grant access to all geom functions and tables to public.
This fixes bug #4059.

Comment 22337

Date: 2016-08-30 13:56:41 +0200
From: @sjoerdmullender

Work around for the problem until the next release is published:

get the source of MonetDB [1], then execute:

grep '^GRANT' geom/sql/40_geom.sql | mclient -d $DBNAME

where $DBNAME is the name of the database.

[1] hg clone -u Jun2016 http://dev.monetdb.org/hg/MonetDB/; cd MonetDB

Comment 24486

Date: 2016-10-13 10:03:37 +0200
From: @sjoerdmullender

Jun2016-SP2 has been released.