Opened 7 years ago

Last modified 6 years ago

#1759 closed enhancement

FROM clause in UPDATE statement — at Initial Version

Reported by: Dimitar Misev Owned by:
Priority: critical Milestone: 9.7
Component: qlparser Version: development
Keywords: Cc: Peter Baumann, Bang Pham Huu, Vlad Merticariu, bbell
Complexity: Medium

Description

It is not possible to perform UPDATE query on coll A based on the values of coll B, i.e. something like

UPDATE A SET A[..]
ASSIGN B
WHERE oid(B) = ..

What's missing in the syntax is support for an optional FROM clause, so we can say

UPDATE A SET A[..]
ASSIGN B
FROM B
WHERE oid(B) = ..

Change History (0)

Note: See TracTickets for help on using tickets.