Bugs item #2776184, was opened at 2009-04-20 15:09 Message generated for change (Tracker Item Submitted) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&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: SQL/Core Group: MonetDB5 CVS Head Status: Open Resolution: None 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; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&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
