Changes between Version 1 and Version 2 of Ticket #29630, comment 13


Ignore:
Timestamp:
Sep 12, 2018, 2:31:37 PM (7 years ago)
Author:
Rafael Zinezi Araújo

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #29630, comment 13

    v1 v2  
    1818
    1919
    20 > It seems that is not easy to reproduce this issue (see [https://asktom.oracle.com/pls/apex/asktom.search?tag=duplicate-columns-in-oracle-query-using-row-limiting-clause AskTom]). It works in both cases i.e. when identically named columns are in the [https://code.djangoproject.com/attachment/ticket/29630/29630.diff same table] or in [https://code.djangoproject.com/attachment/ticket/29630/29630_different_tables.diff different tables], e.g.
    21 >
    22 > {{{
    23 > SELECT
    24 >     "QUERIES_TAG"."NAME",
    25 >     "QUERIES_NAMEDCATEGORY"."NAME"
    26 > FROM
    27 >      "QUERIES_TAG"
    28 > LEFT OUTER JOIN "QUERIES_NAMEDCATEGORY" ON
    29 >      ("QUERIES_TAG"."CATEGORY_ID" = "QUERIES_NAMEDCATEGORY"."DUMBCATEGORY_PTR_ID")
    30 > ORDER BY "QUERIES_TAG"."NAME" ASC
    31 > FETCH FIRST 2 ROWS ONLY
    32 > }}}
     20> It seems that is not easy to reproduce this issue (see [https://asktom.oracle.com/pls/apex/asktom.search?tag=duplicate-columns-in-oracle-query-using-row-limiting-clause AskTom]). It works in both cases i.e. when identically named columns are in the [https://code.djangoproject.com/attachment/ticket/29630/29630.diff same table] or in [https://code.djangoproject.com/attachment/ticket/29630/29630_different_tables.diff different tables]
Back to Top