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
Using the Jul2017-SP2 release candidate,
in the below example,
the first query works fine,
while the second one fails with "SELECT: identifier 'c' unknown",
which it IMHO should not.
start transaction;
create table "t" ( "c" int );
insert into "t" values (1),(2);
select * from "t";
-- works fine:
select
(
sum(
("c" - (select avg("c") from "t"))
*
("c" - (select avg("c") from "t"))
)
-- /
-- (select count("c") from "t")
)
/
(
stddev_pop(c)
*
stddev_pop(c)
)
/
(select count("c") from "t")
from
"t"
;
-- FAILS with "SELECT: identifier 'c' unknown"
select
(
sum(
("c" - (select avg("c") from "t"))
*
("c" - (select avg("c") from "t"))
)
/
(select count("c") from "t")
)
/
(
stddev_pop(c)
*
stddev_pop(c)
)
-- /
-- (select count("c") from "t")
from
"t"
;
fixed, we now keep the value returning 'relational expressions' in a dag of seperate relational operators (not a one big relation). This simplifies a lot (more simplification is still required)
Date: 2017-10-22 19:22:38 +0200
From: @drstmane
To: SQL devs <>
Version: 11.27.5 (Jul2017-SP1)
CC: @njnes
Last updated: 2017-12-14 14:46:03 +0100
Comment 25783
Date: 2017-10-22 19:22:38 +0200
From: @drstmane
Using the Jul2017-SP2 release candidate,
in the below example,
the first query works fine,
while the second one fails with "SELECT: identifier 'c' unknown",
which it IMHO should not.
start transaction;
create table "t" ( "c" int );
insert into "t" values (1),(2);
select * from "t";
-- works fine:
select
(
sum(
("c" - (select avg("c") from "t"))
*
("c" - (select avg("c") from "t"))
)
-- /
-- (select count("c") from "t")
)
/
(
stddev_pop(c)
*
stddev_pop(c)
)
/
(select count("c") from "t")
from
"t"
;
-- FAILS with "SELECT: identifier 'c' unknown"
select
(
sum(
("c" - (select avg("c") from "t"))
*
("c" - (select avg("c") from "t"))
)
/
(select count("c") from "t")
)
/
(
stddev_pop(c)
*
stddev_pop(c)
)
-- /
-- (select count("c") from "t")
from
"t"
;
rollback;
Comment 25908
Date: 2017-11-26 10:05:38 +0100
From: @njnes
fixed, we now keep the value returning 'relational expressions' in a dag of seperate relational operators (not a one big relation). This simplifies a lot (more simplification is still required)
Comment 25909
Date: 2017-11-26 10:06:33 +0100
From: MonetDB Mercurial Repository <>
Changeset df058ebf2575 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=df058ebf2575
Changeset description:
The text was updated successfully, but these errors were encountered: