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

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.

• SAP Adaptive Server Enterprise version (ASE) 15.0
• SAP Adaptive Server Enterprise version (ASE) 15.5
• SAP Adaptive Server Enterprise version (ASE) 15.7 

encrypted column, datetime , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To