You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)'
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).
The text was updated successfully, but these errors were encountered: