[ASTERIXDB-1493] Upsert won't insert the record with the autogenerated id

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: MTD - Metadata, STO - Storage
• Environment: commit fd1d460da73397de9f44d7b098543f7897844794; Date: Wed Jun 15 11:29:36 2016 -0400
• Assignee: Xikui Wang
• Reporter: Jianfeng Jia
• Created: 22/Jun/16 06:44
• Updated: 17/Apr/17 22:44
• Resolved: 14/Apr/17 21:21

Description

AQL

use dataverse twitter
drop dataset twitter.ds_tweet_d41d8cd98f00b204e9800998ecf8427e if exists

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"}])

error msg:

type mismatch: missing a required closed field id:uuid [IllegalStateException]

It works if using `insert`.