Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
Date: Fri, 14 Apr 2017 22:20:42 +0000 (UTC)
From: "Xikui Wang (JIRA)" <jira@apache.org>
To: notifications@asterixdb.incubator.apache.org
Message-ID: <JIRA.12981787.1466577885000.287853.1492208442171@Atlassian.JIRA>
In-Reply-To: <JIRA.12981787.1466577885000@Atlassian.JIRA>
References: <JIRA.12981787.1466577885000@Atlassian.JIRA> <JIRA.12981787.1466577885198@jira-lw-us.apache.org>
Subject: [jira] [Commented] (ASTERIXDB-1493) Upsert won't insert the record
 with the autogenerated id
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 14 Apr 2017 22:20:47 -0000


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

Xikui Wang commented on ASTERIXDB-1493:
---------------------------------------

[~imaxon] It's not. I just tried on the latest one. The patch that I submitted only resolves the feed uuid issue. Investigating this one now. 

> 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: Xikui Wang
>
> AQL 
> {code}
> 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"}])
> {code}
> error msg: 
> {code}
> type mismatch: missing a required closed field id:uuid [IllegalStateException]
> {code}
> It works if using `insert`.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)