What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

Possible Duplicate:
Edit history may become out of order if suggested edit was approved with improvements

I recently improved an edit suggested on this answer. The edit can be seen here, and is reflected in the current version of the answer. I decided to improve the edit and left the checkbox "this edit was helpful" checked, since it was in fact helpful and made me realize that I left out some information.

However, when I go to edit the question now, the edit box shows the old version of the answer. Well, more specifically, the version of the answer that included only the suggested edit, not the version that the answer reflects now, which includes my improvement. I noticed that on the revisions page the suggested edit is marked as revision 3, and my edit is revision 2, even though my edit is reflected in the current version. They seem to be listed in the wrong order.

Why does the edit option now show me an obsolete version of the answer, and the public site show me a different revision? Why are the revisions sorted out of order?

share|improve this question

migrated from meta.dba.stackexchange.com Jul 16 '12 at 22:18

This question came from our discussion, support, and feature requests site for database professionals who wish to improve their database skills and learn from others in the community.

marked as duplicate by Anna Lear Jul 18 '12 at 16:26

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
Looks like a bug in the ordering of revisions to me... –  JNK Jul 16 '12 at 22:13
    
I wonder if while you were "improving", other people approved the edit and it went through? –  Ernest Friedman-Hill Jul 16 '12 at 22:30
1  
@ErnestFriedman-Hill Possibly, but there still shouldn't be a scenario where both edits "kind of" won. Either the improvement won or the suggestion won. –  Aaron Bertrand Jul 16 '12 at 22:44
    
Did you go back using the back button? –  jcolebrand Jul 17 '12 at 1:01
2  
@jcolebrand absolutely not. I've learned to not use browser nav buttons here. :-) –  Aaron Bertrand Jul 17 '12 at 1:01

3 Answers 3

I believe that this is an issue provoked by the fact that, both edits have the same timestamp (down to seconds at least).

enter image description here

Seems like the "system" uses one query method to present the answer and a different one to present the answer revisions.

Mere speculation, since only developers can fully answer this.


Nonetheless, as seen by the revision ID:

  1. answered 5 hours ago by Aaron Bertrand
  2. edited 47 mins ago by Aaron Bertrand
  3. suggested 47 mins ago by AngryHacker

This tells us that the answer was placed, an edit was made and a suggested edit gone through.

share|improve this answer
1  
If I improve a suggested edit, doesn't the improvement inherit the same timestamp as the suggestion? I don't think the person who suggested the edit came in and modified their suggestion as I was improving it. I suppose it is feasible that the suggestion was approved at the exact same second as my edit, the suggestion was at edit(0) when I improved it, and it only took me about 10 seconds to improve. So it seems possible but unlikely. –  Aaron Bertrand Jul 16 '12 at 22:51
    
@AaronBertrand Possible nonetheless... I believe that developers will pronounce themselves as to clarify what happened. –  Zuul Jul 16 '12 at 23:06
    
Yes, possible. I'm holding off on a further edit to the answer in question to leav it in its current stat for the devs, but I'm not sure how long I'll have to wait. :-) –  Aaron Bertrand Jul 17 '12 at 3:27
1  
I bet they don't use an ORDER BY... –  JNK Jul 17 '12 at 21:41

According to this answer, this was due to a bug and the fix is being rolled out soon.

share|improve this answer

Here is an other example, where I just improved a proposed edit.

http://stackoverflow.com/posts/11524960/revisions

Even though I just corrected one word in the edit (and removed the Thank you), the diff shows that I did the bulk of the edit, which I did not. The revision numbers are also reversed.

Definitely a problem.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged .