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
