Strange one: After upgrading to Slackware64-current, MariaDB sorts on different column
by Johncc330 from LinuxQuestions.org on (#6HEAE)
A couple of days ago, I upgraded my wife's pharmacy's machine to Slackware64-current, and now she complained that the products appear sorted on product number instead of product description, which are separate columns in the table.
Effectively, I have a database, say XXX, which has a number of columns. I had created a composite key, column 1 and column 3 concatenated.
This worked for years till the upgrade. Now, not changing the code, it only indexes on the column 1 (and ignores column 3).
Does anyone know if the mysql upgrade changed anything relating to this?
Effectively, I have a database, say XXX, which has a number of columns. I had created a composite key, column 1 and column 3 concatenated.
This worked for years till the upgrade. Now, not changing the code, it only indexes on the column 1 (and ignores column 3).
Does anyone know if the mysql upgrade changed anything relating to this?