Ticket #17 (closed defect: fixed)

Opened 14 years ago

Last modified 14 years ago

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

Changed 14 years ago by jerome

  • status changed from new to closed
  • resolution set to fixed

(In [3388]) Fixed an SQL incompatibilities problem, thanks to Jens Weibler.
Fixes #17.

Changed 14 years ago by jerome

Note: See TracTickets for help on using tickets.