[
https://issues.apache.org/jira/browse/ASTERIXDB-1493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jianfeng Jia updated ASTERIXDB-1493:
------------------------------------
Description:
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`.
was:
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`.
> 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
>
> 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.4#6332)
