demonstrate_pyfirebirdsql_issue.py

import firebirdsql

FIREBIRD_HOST = "localhost"
FIREBIRD_DB = "D:\\Databases\\TEST.fdb"
FIREBIRD_USER = "SYSDBA"
FIREBIRD_PASS = "masterkey"

conn = firebirdsql.connect(host=FIREBIRD_HOST, database=FIREBIRD_DB, user=FIREBIRD_USER, password=FIREBIRD_PASS)
cur = conn.cursor()

MIN_NUMBER = 380
MAX_NUMBER = 500

for i in range(MIN_NUMBER,MAX_NUMBER):
    if i % 10 == 0:
        print "{0}/{1}".format(i,MAX_NUMBER)
    try:
        cur.execute("select FIRST {0} * from TEST".format(i))
        a = cur.fetchall()
        
        if len(a) < i:
            print "Stopping at {0} since there are not enough entries in the table.".format(i)
            break
    except Exception:
        print "Failed at {0}".format(i)
        raise
conn.close()