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

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

XMLWordPrintable

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

      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)

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

              Created:
              Updated:
              Resolved: