search

inspirehep / invenio

Invenio digital library software, INSPIRE OPS version
http://invenio-software.org/
GNU General Public License v2.0
3 stars 10 forks source link

WebSearch: fix fielded alephseq output #504

Closed tsgit closed 5 years ago

tsgit commented 5 years ago

Signed-off-by: Thorsten Schwander thorsten.schwander@gmail.com

tsgit commented 5 years ago

fixes 2 separate errors in

https://sentry.inspirehep.net/inspire-prod/legacy/issues/13056/

'SELECT b.tag,b.value,bb.field_number FROM bib 1x AS b, bibrec_bib 1x AS bb WHERE bb.id_bibrec=%s AND b.id=bb.id_bibxxx AND b.tag LIKE %sORDER BY bb.field_number, b.tag ASC'

missing space before ORDER and ensuring tags don't have leading whitespace, which messes up table selection, e.g. FROM bib 1x and AS b, bibrec_bib 1x which should be bib10x and bibrec_bib10x