asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Carey <dtab...@gmail.com>
Subject Re: inserting into an autogenerated key dataset from a query result
Date Tue, 19 Sep 2017 17:49:06 GMT
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
> );
>


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