[jira] [Updated] (ASTERIXDB-2391) IntroduceDynamicTypeCastRule doesn't propagate through insert

["Steven Jacobs (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Jacobs updated ASTERIXDB-2391:
-------------------------------------
    Description: 
This makes it so returning clauses refer to non-existent variables. Can be reproduced buy the following:

 

drop dataverse channels if exists;
 create dataverse channels;
 use channels;

create type sub as

{ subscriptionId: uuid }

;

create dataset subscriptions(sub) primary key subscriptionId;

upsert into subscriptions as record(
 [\{"subscriptionId":create_uuid()}]
) returning record.subscriptionId;

 

  was:
This makes it so returning clauses refer to non-existent variables. Can be reproduced buy the following:

 

drop dataverse channels if exists;
create dataverse channels;
use channels;

create type sub as {
 subscriptionId: uuid
};

create dataset subscriptions(sub) primary key subscriptionId;

upsert into subscriptions as record(
(let v = (select value s from subscriptions s where param0 = "HenryGale")
select value (CASE (array_count(v) > 0) 
WHEN true THEN \{"subscriptionId":v[0].subscriptionId, "param0": v[0].param0,"brokerSubscriptions":v[0].brokerSubscriptions} 
ELSE \{"subscriptionId":create_uuid(), "param0": "HenryGale", "brokerSubscriptions":[{"brokerSubscriptionId":create_uuid(), "brokerDataverse":"dataverse1","brokerName":"broker1"}]} 
END))
) returning record.brokerSubscriptions;

 


> IntroduceDynamicTypeCastRule doesn't propagate through insert
> -------------------------------------------------------------
>
>                 Key: ASTERIXDB-2391
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2391
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>            Reporter: Steven Jacobs
>            Priority: Major
>
> This makes it so returning clauses refer to non-existent variables. Can be reproduced buy the following:
>  
> drop dataverse channels if exists;
>  create dataverse channels;
>  use channels;
> create type sub as
> { subscriptionId: uuid }
> ;
> create dataset subscriptions(sub) primary key subscriptionId;
> upsert into subscriptions as record(
>  [\{"subscriptionId":create_uuid()}]
> ) returning record.subscriptionId;
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)