Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: leoholanda on October 11, 2005, 10:24:57 am

Title: Wrong comment terminator in generated DDL
Post by: leoholanda on October 11, 2005, 10:24:57 am
I'm using Oracle as DBMS.
I wrote some text in the COLUMN notes box as follows:

0=nao 1=sim 2=talvez


When generating DLL I used the "column" option in comment level. But the generated comment is like the following:

Code: [Select]
COMMENT ON COLUMN TB_MYTABLENOME.MYCOLUMN IS '0=no 1=yes 2=maybe ;

so oracle produces an error about the quoted string not properly terminated, as we can see...
Is this a bug or am i doing something wrong?
I also tried to insert an artificial single quote at the end of the comment but the produced sql was:

Code: [Select]
COMMENT ON COLUMN TB_MYTABLENOME.MYCOLUMN IS '0=no 1=yes 2=maybe '' ;


Title: Re: Wrong comment terminator in generated DDL
Post by: hd on October 11, 2005, 03:07:29 pm
It's a bug  :-[

We will fix it for the next release.

Thanks for reporting it.  :)