← Back to team overview

maria-discuss team mailing list archive

Re: Collations, trailing spaces and unique indexes


> Le 11 Mar 2016 à 14:39, Binarus <lists@xxxxxxxxxx> a écrit :
> On 11.03.2016 12:59, Rhys.Campbell@xxxxxxxxxxxx wrote:
>> I think I could try this as a last resort, but it would require changes in the existing applications.
>> Could do it with a trigger to avoid application changes although that's something I'd probably try to avoid.
> Agreed. I want to avoid this, too.
>> If you can afford it, then you could only index part of your VRAHCAR columns to make space for the extra field, i.e. 
>> CREATE INDEX part_of_name ON customer (name(200), str(200), str_length);
> The problem with this special application is that a) the column is VARCHAR(255), b) there are rows where the column is filled completely, i.e. where 255 chars are in the column, c) that the index is a unique one, d) 254*'a' + ' ' must (index wise) be another value than 254*'a'. Furthermore, the changes in the applications which are required for that probably are substantial.
> I know that this might be a special requirement, but on the other hand please see my reply to Alexander Barkov's post where I (hopefully) can explain why ignoring these trailing spaces in unique indexes is a faulty design from the beginning on, may it be standard or not.
> So, even if I could circumvent the problem with this special application by some mad index constructions and programming techniques, I still would really like to have a clean solution.
> Alexander has made me hope that he or one of his fellows might be willing to implement this, and I will try to give him arguments for doing so.
> Therefore, I now have two options:
> 1) If it will be implemented in MariaDB, I'll switch our applications from MySQL to MariaDB.
> 2) If it will not be implemented, I will stick with MySQL and switch all respective rows in all tables from VARCHAR(255) to VARBINARY(765).
Hi Binarus,  

I see 3 options here: 

1) MariaDB captains can help you implementing this, we always welcome contributions and Alexander already point you where to start.

2) You really need this feature and can switch to MariaDB, please contact one of our sale reps to quote you some NRE work . 
3) Captains fill this is a generic issue that need to be fixed for the benefit of all, but also prioritise it on other tasks they are working on.

Tell us the time you are ready to wait, How much you can afford to help etc. ..? 

An other option is that you switch to MariaDB and use VarBinary, that would help our captains not to forget your request! 


> Thank you very much again,
> Binarus
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Follow ups