Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Labels:
      None
    • Environment:
      win7 xamp mysql

      Description

      GenericPositionPair XML:
      <mapped-superclass name="GenericPositionPair">
      <indexes>
      <index columns="position" />
      </indexes>
      <field name="position" type="integer" column="position" />
      </mapped-superclass>

      GenericPrimaryPositionPair XML:
      <mapped-superclass name="GenericPrimaryPositionPair">
      <indexes>
      <index columns="isPrimary" />
      </indexes>
      <field name="isPrimary" type="boolean" column="isPrimary" />
      </mapped-superclass>

      PrimaryPositionPair XML:
      <entity name="PrimaryPositionPair" table="PrimaryPositionPair">
      <id name="first" type="integer" column="first_id" association-key="true" />
      <id name="second" type="integer" column="second_id" association-key="true" />
      <many-to-one field="first" target-entity="First">
      <join-column name="first_id" referenced-column-name="id" />
      </many-to-one>
      <many-to-one field="second" target-entity="Second">
      <join-column name="second_id" referenced-column-name="id" />
      </many-to-one>
      </entity>

      PHP:
      PrimaryPositionPair exteds GenericPrimaryPositionPair
      GenericPrimaryPositionPair extends GenericPositionPair

      Finally - the resulting SQL statement contains no idexes on position and isPrimary fields.

      Suggestion - wouldn't it be easier to just include attribute index="true" instead od <indexes> tag, since attribute unique="true" already works.

        Activity

        Hide
        Lazar Otasevic added a comment -

        HELLO?

        Show
        Lazar Otasevic added a comment - HELLO?
        Hide
        Lazar Otasevic added a comment -

        Anybody?

        Show
        Lazar Otasevic added a comment - Anybody?
        Hide
        Lazar Otasevic added a comment -

        As far as i can see, the shcema-tool gathers only fields and relations from xml and not <indexes> WHY?
        Since it fetches unique attribute from a field and accordingly adds an unique index to the final statement, wouldnt it be natural to also gether indexes?
        My suggestion remains about index attribute of a field.

        Show
        Lazar Otasevic added a comment - As far as i can see, the shcema-tool gathers only fields and relations from xml and not <indexes> WHY? Since it fetches unique attribute from a field and accordingly adds an unique index to the final statement, wouldnt it be natural to also gether indexes? My suggestion remains about index attribute of a field.

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Lazar Otasevic
          • Votes:
            3 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: