babelfish-for-postgresql / babelfish_extensions / 8922567081

74%

BABEL_4_X_DEV: 75%

push

github

Introduce operator class and operators between int and numeric (#2542)

Today in Babelfish, Index scan would not be chosen by optimiser if there is any filter that involves operator between int and numeric even though index is created on int column. For example,

```
create table test_int_numeric(a int);

-- insert 1M rows of data
INSERT INTO test_int_numeric (a) SELECT generate_series(1, 1000000);

CREATE INDEX test_int_numeric_idx on test_int_numeric(a);
```

Here, Index scan would not be chosen for following query as operator class and operators between int and numeric does not exist in native Postgres.

```
select count(*) from test_int_numeric where a = 5.0;
```

This commit fixes this issue by appropriately defining operator class and operators between int and numeric.

This changes also requires engine changes (babelfish-for-postgresql/postgresql_modified_for_babelfish#355) in order to dump these Babelfish defined operator class correctly during pg_upgrade.

Task: BABEL-3385
Signed-off-by: Dipesh Dhameliya <dddhamel@amazon.com>

198 of 210 new or added lines in 1 file covered. (94.29%)

41453 of 56750 relevant lines covered (73.04%)

102905.8 hits per line