asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Jacobs <>
Subject inserting into an autogenerated key dataset from a query result
Date Tue, 19 Sep 2017 17:08:01 GMT
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:

drop dataverse channels if exists;
create dataverse channels;
use channels;
create type result as {
create type subscriptionType as {
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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message