DuplicateCheckEnroller cannot be deployed with MySQL 8.x

XMLWordPrintable

      The database schema for the DuplicateCheckEnroller plugin for the redirect_url column is missing a "size" attribute.

      As such, the SQL generated by AdoDB is

      CREATE TABLE cm_duplicate_check_enrollers ( id INTEGER NOT NULL AUTO_INCREMENT, co_enrollment_flow_wedge_id INTEGER , `redirect_url` VARCHAR , `identifier_type` VARCHAR(32) , `env_remote_user` VARCHAR(80) , created DATETIME , modified DATETIME , duplicate_check_enroller_id INTEGER , revision INTEGER , deleted TINYINT(1) , `actor_identifier` VARCHAR(256) , PRIMARY KEY (id) )

      That fails for MySQL 8.x with

      You have an error in your SQL syntax;

       

            Assignee:
            Scott Koranda
            Reporter:
            Scott Koranda
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: