Bugs item #2679525, was opened at 2009-03-10 17:26 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=2679525&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 CVS Head Status: Open Resolution: None Priority: 5 Private: Yes Submitted By: Jens Oehlschlägel (jens_oehl) Assigned to: Niels Nes (nielsnes) Summary: HAVING returns row with NULLs instead of empty result set Initial Comment: NOTE: relates to RequestIDs 2679457 and 2679434 Niels, The following query returns a row with NULLs instead of an empty result set. This was my entry point to the tri-boolean investigation. Stefan, please put the problem and its workaround into our autotest repository Cheers Jens sql>-- autotest #93 tri-boolean problem 0 tuples sql>SELECT sum(DT_VOLUME) as volume, sum(DT_D00) as vStart, sum(DT_C01_01) as VB01, sum(DT_C02_01) as VB02, sum(DT_C03_0 1) as VB03, sum(DT_C04_01) as VB04, sum(DT_C05_01) as VB05 FROM voc.q_SourceExplorer WHERE (DT_CURR='USD') AND (DT_UOM= 'kg') AND ( (PostingYear=2006) AND (PostingWeek=8) ) more>HAVING sum(DT_VOLUME) > 0 more>; +----------+----------+----------+----------+----------+----------+-----------+ | volume | vstart | vb01 | vb02 | vb03 | vb04 | vb05 | +==========+==========+==========+==========+==========+==========+===========+ | null | null | null | null | null | null | null | +----------+----------+----------+----------+----------+----------+-----------+ 1 tuple sql> 0 tuples sql>-- autotest #94 tri-boolean workaround 0 tuples sql>SELECT sum(DT_VOLUME) as volume, sum(DT_D00) as vStart, sum(DT_C01_01) as VB01, sum(DT_C02_01) as VB02, sum(DT_C03_0 1) as VB03, sum(DT_C04_01) as VB04, sum(DT_C05_01) as VB05 FROM voc.q_SourceExplorer WHERE (DT_CURR='USD') AND (DT_UOM= 'kg') AND ( (PostingYear=2006) AND (PostingWeek=8) ) more>HAVING sum(DT_VOLUME) IS NOT NULL more> AND sum(DT_VOLUME) > 0 more>; !relational query without result 0 tuples ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2679525&group_id=56967 ------------------------------------------------------------------------------ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
