2044966- Optimizer does not consider any index scan for a constant valued search argument and an encrypted datetime column - SAP ASE

Symptom

Adaptive Server Enterprise (ASE) optimizer does not consider any index scan for equality and non-equality comparison of an encrypted datetime column to a constant value.

Example : where encr_datetime_col = '1988/12/31'

Even if the encrypted column 'encr_datetime_col' is the first column of an index, ASE optimizer does not consider that this predicate is a search argument, and the index scan is never used.This is because the left node and right node have different data types. In the above case, encr_datetime_col is a datetime data type column and '1988/12/31' is a constant value treated as a character data type.