There is a bug. must be None i.e. the result is not defined.
I fixed the bug and I will send the PR asap
db.define_table('tt', Field('aa', 'integer'))
assert(db(db.tt.aa == 2).count()==0)
sum = (db.tt.aa + 1).sum()
assert(db(db.tt.aa == 2).select(sum).first()[sum]==0)
-> AssertionError
I added tests for travis too.
2013/7/21 Jim Steil <ato.st...@gmail.com>
> Do you have a test you can run on it? None of mine are working and I just
> updated in the last hour.
>
>
> On Sun, Jul 21, 2013 at 8:48 AM, Niphlod <niph...@gmail.com> wrote:
>
>> this should have been fixed already on the latest trunk....
>>
>>
>> On Sunday, July 21, 2013 3:33:51 PM UTC+2, Jim S wrote:
>>>
>>> Just upgraded to latest trunk, Version 2.6.0-development+timestamp.**
>>> 2013.07.20.12.59.52.
>>>
>>> Having a problem with SUM statements that previously worked.
>>>
>>> If the query returns no rows, then I'm getting this traceback:
>>>
>>> Traceback (most recent call last):
>>>
>>> File "C:\dev\web2py\gluon\**restricted.py", line 212, in restricted
>>>
>>> exec ccode in environment
>>> File "C:/dev/web2py/applications/**ibc/controllers/dashboard.py"
>>> <http://127.0.0.1:8000/admin/default/edit/ibc/controllers/dashboard.py>,
>>> line 2035, in <module>
>>>
>>> File "C:\dev\web2py\gluon\globals.**py", line 193, in <lambda>
>>>
>>> self._caller = lambda f: f()
>>>
>>> File "C:/dev/web2py/applications/**ibc/controllers/dashboard.py"
>>> <http://127.0.0.1:8000/admin/default/edit/ibc/controllers/dashboard.py>,
>>> line 1094, in contract_fees_ytd_by_**distributor
>>>
>>>
>>> (db.national_sales_data.Invoic**e_Print_Date__c<=to_date)).sel**ect(processing_fees_sum).first**()[processing_fees_sum]
>>> or 0
>>>
>>> File "C:\dev\web2py\gluon\dal.py", line 6888, in __getitem__
>>>
>>> return ogetattr(self, key)
>>> AttributeError: 'Row' object has no attribute
>>> 'SUM(national_sales_data.**Processing_Fees__c)'
>>>
>>> My code is:
>>>
>>> processing_fees = db((db.national_sales_data.**
>>> Invoice_Print_Date__c>=from_**date) &
>>> (db.national_sales_data.**Trading_Partner_ID__c==**trading_partner) &
>>> (db.national_sales_data.**Invoice_Print_Date__c<=to_**
>>> date)).select(processing_fees_**sum).first()[processing_fees_**sum] or 0
>>>
>>> Previously this would return 0 if there were no rows selected in the
>>> query.
>>>
>>> -Jim
>>>
>>> --
>>
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/hgYEY3ZdSK4/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>>
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
