Changes between Initial Version and Version 1 of Ticket #34771


Ignore:
Timestamp:
Aug 11, 2023, 9:57:06 AM (16 months ago)
Author:
Yitao Xiong
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #34771 – Description

    initial v1  
    7474This is under MySQL 8.0.33 by the way. Not sure if it's just syntax not supported by MySQL.
    7575
    76 Since Django doesn't seem to require an annotated field to be present in `values` or `values_list` to be used in `order_by`, my humble opinion is that it should be slightly smarter for this case by implicitly adding the field into the `SELECT` statement.
     76Since Django doesn't seem to require an annotated field to be present in `values` or `values_list` to be used in `order_by`, my humble opinion is that it should be slightly smarter for this case by implicitly adding the field into the `SELECT` statement, and use its alias in the `ORDER BY`.
    7777
    7878Thanks for taking a look, and feel free to let me know if you need more information.
Back to Top