Feature Requests item #2776184, was opened at 2009-04-20 15:09 Message generated for change (Comment added) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2776184&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: None Group: None >Status: Closed Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: Update using JOIN Initial Comment: UPDATE p SET p.col1 = p.col1 + q.otherCol FROM table1 AS p join table2 AS q ON p.fk_table2_pk = q.pk WHERE q.filterColumn = 'something' The above should allow bulk processing ot updates. I have tranlated it to the following query; create table test3(id integer, hoi integer); create table test4(id integer, hoi integer); insert into test3 values (1, 2); insert into test4 values (1, 3); This works: update test3 set hoi = (select hoi from test4 where test3.id = test4.id); I expect this should have better performance, if it would be supported: update test3 set test3.hoi = test4.hoi from test3 join test4 on test3.id = test4.id; ---------------------------------------------------------------------- >Comment By: Stefan de Konink (skinkie) Date: 2009-04-20 15:39 Message: Shame on me... it is already by design; #update(sys.test3a, #| project ( #| | left outer join ( #| | | table(sys.test3a) [ test3a.id, test3a.hoi, test3a.%TID% NOT NULL ], #| | | group by ( #| | | | table(sys.test4a) [ test4a.id, test4a.hoi, test4a.%TID% NOT NULL ] #| | | ) [ test4a.id as L1.id ] [ test4a.id as L1.id, zero_or_one(test4a.hoi) NOT NULL as L2 ] #| | ) [ test3a.id = L1.id ] #| ) [ test3a.%TID% NOT NULL, L2 NOT NULL as L3.L3 ] #) [ test3a.hoi NOT NULL ] ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2776184&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
