Page MenuHomePhabricator

Project queries with a Ferret fulltext constraint encounter ambiguous column error when paging
Closed, ResolvedPublic

Description

See downstream https://phabricator.wikimedia.org/T230217.

To reproduce the issue:

  • Issue a query in Projects which includes a Ferret fulltext constraint and matches more than one page of results.
  • Click "Next Page".

Expected behavior:

  • Next page.

Actual behavior:

Unhandled Exception ("AphrontQueryException")
#1052: Column 'id' in where clause is ambiguous