Ticket #17 (closed defect: fixed)
SQL problems with at least MySQL
Reported by: | jerome | Owned by: | jerome |
---|---|---|---|
Priority: | major | Milestone: | |
Component: | pykota | Version: | stable |
Keywords: | sql, mysql | Cc: |
Description
With 'SELECT COUNT(*) ...' PostgreSQL creates a virtual field named 'count'. MySQL names this field 'count(*)'.
Some of these selects appear in PyKota's source code, and are problematic since the code was initially written with PostgreSQL in mind.
Change History
Note: See
TracTickets for help on using
tickets.