Note that this works on the release from a couple of weeks ago, so this is a regression that got missed by our tests (surprise!) it seems.

On 9/19/17 10:08 AM, Steven Jacobs wrote:
Hi all,
I'm seeing a strange issue when inserting into a dataset with an
autogenerated key the result of a query. I was wondering if anyone has had
success with such a case. I have a simple example below which fails on
master (The full JIRA issue is here:
https://issues.apache.org/jira/browse/ASTERIXDB-2101)


drop dataverse channels if exists;
create dataverse channels;
use channels;
create type result as {
   id:uuid
};
create type subscriptionType as {
   subscriptionId:uuid,
   param0:int
};
create dataset roomRecordsResults(result)
primary key id autogenerated;
create dataset roomRecordsSubscriptions(subscriptionType)
primary key subscriptionId autogenerated;
use channels;
insert into channels.roomRecordsResults (
   select sub.subscriptionId
   from channels.roomRecordsSubscriptions sub
);


Reply via email to