Feature Requests item #2778533, was opened at 2009-04-22 13:56 Message generated for change (Tracker Item Submitted) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2778533&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 - general Group: None Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Nobody/Anonymous (nobody) Summary: Use UNIQUE instead of Group By Initial Comment: #update(sys.node_tags, #| project ( #| | left outer join ( #| | | table(sys.node_tags) [ node_tags.node, node_tags.k, node_tags.v, node_tags.vlen, node_tags.%TID% NOT NULL ], #| | | group by ( #| | | | table(sys.node_tags) [ node_tags.node as y.node, node_tags.k as y.k, node_tags.v as y.v, node_tags.vlen as y.vlen, node_tags.%TID% NOT NULL as y.%TID% ] #| | | ) [ y.node as L1.node, y.k as L1.k, y.v as L1.v ] [ y.node as L1.node, y.k as L1.k, y.v as L1.v, zero_or_one(length(y.v)) NOT NULL as L2 ] #| | ) [ node_tags.node = L1.node, node_tags.k = L1.k, node_tags.v = L1.v ] #| ) [ node_tags.%TID% NOT NULL, L2 NOT NULL as L3.L3 ] #) [ node_tags.vlen NOT NULL ] This could use the unique property instead of group by. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2778533&group_id=56967 ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
