Criteria on columns of different data types

[mtawk]

Since we migrated to Teiid 9.0.0, we started to get errors whenever we have criterias comparing fields of different data types, varchar and integer for example.

Those cases use to pass in teiid earlier versions. I guess there were an automatic cast that was added to match the other column datatype.

is there a way to enable casting columns in such cases?

[shawkins]

> is there a way to enable casting columns in such cases?

[TEIID-3722] Add an option to not widen comparisons to string - JBoss Issue Tracker was added in 8.12, but still defaulted to the old behavior.  With 9.0 we wanted to default to stricter behavior - Migration Guide From Teiid 8.x · Teiid Documentation