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

        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?

        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: