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