On November 13, 2014 2:32:27 AM CET, Tim Burress <tim@variosecure.net> wrote:

Hello,

I'm a relatively new user and have run into a problem which may just be
a misunderstanding. I'm using the Oct2014 version, installed on Fedora
20 from the MonetDB rpm repository. When I try to query a database using
inet "containment" operators like << or <<= it seems that the operators
are not recognized:

sql> select src,dst from raw.ids where src << inet'xxx.xxx.xxx.xxx/27';
SELECT: no such binary operator 'left_shift(inet,inet)'

sql> select src,dst from raw.ids where src <<= inet'xxx.xxx.xxx.xxx/27';
syntax error, unexpected '=' in: "select src,dst from raw.ids where src <<="

Other ordinary binary inet operators seem OK:

sql> select src,dst from raw.ids where src = inet'xxx.xxx.xxx.xxx';
(prints out table)
sql> select src,dst from raw.ids where src < dst;
(prints out table)

However the documented
functions do not seem to be recognized:

sql> select masklen(inet'192.168.0.0/24')
SELECT: no such unary operator 'masklen(inet)'
sql> select netmask(inet'192.168.0.0/24')
SELECT: no such unary operator 'netmask(inet)'

So it seems that support for network address types is only partially
available in this release. Is that normal? Do I need to rebuild from
source in order to get them?

Thanks!

Tim





users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list