Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-3362

QSqlRelationalTableModel generates duplicate fieldnames

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • P3: Somewhat important
    • 4.7.1
    • 4.4.3
    • SQL Support
    • None

    Description

      Setting a relation to the same relational table (and the same displaycolumn) to different columns of the source table.
      e.g.
      relmodel.setRelation(0, QSqlRelation("reltable", "relindexcolumn", "reldisplaycolumn));
      relmodel.setRelation(1, QSqlRelation("reltable", "relindexcolumn", "reldisplaycolumn));
      relmodel.setRelation(2, QSqlRelation("reltable", "relindexcolumn", "reldisplaycolumn));

      Expected to see:
      This should generate unique fieldnames e.g.
      select
      relTblA_0.reldisplaycolumn reltable_reldisplaycolumn_0,
      relTblA_1.reldisplaycolumn reltable_reldisplaycolumn_1,
      relTblA_2.reldisplaycolumn reltable_reldisplay_column2 ....

      Got instead:
      instead the resulting sql looks like
      select
      relTblA_0.reldisplaycolumn reltable_reldisplaycolumn,
      relTblA_1.reldisplaycolumn reltable_reldisplaycolumn,
      relTblA_2.reldisplaycolumn reltable_reldisplaycolumn ...
      The same alias is generated for all 3 columns.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            bilking Bill King
            xcm Martin Petersson (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes