Large value of User Attribute

[cgeorgilakis]

We want to save complex attributes from Identity Providers in json format and release them in the same format in Clients ( see ORCID publications). The problem is that these attribute value is over 255 length, which is the database length of value field of user_attribute table.
Related jira issue : https://jira.argo.grnet.gr/browse/RCIAM-656 for publications.

Dev discussion: https://groups.google.com/g/keycloak-dev/c/z6htKyfByd0
Keycloak jira issue has been closed by Stian.

Stian response :

User attributes have been designed to store simple user properties, not complex properties. So an address should be stored as addr.postcode, addr.country, etc, not as {addr.postcode:

{..}
, addr.country: {..}}.

It is too complex for our use case. Or we should find simple value like url to

[cgeorgilakis]

text field in postgresql

[cgeorgilakis]

They have added an index in USER_ENTITY table ( correctly). In postgresql index field value maximum size is 8191.
So we have two options either have this size limit either remove index also.

[cgeorgilakis]

Moreover, tests fail due to index in clob. Other databases do not have text field and liquibase try to create lob field.

[cgeorgilakis]

We increase User Attribute Value to 4000 length and test in https://login-devel.einfra.grnet.gr/auth/ ( release 15.0.2-r1.0.6) .

Some tests in our stage-15.0.2 will be failed due to problem with MySQL with this length. We will ignore them.

@nikosev you could test large User Attributes