[jira] [Commented] (ASTERIXDB-1493) Upsert won't insert the record with the autogenerated id

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

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

Steven Jacobs commented on ASTERIXDB-1493:
------------------------------------------

I'm guessing this throws an error? Is this a problem in general with auto generated keys and upsert, or just a specific bug?

> Upsert won't insert the record with the autogenerated id
> --------------------------------------------------------
>
>                 Key: ASTERIXDB-1493
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1493
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: Metadata, Storage
>         Environment: commit fd1d460da73397de9f44d7b098543f7897844794
> Date:   Wed Jun 15 11:29:36 2016 -0400
>            Reporter: Jianfeng Jia
>            Assignee: Ian Maxon
>
> use dataverse twitter
> drop dataset twitter.ds_tweet_d41d8cd98f00b204e9800998ecf8427e if exists
> AQL 
> {code}
> create type autoType if not exists as open {
>   id: uuid
> }
> create dataset twitter.ds_tweet_d41d8cd98f00b204e9800998ecf8427e(autoType) if not exists primary key id autogenerated;
> upsert into dataset twitter.ds_tweet_d41d8cd98f00b204e9800998ecf8427e 
> ( [ { "fa": "x", "fb":"y"}, {"fa":"u", "fb":"w"}])
> {code}
> It works if using `insert`.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)