[BlueOnyx:22661] Re: Newlinq Package Version Numbers

[Greg Kuhnert]

Yep - Useful, but not helpful. I need to do VERSION sorting, which is multiple passes of this… so I had to write something to accomplish what I needed. But its done now. Should be good going forward.
GK

> On 31 Jan 2019, at 11:33 am, Rickard Osser <rickard.osser at bluapp.com> wrote:
> 
> Hi Greg!
> 
> This tip should actually work for the versioning:
> 
> https://www.copterlabs.com/natural-sorting-in-mysql/
> 
> Best regards,
> 
> Rickard
> 
> On Thu, 2019-01-31 at 10:22 +1100, Greg Kuhnert wrote:
>> Hi Team
>> 
>> Recently, Felix wrote to me about Owncloud. The last vendor published
>> version was 10.0.10, but only 10.0.9 was showing to Felix in Newlinq.
>> We had actually created a 10.0.10 package, but it was not showing up.
>> Let me explain the problem I was dealing with
>> 
>> For Owncloud, the version number went from 10.0.9, and then 10.0.10
>> …. Newlinq uses a mysql function to find max(Version) … However,
>> according to mysql, 9 is bigger than 10. (It is a string sort). In
>> the past, I manually tweaked the database to replace 10.0.9 with
>> 10.0.09…. which fixed it for that package, but then another package
>> will have the same problem later.
>> 
>> So. Today, I wrote my own user defined function that splits apart the
>> version numbers into components, and sorts correctly. This SHOULD now
>> give you the appropriate max version you are entitled to (based on
>> purchase date).
>> 
>> My request to everyone - Please check the packages available to you
>> today, and please report any errors or concerns to me via a support
>> ticket.
>> 
>> Regards,
>> Greg.
>> 
>> 
>> _______________________________________________
>> Blueonyx mailing list
>> Blueonyx at mail.blueonyx.it
>> http://mail.blueonyx.it/mailman/listinfo/blueonyx
> 
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx