Cursor.description returning () instead of None

FirebirdSQL / python3-driver

Firebird driver for Python that uses new Firebird API

https://www.firebirdsql.org/en/devel-python-driver/

MIT License

26 stars 10 forks source link

Cursor.description returning () instead of None #20

Closed fdcastel closed 1 year ago

fdcastel commented 1 year ago

As discussed here.

Working on a new SQLAlchemy dialect I found that firebird-driver does return an empty tuple () instead of None in cursor.description when the cursor has no rows.

Is this the correct value in this case? What DBAPI says about?
Should it be changed to None? (as every other database driver used by SQLALchemy does); or
Should we change SQLAlchemy code to handle both None or ()?

fdcastel commented 1 year ago

According to PEP 249 – Python Database API Specification v2.0 it should really return None.