-
-
Notifications
You must be signed in to change notification settings - Fork 85
Open
Description
ArcadeDB Version 25.1.1
Inserting into a bucket via a sub-query reports inserted records but they don't exists, ie:
CREATE DOCUMENT TYPE src;
INSERT INTO src SET name = 'Hi';
CREATE DOCUMENT TYPE doc BUCKET doc;
INSERT INTO BUCKET:doc FROM (SELECT name FROM src); -- This fails silently
SELECT FROM BUCKET:doc; -- This returns 0 recordsThis (without BUCKET) works as expected:
CREATE DOCUMENT TYPE src;
INSERT INTO src SET name = 'Hi';
CREATE DOCUMENT TYPE doc BUCKET doc;
INSERT INTO doc FROM (SELECT name FROM src);
SELECT FROM doc; -- This returns 1 recordThis reports: Error on command execution (PostCommandHandler): Cannot update a record in a custom bucket:
CREATE DOCUMENT TYPE doc BUCKET doc, src;
INSERT INTO BUCKET:src SET name = 'Hi';
INSERT INTO BUCKET:doc FROM (SELECT name FROM BUCKET:src);Metadata
Metadata
Assignees
Labels
No labels