Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When having multiple selections combined with aliases not all of them seem to be evalauted. #3511

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant