left shift for IP addresses not available to non-system users

[monetdb-team]

Date: 2015-05-28 21:01:37 +0200
From: Raffy <>
To: SQL devs <>
Version: 11.19.11 (Oct2014-SP3)
CC: @njnes

Last updated: 2015-06-22 22:32:17 +0200

Comment 20898

Date: 2015-05-28 21:01:37 +0200
From: Raffy <>

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Firefox/38.0
Build Identifier:

As a non-system user on a non-system schema, using the left_shift does not work:

select * from ip_range where ip << inet '10.0.0.0/8’
SELECT: no such binary operator 'left_shift(inet,inet)'

Doing the same table as moentdb user with the same query, works as intended.

Workaround that works:

select * from test where sys.left_shift(a, inet '10.0.0.0/8');

Reproducible: Always

Steps to Reproduce:

use a non system user and a non-sys schema

create table test (a inet);
insert into test (a) values ('10.0.0.1’);
select * from test where a << inet '10.0.0.0/8’;
SELECT: no such binary operator 'left_shift(inet,inet)'

Comment 20901

Date: 2015-06-02 13:51:03 +0200
From: @njnes

fixed, we now always pass the proper schema info (ie sys).