UserDefinedType CIText() will not produce a cache key because the cache_ok attribute is not set to True

[biyani701]

I keep getting this error. Tried to use cache_ok = True in the Table Class mapping where column of type CIText() is defined. But it does not help.

UserDefinedType CIText() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)

Below are the package versions with python 3.10
sqlalchemy-citext 1.8.0
SQLAlchemy 1.4.31

---

The error goes away if I add,
cache_ok = True

in class CIText(types.Concatenable, types.UserDefinedType) defined in init.py file of citext package.
Is this the right way to handle this?

[rouge8]

See #25 and #28

[biyani701]

Thanks a lot. This is helpful