On Thu, Mar 7, 2019 at 5:14 PM Brooke Storm bstorm@wikimedia.org wrote:
but it is recommended that comment references use a join to the new comment table on a “comment_id” field instead where possible.
I would like to insist in this part- the change wasn't made to annoy users- we tried to provide compatibility where possible, but some tools users observed reduced performance if something more complex than a point select was being used, so we encourage to use the non-compat ones for performance reasons when possible. Sorry for the inconveniences- unlike an API, while we are happy to provide access to the internal database format, we cannot always guarantee to be stable over the years.