SELECT p.name                                                         AS package_name,
       ds.dir_name                                                    AS data_stream_name,
       f.name                                                         AS field_name,
       f.value                                                        AS defined_constant,
       GROUP_CONCAT(DISTINCT
                    json_extract(pro.attributes, '$.value'))          AS pipeline_values
FROM data_streams ds
         JOIN packages p ON ds.packages_id = p.id
         JOIN data_stream_fields dsf ON ds.id = dsf.data_stream_id
         JOIN fields f ON dsf.field_id = f.id
         JOIN ingest_pipelines ip ON ds.id = ip.data_streams_id
         JOIN ingest_processors pro ON ip.id = pro.ingest_pipelines_id
WHERE f.type = 'constant_keyword'
  AND pro.type IN ('set', 'append')
  AND json_extract(pro.attributes, '$.field') = f.name
GROUP BY ds.id, f.id
HAVING
-- Conflict 1: Pipeline sets a value different from the defined constant
    (defined_constant IS NOT NULL AND pipeline_values != defined_constant)
-- Conflict 2: Pipeline sets multiple distinct values for a constant field (even if defined_constant is null)
    OR (COUNT(DISTINCT json_extract(pro.attributes, '$.value')) > 1);