Method diffIndex

packages/sql/src/schema/SchemaComparator.ts:986–994

* Finds the difference between the indexes index1 and index2. * Compares index1 with index2 and returns index2 if there are any differences or false in case there are no differences.

(index1: IndexDef, index2: IndexDef)

   * Compares index1 with index2 and returns index2 if there are any differences or false in case there are no differences.
   */
  diffIndex(index1: IndexDef, index2: IndexDef): boolean {
    // Opaque raw expressions (`expression` escape hatch) and full-text indexes can't be
    // compared structurally — fall back to name-only matching.
    if (index1.expression || index2.expression || index1.type === 'fulltext' || index2.type === 'fulltext') {
      return index1.keyName !== index2.keyName;
    }

    return !this.isIndexFulfilledBy(index1, index2) || !this.isIndexFulfilledBy(index2, index1);
  }

  /**
   * Checks if the other index already fulfills all the indexing and constraint needs of the current one.