Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-12966

Undefined sorting of posts with same post_time on postgres

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0.12, 3.1.0-RC2
    • Fix Version/s: 3.1.0-RC4
    • Component/s: Viewing posts
    • Labels:
      None

      Description

      Posts are sorted by using ORDER BY p.post_time. As far as postgres is concerned, the sorting for rows with the same post time is undefined. It apparently only depends on which row is loaded from the database backend first.

      This should be changed to also sort by post_id.

        Attachments

          Activity

            People

            • Assignee:
              Marc Marc
              Reporter:
              Marc Marc
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: