SQL UPDATE against collections and maps [moved]

[lvca]

This is Issue 91 moved from a Google Code project.
Added by 2010-08-02T08:27:30.000Z by l.garu...@gmail.com.
Please review that bug for more context and additional comments, but update this bug.
Closed (Fixed).

Original labels: Type-Enhancement, Priority-High, v0.9.22, sql

Original description

Unfortunately the UPDATE command doesn't work yet on field that are collections or maps.

We need a simple way to add and remove items to/from collections and maps.

I'm thinking to a syntax like:

> UPDATE add father = 16:3 where firstname = 'Donald' and lastname = 'Duck'

For all the records that satisfy the condition(s) add the item 16:3 into the collection "father".

and

UPDATE remove father = 16:3 where firstname = 'Donald' and lastname = 'Duck'

For all the records that satisfy the condition(s) remove the item 16:3 from the collection "father".

For maps it could be:

UPDATE add father = 'Bob', 16:3 where firstname = 'Donald' and lastname = 'Duck'

and

UPDATE remove father = 'Bob' where firstname = 'Donald' and lastname = 'Duck'