Yes, same thing.
Franck Pachot schrieb am 24.06.2016 um 18:30:
Hi, did you try virtual column? Does Hybris 'crash' with it as well?--
Le ven. 24 juin 2016 à 07:41, Thomas Kellerer <thomas.kellerer@xxxxxxxxxx
<mailto:thomas.kellerer@xxxxxxxxxx>> a écrit :
Mark W. Farnham schrieb am 22.06.2016 um 18:05:
> Perhaps:
>
> create unique index tk_test on
> orders(code,cast(coalesce_wrapper1(p_versionid) as varchar2(255 byte)));
>
> will work. I think casting the return to your desired maximum length
*might*
> be the most performant.
>
> Unfortunately I don't have a database handy with extended varchar2, so I
> cannot test that for you.
Thanks, but unfortunately that syntax also makes Hybris crash (and so
does the substr() version).
Thomas