about summary refs log tree commit homepage
path: root/lib
diff options
context:
space:
mode:
authorEric Wong <e@80x24.org>2020-12-15 02:02:18 +0000
committerEric Wong <e@80x24.org>2020-12-17 19:13:08 +0000
commit4c434e62a115c1158a0dc31468f109616a4ed088 (patch)
tree6f60dd200ce2caa02f661054a8c68160082998d3 /lib
parent7fd78e7e8d99600effd9c878ff853a2e1969c4d3 (diff)
downloadpublic-inbox-4c434e62a115c1158a0dc31468f109616a4ed088.tar.gz
While unlikely to happen, it may be possible for messages
from the same inbox to get indexed multiple times.  Provide
consistent results in this case for ease-of-testing.
Diffstat (limited to 'lib')
-rw-r--r--lib/PublicInbox/Over.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/PublicInbox/Over.pm b/lib/PublicInbox/Over.pm
index 51284601..62709468 100644
--- a/lib/PublicInbox/Over.pm
+++ b/lib/PublicInbox/Over.pm
@@ -264,7 +264,7 @@ sub get_xref3 {
         my ($self, $num) = @_;
         my $dbh = dbh($self);
         my $sth = $dbh->prepare_cached(<<'', undef, 1);
-SELECT ibx_id,xnum,oidbin FROM xref3 WHERE docid = ? ORDER BY ibx_id ASC
+SELECT ibx_id,xnum,oidbin FROM xref3 WHERE docid = ? ORDER BY ibx_id,xnum ASC
 
         $sth->execute($num);
         my $rows = $sth->fetchall_arrayref;