ver 23.2, issue with the column name (table or sequence or index name) having special character as $

[bharanisvng]

We recently upgraded to ora2pg Ver 23.2. we noticed issue with the column name (table or sequence or index name) having special character as "$" in their name

With the older version of ora2pg , it got converted without any issues.

We faced issued in the conversion of a Sequence name having " $" in their name.
CREATE SEQUENCE "public"."bsv_ISEQ$$_25269" MINVALUE 1 MAXVALUE XXXX INCREMENT BY 1 START WITH 142 ;

[mkgrgis]

See #1581 #1563 #1567

[darold]

This have been fixed.

[bharanisvng]

Darold - I believe your fix ( We recently upgraded to ora2pg Ver 23.2. we noticed) is fixed in ora2pg ver 24.0 or the future release ?. can you pl clarify ,

[darold]

I have not made archeoligical research in the commits but when I export such sequence I have the following result:

CREATE SEQUENCE bsv_iseq$$_25269 INCREMENT 10 MINVALUE 10 MAXVALUE 100 START 10 CACHE 2 CYCLE;

or when PRESERVE_CASE is enabled:

CREATE SEQUENCE bsv_iseq$$_25269 INCREMENT 10 MINVALUE 10 MAXVALUE 100 START 10 CACHE 2 CYCLE;

There was lot of fixes in 24.0, you should upgrade or better use latest development code if possible.