I found ZODBC bug at max_rows.

file name: db.py

line: 230

Current version is getting all rows regardless of max_rows.

Fixed version is getting rows until rows are smaller than max_rows.

Current version:

while status==SQL_SUCCESS:

.....

r.append(rd)

status=SQLFetch(stmt)

.....

Fixed version:

cnt = 0

while status==SQL_SUCCESS and cnt < max_rows:

.......

r.append(rd)

cnt = cnt + 1

status=SQLFetch(stmt)

.......

Have a nice day !!!!!!