Uploaded image for project: 'JBeret'
  1. JBeret
  2. JBERET-237

can't specify target table 'JOB_EXECUTION' for update in FROM clause

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.3.0.Beta2
    • 1.3.0.Beta1
    • tests
    • None

    Description

      Some tests use subquery in update or delete sql statement, but when running with MySQL, may encouter the following error:

      You can't specify target table 'JOB_EXECUTION' for update in FROM clause
      at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1106)

      Attachments

        Issue Links

          relates to

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) JBERET-99 Add a way to delete/purge job repository artifacts

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              cfang@redhat.com Cheng Fang
              cfang@redhat.com Cheng Fang
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: