asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Jacobs <sjaco...@ucr.edu>
Subject Re: inserting into an autogenerated key dataset from a query result
Date Tue, 19 Sep 2017 18:20:47 GMT
Apologies, this appears to be only happening on my local copy of master.
I've cleaned and rebuilt several times and still can't get it to resolve
locally, but it seems to be my problem and not the code base.
Steven

On Tue, Sep 19, 2017 at 10:49 AM, Mike Carey <dtabass@gmail.com> wrote:

> 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