[midPoint-git] [Evolveum/midpoint] ae7c7b: MID-6691: index ON M_OBJECT_EXT_STRING(ownerType, ...

[virgo47]

  Branch: refs/heads/master
  Home:   https://github.com/Evolveum/midpoint
  Commit: ae7c7be52a95fefcfeee78e07a20ede5983dd2cf
      https://github.com/Evolveum/midpoint/commit/ae7c7be52a95fefcfeee78e07a20ede5983dd2cf
  Author: Richard Richter <richard.richter at evolveum.com>
  Date:   2021-03-18 (Thu, 18 Mar 2021)

  Changed paths:
    M config/sql/oracle-4.3-all.sql
    M config/sql/oracle-upgrade-4.2-4.3.sql
    M config/sql/postgresql-4.3-all.sql
    M config/sql/postgresql-upgrade-4.2-4.3.sql

  Log Message:
  -----------
  MID-6691: index ON M_OBJECT_EXT_STRING(ownerType, ITEM_ID, (lower...

ON M_OBJECT_EXT_STRING(ownerType, ITEM_ID, (lower(stringvalue)))
Added for PG and Oracle, other databases don't support function based
index directly, so we skip it.
Anyway, this is a problem in extreme deployments only.