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

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

Steven Jacobs created ASTERIXDB-1261:
----------------------------------------

             Summary: 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


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)