Error converting Views

[ayh20]

In the MySQL DB i have a set of views and conversion fails on them with a syntax error..

In MySQL the view is:
select tracks.id AS id,tracks.name AS name,best_laps.laptime AS laptime from (best_laps join tracks on((best_laps.id = tracks.id)))

nmig throws the following error:

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

SQL: CREATE OR REPLACE VIEW "public"."fastestlaps" AS select "tracks"."id" AS "id","tracks"."name" AS "name","best_laps"."laptime" AS "laptime" from "public".("best_laps" join "public"."tracks" on(("best_laps"."id" = "tracks"."id")));

the SQL generated has the bracket misplaced ... it should be before "public". so the correct string should be:
CREATE OR REPLACE VIEW "public"."fastestlaps" AS select "tracks"."id" AS "id","tracks"."name" AS "name","best_laps"."laptime" AS "laptime" from ("public"."best_laps" join "public"."tracks" on(("best_laps"."id" = "tracks"."id")));

[ayh20]

ALSO ....

When it fails it tries to create a SQL file in a directory called: nmig\logs_directory\not_created_views

The first error works .... the rest fail with:

    --[logNotCreatedView] Error: EEXIST: file already exists, mkdir 'C:\Users\ahampshi\Downloads\nmig\logs_directory\not_created_views'

[AnatolyUss]

Hi Andy, Thanks for posting this issue. I'll check it asap (probably at the weekend).

…

On Tue, Feb 12, 2019, 2:02 PM Andy Hampshire ***@***.*** wrote: ALSO .... When it fails it tries to create a SQL file in a directory called: nmig\logs_directory\not_created_views The first error works .... the rest fail with: --[logNotCreatedView] Error: EEXIST: file already exists, mkdir 'C:\Users\ahampshi\Downloads\nmig\logs_directory\not_created_views' — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#56 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AM8ftxysd4n9JmIXeMqKfU8qs__nlXu5ks5vMq1UgaJpZM4a2POn> .

[AnatolyUss]

Failed views logging is fixed.
Thanks