Hi,
I added a new boolean field to a table. And I manually updated the
value of the field outside web2py. Now, I get zero rows for any
condition I put on that field. Please see the following shell output
for an idea:
In [7]: offers = db(db.OFFER.IS_PRICE_COMPARED == False).select()
...:
In [8]: len(offers)
Out[8]: 0 #####<-- This is not expected. It should return all the
rows
In [9]: offers = db(db.OFFER.IS_PRICE_COMPARED == True).select()
...:
In [10]: len(offers)
Out[10]: 0
In [11]: offers = db().select(db.OFFER.IS_PRICE_COMPARED)
....:
In [12]: len(offers)
Out[12]: 668
In [13]: offers[0]
Out[13]: <Row {'IS_PRICE_COMPARED': False}> ######<-- Notice the value
being False here
In [14]: offers[1]
Out[14]: <Row {'IS_PRICE_COMPARED': False}>
