Avatar

Another case of ordering by a column, that is not in the SELECT (Development)

by Auge ⌂, Tuesday, August 06, 2024, 10:29 (41 days ago) @ Joe I

Hello Joe

Line 88 Update
I Think this looks good, but need to test numerous combinations. The original format should not have caused any issue according to SQL standards, however there have been some SQL / MySQL implementations that required any ORDER BY also be in the SELECT. I need to make sure adding ft.sticky and ft.time in the SELECT DISTINCT won't change the # of output rows.

I found another case of that type. When reordering the list of threads on the main page by the date of the latest reply (in my testing installation the threads are ordered by the date of the opening posting by default), one gets an error message, I documented on Github in the issue #731.

The message states clearly "this is incompatible with DISTINCT".

Tschö, Auge

--
Trenne niemals Müll, denn er hat nur eine Silbe!


Complete thread:

 RSS Feed of thread