Torque
  1. Torque
  2. TORQUE-45

Generated SQL is in wrong order when dropping tables on table re-creation

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.1, 3.2
    • Fix Version/s: 4.0-beta1
    • Component/s: Generator
    • Labels:
      None
    • Environment:
      java 1.4.2, 1.5. Solaris 10.

      Description

      When the table creation SQL is re-run when the schema contains foreign keys, you will get referential integrity complaints.
      This is because the table drop order means that it tries to drop dependent tables first.
      To fix this, the drop statements should be before all the creates. They should also be in reverse order to the creates.
      A method to be able to obtain the tables in reverse order will be needed to allow the templates to be modified to fix this.

        Activity

        Joe Carter created issue -
        Thomas Fox made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 4.0 [ 12312102 ]
        Resolution Fixed [ 1 ]
        Thomas Fox made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Joe Carter
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development