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

Undefined sorting of posts with same post_time on postgres

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • 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: