with 8.1.4 you get.
ERROR: subquery in FROM must have an alias
On Tue, 25 Jul 2006, Michael Bayer wrote:
> i didnt think this problem was in postgres (whats the error message?) only
> in mysql.
> solution:
>
> f = table.select().alias('foo')
> x = f.count(f.c.colname == value).scalar()
>
>
> On Jul 25, 2006, at 5:06 AM, Khaled Daham wrote:
>
>> Hi!
>>
>> I made something really funny today, I managed to have a
>> Table.select().count(column == value) instead of a straight
>> Table.count(column == value) and this resulted in the following.
>>
>> SQLError: (OperationalError) (1248, 'Every derived table must have its own
>> alias') 'SELECT count(id) AS tbl_row_count \nFROM
>> (SELECT dhcp_hosts.id AS id, dhcp_hosts.IP AS IP, dhcp_hosts.subnet AS
>> subnet, dhcp_hosts.netmask AS netmask, dhcp_hosts.gw A
>> S gw, dhcp_hosts.status AS status, dhcp_hosts.port AS port, dhcp_hosts.slot
>> AS slot, dhcp_hosts.type AS type, dhcp_hosts.host
>> AS host \nFROM dhcp_hosts \nWHERE dhcp_hosts.IP = %s)' ['127.0.0.1']
>>
>> The query fix is "simple", just add ' AS dhcp_host' after the subselect
>> and mysql will be happy, the problem is that I dont see a straight forward
>> way of doing it, been reading through ansisql.py, any hints ?
>>
>> This error manifests itself in both mysql 5.x and postgrsql 8.x, 4.0
>> doesnt have subselects so this query wouldnt work in the first place, I
>> think however that 4.1 is forgiving.
>>
>> /Khaled Daham
>> Cell: +46-70-1810278
>> FreeBSD: The Power to Serve! http://www.FreeBSD.org/
>> This isn't rocket science -- but it _is_ computer science.
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys -- and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Sqlalchemy-users mailing list
>> Sqlalchemy-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
/Khaled Daham
Cell: +46-70-1810278
FreeBSD: The Power to Serve! http://www.FreeBSD.org/
This isn't rocket science -- but it _is_ computer science.
<bitti> "Todayy we are going to re-arrange our core with d-link switches"
<bitti> "wtf?"
<bitti> "Yes, they have 424 682 semlor points against ciscos 410 589 so we
decided to buy hw from them"
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
