babelfish-for-postgresql / babelfish_extensions / 11522401238

75%

push

github

Extend the function of eliminating unnecessary CAST function for integer (#3016)

Description
-----------
Some unnecessary CAST functions for integer type exist in the SQL
preventing the optimizer making use of the indexes on those
columns. By removing those functions, we can give the optimizer an
option to choose index.

This patch extends the following supported scenarios:
1. Functions nested in AND/OR clauses.
2. Functions appear in both sides of the operator.
3. Nested CAST functions.
4. CASTs among SMAILLINT, INT, BIGINT.
5. Apart from '=', more operators are supported: </>/<=/>=
6. User-defined operators are not supported.

Task: BABEL-4550
Signed-off-by: Bo Li <zboli@amazon.com>

53 of 54 new or added lines in 1 file covered. (98.15%)

45249 of 60716 relevant lines covered (74.53%)

162696.95 hits per line