GrouperDdlDataMigration() generates invalid SQL statements in its ddlScripts/

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major
    • None
    • Affects Version/s: 4.17.6, 4.17.7
    • Component/s: gsh
    • None
    • Environment:
      Internet2 Docker container

      new GrouperDdlDataMigration().assignDatabaseFrom("grouper").assignDatabaseTo("mysqlDb").migrateDatabase();
      {{}}

      ...Will generate and attempt to execute a bad sql script shortly after execution.  The chief error looks to be a repeated CREATE TABLE [TABLENAME] in each of the CREATE TABLE statements.

      {{}}

      Steps to recreate:
      -create an external system pointed to a blank postgres database

      -start a gsh container and run:
      import edu.internet2.middleware.grouper.ddl.GrouperDdlDataMigration;
      new GrouperDdlDataMigration().assignDatabaseFrom("grouper").assignDatabaseTo("targetDB").migrateDatabase();

      Error should occur shortly after execution starts.
      {{}}
      Note: issue does not occur in 4.17.4.{}
      {{}}

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Jeffrey Williams
            Chris Hyzer, Vivek Sachdeva
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: