internetarchive/openlibrary — Issue #137: Bug in get-lists-of-user
Author: anandology
Created: 2012-02-02 11:24:16+00:00
State: open

The page http://openlibrary.org/people/book_lover was showing list created by `bookslover`.

Here is the query that user page makes to get the lists if a user.

$ curl 'http://openlibrary.org/query.json?key~=/people/book_lover/lists/*'
[{"key": "/people/bookslover/lists/OL6317L"}]

It looks like postgres/SQL has a special meaning for `_` when used in the LIKE query. We need to escape underscores when executing wild-card queries.