Hi,

I am getting the following error during testing of my application, but
only on Py2.7, if I run the same application on Py3.4 with the same fdb
and SQLAlchemy version I don't see this error.

I'll continue to search for the reason but if someone has a tip, please
let me know.

OK, I found the actual culprit and fixed it in my code, but maybe fdb can be improved.

The code causing it is:
s = """
SELECT cellarbook.id AS cellarbook_id, cellarbook.maturityfirst AS cellarbook_maturityfirst, cellarbook.maturitybest AS cellarbook_maturitybest, cellarbook.maturitypast AS cellarbook_maturitypast, cellarbook.storagelocation AS cellarbook_storagelocation, cellarbook.lastpurchaseprice AS cellarbook_lastpurchaseprice, cellarbook.avgpurchaseprice AS cellarbook_avgpurchaseprice, cellarbook.currentvalue AS cellarbook_currentvalue, cellarbook.quantitypurchased AS cellarbook_quantitypurchased, cellarbook.quantityconsumed AS cellarbook_quantityconsumed, cellarbook.quantityonhand AS cellarbook_quantityonhand, cellarbook.purchasevalueonhand AS cellarbook_purchasevalueonhand, cellarbook.currentvalueonhand AS cellarbook_currentvalueonhand, cellarbook.isactive AS cellarbook_isactive, cellarbook.printlabel AS cellarbook_printlabel, cellarbook.minqoh AS cellarbook_minqoh, cellarbook.avgscore AS cellarbook_avgscore, cellarbook.avgscore2 AS cellarbook_avgscore2, cellarbook.maxprice AS cellarbook_maxprice, cellarbook.purchaseagain AS cellarbook_purchaseagain, cellarbook.uservint1 AS cellarbook_uservint1, cellarbook.uservint2 AS cellarbook_uservint2, cellarbook.userbot1 AS cellarbook_userbot1, cellarbook.userbot2 AS cellarbook_userbot2, cellarbook.fk_supplier_id AS cellarbook_fk_supplier_id, cellarbook.fk_cellar_id AS cellarbook_fk_cellar_id, cellarbook.fk_authuser_id AS cellarbook_fk_authuser_id, cellarbook.fk_bottle_id AS cellarbook_fk_bottle_id, cellarbook.fk_vintage_id AS cellarbook_fk_vintage_id, cellarbook.fk_drinkinfo_id AS cellarbook_fk_drinkinfo_id, cellarbook.created_at AS cellarbook_created_at, cellarbook.updated_at AS cellarbook_updated_at, cellarbook.created_by AS cellarbook_created_by, cellarbook.updated_by AS cellarbook_updated_by
FROM cellarbook
WHERE cellarbook.fk_authuser_id = :fk_authuser_id_1 AND cellarbook.maturityfirst BETWEEN :maturityfirst_1 AND :maturityfirst_2
"""

s = db.sasql.text(s)

result = session.connection().execute(s, fk_authuser_id_1=1, maturityfirst_1='', maturityfirst_2='')

for i in result:
    print(i)

The two "maturityfirst" are integer columns and I inadvertently used a string for the filter value.

It would be nice if fdb could get a more detailed error to make it easier to track down such an error.

Werner