OpenMetadata/bootstrap/sql/migrations/native/1.9.6/mysql/schemaChanges.sql

-- Add displayName virtual column to glossary_term_entity for efficient search
ALTER TABLE glossary_term_entity ADD COLUMN displayName VARCHAR(256) GENERATED ALWAYS AS (json ->> '$.displayName') STORED;

-- Create index on displayName for efficient LIKE queries
CREATE INDEX idx_glossary_term_displayName ON glossary_term_entity (displayName);