[jira] [Issue Comment Deleted] (ASTERIXDB-1261) Tables with auto generated keys return incorrect key values nondeterministically

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

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Jacobs updated ASTERIXDB-1261:
-------------------------------------
    Comment: was deleted

(was: The first result is wrong.)

> Tables with auto generated keys return incorrect key values nondeterministically
> --------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-1261
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1261
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Steven Jacobs
>         Attachments: Screen Shot 2016-01-12 at 4.28.42 PM.png
>
>
> When returning tuples from a dataset with an auto generated key, the value for the primary key field sporadically gets mixed up. It seems to be very infrequent, so I'm unsure whether it is on the storage layer or the record parsing layer. To produce, first run this AQL:
> drop dataverse channels if exists;
> create dataverse channels;
> use dataverse channels;
> create type TypeA as closed
> { "resultId":uuid, "subscriptionId":uuid, "deliveryTime":datetime }
> create dataset nearbyTweetChannelResults(TypeA) primary key resultId auto generated;
> insert into dataset nearbyTweetChannelResults(
> {"subscriptionId":uuid("d0b6fac0-3903-43dc-8ef6-7b0923ffc759"), "deliveryTime":datetime("2011-08-25T10:10:00.000Z")}
> );
> Next, run the following AQL repeatedly. It should change within 20 or so times.
> use dataverse channels;
> for $result in dataset nearbyTweetChannelResults
> return $result.resultId;
> for $result in dataset nearbyTweetChannelResults
> return $result.resultId;
> for $result in dataset nearbyTweetChannelResults
> return $result.resultId;
> I have a screenshot of a failed instance that I will try to attach.



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