Subject Re: Odd listing in the DDL (FB 2.0, FlameRobin 0.7.6)
Author red_october_canada
Hi Milan! Based on the domain declared in the previous post, the DDL
you asked for is:

CREATE TABLE ...
(
...
IS_ACV DOM_BOOLEAN DEFAULT 'Yes'
...
);
COMMIT;

I have declared many fields of type DOM_BOOLEAN through-out my DB and
the problem appears to be random. Some end up with the the extra 'T'
and some don't. It doesn't seem to matter if I don't declare an
'override' to the domain's default or not, example:

IS_ACV DOM_BOOLEAN /* Uss the domain's default of 'No'*/
IS_ACV DOM_BOOLEAN DEFAULT 'Yes' /* Override with a 'Yes' */

In either case, the extra T may or may not show up.


> Looks like a possible bug in FlameRobin, we'll look into it ASAP. Could
> you please show us the original DDL you used to create IS_ACV ?
>
> --
> Milan Babuskov
> http://www.flamerobin.org
>