diff options
author | Eric Wong <e@80x24.org> | 2020-12-15 02:02:18 +0000 |
---|---|---|
committer | Eric Wong <e@80x24.org> | 2020-12-17 19:13:08 +0000 |
commit | 4c434e62a115c1158a0dc31468f109616a4ed088 (patch) | |
tree | 6f60dd200ce2caa02f661054a8c68160082998d3 | |
parent | 7fd78e7e8d99600effd9c878ff853a2e1969c4d3 (diff) | |
download | public-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.
-rw-r--r-- | lib/PublicInbox/Over.pm | 2 |
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; |