[Zope] ZSQL method broken on 2.1.6

[Phill Hugo]

Umesh Soni wrote:
> 
> (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
> 
> Hi there,
> 
> I had this ZSQL method (simplified for clarity) working on 2.1.4
> 
> select id, nickname  from bboard
> where id<=50
> order by id desc
> limit 30

Remove either the limit 30 or the LIMIT 1000 Advanced property of the
ZSQL method (advanced tab). To speed things up, the limit 1000 appended
to the query to stop MySQL giving Zope lots of lines when it only wants
1000 anyway. Its not too clever though. There should maybe be a check to
see if "limit x" exists in the query.

Phill