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.

        Issue Links

          Activity

          Lazar Otasevic created issue -
          Lazar Otasevic made changes -
          Field Original Value New Value
          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.

          Suggestion - wouldn't it be easier to just include attribute index="true" instead od <indexes> tag, since attribute unique="true" already works.
          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.
          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.
          Lazar Otasevic made changes -
          Summary Multiple level mapped-superclass, indexes not working Mapped-superclass, indexes not gathered
          Hide
          Lazar Otasevic added a comment -

          Anybody?

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

          HELLO?

          Show
          Lazar Otasevic added a comment - HELLO?
          Dustin Thomson made changes -
          Link This issue is referenced by DDC-3418 [ DDC-3418 ]

          This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

          • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=OXM-2, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

            People

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

              Dates

              • Created:
                Updated: