ERROR mysql: Failed to connect to mysql at "XXX" (port 3306) as user "XXX": The value of SEQUENCE is "/d*w+D7Lu_w3`G-i", which is not of type IRONCLAD::SIMPLE-OCTET-VECTOR

• pgloader --version

  pgloader version "3.6.1"
  

compiled with SBCL 1.4.0-1.el7
```

• did you test a fresh compile from the source tree?

  Yes

• did you search for other similar issues?
  Yes

• how can I reproduce the bug?

  Incude a self-contained pgloader command file.

  Microsoft Azure's MySQL service is using MySQL's authentication switch protocol and pgLoader does not support that. You can actually expect this behavior by looking at pgLoader's code or create and try an Azure MySQL server to test with.

pgloader --debug --verbose script.load

script.load contents:

load database
FROM  mysql://XXX
 INTO  postgresql://XXX
WITH include drop, create tables, no truncate,
create indexes, reset sequences, foreign keys
--SET maintenance_work_mem to '128MB', work_mem to '12MB', search_path to 'sakila'
CAST type datetime to timestamptz
drop default drop not null using zero-dates-to-null,
type date drop not null drop default using zero-dates-to-null
MATERIALIZE VIEWS film_list, staff_list
-- INCLUDING ONLY TABLE NAMES MATCHING ~/film/, 'actor'
-- EXCLUDING TABLE NAMES MATCHING ~<ory>
BEFORE LOAD DO
$$ create schema if not exists testdb; $$;

• How the data is different from what you expected, if relevant