IdStory Identity Manager

I was not able to delete the EAV already created and filled with some value so I had to create a new EAV of new type and made a reconciliation of all users.

Marcel Poul wrote:

which does not work for automatic roles.

For TEXT (string_value, org.hibernate.type.StringClobType) doesn't work equals on database. Automatic role behavior is only result from this behavior :D don't get mad at my automatic roles.

Ondřej Kopr wrote:

Marcel Poul wrote:

which does not work for automatic roles.

For TEXT (string_value, org.hibernate.type.StringClobType) doesn't work equals on database. Automatic role behavior is only result from this behavior :D don't get mad at my automatic roles.

I am not of course :-). In fact that is the reason why I suggest to make a shorttext a default EAV type. So you do not come across the same situation I mentioned I my first comment.

This is a little complicated because when will be shrotext used as default, then will not worked sync of attributes with value larger than 2000 chars.

Next good reason why is TEXT default presistent type in sync is performence. TEXT is not indexed, but SHORTTEXT yes (SHORTTEXT is using in searching ... automatic role..).

Vít Švanda wrote:

Next good reason why is TEXT default presistent type in sync is performence. TEXT is not indexed, but SHORTTEXT yes (SHORTTEXT is using in searching ... automatic role..).

So if the shorttext is indext, it should be prefered and default then?

I see that this ticket might be a little struggle between UX and performance, but I guess that almost every administrator during synchronization use EAV and so default type TEXT. Then he will be really surprised that he cannot use automatic role. Even worse, he will have no easy and convenient way of how to swich TEXT -> SHORTTEXT. So I vote rather to have shorttext as default.
Or maybe you can think of some better solution that I cannot see now, since I do not have detailed implementation knowledge. Maybe some discussion with Zdenek or Radek can take place too.

Marcel Poul wrote:

So if the shorttext is indext, it should be prefered and default then?

Indexed columns are fast for read, but slow on insert (DB have to create the index).
And you want to have fast sync :-).

But I agree, we have to solve this case (switching TEXT -> SHORTTEXT).

I canceled modifications in converters, because this changes broke VS and RPT module.
No only on creating new EAV attribute from attribute mapping use SHORTTEXT as default.