View is not created, syntax error

[robert-sjoblom]

Set up two databases.

MySQL: https://github.com/datacharmer/test_db Postgres: Empty

Move data from MySQL to Postgres.

Expected:

All views are created on PG side

Actual:

Query fails with message

--[ViewGenerator::default] error: syntax error at or near "("

    SQL: CREATE OR REPLACE VIEW "public"."current_dept_emp" AS select "l"."emp_no" AS "emp_no","d"."dept_no" AS "dept_no","l"."from_date" AS "from_date","l"."to_date" AS "to_date" from "public".("dept_emp" "d" join "public"."dept_emp_latest_date" "l" on((("d"."emp_no" = "l"."emp_no") and ("d"."from_date" = "l"."from_date") and ("l"."to_date" = "d"."to_date"))));

[AnatolyFromPerion]

nmig doesn't implement a real SQL parser, so it attempts to create a view in PostgreSQL with the original (MySQL) syntax. Sometimes, in simple cases, it works. Sometimes it doesn't. When it doesn't - nmig leaves a ditailed error log.