Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-769

Disabling discriminator column in WHERE clause

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 2.0-BETA3
    • Fix Version/s: None
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

      Per default Doctrine 2 adds an IN(...)-part to the query when hydrating an entity where a discriminator column is defined. While this makes sense as a default behavior, it would be pretty helpful if one could disable the WHERE-clause for discriminator columns alltogether for performance optimization.

        Activity

        Hide
        Lars Strojny added a comment -

        I use ENUM("foo","bar") as discriminator columns. That means, the column will contain the right values out of the box, no further result set limiting required with WHERE.

        Show
        Lars Strojny added a comment - I use ENUM("foo","bar") as discriminator columns. That means, the column will contain the right values out of the box, no further result set limiting required with WHERE.
        Hide
        Roman S. Borschel added a comment -

        That would obviously produce wrong results. Maybe you can elaborate more with an example.

        Show
        Roman S. Borschel added a comment - That would obviously produce wrong results. Maybe you can elaborate more with an example.

          People

          • Assignee:
            Roman S. Borschel
            Reporter:
            Lars Strojny
          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: