[ 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)