Support for descending indexes

pauldex / sqlalchemy-firebird

A Firebird dialect for SQLAlchemy using the firebird-driver and/or fdb python Firebird driver

MIT License

23 stars 15 forks source link

Support for descending indexes #6

Closed gordthompson closed 11 months ago

gordthompson commented 4 years ago

Firebird indexes are a bit different than most others in that they are all uni-directional. We would need to do some tweaking of visit_create_index to support this, as described in

https://github.com/sqlalchemy/sqlalchemy/issues/5106

That would be in addition to excluding the "noncol_idx" tests in ComponentReflectionTest.

[ ] update visit_create_index to emit a valid CREATE DESC INDEX... statement for Firebird

pauldex commented 4 years ago

Should this issue be closed?

gordthompson commented 4 years ago

We can leave it open as a reminder that we still haven't done the visit_create_index part yet. That is, we've prevented the existing "DESC" tests from failing, but we are still unable to emit a CREATE DESCENDING INDEX ... statement.

pauldex commented 4 years ago

Sounds good.