Uploaded image for project: 'Doctrine 2 - ORM'
  1. Doctrine 2 - ORM
  2. DDC-954

Look into deferring foreign key checks until flush finished

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None

      Description

      There are several timing issues that will be complicated to fix which relate to foreign key checks.

      If we could optionally allow people to defer the foreign key checks until flush has fully completed we could simply solve them all, maybe even across all vendors?

        Issue Links

          Activity

          beberlei Benjamin Eberlei created issue -
          Show
          beberlei Benjamin Eberlei added a comment - Postgresql: http://stackoverflow.com/questions/139884/how-do-i-disable-referential-integrity-in-postgres-8-2 Mysql: http://cristian-radulescu.ro/article/disable-foreign-key-checks-in-mysql.html Oracle: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html#deferring%20constraint%20checking Mssql: No clue?! Sqlite: no foreign key support (yet) DB2: not researched (IBM should provide better DB2 support for PHP first).
          beberlei Benjamin Eberlei made changes -
          Field Original Value New Value
          Link This issue is required for DDC-959 [ DDC-959 ]
          Hide
          guilhermeblanco Guilherme Blanco added a comment -

          As per https://github.com/doctrine/doctrine2/commit/3e601c3a53226ce981fe82db164f297a8d605ae7 all tests related to this issue are closed.
          Marking this ticket as fixed on 2.3.

          Show
          guilhermeblanco Guilherme Blanco added a comment - As per https://github.com/doctrine/doctrine2/commit/3e601c3a53226ce981fe82db164f297a8d605ae7 all tests related to this issue are closed. Marking this ticket as fixed on 2.3.
          guilhermeblanco Guilherme Blanco made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Benjamin Eberlei [ beberlei ] Guilherme Blanco [ guilhermeblanco ]
          Fix Version/s 2.3 [ 10185 ]
          Resolution Fixed [ 1 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira [ 12259 ] jira-feedback [ 14707 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira-feedback [ 14707 ] jira-feedback2 [ 16571 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira-feedback2 [ 16571 ] jira-feedback3 [ 18824 ]

          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={expand=changesets[0:20].revisions[0:29],reviews, query=DDC-954}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

            People

            • Assignee:
              guilhermeblanco Guilherme Blanco
              Reporter:
              beberlei Benjamin Eberlei
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: