Skip to content

Oracle DDL: automatically add functional index using NLSSORT for string attributes if `NLSSORT_IDX` option exists in `advSetting`

Pavlo Mashliakovskiy requested to merge feat/oraCIIndexes into master

Oracle DDL generator: added new advSetting option NLSSORT_IDX: if connection configured to use case-insensitive string comparison (ALTER SESSION SET NLS_SORT=BINARY_CI exists in executeWhenConnected) and NLSSORT_IDX option is added into connection advSettings, then DDLGenerator automatically add functional index NLSSORT(cloumnName,'nls_sort=BINARY_CI') into existed indexes definitions

Merge request reports