Bugs item #2155606, was opened at 2008-10-09 15:11
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2155606&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL 2.24
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Peter M. Murray (yarrumretep)
Assigned to: Niels Nes (nielsnes)
Summary: GROUP BY query returns no results
Initial Comment:
In trying to emulate the SQL:2003 WITH CUBE clause by permuting group by
elements and joining multiple selects with UNION ALL, we ran into this issue.
It seems that when using NULL in the select statement to align the columns for
UNION ALL, the queries sometimes return no results or erroneous results. Here
is a small SQL script that illustrates this:
create table testola (color varchar(128), count integer);
insert into testola values ('blue', 12);
insert into testola values ('red', 2);
select color, null, sum(count) from testola group by color;
I would expect the results to be:
blue, null, 12
red, null, 2
but instead monetdb returns no results for this query. If you remove the null,
it works fine.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2155606&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
