GluuFederation / GluuFederation/flex

feat(flex): Ensure Deterministic Column Ordering in jansPerson / gluuPerson Schema Across Installations

Open
#2,507 2 comments 0 reactions 2 assignees Claimed by @devrimyatar View on GitHub
enhancement kind-feature
Dominant language
TypeScript
Stars
31
Forks
21
Avg merge
2d 4h
Merged PRs (30d)
29

Description

**Summary**

Column ordering in the jansPerson (formerly gluuPerson) table is inconsistent across Flex + PostgreSQL installations. For example, the "profile" attribute may appear as column 4 in one environment and column 24 in another. Although queries are by name, one of our enterprise customers relies on fixed column positions for downstream ingestion pipelines.

**Problem**

Schema generation does not enforce a consistent column order.

Result: each installation may produce different ordinal positions.

This causes issues for customers using strict schema validation (Kafka, ETL, etc.).

**Expected Behaviour**

New installations should always generate the jansPerson table with the same, deterministic column ordering, regardless of environment.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.