On Friday, August 2, 2019 at 10:17:27 AM UTC-7, Val K wrote:
>
> It is not a bug, as you probably know dal does not support fields aliases 
> and '_extra' is workaround. When do you get an error?


Should it be considered a bug in the book?

I'm not quite sure how aliases fit in ... does Postgres consider "sum" in  
"select 
sum(item) from test1t; " an alias? (Ditto sqlite)
I would think "sum" was more like a virtual field. 

I get the error in trying to follow the book example, but I did my own 
table and filled it in using appadmin (2.18.2):

db.define_table('test1t',
                Field('item', 'integer'),
                Field('description', 'string')
                )

test1t.id test1t.item test1t.description
1           1               something
2           2               buckle my shoe
3           3               fibonacci trey

And I did this because I ran into the issue while running a script to 
analyze a real database (2.15.4).

/dps


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/e889174d-f1b7-4b0e-a57a-2da92bbf28f3%40googlegroups.com.

Reply via email to