Author Topic: Wrong comment terminator in generated DDL  (Read 2494 times)

leoholanda

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Wrong comment terminator in generated DDL
« 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 '' ;



hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Wrong comment terminator in generated DDL
« Reply #1 on: October 11, 2005, 03:07:29 pm »
It's a bug  :-[

We will fix it for the next release.

Thanks for reporting it.  :)