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
Date: 2014-12-25 00:21:21 +0100
From: K <>
To: SQL devs <>
Version: 11.19.7 (Oct2014-SP1)
CC: @njnes
Last updated: 2015-05-07 12:37:54 +0200
Comment 20547
Date: 2014-12-25 00:21:21 +0100
From: K <>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0
Build Identifier:
The 'inet' data type is documented as supporting certain binary operators such as << or <<= (to indicate subnet membership) in WHERE clauses, however these operators are not recognized as such by the command parser. Instead the << is interpreted as a left shift operator, and <<= is flagged as a syntax error.
The code for these operators does appear in monetdb5/modules/atoms/inet.c, but somehow it seems that calls to the functions are missing in the parser code. Note however that other operators (such as =, <, >, etc) are handled correctly.
Date: 2014-12-25 00:21:21 +0100
From: K <>
To: SQL devs <>
Version: 11.19.7 (Oct2014-SP1)
CC: @njnes
Last updated: 2015-05-07 12:37:54 +0200
Comment 20547
Date: 2014-12-25 00:21:21 +0100
From: K <>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0
Build Identifier:
The 'inet' data type is documented as supporting certain binary operators such as << or <<= (to indicate subnet membership) in WHERE clauses, however these operators are not recognized as such by the command parser. Instead the << is interpreted as a left shift operator, and <<= is flagged as a syntax error.
Reproducible: Always
Steps to Reproduce:
Actual Results:
SELECT: no such binary operator 'left_shift(inet,inet)'
syntax error, unexpected '=' in: "select inet'192.168.0.1' <<=
Expected Results:
true
true
The code for these operators does appear in monetdb5/modules/atoms/inet.c, but somehow it seems that calls to the functions are missing in the parser code. Note however that other operators (such as =, <, >, etc) are handled correctly.
Comment 20651
Date: 2015-02-11 18:35:38 +0100
From: @njnes
added support for scanning <<= and >>=. Added the create function statements for <<(inet,int), >>(inet,inet) etc.
Comment 20652
Date: 2015-02-11 18:37:54 +0100
From: MonetDB Mercurial Repository <>
Changeset 7bd0698c0cdd made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=7bd0698c0cdd
Changeset description:
Comment 20667
Date: 2015-02-19 14:28:56 +0100
From: MonetDB Mercurial Repository <>
Changeset e14ed64aa17e made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=e14ed64aa17e
Changeset description:
The text was updated successfully, but these errors were encountered: