query does not find empty author

Bauble / bauble.classic

this is how Bauble and Ghini both started

GNU General Public License v2.0

10 stars 34 forks source link

query does not find empty author #255

Closed mfrasca closed 8 years ago

mfrasca commented 8 years ago

from sqlite3 itself, I find 4 matches, from Bauble just 1.

untitled

mfrasca commented 8 years ago

from the logs:

bauble.search - DEBUG - SearchStrategy "species where sp_author = ''" <sqlalchemy.orm.session.Session object at 0x7f06fc83f710>)
bauble.search - DEBUG - IdentifierToken::__init__([[u'sp_author']])
bauble.search - DEBUG - IdentExpression::__init__([[sp_author, u'=', '']])

mfrasca commented 8 years ago

this came in while doing aggregating functions and I wonder how I could have this pass without breaking tests. return q.group_by(a).having(clause(self.operands[1].express()))