SELECT INTO in rasql

[Dimitar Misev]

It would be helpful if rasql supports a SELECT INTO construct that would allow to directly insert the result of a SELECT query into a specified collection. The syntax in SQL which can be adopted by rasql too is

SELECT generalExp
INTO   newCollection
FROM   collectionList
[ WHERE ... ]

[Peter Baumann]

also, adding TEMPORARY is something useful: keep until end of transaction. Internally, this mechanism could be used for mixed query processing in future.

[Peter Baumann]

also, adding TEMPORARY is something useful: keep until end of transaction. Internally, this mechanism could be used for mixed query processing in future.

[Dimitar Misev]

TEMPORARY would only be useful in the implementation of nested queries I suppose?

[Dimitar Misev]

Fixed in changeset:ebe14b8

[Dimitar Misev]

The patch extends the SELECT statement to include an INTO clause, I believe the ticket description is all the documentation needed.

The type of the new collection is automatically created and everything is automatically set up. If a collection already exists then the new MDD is added to it, unless the types don't match in which case an error is thrown.

Scalar results can not be inserted with a SELECT/INTO, this only works with MDD results.