subject:"\[sqlite\] Order By gives different result"

Re: [sqlite] Order By gives different result

2017-08-21 Thread Dan Kennedy

On 08/21/2017 11:51 PM, Stephen Chrzanowski wrote: I think I may have found a query issue. I haven't checked the SQLite docs to see if this is something that is specified as an order of operations, or if this is a check that has been overlooked. I think using a column alias in a complex

[sqlite] Order By gives different result

2017-08-21 Thread Stephen Chrzanowski

I think I may have found a query issue. I haven't checked the SQLite docs to see if this is something that is specified as an order of operations, or if this is a check that has been overlooked. The database SQL code is here: https://pastebin.com/raw/FukX4qEB select