[ 
https://issues.apache.org/jira/browse/ASTERIXDB-2391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16502559#comment-16502559
 ] 

ASF subversion and git services commented on ASTERIXDB-2391:
------------------------------------------------------------

Commit ee247bb5453537128c003fc54b11850cc3c53102 in asterixdb's branch 
refs/heads/master from Steven Glenn Jacobs
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=ee247bb ]

[ASTERIXDB-2391][SQL] Insure that var for return clause gets optimized

Places the variable created for the return clause below the insert
so future optimizations can work on this variable

Added test

Change-Id: Id285435c4dc8a603c60b177dacd9f09722faac21
Reviewed-on: https://asterix-gerrit.ics.uci.edu/2689
Sonar-Qube: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Reviewed-by: Dmitry Lychagin <dmitry.lycha...@couchbase.com>


> 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
>            Assignee: 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)

Reply via email to