[Bug]: import task splits sql failed when comment contains ';'

[LuckyPickleZZ]

ODC version

4.2.0

OB version

none

What happened?

When a sql like COMMENT ON TABLE "TAB" IS 'A;B', it would be splitted on ; position.

What did you expect to happen?

It should be a unity.

How can we reproduce it (as minimally and precisely as possible)?

import a file contains COMMENT ON TABLE "TAB" IS 'A;B'.

Anything else we need to know?

No response

Cloud

No response

[LuckyPickleZZ]

Correction: The reason for this bug is that there is an SQL statement in the front part of the file, similar to comment on table t is 'a -- b';. Within the content of the annotation, there is a --. Resulting in split failure.