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: