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.

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development