Date: 2014-07-14 16:04:29 +0200
From: @alvanaki
To: SQL devs <>
Version: 11.17.17 (Jan2014-SP2)
CC: @njnes

Last updated: 2015-05-08 10:29:01 +0200

Comment 19900

Date: 2014-07-14 16:04:29 +0200
From: @alvanaki

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
Build Identifier:

I try to evaluate two functions contains(smallc, bigc) and contains(bigc, smallc). When the functions are evaluated in the same query i.e. SELECT contains(smallc, bigc), contains(bigc, smallc) the results are correct. However, if I use aliases for the results, i.e. SELECT contains(smallc, bigc) AS smallcontainsbig, contains(bigc, smallc) AS bigcontainssmall, the result for both functions is the same; that of the first function.

Reproducible: Always

Steps to Reproduce:

1. SELECT contains(smallc, bigc) AS smallcontainsbig, contains(bigc, smallc) AS bigcontainssmall FROM (SELECT Buffer(GeomFromText('POINT(1 2)', 0), 10) As smallc, Buffer(GeomFromText('POINT(1 2)', 0), 20) As bigc) As foo;

Actual Results:

false false

Expected Results:

false true

mserver5 --version gave the following result

MonetDB 5 server v11.17.18 (64-bit, 64-bit oids)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 15.4GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.33 2013-05-28 (compiled with 8.33)
openssl: OpenSSL 1.0.1e 11 Feb 2013 (compiled with OpenSSL 1.0.1e-fips 11 Feb 2013)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: alvanaki@sibuyan.da.cwi.nl (x86_64-unknown-linux-gnu)
Compilation: gcc -g -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code
Linking : /usr/bin/ld -m elf_x86_64

Comment 19980

Date: 2014-08-06 19:02:59 +0200
From: @njnes

fixed bug in rel_select_cse/rel_project_cse.

Comment 19988

Date: 2014-08-06 19:12:38 +0200
From: MonetDB Mercurial Repository <>

Changeset 516d270cbe32 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=516d270cbe32

Changeset description:

fixed bugs 3505 and 3511

Comment 20095

Date: 2014-08-26 11:16:44 +0200
From: MonetDB Mercurial Repository <>

Changeset cefa75ee2806 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=cefa75ee2806

Changeset description:

test bug_in_cse.Bug-3511 requires GEOM

Comment 20390

Date: 2014-10-31 14:14:46 +0100
From: @sjoerdmullender

Oct2014 has been released.

Comment 20856

Date: 2015-05-08 10:29:01 +0200
From: MonetDB Mercurial Repository <>

Changeset 182bb4a55f21 made by Foteini Alvanaki foteini.alvanaki@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=182bb4a55f21

Changeset description:

bug_in_cse.Bug-3511 updated